Hi,
I’m trying to find the consent field description (by searching for the specific string) in phpmyadmin. The only results I get are from the form setting tables, but not inside the entry meta tables.
Where in the database can I find the data shown in the screenshot below? I’ve tried changing the description inside the form, but the text stayed the same inside the entry even after being changed in the form. This means that this description must be saved somewhere in the entry data.
Regards
Hi Marina. The version of the consent they agreed to when they submitted the form is stored in the entry (not the text of the consent itself.) For example, I have a consent field ID 3 in my form. In the wp_entry_meta table I have this record:
meta_key 3.3 stored the value 69, which is the revision of the consent field. If you check the wp_gf_form_revisions table, you will find a record with an id of 69:
There is also a record in the wp_gf_form_revisions table with an id of 68, which is the previous revision to this form where I edited the consent field. When that version of consent was visible in the form, I created entry 68335:
Let us know if you have any other questions.
Ho @chrishajer , thank you for the explanation. I’ve checked the revisions table and I think so only have 5 revision available out of 50. Is there a limit on the number of revisions? If so, what happens to the entry data that gets loaded from the older entries?
I think it would make more sense to save these consent descriptions as entry meta (let’s say as .4 in the database), so that it’s all at one place and easier to work with.
I ended up passing my description text to the consent label itself (the description is in a span tag inside the label), so that I can access it directly from the entry meta and easily use it elsewhere (backend and pdf exporting).
There is no limit to the number of revisions.
If you would like to suggest a change to the way the functionality for the Consent field works, I recommend adding a note to our product roadmap. Click the blue plus in the lower left on this page to add a note for our product team:
Thank you.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
