Forum Discussion

MarkGlevicky's avatar
MarkGlevicky
Qrew Cadet
7 years ago

Importing address info from a large spreadsheet and then creating address field -Step by Step?

I've been trying to make this work, using this old link on the web which unfortunately has the picture links broken, so the story is still fuzzy to me.   https://www.quickbase.com/blog/migrating-ex...
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
There may have been an option right after the import to add fields to form.  If you deleted the fields and re-imported and re-created them, maybe that question would pop up.
EvanMartinez's avatar
EvanMartinez
Moderator
7 years ago
That question is partially controlled by a dropdown in the properties for a form. If you customize the form and then select properties there will be a dropdown for 'When new fields are created in the Checklists table:' where you can set it to add fields automatically, ask you if fields should be added, or not add fields by default. Though in the case of address fields I believe it still defaults to adding just the composite address field itself and not the sub fields so as not to clutter up the form. Since on edit the address field expands to display all the subfields.