What will be the 'do this' action behaviour e...

expressions
(Abu Md. Moniruzjaman) #1

What will be the ‘do this’ action behaviour expression if i want to make my login (datetime type) column blank again??

Help??

(Tony Fader) #2

@Abu_Md_Moniruzjaman Make it a “Set column value” action and set the value to “” (two double quotes)

(Abu Md. Moniruzjaman) #3

Thnx

(Abu Md. Moniruzjaman) #4

Basically, i hv 2 table. The value of the 'A 'column of table1 is coming from the table2(named ‘BCR’), 26 column. In spreadsheet formula 'BCR!RC[26].

I want to remove these spreadesheet formula with a similar app formula. So, what will be App formula

for this (BCR!RC[26]) spreadsheet formula??

(Tony Fader) #5

@Abu_Md_Moniruzjaman There’s no direct equivalent to the BCR!RC[26] formula.

You can use de-references, SELECT, or LOOKUP formulas to do something similar, though.

help.appsheet.com - Dereferences

https://help.appsheet.com/expressions/expression-types/list-expressions-and-aggregates Dereferences help.appsheet.com