Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Automatically assigning based on form submission

118 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_Lake1
8 - Airtable Astronomer
8 - Airtable Astronomer

Good day.

The idea is this.  Someone fills out a form, to request a certificate/license and by the end, they are automatically assigned a certificate #.

I have two tables, one "Recipient" where the form exists, and another table that will have uploaded certificate numbers provided by someone else.

I have the two tables linked so that when that record is generated by the form, it will automatically pull from the second table, the certificate table, a certificate number.  

As each form is received, a certificate number is applied, not generated, as they are 'hard' coded in the second table :). 

Does that make sense?

4 Replies 4
Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

Assuming the Certificates table is named "Certificates"...

Create a linked record field on the Recipients table that links to Certificates. On each table, the name of the field should be the name of the other table.

Create an Automation with the following configuration:

Trigger: When a form is submitted

  • Table: Recipients
  • Form: *YOUR FORM NAME*

Actions

Find Records

  • Table: Certificates
  • Find Records Based on: Condition
  • Conditions: Where Recipients is empty
  • Maximum Record Limit: 1

Update Record

  • Table: Recipients
  • Record ID: Airtable Record ID from the "When a form is submitted" step
  • Fields:
    • Certificates: List of 'Airtable record ID' from the "Find Records" step

In layman's terms, here how the automation works:

When a form is submitted, look for a record in the Certificates table that is not currently linked to a record in the Recipients table. Then, update the record in the Recipients table to link to the record from the Certificates table you found earlier.

Note: This will not select the "next" open certificate number, it will pick one at random. If you need it to follow a certain order let me know.

 

Hello @Sean_Lake1,
I expect that you've also asked for the certificate number as a field in the first form(Recipients).

At the moment Airtable doesn't support trigger action in the middle form filling or multiple steps to handle form data.

So I recommend you to use Fillout Forms which has inbuilt native integration with Airtable. It also supports multiple steps and subforms which is useful for your implementation.

Use multiple or subforms then add a record to Airtable when the first part of the form is complete. Trigger Airtable automation to link certificates based on number. Then based on the first submission show the linked certificate on the second form step.

If you've already used Airtable Automation then implementation of the Fillout form will be easy for you.

I hope this helps you.
Let me know for further enhancement of suggestions. 
👍

 

Yeah, sadly we cannot access external software without a long period of approval through legal, etc.  

@Sean_Lake1 did the solution I provided above work out for you?