Forum Discussion

HeatherBryant2's avatar
HeatherBryant2
Qrew Assistant Captain
6 years ago

'Require' Form Rule Doesn't Require Address Fields

When working with a form rule to require an address field, the record can be saved without a value in the address field. I have a form rule that says: When checkbox=true, require Address: Street 1,...
Forms
CharleneWilbur's avatar
CharleneWilbur
Qrew Trainee
4 years ago

Hi Heather,

Did you ever find a resolution for this?  I am having he same problem now.

Thanks
Charlene



------------------------------
Charlene Wilbur
------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    4 years ago
    As far as I know there is no resolution to this if you want to use the real address fields. This is still a bug that happens. I am not sure 100% why but it probably has something to do with the way address fields are split up into multiple fields of their own.

    There are several possible workarounds that may work for you. These are what I can think of but there may be more or better options.

    1. Create your own text fields to act like the address fields, you can require these. You lose the ability to type an address and have it fill part of it in.

    2. Change your process and find a way to utilize 2 forms. One form would have the normal address field on there but have it be required all the time. If a user is required to fill it out then send them to the required form only.
    • CharleneWilbur's avatar
      CharleneWilbur
      Qrew Trainee
      4 years ago
      HI!  I've already done the first thing in your list.  It's just frustrating.

      Thanks!

      ------------------------------
      Charlene Wilbur
      ------------------------------
      • EvanMartinez's avatar
        EvanMartinez
        Moderator
        4 years ago
        Hi Charlene,

        Being able to prevent a record from saving without an address field being filled in is actually possible now through the use of custom data rules. Custom data rules allows you to set rules under which a record could not be saved or edited and can run from not allowing a record to be saved if a field is blank or up to requiring that several conditions be true. They are built using the formula language used in formula fields and can be added to your table right in the table's advanced settings. You are even able to set your own error messages that pop up to warn a user that they need to fix something on the record before they can save. For example you could use a formula like:

        If([Address Field]="", "You must include an address on each company record")

        This will prevent them from saving till that field is not blank and pop up this message for them. This way you could just require that address field or only require it when someone indicates for example that they are working from home instead of in office and need to provide a home address for your records. Then they would see the error like below to help direct them to next steps.




        ------------------------------
        Evan Martinez
        ------------------------------