Create a Timestamp in ConfiForms when entry is modified

[Christian Englbrecht]

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??

[Christian Englbrecht · Accepted solution]

[Alex Medved _ConfiForms_]

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]

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_]

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

[Christian Englbrecht]

Still not working. 

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

Any ideas?

[Alex Medved _ConfiForms_]

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

Alex

[Christian Englbrecht]

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

[Christian Englbrecht]

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]

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_]

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]

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]

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!

[Alex Medved _ConfiForms_]

Looks correct, do you mind sharing a complete form?