Skip to main content

please help me.


I have a table with two columns: ID and Product.

The information is imputed through a bot.


The more the ID buys the more lines it will have.


At the end of the flow, to ensure that the ID has completed the purchase, I need to flag it in a new column: purchased = YES.


however, the bot can only insert “YES” in the first line of the ID and the others are blank.


There is a way inside airtable so that I can repeat the “YES” for an ID if there is already a row with that ID and the column purchased “yes”.


Example:

table:

ID, purchased

123

123

123

123

Current results:

ID, purchased

123 YES

123

123

expected outcome:

ID, purchased

123 YES

123 YES

567

765

123 YES

123 YES

Hello @leandro_medeiros!



I believe what you are looking to do could be accomplished by either writing a customer script or by using on of Airtable’s integration options. Using either Zapier or Integromat you could trigger the integration when your Airtable record updates, iterate through records with matching names, and update the records necessary. Here is a Community post with a great example of how to iterate through Airtable records with Integromat.


Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution ✅ .


Reply