Support is currently limited. Click here to see our hours of operation.
Help Desk

Record an update to a form

Labels

This Ticket is public

Notifications

I have a form used to evaluate compliance with safety requirements. What I would like to be able to do is create a view that displays where we have not complied, and in that view have a link which allows me to click it changing it from non compliant to compliant, but it needs to record when this was done and preferably by who.

For example:

I test the fire alarm and find it is not working. The view (which I have already created) shows that this particular alarm is not working. In the view I would like a link that I can click when the alarm has been fixed and it changes an entry from not working to working.

I thought of using the shortcode: [frm-entry-update-field id=x field_id=y value="new value"] but this changes the entry, but does not record when it changed, so if one simply looks at the view, I see the alarm is working, not the fact that it was not working and has been fixed.

Any suggestions as to how I can create a way to 'tick off' on compliant issues that have been corrected easily from the front end view?


Attachment:

Hello!

First, you'll want to use this hook: https://formidableforms.com/knowledgebase/frm_setup_edit_fields_vars/#kb-set-field-value-when-editing
this will allow you to set a value in a field when editing. You can use this to set two values in the form--the User Name (taken from global variable User ID) and insert the timestamp of when the entry was updated as well. This will require a bit of customization from your part.

For the second part, you'll need to set up a method of front-end editing for this form. You could allow your view to be edited in place if you'd like. If you did this, I would recommend adding two fields to your view after the "Okay/Not Okay" field: Approved By, and Time Approved or something along those lines.

Would that work for you?

Ticket closed.