Does Appsheet have a null/blank/void value that we can set a field to? Like with a โset value of columnโ action. Or is there any way to clear the value from a column, so that it identifies as true in an isblank() expression?
@Marc_Dillon
Initial Value is for that purpose. Provided you donโt stated any value there, the field is always blank and an ISBLANK(โฆ) expression returns TRUE
Have you tried to write CONCATENATE("") with your action?
Or just ""
.
I currently have the action putting " ". The problem with " " in this case is that it is a ref column, also with a valid if expression that sorts the ref values. By itself being a ref column is fine, but with the valid if, it doesnโt allow the action to run. I guess I can create a โblankโ ref record. Maybe a feature request for a delete value action is in order?
Hey Marc, try returning a blank list?
ANY(LIST())
Or as an if:
IF(CONDITION(),
"Prefilled value",
ANY(LIST())
)
I like that better than a blank string. Not sure if itโll get past the valid if condition though.
or:
IFS(condition, prefilled-value)
What does this mean? Is the Ref column value Required? Thatโs more likely to prevent the action than Valid_If, Iโd think. I donโt even think Valid_If is applied to actions.
The column is not required, but it does have a valid_if expression, thus a blank/void/null value, or value deletion, would work, but a random value such as the blank string " " doesnโt work because it doesnโt meet validation requirements. Does that make sense?
Valid_if does apply to actions, Iโve actually encountered it twice this week on two separate projects.
By the way the valid_if expression is just an ORDERBY() on the refโd table.
Note that when I suggested ""
, thatโs two double-quotes with nothing between.
Maybe this is possible by putting the ORDERBY() expression in suggested values field instead of valid_if field?
It is possible to use ORDERBY() for suggested values.
I am having the same issue. I need to ensure that a ref column PaymentRequest never has a value in it, when the [Billable] column is not true.
What works is to say ORDERBY(IF(NOT([Billable]),SELECT(PaymentRequest[ClaimReference],[ID]="++++++++"),SELECT(PaymentRequest[Claim Reference],[ID]=[_THISROW].[ID])),[LastModified],true)
It adds to my sync time terribly, though.
Help.
Billiable should be boolean, in appsheet, YES/NO type.
NOT([Billiable]) expression is just toggle yes to no, no to yes.
Expression should be corrected like
ORDERBY(IF([Billable]=false,SELECT(PaymentRequest[ClaimReference],[ID]="++++++++"),SELECT(PaymentRequest[Claim Reference],[ID]=[_THISROW].[ID])),[LastModified],true)
Hey Tsuji,
NOT([Billable]) works fine, and your [Billable]=FALSE is fine, too.
The expression above works with:
ORDERBY(IF(NOT([Billable]),SELECT(PaymentRequest[ClaimReference],[ID]=โ11111111โ),SELECT(PaymentRequest[Claim Reference],[ID]=[_THISROW].[ID])),[LastModified],true)
The โ++++++++โ key threw up an error.
My issue is that running a SELECT query on the PaymentRequest table is a big job, as it is 11,000 rows plus. It should be possible to say ORDERBY(IF(NOT([Billable]), MakeNull([_THIS]), โฆ
When using orderby expression in Appsheet, we need to make sure the expression inside orderby() will return the list of key value.
Im not sure but it seems PaymentRequest table key should be [ID] instead of [Claim Reference]?
This will produce an empty list if [Billable]
is FALSE, prohibiting all input in the column, or the ordered list of things otherwise. The ORDERBY() expression wonโt even be processed if [Billable]
is FALSE.
IFS(
[Billable],
ORDERBY(...)
)
LEGEND!!
I did not know that about the IFS function.
Thatโs an awesome bit of know-how, thanks Steve!
There is no need to provide a second outcome, and it defaults to null rather than throwing an error.
Wow.
Thank you.
For reference:
hi , i need to set a field value to be blank using an action.
what has been deemed to be solution for this. i dont see any suggestion on this to be marked as a solution. .
any help please who have sorted the solution for this.
shall i be using "" will that work? when in other actions i have IF condition with ISBLANK(field) .will all that work with ""?
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |