Airtable: Map Unique ID Widget with Airtable's textbox field

  • rcommunity
    Asked on July 29, 2019 at 6:45 PM

    I've been able to get all my form data into AirTable except for one critical piece. I need to create a Unique ID for the form registration and pass that to AirTable as well.

    I've tried the Unique ID widget as well as the Random Value Generator widget and neither of those show up as viable selections to import into one of my AirTable fields, regardless of what type I make the field in AirTable.

    Is there a problem transferring widget field data to AirTable that I don't know about?

    Cheers,

    Kevin

  • Elton Support Team Lead
    Replied on July 29, 2019 at 7:43 PM

    You're right with that, I'll escalate that as a feature request and we'll let you know once those widgets are supported.

    For now, you can try the following workaround.

    1. Airtable has Autonumber field type so this might work for you. This doesn't need to be mapped in the integration, it increments by itself.

    Airtable: Map Unique ID Widget with Airtables textbox field Image 1 Screenshot 50

    2. Use the Random Generator Widget and pass its value to a Short Text Entry field through Update/Calculate Field condition then use the Short Text Entry on integration.

    Example:

    Airtable: Map Unique ID Widget with Airtables textbox field Image 2 Screenshot 61

    Then create a condition like the following.

    Airtable: Map Unique ID Widget with Airtables textbox field Image 3 Screenshot 72

    On integration;

    Airtable: Map Unique ID Widget with Airtables textbox field Image 4 Screenshot 83