I am a little puzzled by the bots. The automations to email/text/etc are pretty simple but when it comes to changing data, it doesn’t make a lot of sense to me. Let me set up what I am trying to do: I have a “Authorized Properties” column in a “Employees” table. I also have a “Authorized Employees” column in a “Properties” table. When admin users add a new property they use a EnumList dropdown to select which employees have access to the new property. This creates a list of employees separated by a comma and space within the “Authorized Employees” column. What I need is a way to update the “Authorized Properties” column based on these new property entries. Both columns are EnumList columns that show up in Google Sheets as text values separated by a comma and a space. The only thing that I can think of that might solve this is a “bot” automation. But I am open to any and all ideas! Thank you so much!
I think you may want to mention if the two tables have reference relationship.
If not, you may want to take a look at the following help article
References between tables - AppSheet Help
Also it sounds that each property can have many employees and each employee can have many properties assigned to each other.
In that case you may want to take a look at tips /posts for options available in ApPSheet to implement many to many table relatinships
1 Like