Hi There,
I have three table, lets say TableA, TableB, and Table Tags
Both Table A and B have a column type Enumlist (Base type Ref to Table Tags) named [TableA_Tags] and [TableB_Tags].
Table B have a [Ref Column] type enumlist (not mandatory column) of Table A.
My initial Value of [TableB_Tags] is: IF(ISNOTBLANK[Ref Column], [Ref Column][TableA_Tags], List(“”))
In the form view if the initial value of [TableB_Tags] have only one value, the value shown normally as the Label Column of Table Tags, but if the initial value have more than one value, it shown as a single value (Ex:“c1471f09, 3e07aff3”), not two value of “c1471f09”, and “3e07aff3” so of course the label of Table Tags is not shown.
If I save it as is, and then wait for a while the system will correct it accordingly.
My question is, is there a way to instantly shows the label (still in form view) no matter how many initial value computed?
I’m just guessing that, based on your screenshot, appsheet sees the initial value as invalid until the app detected the tags being added.
Can you try also putting the initial value expression in the EnumList’s valid_if? See if it forces the Enum List to recognize it as valid at the onset.
I did add the valid if expressions, but it does not recognize the value. Because the initial value generate single value no matter how many value it should’ve compute, like this: “c1471f09, 3e07aff3,3jskf9le”. So the form cannot be saved if I add valid if expression
The Expression with [Ref Column].[TableA_Tags] works if my [Ref Column] Type is enum, the problem is that my [Ref Column] Type is Enumlist so I need the list dereferences the column. the List dereferences technically works, but before I saved the form it shows the value as a single value.
What I want is list dereferences value to instantly shows (in form view) as the label value
This is the result, the dereference value is corrected after the form is saved, not before. so it is a little bit weird for the user to see some key value with exclamation mark.
IF(ISNOTBLANK[Ref Column], [Ref Column][TableA_Tags], “”) , one result ( [Ref Column][TableA_Tags]) of IF() is a list , whereas the second alternate result (“”) is a text value. So expression shows errors in evaluation as below.
Before we going further, I think I need to clarify my question.
Yes, the formula for my initial value have the LIST(“”) already. I already edit my initial formula in my post (My bad ).
My question is not about the expression but about the result value. The formula computed correctly and give the right value which is: c1471f09 (Have Label of Purchase Order #00001), and 3e07aff3 (Have Label of Purchase Order #00002). But in the form view, this value is considered as single value which is “c1471f09, 3e07aff3”. So of course the Label doesn’t show up , and the value have exclamation mark on it. Later if I save the form and wait for a while, Appsheet will correct the value into Two Value of “c1471f09”, and “3e07aff3” after this the label work because Appsheet already know its a key value. So, why Appsheet does not know if Value “c1471f09, 3e07aff3” are Two Value in form view? I already set the list separator as “,”.
Oh okay, now I got it. Thank you. My test was always with first column ( equivalent of ) [PurchaseInvoice_Receiving_ID] ) with one value not an enumlist. So do you mean both [PurchaseInvoice_Receiving_ID] and [Receiving_Tags] are enumlists?
).
