You are viewing limited content. For full access, please sign in.

Question

Question

Forms routing with collections

asked on March 19, 2020

Has anybody been able to route a form based on a value in a collection table.

I have a scenario where any one of my collections are > than 10000.00 the task needs to go for approval else the process can end.

I have set up my conditions however the process just keeps on failing.

The field on the form is currency and my routing rule is (/dataset/Claims/Claim_Amount)>10000.00

One the other path I have tried leaving the path as default with no ruling (but with this the process ends but does not route correctly)

I have tried setting a rules as (/dataset/Claims/Claim_Amount)<10000.00 but than the process terminates.

0 0

Answer

SELECTED ANSWER
replied on March 19, 2020

I would suggest using a hidden field on the form as a flag. Set it to 0 by default and if one of your claim amounts is greater than 10000, set it to 1. Then, in your routing rules, check if the hidden field is 0 or 1. This makes testing easier as you can watch the hidden field change as you input different values to confirm that the logic on the field is correct.

2 0
replied on March 19, 2020

Thank you Justin.

 

This seemed to work for me.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.