Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
ConfiForms (FormView) Registrations Control
restrictionssash
embeddedtrue

 


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 -

Info

Due date is set automatically to +14 days from now

 
ConfiForms Form Definition
formNamemyform


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=[now]

 

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

 

Show all

ConfiForms TableView
formNamemyform

ch

created

dueDate

changedBy

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

Default formatchangedWhen.formatDate()

...

ConfiForms TableView
filterch:true
formNamemyform

dueDate

changedBy

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

 

 

...




Expand
titleSource 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>