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
------------------------------
Original Message:
Sent: 08-26-2021 14:53
From: Michelle Labbe
Subject: Dynamic Form Rules to hide address subfields
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
------------------------------