Jun 18, 2023 11:04 PM
I have an issues table and a issue log form is created where users use it to log their issues. Once the issue log form is submitted i want the Issue ID or record ID of that issue to be shown in the form(For example when we post a complaint on swiggy or zomato it will give us a unique ID for our complaint)
Jun 19, 2023 06:23 AM
The easiest way would be to add an Autonumber field to your issues table, and use that. If you want to make the appearance more consistent you can add a formula field such as
Jun 20, 2023 06:03 AM
I don't think so I'm afraid. You could email the form submitter the record ID maybe?
Jun 20, 2023 09:31 PM
I have an unique id column but i want it to reflect in the form once the form is submitted. So the users can use the ID to track the status of their issues. Is there any way ?
Thanks in advance
Jun 21, 2023 09:18 AM
You can create an automation that will trigger on the form submission and configure it to send an email to the person completing the form and embed the field into the body of the email, as in
"Thank you for submitting your issue. For reference your issue number is 000070 . Please refer to this number if you need further information". |
The limitation being being that the person completing the form would have to be signed in to airtable in order to get their email address. In addition the email will show "Sent by Automations". See https://support.airtable.com/docs/send-an-email-action
On the form itself there is a toggle to allow the person completing the form to request a copy but this method does not let you include formula or autogenerated fields on the email.
Hope this helps