Page History

ConfiForms (FormView) Registrations Control

restrictions	sash
embedded	true

Info

This form tracks the who has changed the data and when, and this is done conditionally, when the field is checked

Also, it shows how to set the date to be in the future from now - Due date is set automatically to +14 days from now

ConfiForms Form Definition

formName	myform

chWill save the user and timestamp when checkedcheckeduncheckedcheckbox

dueDateDate duedate

changedByChanged Byhidden

changedWhenChanged whennumberhidden

*dueDateHide field

dueDate=([now]+1209600000)Set value

ch:truetrueCreate ConfiForms EntryonCreatedentryId=[entry.id]&changedBy=[entry._user]&changedWhen=[entry._now]

ch:truetrueCreate ConfiForms EntryonModifiedentryId=[entry.id]&changedBy=[entry._user]&changedWhen=[entry._now]

Show all

ConfiForms TableView

formName	myform

ch

created

dueDate

changedBy

changedWhen.formatDate(MM.dd.yyyy hh:mm)

Default formatchangedWhen.formatDate()

Show only checked

ConfiForms TableView

filter	ch:true
formName	myform

dueDate

changedBy

changedWhen.formatDate(MM.dd.yyyy hh:mm)

Expand

title	Source code (storage format) for the solution

Code Block

 <ac:structured-macro ac:macro-id="8c230925-7190-4fec-9e13-53374d1278c8" ac:name="confiform-entry-register" ac:schema-version="1">
  <ac:parameter ac:name="embedded">true</ac:parameter>
  <ac:rich-text-body>
    <p> </p>
  </ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="f03b88e5-25e3-48cc-92f6-5c49618c25b4" ac:name="info" ac:schema-version="1">
  <ac:rich-text-body>
    <p>Due date is set automatically to +14 days from now</p>
  </ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="05842fc3-7766-463b-89d0-1ac5d5c7a641" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">myform1</ac:parameter>
  <ac:rich-text-body>
    <p> </p>
    <p>
      <ac:structured-macro ac:macro-id="3bb15f25-2e72-4be4-b7bf-8dde9da46168" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">ch</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Will save the user and timestamp when checked</ac:parameter>
        <ac:parameter ac:name="values">checked</ac:parameter>
        <ac:parameter ac:name="extras">unchecked</ac:parameter>
        <ac:parameter ac:name="type">checkbox</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="820cdd17-2f35-4e9b-a81d-eeacdaa7bc10" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">dueDate</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Date due</ac:parameter>
        <ac:parameter ac:name="type">date</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="eff0e8ed-03bf-4b79-acb4-80fa3c8fb75d" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">changedBy</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Changed By</ac:parameter>
        <ac:parameter ac:name="type">hidden</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="f10890e4-4849-459c-9bc7-2df56752b3ef" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">changedWhen</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Changed when</ac:parameter>
        <ac:parameter ac:name="type">numberhidden</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="5d6b4a43-eb05-4444-b209-b55bc18acca9" ac:name="confiform-field-definition-rules" ac:schema-version="1">
        <ac:parameter ac:name="condition">*</ac:parameter>
        <ac:parameter ac:name="fieldName">dueDate</ac:parameter>
        <ac:parameter ac:name="action">Hide field</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="029ae962-c72c-44b0-a280-0756bde8f346" ac:name="confiform-field-definition-rules" ac:schema-version="1">
        <ac:parameter ac:name="values">dueDate=([now]+1209600000)</ac:parameter>
        <ac:parameter ac:name="action">Set value</ac:parameter>
      </ac:structured-macro>
    </p>
    <ac:structured-macro ac:macro-id="1feca7a0-90b7-4f10-b75f-8a543497ef1b" ac:name="confiform-ifttt" ac:schema-version="1">
      <ac:parameter ac:name="condition">ch:true</ac:parameter>
      <ac:parameter ac:name="extras3">true</ac:parameter>
      <ac:parameter ac:name="action">Create ConfiForms Entry</ac:parameter>
      <ac:parameter ac:name="event">onCreated</ac:parameter>
      <ac:parameter ac:name="title">entryId=[entry.id]&amp;changedBy=[entry._user]&amp;changedWhen=[entry._now]</ac:parameter>
      <ac:rich-text-body>
        <p> </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="7bab024d-1ec5-4d06-9608-30d699c83c19" ac:name="confiform-ifttt" ac:schema-version="1">
      <ac:parameter ac:name="condition">ch:true</ac:parameter>
      <ac:parameter ac:name="extras3">true</ac:parameter>
      <ac:parameter ac:name="action">Create ConfiForms Entry</ac:parameter>
      <ac:parameter ac:name="event">onModified</ac:parameter>
      <ac:parameter ac:name="title">entryId=[entry.id]&amp;changedBy=[entry._user]&amp;changedWhen=[entry._now]</ac:parameter>
      <ac:rich-text-body>
        <p> </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
<p>Show all</p>
<ac:structured-macro ac:macro-id="1df0d59c-8a07-48b5-a76a-692a127eab0f" ac:name="confiform-table" ac:schema-version="1">
  <ac:parameter ac:name="formName">myform</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="cccd8c4d-8aa9-4d7d-9f12-dbb186b57a56" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">ch</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="97380888-791d-4116-b3e6-1f529c7922a3" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">created</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="7cf82a36-c221-49a7-806b-de86c619c8d5" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">dueDate</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="57c8ec8b-d3ba-48e5-a31c-2d45415e356a" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">changedBy</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="e48ea4a8-f6e9-4e7b-b754-5c5f94780d18" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">changedWhen.formatDate(MM.dd.yyyy hh:mm)</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="4c20e02f-b9ed-4566-ab25-af59e7d88ea1" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="overrideLabel">Default format</ac:parameter>
        <ac:parameter ac:name="fieldName">changedWhen.formatDate()</ac:parameter>
      </ac:structured-macro>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p>Show only checked</p>
<ac:structured-macro ac:macro-id="6cf4341c-e3f2-4c60-aab5-c57b32c6592c" ac:name="confiform-table" ac:schema-version="1">
  <ac:parameter ac:name="filter">ch:true</ac:parameter>
  <ac:parameter ac:name="formName">myform</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="d4a0671a-3e12-4059-8b6c-e4d66a6953ec" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">dueDate</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="b42642ea-80aa-4933-9cce-bc44210a3bcc" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">changedBy</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="885f6a63-c4e6-41c9-bf33-e645a9a4c96d" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">changedWhen.formatDate(MM.dd.yyyy hh:mm)</ac:parameter>
      </ac:structured-macro>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>

Versions Compared

Old Version 19

New Version 20

Key