Formula Field - If this, then that; otherwise allow text entry
Hi everyone,
Just finished building a new tool for my team, integrating reporting to contacts tables to allow staff to look up contact records rather than repeatedly inputting the same data.
However, our contacts table uses email addresses as the record ID. When it was established, it made a lot of sense to do that to prevent duplicate entries, among other things. We were only using that table to send emails once a month, and if we didn't know an email address, then that contact wasn't added to that table.
I've now been asked - what happens if we don't have an email address (the newest system requires the input of an email address). My thought is to create a way for an automatic 'fake' email address to be created based on the community of interaction + '@noemail.com' or something to that effect to populate the field; but if the box is unchecked - to allow for regular entry of an email address.
So - I wanted to see if this were possible:
Have a checkbox - you tick if you "don't" have an email address for a new contact
The email address field - has an if/then formula like this:
IF([No_Address]=1,[community]+"@noemail.com",)
Is this possible? I've not seen any formula queries that specify that if the result is other, to allow for field input / data entry to still occur.
Thank you for your thoughts!
Jen
------------------------------
Jennifer Juhasz
FamilySmart
BC, Canada
------------------------------
Just finished building a new tool for my team, integrating reporting to contacts tables to allow staff to look up contact records rather than repeatedly inputting the same data.
However, our contacts table uses email addresses as the record ID. When it was established, it made a lot of sense to do that to prevent duplicate entries, among other things. We were only using that table to send emails once a month, and if we didn't know an email address, then that contact wasn't added to that table.
I've now been asked - what happens if we don't have an email address (the newest system requires the input of an email address). My thought is to create a way for an automatic 'fake' email address to be created based on the community of interaction + '@noemail.com' or something to that effect to populate the field; but if the box is unchecked - to allow for regular entry of an email address.
So - I wanted to see if this were possible:
Have a checkbox - you tick if you "don't" have an email address for a new contact
The email address field - has an if/then formula like this:
IF([No_Address]=1,[community]+"@noemail.com",)
Is this possible? I've not seen any formula queries that specify that if the result is other, to allow for field input / data entry to still occur.
Thank you for your thoughts!
Jen
------------------------------
Jennifer Juhasz
FamilySmart
BC, Canada
------------------------------
