Aug 31, 2022 03:55 PM
I have an automation that uses the Find Records and the Google Sheets actions. Everything works except that the data is html formatted and appears en masse in one cell in the Google Sheet. I’m using the free version.
I’m not sure whether I’m doing something wrong or whether I need to do something on the Find Records action to yield correct formatting for the subsequent Google Sheets action.
Any ideas?
Aug 31, 2022 09:17 PM
Hey Robert, that’s a weird one. Any chance you could provide some screenshots of how the automation’s setup?
Sep 01, 2022 09:30 AM
I’m still trying to figure out how to upload an image to this message. In the meantime, here’s the issue:
I choose the source of the google sheets action to be the prior Find Records action. Then, I choose the column in the google sheet. But when I go to choose the data that goes into that column (“Choose data” dialog box), the only options seem to be “Make a new list of …”
thx for your help!
Sep 01, 2022 12:54 PM
@Robert_Blakeley You have hit upon one of the major limitations of Airtable’s Automations, which is that Airtable’s Automations do not support looping through found records.
Airtable’s Automations can only process your found records as an entire group of records, but it can’t separate them out individually.
First, I would highly recommend sending an email to support@airtable.com about this issue to request that they add this as a feature in Airtable’s automations.
Second, you didn’t actually say what you are trying to accomplish, so I can only assume that you are trying to add new rows to a Google Sheets spreadsheet based on the records that were found — one new row for each record found.
There are at least 3 workarounds that would enable you to accomplish this:
Write a JavaScript. I do not know JavaScript, so I can’t help you there.
Use the workaround that I discuss in this BuiltOnAir Airtable podcast episode:
p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with #2 or #3 above, please feel free to contact me through my website: Airtable consulting — ScottWorld
Sep 02, 2022 07:33 AM
Thank you for your reply. I thought that I had seen a demo that showed this could be done directly within Airtable but I will look into your suggestions.
Sep 02, 2022 08:43 AM
Yes, #2 is done directly within Airtable.