Missing data in Google Sheets

By: Gerry Bolger | Asked: 04/07/2023
ForumsCategory: General questionsMissing data in Google Sheets
Gerry Bolger asked 1 year 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 1 year ago

Thank you

1 Answers
Victor Font answered 1 year 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