Chain-linking fields from several forms
Hi all,
I have a simple application for a basketball club membership on Zoho Creator.
I have created three forms:
1. Person (containing individuals' details, e.g. First Name, Surname, Date of Birth, Street Address, Suburb). Suburb is a lookup from the Suburb form.
2. Suburb (containing Suburb Name, Post Code and State). State is a lookup from the State form.
3. State (containing only State).
I would like to display on the Person form the Suburb Name (which works) PLUS a "calculated" field which, once Suburb is picked up, it automatically displays the Post Code from the Suburb form and the State from the State form. Something like:
Suburb.Suburb + Suburb.PostCode + State.State
I can't really find whether such a construct is possible and, if possible, how to script it. Could someone assist, please?
Thank you in advance.