how to validate below scenarios
a!localVariables( i have A,B,C,D Values and
if local!name = "X" then values should be A>B>C>D and if local!name = "Z" then it should validate A<B<C<D and in any other local!name value it should accept only numeric values
Discussion posts and replies are publicly visible
I'm not sure what you mean by "A>B>C>D" or "A<B<C<D" ?
it contains values which will be entered by user
example : A = 1, B= 3,C= 10,D= 4
I should validate based on above conditions if not it should show validation message to user
It sounds like you are planning to have a single text box into which the user can input one or more numeric values. How many can they input? What will you use as a separator? What is the biggest / smallest number they can input? (Can they enter: "5 99 -33 6863748"? How many can they they input? (I ask all these questions because I have doubts that using a single input test file dis the bets design here. Are you able to elaborate on the bigger picture? What's the purpose? What will you use those values for? What do the values represent?)
no your wrong, we have multiple text boxes for each A,B,C,D and if user enter B then it should validate less than C,D and greater than A
I am pulling A,B,C,D values from db and trying to update them
And will there always/only ever be four text boxes? Or is it a variable number?
ok let me make simple, Please find attached screen shot, I have table with Value columns
if user try to update config name profile_A then it should validate profile_A>profile_B>profile_C>profile_D
If user update case_A config name then Case_A<Case_B<Case_C<Case_D should validate
this should be trivially easy to do using conditional logic in Appian expressions, i.e. by using nested if() commands, or using the and() command, or by potentially a few other ways.
Nobody here will really have the time to both try to figure out the subtleties of your use case and also come up with expression logic for you, particularly when we're a little fuzzy on what your exact desired logic is (since that would mean we could be wasting our time coming up with something completely wrong for what you're actually asking about).
Instead if you could post some sample code for what you've already tried, and exactly how it's not behaving the way you expected, we're usually happy to help fix those sorts of issues.
Hi Mike, I understand you, I implemented this with multiple if conditions but i would like to see if i get any other function or logic which can be used instead of multiple lines of if code
© 2023 Appian. All rights reserved.