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