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