Import Excel data into multiple tables
Suppose I'have the following Excel file: How can I import this information into multiple tables (Projects, Employees, Membership)? I did take a look at the documentation here, here as we...
Forum Discussion
It sounds like you want to run three separate csv imports to bring records into the three tables. If yes, have you thought about importing CSVs using the sync tool? Check out this article if you need more info: https://quandarycg.zendesk.com/hc/en-us/articles/360021085412 (only updates hourly)
You could also setup table-to-table imports and schedule the import using Google Scripts. This could update more frequently than csv sync.
There are some other ways to go about this, but those are good low-code options. Let me know if you're interested in more detail. Thanks.
Jake Rattner | Solutions Architect
(847) 927-1427 | [email protected]
Quandary Knowledge Base
You could also setup table-to-table imports and schedule the import using Google Scripts. This could update more frequently than csv sync.
There are some other ways to go about this, but those are good low-code options. Let me know if you're interested in more detail. Thanks.
Jake Rattner | Solutions Architect
(847) 927-1427 | [email protected]
Quandary Knowledge Base