cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate date in repeating section

I try to calculate a date within an repeating section. If the condition is fullfilled, the value is the current date.

Otherwise the calculated should keep the old date.

How could I build this with standard Nintex functions?

Tags (2)
0 Kudos
Reply
18 Replies
Workflow Hero

Re: Calculate date in repeating section

you can define your formula like

if( condition, Current date, Name_of_control_to_copy_old_date_from )

Accept as Solution Reply
Not applicable

Re: Calculate date in repeating section

Hello Maria,

I already defined a function that way. Now the problem is to save the old date for n different values in n items from the repeating section.

So the most important question is:

How could I save the old dates? (it is not possible to save single values in a list column, only the xml of the complete repeating section)

I develop with Nintex Forms 2010 for SharePoint 2010.

Thank you

Accept as Solution Reply
Workflow Hero

Re: Calculate date in repeating section

could you explain what the 'old date' in fact is?

where do you get it from?

when/how does it change?

it sounds to me, that might need a piece of javascript, is that still in scope of your understanding of "standard Nintex functions"?

Accept as Solution Reply
Not applicable

Re: Calculate date in repeating section

Hello,

In my mind it should be a feature of Nintex, but I also see no other solution than using custom javascript.

I try to design my forms without programming because javascript is deactivated often to security reasons.

problem description

  1. Each item of my repeating section has a date field and a person field
  2. When the form will be edited by a person from the person field, the date field from the item should be updated
  3. Otherwise the date field should show the old value
Accept as Solution Reply
Workflow Hero

Re: Calculate date in repeating section

if you want you change/update date type field then you will have to use javascript since date type field doesn't recalculate on it's own, neither you can define formula for it.

I understood it first that you want to use calculated value control which should either get value of other date control or current date.

Accept as Solution Reply
Not applicable

Re: Calculate date in repeating section

I can only use a calculated value. From a date field you can't get values from other controls inside the repeating section.

The calculated does not save it's data... so it's also no solution.

Furthermore I don't how to grab the data within the repeating section with the central managed js code from the Nintex Form.

Is there any tutorial for accessing repeating section with javascript?

Accept as Solution Reply
Workflow Hero

Re: Calculate date in repeating section

The calculated does not save it's data

have you tested it?

calculated value control stores its data

Is there any tutorial for accessing repeating section with javascript?

I'm not aware of an tutorial but if you search through the forum you will definitely find several different topic.

eg. one of them Having fun with Date / Time in Nintex Forms

Accept as Solution Reply
Not applicable

Re: Calculate date in repeating section

Sorry, I have not expressed myself clearly.

When the calculated value will be calculated when the form ist loaded I see no possibility to access the old value.

An example within a calculated value: (field B is the calculated value)

If field A is true

then calculate field B new

else no calculation in field B (let old value)

I hope there is a possibility

Accept as Solution Reply
Workflow Hero

Re: Calculate date in repeating section

is this what are you looking for?

Accept as Solution Reply