Sep 07, 2024 08:41 AM
All:
I have imported data from an excel into an existing table in a base. The existing table is called "Income Account Transactions." There is another table called "Profit & Loss" that links to Income Account Transactions table. It calculates data from the table. The imported data is not calculating into the Profit & Loss Table. What am I doing wrong?
Sep 07, 2024 12:59 PM
Importing data into an existing Airtable table with formulas can be tricky. The key is to ensure that the structure of the data being imported matches the existing fields. If your data includes formula-based columns, you'll want to double-check that formulas are correctly configured post-import to ensure they work as expected. Using CSV files or third-party tools might streamline the process.
Sep 07, 2024 09:56 PM
Could you provide screenshots of both tables with the relevant fields, specifically the linked field between the tables?
If you could provide a read-only invite link to a duplicated copy of your base with no records in it I could take a look at this for you! https://support.airtable.com/docs/adding-a-base-collaborator#adding-a-base-collaborator-in-airtable
Sep 08, 2024 01:09 AM
Just to understand your question, because there is a difference in excel vs airtable in the way the relation between tables work. Also importing can sometimes cause a few hiccups.