Formula not working on repeating Subform

Valerie Westres

• 2019年01月29日 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

• 

  Karl Makatenas

  • 2019年01月30日 13:41

  Are you trying to cast the return value to a string?  If you're just pulling the number, :[this] works:

  

  0

  評論操作 永久連結
• 

  Valerie Westres

  • 2019年01月30日 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

  評論操作 永久連結
• 

  Karl Makatenas

  • 2019年01月30日 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

  評論操作 永久連結

請登入寫評論。