How do I link a pre-assigned Unique ID number from my database via notification email on paid submission?

I know I can export data from form submissions via spreadsheet CSV, but I want to do this the other way round:

I have a database of sales targets on File Maker Pro.

Each list entry has a unique ID Number.

I want to assign this ID Number of the targeted person/entry from my database on submission of a related payment form.

How do I do this?

Hi,

I'm not sure if I understood it correctly. Did you meant you want to assign specific IDs to specific form submissions and make a notification again? You can do this by editing the submissions, you can follow the screenshot below.

1. Naviget to My Forms->Choose a form->Click the Submissions page.

2. In the submissions page, click the gear icon to check the settings. My ID field is hidden and does not have a value. To assign an ID to the submission, you can click the "Edit" button.

3. You are now in Edit mode. I'll add mine a custom ID, after that, I then click the submit button.

4. I then receive a notification with the update value, this includes the hidden ID field with the custom value I added.

I'm not sure if this is what you are looking for, but I hope this gives you an idea or at least helps you proceed on how to build your form. If you need more assistance on this, feel free to get back to us.

Thank you.

Hi Charlie

This means I would have to allocate the ID number manually after the form submission has been received.

For example:

You are on my database of targets I am trying to get to sign up to 007 already and your entry on my database has the ID 000007

You decide that you want to become a member of MI5 and complete my Jotform MI5 Member payment form.

You automatically receive a notification email thanking you for becoming a Member and assigning you the Unique Membership Number

ID 000007

Without anyone editing the submission.

Is that possible?

Hi,

Can you please do a step-by-step process on how your system or process works?

This is how I see it:

1. I'm registered to your Sales Target, example I have an ID of 007.

2. I decided I want to become a member of MI5 and I will complete the form MI5 Member Payment Form.

3. How to you let your users complete the form? Do you send the form URL via Email? If yes, you can do the following to assign an ID

3.A Display the Properties field of the ID field. Under the Field Details, get the name of the field. In our case it's id.

3.B Get the Form URL of your form.

3.C Add the Form URL + Field Name + Value of the ID. You can try the sample link I have below.

http://form.jotformpro.com/form/43413322132944?id=007 

Blue highlight: Form URL of your Form

Pink highlight: the name of the field we see in it's properties and 007 is the value we want our user to have in it's submission.

You can then send the link via email to specific people who wants to complete your MI5 Payment/Registration Form.

You can find a guide about that here: http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters

Let me know if this helps.

Thank you.

Hi

Thank you for trying to help me on this, however, I think I'll have to do it manually as the form is on a website not sent out via email.

Oh. So it would actually be more difficult to assign existing IDs to users that will complete your form in your website. It could be possible if you setup a PHP or script code to fetch data (IDs) from your database then prepopulate them in your Form, but if you would like to do this you will need to embed and edit the actual Form's source code. This, however, will be quite technical and needs programming and setting up.

I hope this helps or at least gives you an idea on how to proceed. Let us know if you have another solution in mind and needs assistance on that, we'll try our best to help.

Thank you.

Hi Charlie

If you can give me instructions on how to do that, I would be eternally grateful.

Would it be an idea to place the database as a spreadsheet in Google Drive to fetch the data?

Would this be secure enough?

Thanks

Hi,

Unfortunately, it would be hard to give detailed instructions on how to do it as this will depend on how you setup your website.

Also, I'm not sure how you assign them, is it based from the existing email address that the user has?

I have a sample form here: http://form.jotformpro.com/form/43423951656964

Here's the condition that I have. If the user inputs an email user1@email.com, it means that he is already in my database, the condition then will automatically insert ID 12345 in the ID field.

For the spreadsheet in Google Drive, I'm not sure if there's a way to fetch those data back to the form when it's live, not to my personal knowledge though.

Regards.