Loss of format from adobe webform calculated fields in completed agreement (PDF)
Hi community,
I am, after much trial and error, approaching the finish line on a webform for my organization. I used the Adobe Sign webform included with Acrobat Pro, so I don't have access to the advanced Adobe Sign enterprise features. In the webform calculcated field, I am returning a summary of earlier time entries as a weekly schedule. I have provided a sample of the syntax below:
"Monday: " + (if(and([Parent or Guardian 2 - Monday Shift Start] != "", [Parent or Guardian 2 - Monday Shift End] != ""), [Parent or Guardian 2 - Monday Shift Start] + " - " + [Parent or Guardian 2 - Monday Shift End], "OFF")) + "\n" +"Tuesday: " ............ "\n" +"Friday: " + (if(and([Parent or Guardian 2 - Friday Shift Start] != "", [Parent or Guardian 2 - Friday Shift End] != ""), [Parent or Guardian 2 - Friday Shift Start] + " - " + [Parent or Guardian 2 - Friday Shift End], "OFF"))
When I embed the webform and run some sample data in the fields above, the calculated field returns:
Monday: 13:00 - 15:18
Tuesday: OFF
Wednesday: 13:00 - 15:00
Thursday: OFF
Friday: 14:00 - 15:00
I'm not in love with the military time but I'm not super stoked to try to sort that mess out. But, this is the desired format and the data have been matched correctly; but, when I receive the completed agreement and open the pdf, the result is formatted like this (different sample):
Monday: -25203.408333333 - - 25203.90833333333
Kind of at a loss as I'm still getting used to the differences in webforms from a traditional fillable pdf. Any help would be much appreciated, thanks!
