What are you actually trying to do here? Use the two Student datasets to put info into the Final Data dataset or something else.
You can simply use multiple references and use two datasets and then save it into the Final Data dataset.
https://support.wix.com/en/article/about-connecting-multiple-database-collections
https://support.wix.com/en/article/about-displaying-content-from-multiple-database-collections-using-datasets
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931
https://support.wix.com/en/article/working-with-multiple-item-reference-fields
https://www.wix.com/corvid/forum/corvid-tips-and-updates/you-can-now-add-multiple-items-to-reference-field-type
https://support.wix.com/en/article/referencing-multiple-items-in-one-database-field
https://support.wix.com/en/article/about-referencing-multiple-items-in-one-field
Or you can use Wix Data API and the getCurrentItem function.
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#getCurrentItem
$w(“#dataset1”).getCurrentItem(); // For all the users row data in the dataset //
$w(“#dataset1”).getCurrentItem().fieldName; // For just a field in the dataset //
@givemeawhisky I referenced fields from final dataset to pickupInfo dataset, I have set building name as the main field in the pickup info dataset. Now, as you can see I am able to retrieve the building name in my finalInfo but not the data from other fields. Why is that? please help.
