Hi,
I have a column named "Household" which is a type "URL" and have selected the option to have it be a hyperlink. That way when data is entered the link text can be entered as well as the URL. This works great except that I want the link text to be the table label, not the URL.
To try and make the link text the label I have created a virtual column to be the label and used this formula "LINKTEXT([Household]). This seems to work but when adding in a new "Household" I receive a sync error from AppSheet which I am providing a picture of below.
Any thoughts on how to correct this sync error or a different way to make the link text show up as the label instead of the URL?
User | Count |
---|---|
28 | |
13 | |
3 | |
3 | |
3 |