Forum Discussion

BenPonder's avatar
BenPonder
Qrew Trainee
7 years ago

populating the record picker with a value from a spreadsheet

I've got a table or performance standards and a spreadsheet with performance measurements; the standards table is then a parent table for the measurements table.  Even though we've got the standards t...
App builders
Data import and export
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Here is some help text on Relationships.  
https://help.quickbase.com/user-assistance/creating_a_relationship.html

Once you connect a child to a parent record, then you simply lookup any fields you like from the parent down to the children


So yes, you can import an excel sheet and if it has the Key field of the Standards in the import then not only will be import of the measure data be automated, but the lookups of he correct standard will come down from the parent standard table.