Forums

Dear

good afternoon

I am creating a form of complaints and I have a problem

The form must have a unique code so I created a script for it using the " Custom Element " , but I need the value it returns me to be placed on a table .

I noticed that when trying to create a new table appear the existing fields in the form minus the " Custom Element " .

The same situation occurs when the email is sent to the administrator , for, as the code is based on the date , minute, and second , when you click submit , the script runs again and the code that arrives to the administrator is different from that presented in screen before submitting the form .

Below is the code :

< ? php
     / / Echo uniqid ( ) , '<br />' ;
     $ year = substr ( date (' Y' ) , 3,1 ) ;
     $ month = substr ( date (' m ' ) , 1,1) ;
     $ day = date (' d ' ) ;
     $ hour = substr ( date (' H ' ) , 1,1) ;
     $ min = substr ( date (' i ' ) , 1,1) ;
     $ sec = date (' s' ) ;
    
    echo " <p> <centre> color='#ffffff'> _ < / font > < / p > " ;
    echo $ year $ month $ day $ hour $ min $ sec . ;
>

I do not know if I explained well .
What I really need is that my form submit a unique code and that for each user , a new code is generated .

This same code needs to be entered in the table and be properly sent to the administrator .

In await .
Grateful.

Anybody?

Please!!!!

Hi tigshpn,

Please see this FAQ

Bob

Thank's again

I read de FAQ but I still confuse about somethings,

Let's try do diferent:

The cf_id is a unique data?
Maybe can be a good idea show de cf_id to client in Thanks Message.

Example:
"Your form was submitted successfully, please write down your serial protocol (cf_id)"

Is it possible?

If Yes, How can I send this information to admin email too?

The site with form: http://www.portalsupimpa.com.br/site/new/index.php/ouvidoria

Thank's again

Hi tigsphn,

The cf_id is the record identifier in the database 1, 2, 3, . . . it does uniquely identify the record saved. But it's not always a good idea to use it to share with users as it is easy to use it to guess what other ids are valid and that might be a security risk.

Yes it is possible to show the cf_id in a Thank You message; I think that the FAQ tells you now to get the value.

Bob

Hello GreyHead

I tried to use the Unique ID (GH) but had no success.

I noticed that there are 4 fields, my question is regarding the Table column, I tried to do the following:

I created a new table and she, by default now shows which fields will be written on it, right?

So I includes a new field called id_new_column (Figure print01).

I then changed the configuration of the DB Save and put the Unique ID (GH) on the submit area (Figure print02)

In the Settings area of the Unique ID (GH) in the field put id_new_column Table column as well as in Form Input Field (print03 figure)

I did a couple of tests with the form and then I analyze the database id_new_column but the field was empty.

Where am I going wrong? These steps are correct?

I have a similiar problem, that I cant get it how it works:) Is there any documenatation how to use this unique ID.

Actually I need this Unique ID to show in the form, so I cant put this action ON SUBMIT, but I need it ON LOAD. Than I need some visible input field, which will show this number anf after submitting the form I need to be saved in a DB and at the same time I need it to be send as MerchantOrderId to payment gateaway.

Could you please explain me how to do it ?


thanks, I´am hopeless

Hi,

@tigsphn: Well, you need to create the Unique ID before you try to save it to the Database table so the order of your actions needs to change. In order to check that the ID is unique it has to be saved in a table - typically as part of the same record as the other form data.

@scree23: If you have the Unique ID [GH] action installed please check the help tab; there is much more information there.

You can create a unique ID and show it in the form but it is much more complicated to do and probably isn't helpful. There will be many times that the form page is loaded but the form is not submitted; you will need to keep track of these 'wasted' IDs somehow and do some house-keeping to let them expire. It is much better to generate the ID after the form is submitted, then you can show it to the user in an email and/or the Thank you page.

Bob

How can I create the Unique ID before inserting it into the database if the settings for the Unique ID it asks all the database, including the name of the table column?

It makes sense to have at least one record written to be able to do the validation, that is, in fact, it would be necessary to create the Unique ID before but do not understand how this process is done

Please, could be a step by step or just an exemplification of this part?

Hi tigsphn,

. . . because in order to make sure that it is unique the action checks to make sure that it hasn't already been used. It does that by generating an id, then checking if it has been used. If it has, then it generates another id and tests again.

Bob

Okay, I get the concept.

But practically what that means?

Should I put the Unique ID without any configuration to the database and only after the form is submitted the first time, should I create a field in the database to connect the Unique ID?

The problem is that I am unable to see what practical to be done that I need procedure.

I explained some topics above step by step what I did and put up the images, so you mentioned that we need to generate the Unique ID before connecting to the database, but how do I do that?

Hi tigsphn,

Please stop and think this through. You have the Unique ID [GH] action, that will generate a unique ID for you after the form is submitted and before the data is saved to the database. Of course you need a column in the database table to save the ID.

Bob

Hi Bob, ok I get it it make a sense now.

In general, maybe I have a different problem. I need that user and form data are redirected to the payement gateaway jus after form submitting. For that case I need an unique number which could be an cf_id number from column in database.

I am using function ReDirect URL and ReDirect user and I really need that number from database is send to that gateaway.

Could you please tell me how to use that value of column and send it by function ReDirect URL?


There is more explanation:
http://resize.like.cz/images/213_168_186_238_11-12-13-11-40-56_13867584561.jpg
http://resize.like.cz/images/213_168_186_238_11-12-13-11-41-08_13867584682.jpg

thank you

Hi scree23,

Please check the FAQ I linked to in this earlier post here.

Bob

Thanks for information, I already checked this FAQ to see all the possibilities I have.

Into ReDirect URL I add a line for MerchantOrderId, which is send to the payment gateaway. Now I have this :

MerchantOrderId={$form->data['chronoform_data']['cf_id']}

But still have no success to see this number, when it redirect to gateaway, I can´t see MerchantOrderId value.

When I want to use this column cf_id in thanks message, or in e-mail. How I can define it?

Hi Scree23,

Please try MerchantOrderId={chronoform_data.cf_id}

And put {chronoform_data.cf_id} in the email

Bob

Hi Bob,

I have tried it but I still can´t see that number on payment gateaway. I can see Amount value there, I can see MicroAccountNumber (which is fixed) but I can´t load this important value from database CF_ID.


Just one idea I have, my table´s name is: ew23_chronoforms_data_nova_sim_cz_paysec

Could I use: {ew23_chronoforms_data_nova_sim_cz_paysec.cf_id} ??? Or something similiar, cause I have more tables in Chronoforms and every table using cf_id.

Do you have any other idea ? I´m sure I have function Save to database before function ReDirect URL.


thank you for reply

Hi scree23,

You can try that but I don't expect it to work; the more useful approach is to add a Debugger action to see exactly where the value you need it saved.

Bob

Finally I have it, thank you Bob. This debugger helps me a lot to find a real name of this database field. Sending you a printscreen, if someone needs to use CF_ID as unique number for online payments here we go.

Hi scree23,

I think that Sloan's answer is to an earlier post in the thread.

In general I advise against using the cf_id as an identifier - but it does depend on the application and may be fine. The potential problem is that if 98 is valid then probably 97 and 99 are as well and if they are used in any url, like a download link a malicious user could guess other valid urls and use them.

Bob

Hi, thanks for help by both of you guys. I don´t know where is really problem with syntax, only thing I know is that if I use syntax: MerchantOrderId={chronoform_data_cf_id} it is OK. It sends data to the payment gateaway. If I use some other syntax, it does nothing.

But I have another small problem I want to discuss, maybe it is so trivial I can´t figure it out. Maybe it is because we are so closed to holidays I can´t even logically think:)

But ... I have to tables in database which use CF_ID as unique number. What I want to do is to use prefix before CF_ID number to be sure to which table it belongs. For example one table will use prefix C + {chronoform_data_cf_id} and the other use S + {chronoform_data_cf_id}. I need to be saved in DB with this prefix and than it should be send to payment gateaway.

Do you have any idea how to add this prefix to CF_ID and save completely to one field in our database.

Thank you for your help

Thank for your reply.

First of all I will try to explain what is going on exactly. I have no problem to use simple CF_ID as unique identifier becasue it is unique untill you have two tables that generates CF_ID both the same way. It means when I want to verificate the payment using this CF_ID value there should be a conflict because I have two forms with same CF_ID value and I need to verificate both of them using the same method.

It should sound comlicated but it isn´t:) Just imagine you are redirecting two different forms to one payment gateaway. I can use different names for tables of course to be sure which payment belongs to which database. But than I have one script on BackURL adress which verificates the status of the payment, using CF_ID to call unique MerchantOrderId to generate YES this payment n.3 was successfull or not successfull. But what happens when number 3 is used in two different tables. Which table CF_ID I will verificate?

In this case I think not even the unique_ID application for Chronoforms will help. Because when I am using unique_ID this number origanilty could be verified just in one table complex. When I am using another table wich will generate another Unique_ID, there will be no option to verify it with other table.

I´am really thinking about possibility to use CF_UID as Unique number, because it is so long that possibility to be duplicated by another table is too small.

What do you think? It could be the way out?

thanks for reply

Hi again,

I really appriciate your help. I rode this topic 100 times and I still do not understand why it is so bad to use CF_ID as UniqueOrderNumber for payment gateaways.
It is because it´s so clear that number increases the values like 100,101,102 and if it´s like this, who will try to break in that account just because he knows this UniqueID. Or did I understood well, that there´s for security reasons, right?

I tried to use Bob´s application for unique ID but I never found some support documentation and than I decide for more simplicity.

Anyway, maybe I just figure it out how to use that simple CF_ID as identificator for both tables. And I want to try this.

The different values for CF_ID Autoincrement has to be set. For first table numbers began with value 1000 (for example: 1001,1002,1003) and for the other table We can start by 5000 (ex. 5001,5002,5003). I just do not know how to change the value for Autoincrement in Chronoforms tables. Could you help me with that please?

For future use maybe I will think about different Unique ID usage. But know I just need to be done till Christmas:)

Thanks again for any help.

Hi scree23,

By all means use the cf_uid, it is *almost' certain to be unique (there is no actual check, its just a random string). The problems are the obvious ones, that it is long and not human readable (which may not be a problem).

If you want to add a prefix to the cf_id record key then it may help to save it back to the table after it is used (not strictly necessary as long as you remember which prefix associates to which table).

I'd still recommend my Unique ID [GH] action - it is simple to either add a prefix to the ids or to change the template so that each form uses a different structure for the ID e.g. AAA999A, AA9999A AAAA9999, . . . Using it is very simple, add a column to your table to hold the ID, add the action to the form On Submit event, configure the action to point to the table and column (leave the Form Input box empty). Use the resulting ID as you need.

Bob

OK thanks for help I will do the best to make it functionall. You´re right about Unique ID [GH] action. Maybe I was just confused, now it seems to me more clear than before:)

Thank you, I appriciate your help.

Last problem guys:)

I succesfully added the action Unique ID [GH] on submit of the form. I added a field "order_id" into my database. When I submit the form I can see that Unique ID was succesfully saved into database under the field "order_id". Untill that moment everything works like a charm, but when I am sending data to payment gateaway through Redirect URL and I have the same value :

MerchantOrderId={chronoform_data_order_id}

It sends no value to payment gateaway !!! WTF
When I change "order_id" to other field for example cf_id it sends data from database.

For me, it seems to be similiar if I am sending first or last field from database with just different names. I check the name of field 100 times and can´t see no fuckin difference.

Anyway guys could you hellp me with that, zhat´s the last I want. Thanks

Hi scree32,

Please try

MerchantOrderId={order_id}

If in doubt about the name of a variable in the $form->data array (that where all these are stored) you can temporarily add Debugger action to your form to see the names and values.

Bob

Your syntax works like a charm. Thank you Bob, I think you are tired with all the questions We have. I am sorry everytime I forget to use debugger:) Now I know ... thanks

Sorry, I've been without internet for a few days

GreyHead.

About my situation, little miss.
See, I colequei Debbug one and saw that it is generating a Unique ID and putting on the field that I created in the table. (see image 01)

But when I select the table and click on Show Data, the field appears empty (see image 02)

I wonder what is missing

Hi tigshpn,

Please check that the Unique ID action is before the DB Save action in the On Submit event.

Bob

It worked perfectly!
Now it logs and displays the value in the database.

But a new problem arose:

first:

How I can send that code generated by the Unique ID by e-mail?

second:

I had to move my site to another server, apparently everything is working, however, I noticed that when selecting my form and click Show Data shows nothing, even creating a new database and connecting it to the DB and SAVE UNIQUE ID, the problem persists ,

The debug log shows that the field created for the UNIQUE ID is working, but when I try to verify the information entered into the table nothing appears.

This is connected with the server change? If I uninstall and intalar the ChronoForms will work again?

Below is the result of the debug

Data Array:
Array
(
[chronoform] => teste_ouvidoria
[event] => submit
[Itemid] => 321
[option] => com_chronoforms
[view] => form
[tipo_ocorrencia] => Dúvida
[assunto] => Notas Erradas
[relato] => Favor verificar minhas notas do 4ºBimestre
[responsavel_pedagogico] => Rodrigo Santana
[nome] => Charles Santana
[email] => [email]thiago.rcc@gmail.com[/email]
[turma] => 9ºA
[enviar_button] => Enviar
[96a5691b8b2b13308cd02806d03ce729] => 1
[cd_oc] => MQ7949L
[chronoform_data] => Array
(
[cf_uid] => 4ef689198add55ee28476a92aae69115
[cf_created] => 2013-12-19 16:55:43
[cf_created_by] => 0
[cf_ipaddress] => 177.34.87.97
[cf_user_id] => 0
[chronoform] => teste_ouvidoria
[event] => submit
[Itemid] => 321
[option] => com_chronoforms
[view] => form
[tipo_ocorrencia] => Dúvida
[assunto] => Notas Erradas
[relato] => Favor verificar minhas notas do 4ºBimestre
[responsavel_pedagogico] => Rodrigo Santana
[nome] => Charles Santana
[email] => [email]thiago.rcc@gmail.com[/email]
[turma] => 9ºA
[enviar_button] => Enviar
[96a5691b8b2b13308cd02806d03ce729] => 1
[cd_oc] => MQ7949L
[cf_id] => 4
)

[chronoform_data_cf_id] => 4
)
Validation Errors:
Array
(
)

Hi tigsphn,

To show the cd_oc value in the email add {cd_oc} to the template and make sure that the Email action is after the Unique ID [GH] action.

If you move servers you will probably need to re-set all of the database connections in your form, including the one in the Unique ID [GH] action.

Bob

I uninstalled and installed again and it worked ChronoForms also repositioned the elements and now everything is perfect.

Thank you for your patience and collaboration