ID numbers of requests

Hi Bob!

I work with chronoforms but i want to upgrade my form. Need to add in the form the function which gives to the users ID number of their requests, also the current status of their request. I found something like this in the other site. So could you please be so kind and explain me how to make this function through chronoforms v5

Thanks in advance,

Diyora

Hi Diyora,

If you save the query to a database table then you can update the record there with the current status and have a form that will read and show the status for a particular record.

The simplest way to do this is to use the record ID from the table - but this is not very secure, IMHO it is better to assign a unique random string to each record and use that.

The record ID is available in the form data after the record is saved / I have a custom Action that will create a short random ID string.

Bob

Don't you have the tutorial of this theme?

And where I can find a custom Action that will create a short random ID string.?

Thanks for any help..it's apreciated

Hi uzb_89,

Sorry, there is no tutorial for this, but it is quite simple if you take it step-by-step.

I have sent you a PM with a link for the Unique ID action.

Bob

Hi Bob!

Thank you for the sent link, i installed it to my form
it seems this is what I was looking for

But i have no idea about it's applying
Could you please explain me how to use it, where exactly in the form setup this action should be used? And a few words about it's editing

Thanks,
Diyora

Hi Diyora,

Please drag a copy of the action into the On Submit event of your form and drag it up after any validation actions and before any Email or DB Save actions. The click the Edit icon and check the Help there.

Bob

Hi Bob,
I followed your instructions and added Unique ID action into the Submit event after DB Save action, before Email, and drag it in the end of On Submit event. Then I tried to test my form...But after all these steps the site gave me the message with 1054 error...please tell me where i did mistake

Thank you,

Diyora

Hi Diyora,

What exactly is the error message you get?

Bob

Hi Bob!

here's the screenshot of the page with error

Hi uzb_89,

That's pretty clear - there is no 'unique_id' column in the table - have you added one, or used a different column name?

Bob