Jan 23, 2021 12:08 PM
Hello,
I am new to Airtable. I tried looking for this answer already in the community, but I could not find a post. I am using Airtable Automations to copy specific fields to another table. So far the first three fields have been a success, but now that I am trying to copy the value from the formula field, it won’t show or copy that value from that field into the other table. Is this a limitation in Airtable? Thank you for your assistance!
Solved! Go to Solution.
Jan 24, 2021 12:21 PM
Thank you for your response and for welcoming me Kuovonne! The issue is resolved. It’s hard to explain, but after my post, I deleted the field and added two additional (Non-formula) fields, and those values would not populate. Only the first three fields would populate again. I ended up deleting the automation and remaking it. After that, it worked. Strange, not sure why, because the automation was the same. Also, thank you for your contributions to the community. I see you are consistently assisting others.
Jan 23, 2021 07:33 PM
Welcome to the Airtable community!
Are you giving the formula field enough time to calculate? For example, if your automation triggers before the value of the formula is calculated, the automation won’t have access to the calculated value.
Jan 24, 2021 12:21 PM
Thank you for your response and for welcoming me Kuovonne! The issue is resolved. It’s hard to explain, but after my post, I deleted the field and added two additional (Non-formula) fields, and those values would not populate. Only the first three fields would populate again. I ended up deleting the automation and remaking it. After that, it worked. Strange, not sure why, because the automation was the same. Also, thank you for your contributions to the community. I see you are consistently assisting others.