TEST
Page tree
Skip to end of metadata
Go to start of metadata

Playground and DEMO space

This is a playground and demo space for ConfiForms and ConfiDoc addons developed and supported by Vertuna LLC

Most pages provide a storage format for the demo, so you can use the free add-on from Atlassian Confluence Source Editor to import this configuration into your Confluence and see it in action

Please note, all the examples here are provided without any obligation and may or may not be incomplete or may have bugs, and we provide NO SUPPORT for these examples and demos.


In this demo we show how to work with dates and calculate an interval between 2 given dates


Dates registered

d1

d2
Apr 03, 2019 Apr 04, 2019
Apr 04, 2019 Apr 29, 2019
Apr 02, 2019 Apr 02, 2019
May 14, 2019 May 16, 2019
Jan 01, 2019 Mar 31, 2019
Apr 01, 2019 Jun 30, 2019
Jul 01, 2019 Sep 30, 2019
Oct 01, 2019 Dec 31, 2019
May 10, 2019 May 18, 2019
May 22, 2019 Jun 29, 2019
May 24, 2019 May 25, 2019
May 01, 2019 May 23, 2019
Aug 18, 2018 Aug 18, 2019
Jun 08, 2019 Jun 11, 2019
Jun 05, 2019 Jun 29, 2019
Jul 08, 2019 Jul 17, 2019
Jul 11, 2019 Jul 20, 2019
Aug 06, 2019 Aug 10, 2019
Aug 23, 2019 Aug 30, 2019
Aug 01, 2019 Aug 06, 2019
Aug 21, 2019 Aug 23, 2019
Sep 03, 2019 Sep 10, 2019
Sep 11, 2019 Sep 27, 2019
Oct 01, 2019 Oct 02, 2019
Oct 01, 2019 Oct 05, 2019
Nov 06, 2019 Nov 16, 2019
Dec 05, 2019 Dec 12, 2019
Dec 14, 2019 Dec 28, 2019
Jan 13, 2020 Jan 25, 2020
Feb 14, 2020 Feb 21, 2020
Feb 18, 2020 Feb 19, 2020
Feb 19, 2020 Feb 21, 2020
Mar 18, 2020 Mar 19, 2020
Mar 02, 2020 Mar 29, 2020
Mar 21, 2020 Mar 28, 2020
Apr 02, 2020 Apr 03, 2020
Apr 08, 2020 Apr 10, 2020
Apr 02, 2019 Apr 10, 2019
May 07, 2020 May 28, 2020
May 01, 2020 May 30, 2020
Jun 22, 2020 Jun 24, 2020
Apr 27, 2020 Aug 07, 2020
Apr 03, 2019 Jul 04, 2020
Aug 05, 2020 Aug 06, 2020
Aug 14, 2020 Aug 21, 2020
Jan 27, 1980 Sep 02, 2020
Nov 25, 2020 Nov 26, 2020
Dec 01, 2020 Dec 18, 2020
Dec 02, 2020 Dec 18, 2020
Dec 04, 2020 Dec 04, 2020
Dec 02, 2020 Jan 08, 2021
Jan 05, 2021 Jan 26, 2021
Feb 12, 2021 Mar 12, 2021
Feb 18, 2021 Feb 19, 2021
Feb 16, 2021 Feb 17, 2021
Mar 29, 2021 Mar 31, 2021
Mar 15, 2021 Mar 30, 2021
Apr 10, 2021 Apr 17, 2021
Apr 22, 2021 Apr 25, 2021
May 05, 2021 May 12, 2021
May 05, 2021 May 06, 2021
May 06, 2021 May 13, 2021
May 03, 2021 May 06, 2021
May 10, 2021 May 21, 2021
May 29, 2021 Jun 05, 2021
May 31, 2021 May 31, 2021
Jun 02, 2021 Jun 10, 2021


Dates with interval calculated (In TableViewMerger)

d1

d2

interval
Apr 03, 2019 Apr 04, 2019 1
Apr 04, 2019 Apr 29, 2019 25
Apr 02, 2019 Apr 02, 2019 0
May 14, 2019 May 16, 2019 2
Jan 01, 2019 Mar 31, 2019 88.95833333333333
Apr 01, 2019 Jun 30, 2019 90
Jul 01, 2019 Sep 30, 2019 91
Oct 01, 2019 Dec 31, 2019 91.04166666666667
May 10, 2019 May 18, 2019 8
May 22, 2019 Jun 29, 2019 38
May 24, 2019 May 25, 2019 1
May 01, 2019 May 23, 2019 22
Aug 18, 2018 Aug 18, 2019 365
Jun 08, 2019 Jun 11, 2019 3
Jun 05, 2019 Jun 29, 2019 24
Jul 08, 2019 Jul 17, 2019 9
Jul 11, 2019 Jul 20, 2019 9
Aug 06, 2019 Aug 10, 2019 4
Aug 23, 2019 Aug 30, 2019 7
Aug 01, 2019 Aug 06, 2019 5
Aug 21, 2019 Aug 23, 2019 2
Sep 03, 2019 Sep 10, 2019 7
Sep 11, 2019 Sep 27, 2019 16
Oct 01, 2019 Oct 02, 2019 1
Oct 01, 2019 Oct 05, 2019 4
Nov 06, 2019 Nov 16, 2019 10
Dec 05, 2019 Dec 12, 2019 7
Dec 14, 2019 Dec 28, 2019 14
Jan 13, 2020 Jan 25, 2020 12
Feb 14, 2020 Feb 21, 2020 7
Feb 18, 2020 Feb 19, 2020 1
Feb 19, 2020 Feb 21, 2020 2
Mar 18, 2020 Mar 19, 2020 1
Mar 02, 2020 Mar 29, 2020 26.95833333333333
Mar 21, 2020 Mar 28, 2020 7
Apr 02, 2020 Apr 03, 2020 1
Apr 08, 2020 Apr 10, 2020 2
Apr 02, 2019 Apr 10, 2019 8
May 07, 2020 May 28, 2020 21
May 01, 2020 May 30, 2020 29
Jun 22, 2020 Jun 24, 2020 2
Apr 27, 2020 Aug 07, 2020 102
Apr 03, 2019 Jul 04, 2020 458
Aug 05, 2020 Aug 06, 2020 1
Aug 14, 2020 Aug 21, 2020 7
Jan 27, 1980 Sep 02, 2020 14829
Nov 25, 2020 Nov 26, 2020 1
Dec 01, 2020 Dec 18, 2020 17
Dec 02, 2020 Dec 18, 2020 16
Dec 04, 2020 Dec 04, 2020 0
Dec 02, 2020 Jan 08, 2021 37
Jan 05, 2021 Jan 26, 2021 21
Feb 12, 2021 Mar 12, 2021 28
Feb 18, 2021 Feb 19, 2021 1
Feb 16, 2021 Feb 17, 2021 1
Mar 29, 2021 Mar 31, 2021 2
Mar 15, 2021 Mar 30, 2021 14.95833333333333
Apr 10, 2021 Apr 17, 2021 7
Apr 22, 2021 Apr 25, 2021 3
May 05, 2021 May 12, 2021 7
May 05, 2021 May 06, 2021 1
May 06, 2021 May 13, 2021 7
May 03, 2021 May 06, 2021 3
May 10, 2021 May 21, 2021 11
May 29, 2021 Jun 05, 2021 7
May 31, 2021 May 31, 2021 0
Jun 02, 2021 Jun 10, 2021 8


Same calculation using ValueView for each row

1

25

0

2

88.95833333333333

90

91

91.04166666666667

8

38

1

22

365

3

24

9

9

4

7

5

2

7

16

1

4

10

7

14

12

7

1

2

1

26.95833333333333

7

1

2

8

21

29

2

102

458

1

7

14829

1

17

16

0

37

21

28

1

1

2

14.95833333333333

7

3

7

1

7

3

11

7

0

8



<p>In this demo we show how to work with dates and calculate an interval between 2 given dates</p>
<ac:structured-macro ac:macro-id="da3fc550-ce75-47a6-8c08-719c3a763c53" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">myform1</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="d37d4019-4258-423e-a2b3-869dfd592f5b" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">d1</ac:parameter>
        <ac:parameter ac:name="fieldLabel">d1</ac:parameter>
        <ac:parameter ac:name="type">date</ac:parameter>
        <ac:parameter ac:name="required">true</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="4675557b-f3bc-419a-9da7-4fdbd119993a" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">d2</ac:parameter>
        <ac:parameter ac:name="fieldLabel">d2</ac:parameter>
        <ac:parameter ac:name="type">date</ac:parameter>
        <ac:parameter ac:name="required">true</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="de897a81-2ad9-43b5-9963-b9af7ff82d6b" ac:name="confiform-field-definition-rules" ac:schema-version="1">
        <ac:parameter ac:name="condition">d2.timestamp:<[entry.d1.timestamp]</ac:parameter>
        <ac:parameter ac:name="fieldName">Date 2 shall be after the date 1</ac:parameter>
        <ac:parameter ac:name="action">Validation rule</ac:parameter>
      </ac:structured-macro>
    </p>
    <ac:structured-macro ac:macro-id="8113db66-54be-48cc-a860-b854975f43a1" ac:name="confiform-entry-register" ac:schema-version="1">
      <ac:parameter ac:name="embedded">true</ac:parameter>
      <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>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <br/>
</p>
<h2>Dates registered</h2>
<ac:structured-macro ac:macro-id="1573f180-b0d8-40b2-ae70-caa2bb6272e6" ac:name="confiform-table" ac:schema-version="1">
  <ac:parameter ac:name="formName">myform1</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="d0d2cbf5-4b8c-423b-aa82-7b2846df6265" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">d1</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="06f0d811-d291-4c84-8c4a-8634f8f1ff61" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">d2</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <br/>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <br/>
</p>
<h2>Dates with interval calculated (In TableViewMerger)</h2>
<ac:structured-macro ac:macro-id="7294e9e3-2708-482a-b9de-9a8bd12aa94e" ac:name="confiform-table-merger" ac:schema-version="1">
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="d066fb57-10cb-4a4b-9491-6573974c28be" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="hideIfEmpty">true</ac:parameter>
        <ac:parameter ac:name="fieldName">id</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="d8f3e1b5-f723-4e5c-8e34-eada35165616" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">d1</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="1950633a-1deb-4611-8ce8-fade96ee9f23" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">d2</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="12c8e4da-2cf8-4c81-8835-0e984a3f06e3" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">interval:(([entry.d2.timestamp] - [entry.d1.timestamp])/86400000)</ac:parameter>
      </ac:structured-macro>
    </p>
    <ac:structured-macro ac:macro-id="ee5b80a2-006e-4cae-bec0-8d5f7fa029fd" ac:name="confiform-table" ac:schema-version="1">
      <ac:parameter ac:name="formName">myform1</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br/>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <br/>
</p>
<h2>Same calculation using ValueView for each row</h2>
<ac:structured-macro ac:macro-id="b3a1f171-b0f2-428d-9a74-4a0a3320b957" ac:name="confiform-list" ac:schema-version="1">
  <ac:parameter ac:name="formName">myform1</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="29960d37-f82b-43f9-93df-a4d024b5f9c1" ac:name="confiform-value" ac:schema-version="1">
        <ac:parameter ac:name="filter">id:[entry.id]</ac:parameter>
        <ac:parameter ac:name="fieldName">interval:(([entry.d2.timestamp] - [entry.d1.timestamp])/86400000)</ac:parameter>
        <ac:parameter ac:name="formName">myform1</ac:parameter>
      </ac:structured-macro>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <br/>
</p>
<p>
  <br/>
</p>
<p>
  <br/>
</p>
<p>
  <br/>
</p>
<p>
  <br/>
</p>
<p>
  <br/>
</p>







  • No labels