I have a list of documents that require periodic reviews. I would like to have a Calculated field that adds a Red border on the Title field when the Review Date field is =< Today, and Amber if the Review Date field is Today -1 Month. JS is not allowed hence the need for a Calculated field. Title - T...

@nowackem, thanks very much for helping me out. I was able to get the format I wanted, albeit without a leading "0" on single digit days.The below code gives me this format - D MMMM YYYYFor what I am doing, it is good enough Thanks again if(SDSDate.rawValue!=null){if(Plus5Years.rawValue!=null){var d...

This coding is what I have been looking for, thanks I have modified it a little so that it populates the End Date field with the "Start Date +5 years", I was wanting the this format e.g..  24 March 2027 (DD MMMM YYYY) .The issue a cannot seem to fix is this "this.rawValue = newDate.toDateString();",...

Yes it is tricky, found out that if the code isn't perfect it closes the application.So when I added your code, the subform names was wrong.Then I made a change so there was a space after the comma (values.join(", ");), but didn't use quotation marks around it initially.Eventually I got it correct a...

BR001, Perfect,  that is exactly what I what. Thanks very much. The only problem I have is that when I enter anything into the calculate field the application closes.  No idea why.  So I can see the code in your example  but I am unable to add it to my form. Anyway thanks very much for the help.

Any ideas?

Hi all,I am creating a form where the user can make multiple selection via checkbox's, and I am trying to have the selections entered into 1 text field.eg,checkbox1 = applecheckbox2 = orangecheckbox3 = pearif checkbox 1 and 2 are selected I want the text field to read "apple, orange"if all 3 are sel...

Brilliant, works perfectly, thanks very much for the help Pete

‌Every thing is flowed, all fields except the table are in flow able sub forms, and everything is enclosed in 1 flowable sub form.am I able to send you a copy of the form?

‌Works great except when I print it leaves a gap where the table was. I have the table default as hidden (exclude from layout).thanks for your assistance so far.