Data not displayed any longer on ConfiForms CalendarView

[Markus Kovar]

Hi,

I recently created a calendar using the "ConfiForms FormDefinition" form for users to enter their dates and the "ConfiForms CalendarView" to display the dates.
I am using some "ConfiForms Rules for Form Definition" for the data entry form and IFTTT Integration Rules to manipulate the data.

Everything worked as expected until yesterday when all of a sudden the data that are being submitted in the form is not displayed any longer on the calendar.

I checked the underlying records and confirmed that all data are being recorded correctly.

I've tried to find the root cause but cannot identify where the issue is. Do you have any idea what to look for?

I would like to avoid having to start a new calendar and potentially loose all the records. 

Thanks in advance for any ideas!

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Markus Kovar 

Hard to tell without seeing your configurations and it's extremely hard to provide any help when things "suddenly" stopped working

Feel free to open a support ticket with us https://wiki.vertuna.com/display/VERTUNA/Support+Request+Form sharing your configurations (form and calendarview)

Alex

[Markus Kovar]

Hi @Alex Medved _ConfiForms_ 

Thanks for the quick response! The issue seems to be regarding the following...

How do I calculate a time span type "DateTimeInterval" from two data points type "DateTime"?

Following your instruction from this post the formula that used to work was:

entryId=[entry.id]&DateInterval=[entry.TmpDateTime1]-[entry.TmpDateTime2]

It is not working any longer and I believe that's where the root cause lies.

wdyt?

[Alex Medved _ConfiForms_]

When you use the formula field you can have your expressions placed as you like, but in the IFTTT macro parameters you need to tell explicitly that this is an expression and should be calculated and not taken as-is

Long story short - put the () around

entryId=[entry.id]&DateInterval=([entry.TmpDateTime1]-[entry.TmpDateTime2])

Also recent versions of ConfiForms have some handy helper methods available in the DateTime Interval field

https://wiki.vertuna.com/display/CONFIFORMS/Accessing+field+values+and+properties

• periodInSeconds
• periodInMinutes
• periodInHours
• periodInDays
• periodInWorkDays

Alex

[Markus Kovar]

Ok, thank you for the quick response!