Right now, all I can see is,you can have a user entered field be conditional on a constant value.
Can you set it up to have a user entered field be conditional on another user entered field?
This would be super helpful for me.
Hi Jim,
I hope I'm understanding your question correctly, but let me know if this wasn't what you're looking for. You can set a field to be conditional on data entered on a previous field. Here's a help topic on that if you want some longer reading: https://help.gocanvas.com/hc/en-us/articles/231963587. Here's how it looks in the App Builder:
What that setup means is that if a user enters the number 2 in the number field on the number screen, this field will appear.
The key is to set the condition on the field that may or may not show (not the field the condition is based on).
Does that help at all?
Hi
Thanks for the reply.
On your picture, the condition value is 2.
So that is user entered value, and if that user entered value that is entered is equal to the condition value, then X happens.
But in my case, I wouldn't know what the condition value would be, as it would be user entered, and it could be anything.
Here is my ultimate goal:
so an example;
X = 14, user entered value, can be anything
Y = 3, user entered value, can be anything
Z = (hidden computation = Y*75*0.15), the 75, and the 0.15 are fixed)
Then
Show a "long text field" IF Z is greater than X.
I hope that makes sense...
Hi Jim,
You can certainly create a condition on a conditional field. There is an option for "if value is greater than" or "if value is less than" as well as If greater than or equal or if less than or equal. In this situation, you need more than one calculation. You can't create a condition for "comparing" two fields, but as long as they are both numbers, all you need to do is a calculation with those two numbers where you subtract one from another. If the value is positive than you know one number is bigger than the other.
Step one: create middle calculation
In this situation I do Z - X.
Step 2: Create condition based off this calculation
In my example, I do Z minus X which means that if Z is greater than X the answer will be greater than 0. Therefore, my condition on the next field can be if that middle calculation was "greater than" 0.
Hope this helps!
Hi Karina,
Can you give me an example of what a barcode number would look like for you? I think in certain cases we could make this work using a similar setup as above, but using the mirror backdoor to convert your text fields into number fields, but it kind of depends on where the space is. Let me know if you can give an example and I'll play with it and see if I can get it working.
Otherwise, I think this feature request addresses the issue, so I'd recommend you upvote it so we can see how popular the request is: https://help.gocanvas.com/hc/en-us/community/posts/360000178108-Compare-values-of-two-fields-when-the-contents-aren-t-just-number.
Thanks,
Sara
Hi Karina,
I thought I might be able to trick a number field into accepting the space using one of our backdoors, but alas, it didn't work. There is this feature request that I'd recommend upvoting so that our Product Team knows how much it's wanted: https://help.gocanvas.com/hc/en-us/community/posts/360000178108-Compare-values-of-two-fields-when-the-contents-aren-t-just-number.
Sorry I couldn't be of more help. Maybe someone else has figured out a way around this?
Please sign in to leave a comment.
Comments
9 comments