It seems that I can't Unique ID [gh] works fine

How to fix a ChronoForms Unique ID action not saving to the database.

Overview

The issue was caused by using a TEXT column type for the ID field, which may have been incompatible, and potentially by cached form settings.
Change the database column type to VARCHAR(8) and clear the form cache in the CF manager.

Answered
ChronoForms v5
dh dhuizinga1 16 Apr, 2017
First of all thnx to Bob for sending me the action Unique ID [GH]. I've installed it succesfully.

It seems that I can't Unique ID [gh]  works fine  image 1

In a little testdatabse i made a new table with the name "uniek_kenmerk".

It seems that I can't Unique ID [gh]  works fine  image 2


In the setup tab at the submit section I add the [GH] Action'

It seems that I can't Unique ID [gh]  works fine  image 3

It seems that I can't Unique ID [gh]  works fine  image 4

And guess??? Nothing seems to happen. Nothing (uniek_kenmerk) will stored at the database table.
see DB Viewer

It seems that I can't Unique ID [gh]  works fine  image 5


I kno, i know.. somewhere i made a mistake... but I can't figure it out where this is...who can tell me what i'm doing wrong...

thanx in advance
dirk
Gr GreyHead 16 Apr, 2017
Answer
Hi Dirk,

The settings look correct (though you don't need a TEXT column for the ID, VARCHAR(8) is enough).

Please click the Delete Cache icon in the Forms Manager Toolbar to update any cached settings that CF has saved.

And, Please drag a Debugger action into the On Submit event, then submit the form - the Debugger output should show you the id being created and the DB Save MySQL query.

Bob
dh dhuizinga1 16 Apr, 2017
Thnx

Bob... I changed te colum into VARCHAR and delete the cache.. and now it will be stored..

i don't get it.. but it's works.. and that's important....

now can i complete the form further...

topic may be closed
This topic is locked and no more replies can be posted.