Hi, I have a doubt about a formula. I try to create a schema of status for Skid or Trucks, depending on the type is a status. example:
if Type storage is Skid the status must say โMaterial in Storageโ
If Type Storage is Truck status must say " Truck in the Yard"
etc etc the formula is this
but when add a register and the first condition is complete donโt show in row Status
but when save โฆapparently, all is ok but a few seconds the status disappear
I check my formule a donโt know why take a last criterion " "
Solved! Go to Solution.
I have changed the original legend called โMaterial en Bodegaโ to โAlmacenado en Bodegaโ and it worked !!
I still donโt understand what happened
Perhaps you have a data change action thatโs resetting it?
I suppose but the stranger is this app just started to develop. and not have any data or actions
Instead of using so many if condition you can use ifs here
For example ifs ([storage type] =โ1โ ,[STAUTS]=โ1โ,
[storage type] =โ2โ ,[STAUTS]=โ1โ)
Try in this format
Change the formula for ifs and happen sameโฆ
simplify the formula so that it only shows the first two statuses
if for example makes the entry โCajas de Zincโ the status shows the correct legendโฆ
but is change to โMaterial en Bodegaโ
I have changed the original legend called โMaterial en Bodegaโ to โAlmacenado en Bodegaโ and it worked !!
I still donโt understand what happened
Hi @daniel_sanchez
Do you have a conflict with โinitial value expressionโ vs โapp formulaโ ?
You should have only one, but not both fields completed.
Is a virtual Colum, is not supposed to have Initial value expression?
You are correct, I was assuming you were calculating a real column.
So, that means one of the input for your calculation is evolving when syncing.
I suggest you have a look to the expressions of each column input, such as [Tipo de Almacenaje] , [Fecha de Envio], and so on.
Typically, with virtual column you have (it is probably not accurate but that the behavior I see from my experience) :
So, maybe one of your form values is not being written properly. Can you check these ?
About the last criterion: if you write โTESTโ, the โTESTโ remains ?
โAbout the last criterion: if you write โTESTโ, the โTESTโ remains ?โ
yes, so this confirm that the formula works but no criteria is valid
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |