Sync Error with trying to use LINKTEXT for the column label

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?

Screenshot 2024-10-27 9.39.56 AM.png

0 2 281
2 REPLIES 2
Top Labels in this Space