I currently don't have the registration add on installed I would have to upgrade my plan. So I have used the default value short codes which pulls the user who initially submits the form into a field. But I could not get it to work when a different user goes in and edits a form on the front end. would either the default value shortcodes or the user_meta work for this?
Default values fire when an entry is created, not edited. If you look at Formidable's Database schema, you'll see that it stores entry ids for both the original creator and the last person to edit the entry in the frm_items table. The frm_items table is the entry's header record.
All other form data is metadata stored in the frm_item_metas table, where each entry field's value is one table row. If you have 10 fields on a form and all 10 fields have values submitted, there will be 10 rows for that entry. Formidable does not store metadata records for fields without a default value that have not been populated by an end user.
Your approach could work assuming the user is logged in when the form displays. The hook you want to use, frm_setup_edit_fields_vars, fires before the form hits the browser, so you can update the field values before they are sent to the browser. When the submit button is clicked, Formidable will update the updated_by field in the database and your hidden fields will be stored as metadata.
here's the database schema: https://formidableforms.com/knowledgebase/database-schema/
Please login or Register to submit your answer