Hello Airtable Community,
I hope you are all doing well and I hope that you will be able to help me with my little issue (little issue, but still trying to find the solution since weeks ahah)
I’m currently building the website of my company, and to explain you basically Users can choose different bots from the interface and it goes to our Airtable Table : “BotsSelection”:
The thing i’m trying to do it’s basically when “A_Activity” for exemple is “Active” I would like to automaticaly assign in “Used_Bot” the “Bot_A” id (if the Bot A and the Bot B is “Active” add id of Bot A and B etc, etc…).
I tried to use Automation :
So basically the issue is it work when it’s only one field who is updated, if I repeat this automation for every bots but the issue is it will delete the previous data instead of just adding one :
Can you help me with my problem?
Thanks a lot