Discussions

 View Only
  • 1.  Dynamic Form Rules to hide address subfields

    Posted 08-26-2021 14:53
    Hello, 

    I am trying to display latitude/longitude coordinates on the map using the Address field. This only works if the lat/long are entered in the Address:Street 1 and Address:Street 2 subfields AND no other address subfields are populated. Once any of other subfields have information in them, the lat/long is overridden and the lat/long location does not display on the Map.

    To reduce confusion for users entering this data, I am trying to use the Dynamic Form Rules to hide the other Address subfields when the Street 1 and Street 2 are populated with lat/long.

    Here is the rule I came up with, which is not working to hide the other subfields when Street 1 and Street 2 are populated. Can anyone help straighten me out? Thanks!


    ------------------------------
    Michelle Labbe
    ------------------------------


  • 2.  RE: Dynamic Form Rules to hide address subfields

    Posted 08-26-2021 15:30
    I don't believe that you can add the subfields, but you could have a form rule to blank them out.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Dynamic Form Rules to hide address subfields

    Posted 08-26-2021 15:33
    Hi, thanks. -- yes, I am trying to "blank them out" with the Form rules. The Rule I wrote is not working (see screenshot from original post)...

    ------------------------------
    Michelle Labbe
    ------------------------------



  • 4.  RE: Dynamic Form Rules to hide address subfields

    Posted 08-26-2021 18:00
    By blank them out I don't mean hide the fields (as I don't believe you can do that for parts of an address "field" - its show hide all or nothing), I mean change any data entry in those fields to be blank.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Dynamic Form Rules to hide address subfields

    Posted 08-26-2021 20:40
    Does the person submitting the details for your Street 1 and Street 2 fields have the option to submit an actual address  or  submit latitude and longitude?

    If so, this might work for you:
    • Add a field to have the person submitting select if they are submitting an actual address or Lat/Long
      • Hide the address fields until this is selected
      • Once selected, provide the appropriate fields that should be used for those options
    This way if they are submitting Lat/Long they would not have access to the additional fields. 


    ------------------------------
    Amber Anderson
    ------------------------------



  • 6.  RE: Dynamic Form Rules to hide address subfields

    Posted 08-26-2021 20:44
    Amber, the address subfields cannot be individually hidden.  That's the issue.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Dynamic Form Rules to hide address subfields

    Posted 08-26-2021 20:51
    Perhaps the same set up with the drop down of selecting Full Address or Lat/Long and instead of hiding make a Dynamic rule that:
    • Make them read only
    • Clear out the extra fields as well (incase someone entered something and didn't clear them out. 


    ------------------------------
    Amber Anderson
    ------------------------------



  • 8.  RE: Dynamic Form Rules to hide address subfields

    Posted 08-27-2021 11:33
    Apparently the answer to my question is that "its impossible'

    Your original question: Use GPS for location info instead of street address...

    Our Response:

    I was able to reproduce this in a test app, so I did more digging. As it turns out, this is the effect of a known bug we have already documented.

    I have attached this case to the bug report so you will be notified when it it addressed in a future release.

    Regrettably, at this time, there are no timelines available for when this will be fixed, nor is there is a workaround available.

    If you have any further questions, please do not hesitate to ask by sending along a reply to this case.

    Otherwise if all set, have a great rest of your day and week ahead!

    Cheers.






  • 9.  RE: Dynamic Form Rules to hide address subfields

    Posted 08-27-2021 16:47
    I think I've found a way to make this work.

    Set up text fields for the lat and long values. Add these to the form, along with the address field. Set the address field to only show when viewing the record (so users don't have the option to edit it). Then, set up form rules as such:


    ...and...


    I wasn't sure if the form rule would populate the values in the address field if the field wasn't displayed when adding/editing, but it seems to work.


    Hope this helps. Also, I'm curious--what exactly is the "known bug" QB mentions in their response?

    ------------------------------
    Dan Ladner
    ------------------------------