Child pages
  • Using generate next number IFTTT rule to have sequence numbers per day

This is the documentation for ConfiForms Server/Data Center app

However, this might also work for ConfiForms cloud and in most cases it does. But please see this page to understand the differences between server and cloud versions of the ConfiForms app.

Using "Generate next number" IFTTT action to have a sequence number running from 1 every day

See also Using generate next number IFTTT rule to see how "Generate next number" can be used

We have a very simple form with just one arbitrary field, let's say text and one hidden field to store sequence number


And particular configuration for the IFTTT rule is as follows


Where complete expression for the filter to use is as follows

created.formatDate(ddMMyyyy):[entry._now.formatDate(ddMMyyyy)]

Showing results

Text field

Sequence

Created

test 1 Oct 31, 2019 16:58
test on the same day 2 Oct 31, 2019 16:58
next day 1 Nov 01, 2019 10:27

Complete storage format for the form 

<ac:structured-macro ac:macro-id="227792ed-d6fa-4b9a-a0bb-eb97d8363683" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">myform1</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="9085ca4a-d4fa-4da8-80fa-c241e0998fc5" ac:name="confiform-entry-register" ac:schema-version="1">
      <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br/>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p>
      <ac:structured-macro ac:macro-id="435b917c-b8bb-41b7-a988-656b7eba3f53" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">text</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Text field</ac:parameter>
        <ac:parameter ac:name="type">text</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="6047480b-4c44-493e-ab4a-917a8397662a" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">seqNo</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Sequence</ac:parameter>
        <ac:parameter ac:name="type">numberhidden</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <br/>
    </p>
    <ac:structured-macro ac:macro-id="4abf63ca-029d-43a0-bcdd-9c209013d366" ac:name="confiform-ifttt" ac:schema-version="1">
      <ac:parameter ac:name="action">Generate next number</ac:parameter>
      <ac:parameter ac:name="event">onCreated</ac:parameter>
      <ac:parameter ac:name="title">seqNo</ac:parameter>
      <ac:parameter ac:name="extras2">created.formatDate(ddMMyyyy):[entry._now.formatDate(ddMMyyyy)]</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br/>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p>
      <br/>
    </p>
    <p>
      <br/>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
  • No labels