I have Users, Todo tables. Each Todo has Category & Assigned User among other things. Now I wish to use Category to bulk create Todo for User e.g. an action can be ‘Create all Onboarding category Todos for User XYZ’.
I’ve looked at the looping posts here. They’re helpful but fall short because I need to create a new copy of Todo rows and not reference existing items.
How can I achieve this? Is this even possible with the new ‘Automation’ features? Do I need to think of new data structure to make this easier?
You need to pass two pieces of information the User and list of To Do. But you can only do one with AppSheet. I’m stuck here.
This surprising limitation is because you cannot have non-virtual columns as List of Ref. Hope it’s added soon because this is super lame.
LinkedIn
Twitter
