submission ID to Hidden Field

Hello @wendybedell !

Hope you’re doing well today!

The submission ID is assigned after the form is submitted – basically the database assigns it when we save the data and just gives it back to display later.

You can use the macro {submission_id} in the emails to show that value as at that point the data is already saved.

However, maybe you can share some additional details about the use case here – what you’d like to use that for etc., maybe we can find an alternative solution for you.

Kind regards,
Pawel

We are passing the information from the form to a google sheet. The google sheet data is being used in another program that needs a unique id field.

Hi @wendybedell

You can try using this custom code snippet:

https://gist.github.com/wpmudev-sls/2360bd0cfafdbf1dc50e0f96caca398e

First, you’d need to add it as an MU plugin to the site:

– put the code into a new file with .php extension (e.g. “formiantor-submission-id.php”)
– upload the file to the “/wp-content/mu-plugins” folder of the site

Then add a “HTML” type field to the form and put

{submission_id} in it.

and update the form. The HTML field will be visible (but not editable) but you can hide it with CSS too if needed.

Best regards,
Adam

Hello @wendybedell ,

We haven’t heard from you for some time now, so it looks like you don’t need our assistance anymore.

Feel free to re-open this ticket if needed.

Kind regards
Kasia

Hello supports,

I tried your solution with the mu plugin and .php file upload but it did not worked for me. I would like to ask, this solution only works with the Forminator PRO or I just messed up something? I’m currently using the free version.

Thank you for your answer!

Best regards.

Hello @szilveszterg !

I’m sorry to hear that the snippet we shared didn’t work for you. Can you share some additional details as to what happened after adding it? Were there any error messages etc.?

The snippet doesn’t require the Pro version to work as it’s not relying on any of the Pro features.

Warm regards,
Pawel

Hello @wpmudev-support9!

So after integrating your solution, I just added a HTML type field to my form and put the {submission-id} into it. In the confirmation email I added the {html-1} tag which works fine because I got the ID number in the email. But my problem is that in the submissions that ID (HTML type field with the submission-id) did not appear at all like the other fields (ex. name, email etc.).

Is that possible to that HTML field which contain the {submission-id} tag will appear in the submissions as a data field, like the others? So when I export my submissions the id will be there too?

Of course in the submissions there are all of the IDs in the first column, but I want to export that IDs too like the other data. That is why I’m trying this solution.

Thank you for your answer!

Best regards.

Hi @szilveszterg

Per forum rules, we don’t spam the thread starter, could you please create a new ticket for this and we can take a deeper look for you?

Best Regards
Patrick Freitas