Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 21, 2023 04:01 AM - edited Apr 21, 2023 04:03 AM
Howdy AT Community!
Hoping a kind soul can provide some assistance with an automation query.
I'm trying to track subscription activations for a University cohort, pulling from a large Uni Cohorts table to update a specific cohort tracker table. Desired automation flow is as follows:
Student submits subscription activation request form > record is auto populated in main Uni cohorts table (first name, last name, email, Uni name) > record 'Status' field is set to 'activated' if approved in main table > student record status field is updated/reflected in cohort activation tracker table
The list of student names and emails is already populated in the tracker table, purely need to track them in for external onboarding reporting purposes. Struggling to get the update record automation to work between the two tables (unless there's a formula trick I'm missing?)
Any assistance greatly appreciated.
Solved! Go to Solution.
Apr 24, 2023 04:41 PM
OK. I think I understand.
You have a main Uni cohorts table that houses a form. When the form is submitted, a new record is created in the main Uni cohorts table with the Student's first name, last name, email, and Uni cohort name. That same table has a Status field that can be set to Activated and then you want that Status change to trigger an automation that finds the records that have the same email in the cohort activation tracker table and then updates the Status field on that record.
If that's correct, then you have an automation with a trigger, a find records action, and an update records action. The thing is that you might have more than one record with an email, so you're going to probably need a conditional action based on the length of the list of records found. If it's =1, then you update that record, but if it's 0 or >1 then you're going to need to specify what happens.
You can see the automation in action here.
Apr 21, 2023 09:36 AM
Is the cohort activation tracker table the table that houses the subscription activation request form?
Apr 24, 2023 06:45 AM
Hi pressGO_design,
Many thanks for your response.
No, the main cohorts table currently houses the activation request form.
Apr 24, 2023 04:41 PM
OK. I think I understand.
You have a main Uni cohorts table that houses a form. When the form is submitted, a new record is created in the main Uni cohorts table with the Student's first name, last name, email, and Uni cohort name. That same table has a Status field that can be set to Activated and then you want that Status change to trigger an automation that finds the records that have the same email in the cohort activation tracker table and then updates the Status field on that record.
If that's correct, then you have an automation with a trigger, a find records action, and an update records action. The thing is that you might have more than one record with an email, so you're going to probably need a conditional action based on the length of the list of records found. If it's =1, then you update that record, but if it's 0 or >1 then you're going to need to specify what happens.
You can see the automation in action here.
Apr 25, 2023 02:09 AM
Hi, this is great!
Thanks for the visual aids, have configured and tested and it works!
Appreciate your time on this. Shall mark this as solution.
🙏 🙏 🙏
May 05, 2023 06:33 AM
May 05, 2023 07:31 AM
It's the RecordID of the record you just found.