ContributionsMost RecentMost LikesSolutionsRe: Lat/LongThank you for the detailed explanation, for the time being I've configured a zapier task that will geocode using their built in code action to filter any added rows to the database, calculate their coordinates and send it along with the rest of the information since these get added via external forms anyways. Alongside using their coordinates to calculate the time zone with another external API. However, this will be extremely useful in updating existing locations within the database, if the address is incorrect or needs to be modified in any way. Re: Lat/LongSomething to note, each row in our "locations" table that has an address field is automatically added via zapier already. So nobody is interacting with quickbase, opening pages, or editing to input this information, unless it is wrong or gets updated after the fact during our routine checks and surveys. So I may have to implement this in both our zap and on the quickbase application itself. I would love to go through and batch these locations without exporting them, but if thats not possible its no problem. Thank you for your assistance.Re: Lat/LongI suppose I could try the image onload technique or run every added location through zapier parsing the address with the js code to update the record.Re: Lat/LongThanks Dan, any guidance on how to get this rolling inside of quickbase? I am unfamiliar with some of the javascript practices and workarounds outside of making buttons inside of qb app.Re: Lat/LongI have a subscription to google cloud for many various projects I work on outside of quickbase. So the api key is no issue. I can export the data and re-import it with updated lng/lat information for all existing locations. But if I wanted to update a location as it comes in what would be the best route here without paying a fortune to have an addon installed to quickbase.Re: Lat/LongI simply need to convert the address field into lat and lng every time one is added.Re: Lat/LongI am indeed.Re: Lat/LongWhat would be the easiest way to run this on existing data in a table? A formula field?Formula URL Working IntermittentlyI have a Formula URL button that is working intermittently. Sometimes it will work and refresh the page. Other times it will go directly to edit the record it pertains to. If I click the URL button/image with CTRL + Click to open in a new tab, it will edit and refresh current page and open the record edit page in a new tab. Essentially performing the operation but still opening the edit record page. Other times, I click the URL and it will edit the record and refresh to current page. Any ideas? The way the formula is written, it only shows the button if condition is met, and then uses a checkbox field to determine the image URL, only operating on a second field and editing a date if other conditions are met. Other than the occasional quirk it works perfectly fine. If([InstallStatus] = "Installed", var text urlyes = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=bpex6r9cehf3tv575f5mcc4zthh&rid=" & [Record ID#] & "&_fid_204=1"; var text urlnodate = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=bpex6r9cehf3tv575f5mcc4zthh&rid=" & [Record ID#] & "&_fid_204=0" & "&_fid_250=" & ToText(Today()); var text urlno = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=bpex6r9cehf3tv575f5mcc4zthh&rid=" & [Record ID#] & "&_fid_204=0"; If([Needs Audit] = false, "<center><a href=\"javascript:" & "$.get('" & $urlyes & "',function(){" & "location.reload();" & "});" & "void(0);\"><img src=\"https://images.quickbase.com/si/32/203-info.png\"></a></center>";, If([Online] = false and ToDays(Today()-[Last Audit Email Date]) >= 7 or [Online] = false and IsNull([Last Audit Email Date]), "<center><a href=\"javascript:" & "$.get('" & $urlnodate & "',function(){" & "location.reload();" & "});" & "void(0);\"><img src=\"https://images.quickbase.com/si/32/204-warning.png\"></a></center>";, "<center><a href=\"javascript:" & "$.get('" & $urlno & "',function(){" & "location.reload();" & "});" & "void(0);\"><img src=\"https://images.quickbase.com/si/32/204-warning.png\"></a></center>"; ) ) )Multiple Parent or Master Record RelationshipThis is kind of difficult to explain... Locations/Company Table Notes Table Issue Table I have Notes and Issues both children of the parent table Locations individually. But I want to also add the same Notes Table to be a child of a Location's child Issue. So that when I go to a location, enter an issue record and add a note, it will automatically populate the parent relationship with the same location as the issue has. I've tried this a couple of times to no avail using Dynamic Form Rules. Locations < Notes Locations < Issues Issues < Notes The reason for this is I want to be able to have all of the cumulative notes within the Locations under the same relationship and in the same report. Not all notes will be associated with an issue, but some issues may have notes. All issues will be associated with a location and all notes will be associated with a location. I just don't want to have to manually select the location while already in the issue adding a note.