Hi there, I'm trying to have the "Save" butt...

(Kayman Mckay) #1

Hi there,

I’m trying to have the “Save” button output to another text based on the value of a column. my current formula is:

IF([SEND ESTIMATE] = “YES”.“RESEND?”,“Save”

However the error I get says it can’t find the column. Bug or issue on my end? ERROR OUTPUT: Unable to find column ‘SEND ESTIMATE’

Thank you!

(Steven Coile) #2

I don’t know for sure, but I suspect localization formulas can’t see the current record. Or, if they can, you need to reference it with [_ThisRow], as in IF([_ThisRow].[SEND ESTIMATE] = “YES”, “RESEND?”, “Save”). I’d be surprised if that works, though.

(Dinh Nguyen Nguyen) #3

@Kayman_Mckay I’m afraid it is not possible to reference specific columns or rows in expressions in localization settings. This is because these settings are not tied to any specific table and thus have no context or knowledge of the tables’ rows and columns.

(Kayman Mckay) #4

Thanks for the info! too bad. @Harry +Steve Coile