Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
10 years ago

Formula text field isn't working with IfNull()

I have a formula text field with the following formula: If(IsNull([Preferred Vendor(Form)]),[Item List - Preferred Vendor],[Preferred Vendor(Form)]). The [Item List - Preferred Vendor] field is a loo...
Forms
Formulas and functions
Relationships
KenKen's avatar
KenKen
Qrew Trainee
8 years ago
I've found this discussion very helpful because I'm having the same issue. I tried the solution above in my app but I get a 0 instead of the expected text field. The complete formula is below:

If(Trim([invoiceNumberOverride]) <> "",[invoiceNumberOverride],ToText(5000 + [Record ID#]))

Any ideas what I am doing wrong? Any help would be greatly appreciated.