Hi, I need help on how can I update the status for a calculated field, for example, my calculated field must be more than 50 then the status will display or update to pass otherwise it will display fail.
Ex:
Total>50 = pass
Total<50 = fail
How should I update the data if I want it update on my form status?
Solved! Go to Solution.
Hi @biha,
You are said want to update your form status. So, I think you are using submit form method.
So, Simply your text box filed to put below coding like..
You are said more than 50 only pass. I guess, 50 & above pass. My guess right means use below formula in your text filed in your submit form
If(Value(TotalMark.Text)=>50,"Pass","Fail")
My guess is wrong and you need only above 50 only pass means use below formulae
If(Value(TotalMark.Text)>50,"Pass","Fail")
I hope now you got the solutions.
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up/Like it's make me a smile 😌.
I am not exactly sure but I'll give solutions to the two things I think you're asking for.
To update a certain field until it gets to a certain value.
On the onstart, set the value of a variable
Set(various, 0)
Then whenever an action is taken that needs to update that variable,
Update({varCount: varCount + 1})
So when the action runs the count is updated till you hit your desired result.
As for updating a field based on another.
Initialize another variable.
Set(varStatus, Blank())
Since it's a calculator field so the onchange property of I'm guessing a text input field you'll write an if statement. If(value(textinput.text) = 50, Set(varStatus, true), Set(varStatus, false))
Then set the visible property of the field to varStatus. Thus if the value 50 is reached, it sets to true and the field becomes visible.
Also this works for the situation where you want to patch a value based on the value of another filed
On the default property of the new field, write the if statement
If(value(calculatedfeild.text) > 50, "Pass", "Fail").
Hi @biha,
You are said want to update your form status. So, I think you are using submit form method.
So, Simply your text box filed to put below coding like..
You are said more than 50 only pass. I guess, 50 & above pass. My guess right means use below formula in your text filed in your submit form
If(Value(TotalMark.Text)=>50,"Pass","Fail")
My guess is wrong and you need only above 50 only pass means use below formulae
If(Value(TotalMark.Text)>50,"Pass","Fail")
I hope now you got the solutions.
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up/Like it's make me a smile 😌.
User | Count |
---|---|
252 | |
126 | |
104 | |
50 | |
49 |