Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › “IF” Calculation
Tagged: IF Statement
I’m trying to create a formula to select whether the record is filed by Company Name or Individual’s name.
IFEMPTY(FILE_BY_COMPANY;CONCAT(LASTNAME + “, ” + FIRSTNAME;COMPANYNAME)
Where FILE_BY_COMPANY is a checkbox. If not checked, file by “Lastname, Firstname” else Companyname
What am I missing?
Nevermind… got it: IF(FILE-BY-COMPANY;COMPANY;(LASTNAME+”, “+FIRSTNAME))
Had the Companyname and Concated name reversed.
Cheers,
Glad you figured it out.
You must be logged in to reply to this topic.
Log in / Register