Hey all! This is my first post, so I’ll do my best to provide all the info.
Narrative Goal:
I have an app that is basically an internal job board for folks to sign up for volunteer opportunities within our agency. What I am trying to do is when someone creates a new “opportunity” for the first time, the system will automatically append their “user permissions” with “organizer.”
Basic Info:
Tables:
Opportunities
User Info
Fields:
Opportunities[Owner] is referencing User Info[Email Address] (which is the key field)
User Info[User Permissions] is an EnumList with the values “User”, “Participant”, “Organizer”, “Admin”
When a new row is added to “Opportunities”, I want the system to check the Opportunities[Owner] against the User Info[Email Address] and, if there is a match, update User Info[User Permissions] to add “Organizer” to the EnumList on that row
What I have done:
Created an Action for “User Info”
I have an expression for “Only if this condition is true”= Opportunities[Owner]=User Info[Email Address]
Created an Action for “Opportunities” that references “Update Permissions”
Created a Bot that acts when a record is added to “Opportunities”
Added the “Update Permissions” Action to the Bot
So, I would think that the Bot would run when a row is added to “Opportunities” and it would check to see if the “Opportunity Owner” and “Email Address” match and update the “User Permissions.”
However, when I create a new opportunity using a user that does not already have “Organizer” in the “User Permissions” column, the app does not add it.
After much searching and reading and experimenting, I cannot for the life of me figure out what I’ve done wrong in the setup. I’m sure it’s something obvious - please help!
