Hi, hoping this is quite simple and I am missing the obvious somewhere.
Goal: Create a group, where each group member is created as a entry in my database connected to the group.
Current Implementation:
- User selects to create a group, (think WhatsApp groups), they name the group and then search and add other users. This is held in a custom state “GroupMembers”
- Have a database for the “Group” and “GroupMembers”
- When user clicks create group CTA run workflow:
- Create a new thing = Group
- Create a new thing = GroupMember (for current user as they default set to Admin role)
- Group = Result of Step 1
- User = User etc.
- Role = Admin
- I am then trying to schedule an API workflow to iterate through the users in the Custom State and create a record for each of this, with the same parameters as above but role = member.
The problem: I cannot seem to access the custom state list. Is the “Schedule API workflow on list of things” the correct one to use here? as it cannot access the custom state in “List to run on” field.
Any help on how I can create these records from the Custom State? Thanks in advance.