Hi all, first time posting here. I’ve been building a membership app on Softr connected to Airtable and have hit a wall with a workflow involving a junction table. Would love any guidance from anyone who’s tackled something similar.
**
I’m building a curated membership app connected to Airtable. Members get invited to mini events and need to RSVP through the app. I have three relevant tables: Members, Experiences, and Experience RSVPs (a junction table linking Members × Experiences).
What steps produced the problem? When a member taps an RSVP button on an Experience details page, I want a workflow to find their specific record in Experience RSVPs (where Member = logged-in user AND Experience = current experience) and update the RSVP Status field from “Invited” to “Confirmed.”
Setup:
-
Trigger: Run custom workflow on the RSVP button, passing two data fields:
memberEmail(logged-in user email) andexperienceId(Experience Name from selected record) -
Step 3: Find record in Experience RSVPs where Member is body.memberEmail AND Experience includes exactly body.experienceId
-
Step 4: Update record — update RSVP Status to Confirmed
I’ve already tried
-
“Includes any of” operator on the Experience condition → error: “Operator CONTAINS is not supported for array fields”
-
“Includes exactly” operator → “No record found”
-
“Is” operator on Member field → “No record found”
-
Passing memberEmail via DATA TO USE IN WORKFLOW on the button
I believe the issue is that Member and Experience in the Experience RSVPs table are linked record fields (arrays) and Softr can’t match text values against them in workflow conditions.
Has anyone solved RSVP/junction table updates via workflow? Is there a different approach I should be taking? thank you!