I’m scraping information from a real estate website every week on monday. And I want to add the new houses to a airtable. So everything runs great but now he add all the houses, also the ones I already added. So I setup an action that he gets data from the airtable. In the conditional step I defined that the streaat name can not be the same as the street name in airtable. If that is not the case he add the record to airtable. But somehow he get an error on the conditional step. When I don’t use dynamic fields from the get airtable action but just a static word it works. But with the conditional input it gets an error.
Hi Jordy, welcome to the community!
Seems like you’re struggling to update your airtable data.
A solution we’ve created for these cases is the “Update records in airtable” command, so only new rows are created.
You can use this instead of conditionals.
It works the same as the GSheet one
Hi Ivan, thank you for your answer. It’s not exactly what I’m trying to accomplish. I want to check if the record already exists in my airtable. Because I scrape the website immoweb every week. But I only want to add new houses to the airtbale. So for that I want to check if the adress already exist in my airttable. The adress is in the column straat + nr column in airtable. When the adress does not already exist then a new record can be created otherwise it need to skip this step.
Yeah exactly that’s what the update or add does.
It checks if there’s already an existing house and it doesn’t create a duplicate, rather just updates that record.
If the house is not on the list it’ll create a new record.
Don’t understand what’s different
Maybe you can share your automation link so we can check?
I’ve been having similar issues with my own automation. Conditional step isn’t working.
Hey Ivan,
I also have an issue with the update airtable automation.
As you’ve mentioned, conditionals may not be the best way.
I presume the “update” automation is a standalone process in the builder?
My use case:
If column C features an article, I would like column A and B to to generate a headline and a meta description respectively. Based on the article/content in column C.
I’ve created a blank builder document and started the process with “update records in airtable” block.
“To airtable table:” No issue can select correct table.
“Search rows by column:” copied and pasted the excact column heading. This forms a “bubble” but it was not selected from a dropdown. Purely text input.
“Find rows by value:” This is my stumbling block. I’d like to update all empty cells in column A based on content in column C. (i need to run column B as a separate process?)
- should I be using text or commands?
- Is there a standard string for looking up empty cells?
- Should i be running the chatGPT element within this block or as a second, linked process?
Clearly, I’m a newbie Maybe I’m mising the obvious.
Your thoughts here would greatly appreciated.
Thanks for sharing this!
I’m trying to understand what we’re missing on your case, can you help me understand how the “update or add” doesn’t help here?
Can you share maybe the use-case and automation? Or a quick loom walkthough?
Hi @Figmentr checking your case!
I don’t understand how you’ll be able to do this:
Is it with scraping?
Can you share an article link example maybe? Or a walkthough of your process.
My guess on what’s missing:
Seeing as you want to update if colum C features an Article, the “find rows by value” should contain the links from the articles.
This will look up on the column C for the article links. If the links are the matched, it should update the rows, in this case, with the description and title. If the links are not found, it’ll create new rows.
Seeing your screenshot, theres 3 fixes you can do:
- Add a “find Airtable rows” or “get airtable rows”.
This is needed for update or add so Bardeen can update the existing rows.
-
To do this, in “update or add”, on “values to find”, relate it to the previous step to get airtable rows.
-
On “update rows with data” create the column instead of mapping those 2 custom prompts.
I can help draft it for you if you share the automation link please
I see how this action is not that intuitive, I’m happy to help.