SIGN UP

Missing data in Google Sheets

By: Gerry Bolger | Asked: 04/07/2023
Forums › Category: General questions › Missing data in Google Sheets
0 Vote Up Vote Down
Gerry Bolger asked 2 years ago
Hi all I have a form working well, and the workflow is once completed it sends the data to Google Sheets. However all the data is flowing except for these fields Timestamp Last Updated Created By Updated By Draft IP ID Key   Any idea how to ensure they get captures, especially the Timestamp and the IP address as we want to ensure we don't get duplicates Many thanks
Gerry Bolger replied 2 years ago

Thank you

1 Answers
0 Vote Up Vote Down
Victor Font answered 2 years ago

Those fields are not captured in the form, but added to the wp_frm_items when the entry is written to the database. If you want those details transferred to a google sheet, the fields need to be captured in the form entry as metadata so they're available to the Google sheets action. To do that, create hidden fields and populate them with custom code.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right