HeyItsDoug Posted November 29, 2021 Report Share Posted November 29, 2021 I posted this in General Questions but I think it is better suited here... I have a virtual field on a table view detail screen that contains a single value SELECT statement, fetching a street address, using an emp ID retrieved from a dropdown on the same form. I use this street address in an HTML Block to retrieve and display a google map with the fetched address. It all works fine except when the user changes employees on the dropdown and the virtual field updates with the new address, the reference to the virtual field in the HTML BLOCK does not update. How can I ensure the virtual field reference in the HTML BLOCK updates in real-time? HTML BLOCK: NOTE - [@calcfield1] is a static street address. <script type="text/javascript"> // Popup window code function newPopup(url) { popupWindow = window.open( url,'popUpWindow','height=600,width=900,left=10,top=10,resizable=yes,scrollbars=yes,toolbar=yes,menubar=no,location=no,directories=no,status=yes') } </script> <a href="JavaScript:newPopup('http://maps.google.com/maps?saddr={[@calcfield:1]}&daddr={[@cbParamVirtual1]}');">Map Route</a></p><font color=#a52a68> Thanks for any suggestions Doug Quote Link to comment Share on other sites More sharing options...
kpcollier Posted November 29, 2021 Report Share Posted November 29, 2021 12 hours ago, HeyItsDoug said: and the virtual field updates with the new address, the reference to the virtual field in the HTML BLOCK does not update. Maybe try adding another Calculated Value to the form. Just make the Calculated Value's value to be equal to the Virtual Parameter's value. And use it in place of the cbParamVirtual1 in your anchor tag. Quote Link to comment Share on other sites More sharing options...
HeyItsDoug Posted December 1, 2021 Author Report Share Posted December 1, 2021 Thanks for the suggestion. Unfortunately, that hasn't worked either. I tried creating this scenario in a Submission form (without Calc Fields obviously) using Virtual fields but again, they do not update within the HTML block. Quote Link to comment Share on other sites More sharing options...
Kurumi Posted December 6, 2021 Report Share Posted December 6, 2021 Hi @HeyItsDoug - you may try this solution: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.