Using Hyperlinks in tables and forms

I have the following formula that works okay in the table but as it is a formula does not work in the data entry form. The field is displayed in the form but you can't activate it as it's a formula.


=IF(K2="","",HYPERLINK(CONCATENATE("https://www.carjam.co.nz/car/?plate=",K2)))


What I am trying to do within the form is when a car registration number is entered in cell K2 should one want to check the make and type of vehicle then they just click the link that will take them to a webpage and display the information.


Can i somehow create this link in the data entry form?



iPad 2, iOS 9

Posted on Aug 30, 2021 9:36 PM

Reply

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Using Hyperlinks in tables and forms

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.