Automatically complete

[leandro_medeiro]

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

[Rose_K]

Hello @leandro_medeiros!

leandro_medeiros:

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”.

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 :white_check_mark: .