Hello,
I'd like to ask for help in troubleshooting an automation. I built an automation that works correctly when I "Generate a Preview". BUT, when I go to actually use it, the automation does NOT work. I.e., it does not update my live/active Base in the same way that it updated the Test Record. Actually, it appears to have done *nothing* to my Live Base, lol. Is this a common issue???
Specific Context for my Automation:
Table 1 is "Applications" where Client Application Forms are received.
Table 2 is "Sessions" which lists all of the available time slots for Applicants to sign up for.
Table 3 is "SignUps" where SignUp Forms are received indicating a specific Application # is signing up for a specific Session.
When someone completes a "SignUp" form it automatically includes the Session they're choosing as well as their Application # (through a Prefilled URL). I want the automation to add the Application # from the SignUp Form to the Sessions Table to finish the circle of Application -> SignUp -> Scheduled Session.
I apologize if it's not clear, let me know how I can clarify. Thanks in advance for your help.
-ML
Screenshot of the Airtable "Generate a Preview" that shows "App-5" was successfully added to Linked Record field "LINKEDtoAPPS". (Hooray!)
Screenshot of the Sessions Table after I run a "real life" scenario of the Automation, BUT the "LINKtoAPPS" column does NOT have an "APP-#" linked record in it like the "Generate Preview" example did. (Oh no!)
