Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Create a Timestamp in ConfiForms when entry is modified

Christian Englbrecht March 11, 2024

Hello everybody!

 

I fail at getting a timestamp for the modification date. 

I have a field ddate (means doneDate) which is a date field. 

 

Now I put a IFTTT-Makro inside the form definition. 

Event: On Modified

Choose Action to perform: Create / Update Confiforms Entry

Parameters to set in the entry: entryId=[entry.id]&ddate=[entry._now]

 

If I modify anything in the Entry, nothing happens. What I'm doing wrong??

 

 

 

2 answers

1 accepted

0 votes
Answer accepted
Christian Englbrecht March 11, 2024

screen.jpg

scree1n.jpg

screeen.PNG

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 11, 2024

This all looks perfectly OK.

Tried the same - works well (changed to datetime field as this makes more sense to capture the timestamp)

http://recordit.co/KRlgxiABBl

<ac:structured-macro ac:macro-id="1519c863-1e4b-4374-9eae-6c8168efe59f" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">support</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="5e6db5df-e993-49c1-b11e-747d5f83fcb7" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<ac:structured-macro ac:macro-id="4e4f7558-8622-4a90-b581-55eb57608d90" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">summary</ac:parameter>
<ac:parameter ac:name="fieldLabel">Summary</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="5de888d2-a49d-472e-966d-1db9e6d0bd1c" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">ddate</ac:parameter>
<ac:parameter ac:name="fieldLabel">ddate</ac:parameter>
<ac:parameter ac:name="type">datetime</ac:parameter>
</ac:structured-macro> <ac:structured-macro ac:macro-id="71a18577-1cf3-44ab-8a35-16f03662528d" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="fieldName">ddate</ac:parameter>
<ac:parameter ac:name="action">Hide field</ac:parameter>
</ac:structured-macro>
</p>
<ac:structured-macro ac:macro-id="b2765180-c840-4a50-9261-207f5a3a99df" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="extras3">true</ac:parameter>
<ac:parameter ac:name="silent">true</ac:parameter>
<ac:parameter ac:name="extras4">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;ddate=[entry._now]</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="57e916af-42a4-4fd3-a426-37f02ff0e398" ac:name="confiform-card" ac:schema-version="1">
<ac:parameter ac:name="formName">support</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="35b3484b-f307-49cc-9fcc-2f1f8db63bd2" ac:name="confiform-entry-edit" ac:schema-version="1">
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>

 Alex

Christian Englbrecht March 11, 2024

Doesn't work here...

Is it possible, that it doesnt work because I do the edits on a separate Page within a TableView Macro with Edit controls?

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 11, 2024

No, it does not matter where do you do your edits

Christian Englbrecht March 11, 2024

Still not working. 

 

Found out, that the Modified Trigger doesn't work. Tried with "send mail". No response...

Any ideas?

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 11, 2024

Well, does the configuration I have shared with you works for you?

Alex

Christian Englbrecht March 11, 2024

I can't test it, because html macro is disabled by admins...

Christian Englbrecht March 11, 2024

Ok it works now. Theres one onModified IFFFT Makro more that is not on the picture (Send email). If both onModified Macros would be triggered, only one works. Now the ddate gets updated, but the email isn't sent. 

 

Maybe theres a conflict between those macros?

Christian Englbrecht March 11, 2024

Found a way to get the code....

 

<p class="auto-cursor-target"><ac:structured-macro ac:name="deny_comment" ac:schema-version="1" ac:macro-id="c2d1c2fc-bfab-49ae-b199-d5fa72b9fb7b" /></p><ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="d64183bf-aded-400c-8c71-bb38fbeebef0"><ac:parameter ac:name="hideAdminUI">true</ac:parameter><ac:parameter ac:name="formName">support</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="64a9e6b0-5898-4558-b03f-4d48371239d3"><ac:parameter ac:name="editRestrictions">sebastian.ilg@drv-bayernsued.de</ac:parameter><ac:parameter ac:name="fieldName">cdate</ac:parameter><ac:parameter ac:name="fieldLabel">Erstellt: </ac:parameter><ac:parameter ac:name="type">date</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="751f4c71-a154-49e1-a2df-c69ac6e6f7ff"><ac:parameter ac:name="editRestrictions">sebastian.ilg@drv-bayernsued.de</ac:parameter><ac:parameter ac:name="fieldName">ddate</ac:parameter><ac:parameter ac:name="fieldLabel">Abgeschlossen: </ac:parameter><ac:parameter ac:name="extracontext">false</ac:parameter><ac:parameter ac:name="type">date</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="3fd6154f-89cd-454f-a704-c5028acab114"><ac:parameter ac:name="editRestrictions">sebastian.ilg@drv-bayernsued.de,christian.englbrecht@drv-bayernsued.de</ac:parameter><ac:parameter ac:name="fieldName">status</ac:parameter><ac:parameter ac:name="fieldLabel">Status</ac:parameter><ac:parameter ac:name="values">false[error=offen|success=Erledigt|]</ac:parameter><ac:parameter ac:name="type">status</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="5c337162-a75f-490c-9203-62123f7be7f2"><ac:parameter ac:name="fieldName">name</ac:parameter><ac:parameter ac:name="fieldLabel">Vor- und Nachname oder E-Mail: </ac:parameter><ac:parameter ac:name="type">text</ac:parameter><ac:parameter ac:name="required">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="1e2a7890-0420-4a7d-8d77-8d13ba19d901"><ac:parameter ac:name="fieldName">phone</ac:parameter><ac:parameter ac:name="fieldLabel">Telefonnummer: </ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="fc85453d-309e-4caa-96a9-d713e97e3e3b"><ac:parameter ac:name="fieldName">type</ac:parameter><ac:parameter ac:name="fieldLabel">Art des Problems: </ac:parameter><ac:parameter ac:name="values">false[1=Confluence|2=GBWS|3=Windows|4=Hardware|5=andere Software|]</ac:parameter><ac:parameter ac:name="type">select</ac:parameter><ac:parameter ac:name="required">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="5a387f81-098f-40db-bc99-cb70d359a9ef"><ac:parameter ac:name="fieldName">title</ac:parameter><ac:parameter ac:name="fieldLabel">Problemstellung: </ac:parameter><ac:parameter ac:name="fieldDescription">Beschreiben Sie Ihr Problem in wenigen Schlagworten</ac:parameter><ac:parameter ac:name="type">text</ac:parameter><ac:parameter ac:name="required">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="6ef0ab4a-251a-43b9-a81e-128686f77f09"><ac:parameter ac:name="fieldName">explain</ac:parameter><ac:parameter ac:name="fieldLabel">Beschreiben Sie Ihr Problem:</ac:parameter><ac:parameter ac:name="type">textarea</ac:parameter><ac:parameter ac:name="required">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="d6efc77e-8d85-43e0-a5f4-563ec519378c"><ac:parameter ac:name="editRestrictions">sebastian.ilg@drv-bayernsued.de</ac:parameter><ac:parameter ac:name="fieldName">solution</ac:parameter><ac:parameter ac:name="fieldLabel">Problemlösung:</ac:parameter><ac:parameter ac:name="type">textarea</ac:parameter></ac:structured-macro></p>
<p><br /></p><ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" ac:macro-id="5b130928-d10d-4a66-a725-dfc44e5cc545"><ac:parameter ac:name="hideMetadata">true</ac:parameter><ac:parameter ac:name="overrideSaveButtonLabel">Speichern</ac:parameter><ac:parameter ac:name="formName">support</ac:parameter><ac:parameter ac:name="presetValues">status=error&amp;name=[entry._user.email]&amp;cdate=[now]</ac:parameter><ac:parameter ac:name="registrationButtonLabel">Abschicken</ac:parameter><ac:parameter ac:name="type">Embedded</ac:parameter><ac:parameter ac:name="confirmationMessage">Ihr Ticket wurde erstellt, Sie erhalten in Kürze eine Bestätigung per Mail.</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="d27f5142-fa56-4747-b6e4-011fe6c04b4a"><ac:parameter ac:name="extras3">true</ac:parameter><ac:parameter ac:name="silent">true</ac:parameter><ac:parameter ac:name="extras4">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;ddate=[entry._now]</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="c9288366-0958-4fc2-b24b-f4d1e3a50662"><ac:parameter ac:name="action">Send Email</ac:parameter><ac:parameter ac:name="event">onCreated</ac:parameter><ac:parameter ac:name="title">IT Support-Ticket [entry.id]: [entry.title]</ac:parameter><ac:parameter ac:name="who">[owner]</ac:parameter><ac:rich-text-body>
<p>Hallo [entry.name],</p>
<p><br /></p>
<p>Ihr Ticket wurde eröffnet:</p>
<p><br /></p>
<p><strong>Ticket-Nr:</strong> [entry.id]</p>
<p><strong>Titel:</strong> [entry.title]</p>
<p><strong>Problemstellung:</strong> [entry.explain]</p>
<p><br /></p>
<p>Ihr Ticket wird schnellstmöglich bearbeitet. </p>
<p><br /></p>
<p>Mit freundlichen Grüßen</p>
<p>IT</p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="7e2a2f0a-1cdb-43b1-8be6-4b30f1e7b86a"><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;ddate=[entry._now]</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="025a3301-67de-49a9-81a4-074af9476e8c"><ac:parameter ac:name="action">Send Email</ac:parameter><ac:parameter ac:name="event">onModified</ac:parameter><ac:parameter ac:name="title">IT Support-Ticket [entry.id]: [entry.title]</ac:parameter><ac:parameter ac:name="who">[owner]</ac:parameter><ac:rich-text-body>
<p>Hallo [entry.name],</p>
<p><br /></p>
<p>Der Status ihres Tickets hat sich geändert: <strong><span style="color: rgb(51,153,102);">Erledigt</span></strong></p>
<p><br /></p>
<p><strong>Problemstellung:</strong> [entry.explain]</p>
<p><strong>Problemlösung:</strong> [entry.solution]</p>
<p><strong>Ticket-Nr:</strong> [entry.id]</p>
<p><strong>Titel:</strong> [entry.title]</p>
<p><br /></p>
<p><br /></p>
<p>Mit freundlichen Grüßen</p>
<p>IT</p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p><ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="faa3db44-61fd-4859-b72a-9c7b06df327a"><ac:parameter ac:name="action">Send Email</ac:parameter><ac:parameter ac:name="event">onCreated</ac:parameter><ac:parameter ac:name="title">IT Support-Ticket: [entry.title]</ac:parameter><ac:parameter ac:name="who">sebastian.ilg@drv-bayernsued.de,it-rehafachzentrum@drv-bayernsued.de</ac:parameter><ac:rich-text-body>
<p><strong>Ticket-Nr:</strong> [entry.id]</p>
<p><strong>Art des Problems: </strong>[entry.type]</p>
<p><strong>Titel:</strong> [entry.title] </p>
<p><strong>Problemstellung:</strong> [entry.explain]</p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p>
<h1 class="auto-cursor-target">Meine Tickets:</h1>
<p><br /></p><ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="0f59a8f6-9431-4da2-ad45-eec06b864947"><ac:parameter ac:name="filter">createdBy:[entry._user]</ac:parameter><ac:parameter ac:name="formName">support</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p>
<p class="auto-cursor-target"><br /></p>
<p class="auto-cursor-target"><br /></p>
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 12, 2024

It works for me perfectly well.. as much as the form is configured - sends duplicated emails, twice updates the ddate...

But this is as it is designed - executes all the rules you have set

Christian Englbrecht March 12, 2024

Yes it sends duplicate mails, when you create an issue. But when you modify the entry, it should trigger a third mail, which says that your issue is done. This mail is not sent. 

Christian Englbrecht March 12, 2024

Its working!!!

 

I checked the box at "Stop events propagation When checked, entry update or create via this action will not fire a corresponding event" in the IFFFT-Macro for ddate. 

 

Doesn't really make sense to me, cause the text says the opposite of what it is doing right now, but hey: If it works - don't touch it!

 

Thanks a lot for your help!

 

0 votes
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 11, 2024

Looks correct, do you mind sharing a complete form?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events