I typically make the label of the field into a button with conditional formatting that performs an open url script. The conditional formatting changes the color to blue and underlines the label so that it looks like a typical web link when the field is not empty.
You can also set a script trigger to open the url in the field when the field is entered but ad an if statement to the scrit that if the field is empty the script exits.
Thank you Marc. I understand the words that you have written and when I try conditional formatting and script trigger I cannot set them up because I do not know what all the options mean.
I have tried "open URL" and then specifying and trying various options to play around with it but all I ever get is "the specified table cannot be found" which unfortunately is no use to me because I do not know what that means.
Thus, when I try to add a script trigger by clicking set script triggers I get all these options ( such as "OnObjectEnter") that do not seem like any that you suggested. So, I do not understand how to "open the URL in the field" or to add an "if" statement.
I think that the filed is setup as a button to open the URL and I can make it open the URL in the field when it is clicked. The cursor also turns into a hand when over the field. However, it always opens the same URL and I cannot input any other URLs into other records. So, in each record, even if the website field/box is empty, I can click it and it opens the same URL.
That is why I suggest using the script trigger or use the label as a button. Setting the field up as an actual button is going to make it hard to change anything that is in the field because now the field is a button and wants to open a url instead of letting your cursor in the field to change or add a value (url).
the script triggers:
OnObjectEnter will fire a script when your cursor enters the field.
OnObjectKeystroke will fire when you start typing in a field
OnObjectModify will fire after the field is modified when active
OnObjectValidate will fire before internal validation when an attempt is made to exit the field
OnObjectSave will fire after changes to the selected field are validated and saved
OnObjectExit will run when an attempt is made to exit the active field
The easiest solution for you would be to make the label a button that does the open url. You can set the check box to perform without dialog (no popup)
then on the right hand side click the specify button when the small Open URL Option window opens click specify again and your field list will open. Select the field that your url is in and click OK then OK then OK again to close all of the dialog windows. Click save layout, and you should be good to go.
Ahaaaa! It works! Thank you so much Marc! I have been trying to set that up for ages. Now it works as I would like. I can tweak the layout to make it clearer, like you said in your first response.
Thank you so much.