Formula not working on repeating Subform

Valerie Westres

January 29, 2019 21:46

I have a Subform with repeating Rows and a Formula that displays the Value from a different Subform Control.

My problem is the Formula only works on the first Row. I have tried:

adding a Rule to Set Field Value
using {*}/{this} on both Formula and Rule
executing Rule on Form load

I don't know what else to try, and i don't understand why it wouldn't just work on subsequent rows...

0

Comments

3 comments

Karl Makatenas

January 30, 2019 13:41
Are you trying to cast the return value to a string? If you're just pulling the number, :[this] works:
0

Permalink
Valerie Westres

January 30, 2019 14:15
I set the Currency Code (CAD, USD) for a Client on Subform 1, with other Client Details; then I want that currency code to display next to each row of repeatable Subform 2 where I will enter each invoice amount separately.

p.s. This is how it was working in v5; however, it seems v6 has an issue with it... i might need to find a different way.
0

Permalink
Karl Makatenas

January 30, 2019 15:08
Oh, you have two different subforms. Try putting the formula in the same subform.

See this topic for more details:

https://helpdesk.agilepoint.com/hc/en-us/community/posts/360025072294-Can-Formulas-in-a-Subform-work-with-Controls-from-OTHER-Subforms-
0

Permalink

Please sign in to leave a comment.