LinkedIn
Twitter
Hi there.
I am fairly new to Appsheet and am facing an Issue that I am hoping somebody could help me with or at least guide me in the right direction.
My App is a Fitness Challenge App that basically should have the funcation that a user creates a Fitness Challenge to do 100 Push-Ups daily for 7 days. When creating the Challenge, the signed in use can select multiple people that are also found in the users table and send them invites.
The App has a total of 5 Tables:
- Challenges
- Invites
- Roles
- Trainings
- User
My Problem is that I can Create the Challenge and can write into the Invites Table for every user but I can't get the Challenge ID together with the User ID in the Invite Table.
Here is my Table Setup
Challenges
Invites
Roles
Trainings
User
My Idea was the create an Action "Add Invite" for User Table to add to Invites
and then trigger this on Challenges Save to create an Invitation Entry for each invited User:
This works fine but every line that is created is missing the ChallengeID and I am not sure how I can get the Challenge ID added correctly. I tried group actions to first write the Challenge ID and then trigger the invites but then I get one line for Challenge ID and additional lines for user invites without Challenge ID.
I am pretty sure its a simple Table REF Logic that I am missing. Would be great if anybody had an idea and could help!
Best
Roland
