asked on June 19, 2020

Can a form field being used to collect numerous other field entries have an if then statement for deciding whether to include the additional text of "Box " in the collection field or not?  I have one user that wants the option to put General Delivery into the number field for the mailing address box number, but now my hidden collection field is gathering a result of (for example) this:  "Box General Delivery, Strome, AB" instead of just the desired "General Delivery, Strome, AB"

=IF(INDEX(Mailing_Address.Town_Village,ROW())="Other",INDEX(Mailing_Address.Other,ROW()),CONCATENATE("Box ",INDEX(Mailing_Address.BoxNumber,ROW()),", ",INDEX(Mailing_Address.Town_Village,ROW())))

0 0