Hi. I am trying to get the url field type working. I have a table called Product_Master_File which has a column [Cubic Metres]. When adding a product not everyone will know the cubic metre value so I have added a virtual column, type url. I have another table called External_Links_Index with 2 columns i.e. [Url] & [Link Text]. So i want to use the app formula in the VC to pull out a specific row and make it a url link to the Cubic Metre Calculator Google Sheet.
I have something like this so far but it is returning a null value.
“Cubic Metres Calculation”)
The number in the CONTAINS part of the expression being the id of the tab in the google sheet. Am I on the right track here. Any help would be great, thank you.