O365: Form Variable that calculates a future date

  • 6 December 2021
  • 1 reply
  • 20 views
L
Badge +2

I am new to creating a variable to be used on the New Responsive Form that will calculate a future date when taking into consideration two columns with different field types. Column A is a date/time column and Column B is a number column. For my list I am using a calculated column with the following formula to display a date: =IF([Days Supply]>80,[Last Disp]+([Days Supply]-15),[Last Disp]+([Days Supply]*0.75))

 

I would like for this date to also appear on the form for end users to see when working on a profile, but every time I create the form variable it comes with an error. Any advise would be much appreciated.

20845iFB908AE635FC7BAA.png

 

1 reply

D
Userlevel 1
Badge +6

You should be able to do this with a rule and use a date field where you want it to display on the form (you can then make the field read only if needed):



For the then statement: dateAdd("days",sum([Form].[DaysSupply]-15),[Form].[LastDisp])


For the Else statement: dateAdd("days",sum([Form].[DaysSupply]*.75),[Form].[LastDisp])

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings