Forum Discussion

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

AlexCertificati

Qrew Cadet

7 years ago

My friend. No. You don't want to do ANY of that. You want to import your spreadsheet to your measurements table in one fell swoop. Start here, maybe? https://help.quickbase.com/user-assistance/import_from_excel_existing_app.html

QuickBaseCoachD

Qrew Captain

7 years ago

Just to add to Alex's post above, you would map the Record ID# of the Standard which you say is on your excel sheet into the field [Related Standard] on the Quick Base table of Measurements.

Forum Discussion

populating the record picker with a value from a spreadsheet

Related Content

Auto populate prefilled records

Duplicate Record Checker

Custom Record Titles

Create new app - import a spreadsheet

Using Grid Edit to Edit Multiple Records at Once