Forum Discussion

JenniferJuhasz's avatar
JenniferJuhasz
Qrew Cadet
2 years ago

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. How...
Formulas and functions
JenniferJuhasz's avatar
JenniferJuhasz
Qrew Cadet
Okay - will give this a try this morning; so the formula field I create can also include the action to populate the record ID field with the 'fake' email address.  Can I do all of this with just a formula checkbox then?

And thank you!!! Your advice is always so helpful!

------------------------------
Jennifer Juhasz
FamilySmart
BC, Canada
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago
Just to get our Terminology straight, the key field of your table is the email field. Every table still has a Record ID field even if it is not set as still being the key field.  

The formula will do the work of what you want to go in that field if the user does not have an email address, but the work of putting the value from the formula field into the email field will be done by a Form Rule.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • JenniferJuhasz's avatar
    JenniferJuhasz
    Qrew Cadet
    2 years ago
    Hi Mark,

    I thought I was on the right path, but getting an error.

    I've created my checkbox.
    Created a 'Formula Email Addess' field (and alternatively tried both a Formula Text and Formula Rich Text field), but the following formula keeps generating a syntax error:

    If([No Email Address for Contact],true,[Staff Member - Community]&"@noemail.com")

    If I say ,true, - it says - expecting bool but found text
    If I say ,1, - it says - expecting number but found text

    I'm puzzled, why this isn't working.

    If I understand your guidance correctly, once I can get this field to populate, then I'll use the form rules to populate the 'Email Address' field with this content.  Is that right?

    Thank you!

    ------------------------------
    Jennifer Juhasz
    FamilySmart
    BC, Canada
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      2 years ago
      I suggest simply a  formula email field called [Email address to use if no email]

        [Staff Member - Community] & "@      noemail.com"

      Then a form rule that says,

      when multiple conditions are true
      When
      all of
      email is (leave blank)
      No email available is checked

      Change [email] to the value in the field [Email address to use if no email]
      Change [No email available is checked] to unchecked

      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      • JenniferJuhasz's avatar
        JenniferJuhasz
        Qrew Cadet
        2 years ago
        This worked great!! Thank you Mark!  Always grateful for your help and guidance.

        ------------------------------
        Jennifer Juhasz
        FamilySmart
        BC, Canada
        ------------------------------