I need to export a grand total number from Airtable to import into our payroll software as a csv. The table is setup by an employee and that employee has a new row for each month of the year with a number in it. I know that airtable sums those columns, but I don't know how to export the grand total by employee. I need the grand total of the {Dollar$} field exported. How can I do this? Thanks. Wendy
Grand Total of Rows
+7
+31Hi Wendy, to do that you'll need to create another table, link your records as needed, and use a rollup field with the formula "SUM(values)" I'm afraid
+7Hi Wendy, to do that you'll need to create another table, link your records as needed, and use a rollup field with the formula "SUM(values)" I'm afraid
Thanks. I linked a new table (table 2) to the table with the dollar amounts (table 1). When I roll up the dollar field from table 1 to the rollup field in table 2, I get a $0. I linked table 2 to table 1 using the employee number. Not sure what I am doing wrong; likely something simple :).
+31Thanks. I linked a new table (table 2) to the table with the dollar amounts (table 1). When I roll up the dollar field from table 1 to the rollup field in table 2, I get a $0. I linked table 2 to table 1 using the employee number. Not sure what I am doing wrong; likely something simple :).
Ahh, that's odd. Could you share some screenshots of the relevant tables and fields so that I can help you troubleshoot?
+7Hi, Adam. I decided to enter my data into our payroll system manually. I am retiring the base I used for this information and recreating a more organized one. Thank you for the response and help! - Wendy
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.