TEST : Tracking user and last updated time

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

Show all

Will save the user and timestamp when checked

Created timestamp

Date due

Changed By

Changed when

Default format

unchecked May 14, 2019 13:26 May 28, 2019
checked May 14, 2019 13:26 May 28, 2019 sash 05.14.2019 01:26 May 14, 2019 13:26

Show only checked

Date due

Changed By

Changed when

May 28, 2019 sash 05.14.2019 01:26




Source code (storage format) for the solution
 <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>