SMARTFLOW WARNING: Historical calculations will NOT run if a user does not have read access to the Target Form.

We recently uncovered an issue with a smart flow sequence not being able to perform historical calculations on a smartflow target form when the user did NOT have read access to the target form. This was highlighted when athletes were entering data and the calculations would not run, but when a coach entered in data the calculations would run (because the coach had read access to the target).

As a workaround, the ONLY way to ensure historical calculations in the smartflow target forms function as required is to ensure athletes have read access to the target form  

In the example here, a smartflow is set up for one Trigger form to fire the entry of three Target forms

In the example here, a smartflow is set up for one Trigger form to fire the entry of three Target forms

The three Target forms all have a calculation which performs a historical calculations in the target form using data pulled from the trigger form (see the image in the step below).

The three Target forms are set up almost identically, and they all include a historical calculation, which calculates data from within the Target form

The three Target forms are set up almost identically, and they all include a historical calculation, which calculates data from within the Target form

The athlete ONLY has read access to one of the three Target forms.

The athlete ONLY has read access to one of the three Target forms.

When a coach enters data into the target form (dates 1st-3rd July) the Targets all run the historical calculations correctly.

When a coach enters data into the target form (dates 1st-3rd July) the Targets all run the historical calculations correctly.

Three entries for each of the target form appear, and the historical calculations run (as shown for one of the target forms)

Three entries for each of the target form appear, and the historical calculations run (as shown for one of the target forms)

The historical sum calculations calculate the data entered over the past 3 days (1+2+3=6)

However, when an athlete enters in trigger data, all of the targets willl be entered, but ONLY the form that the athlete has read access to runs the historical calculations.

However, when an athlete enters in trigger data, all of the targets willl be entered, but ONLY the form that the athlete has read access to runs the historical calculations.

On the form that the athlete has read access to, the historical calculations all work

The athlete has read access to this form, and the calculations work correctly.

However, for the targets that the athlete does not have read access to, NONE of the historical components of the calculation works

However, for the targets that the athlete does not have read access to, NONE of the historical components of the calculation works

The historical calculation components are NOT working for any of the athlete entered data!. The calculation looks like it is working (e.g., numbers appear in the calculation column). However, it should be summing 1,2,3,4,5 and 6, but is it NOT. It only performing the latter part of the historical calculation and pulling out the variable entered today.

For example: historicalsum(Historical linked number, linked number).

It is just pulling the linked number which on the 4th was 4, and on the 5th was 5 and on the 6th was 6.

N.B. If the data is opened and saved by the coach, the historical calculations WILL recalculate.

Note, we tried using a template in the smartsave as a workaround, but this had not effect on the historical calculations. They still failed.

0 Comments

Add your comment

E-Mail me when someone replies to this comment