I am having trouble deleting a virtual column. From the docs it says to uncheck some box but I do not see that option and donโt know if the docs are out of date. I can go into the details for that column and choose delete and the column does disappear but it re-appears when I save.
The document you mentioned certainly sounds out of date. Can you point me to it?
Delete the virtual column from within its configuration:
Iโm not sure why it reappears, though. How are you saving? Are you clicking the blue SAVE button?
Thanks.
Here is the link to the outdated doc: https://help.appsheet.com/en/articles/919891-virtual-columns
The procedure you illustrated is exactly what I am doing. When I delete the column it does appear to be deleted immediately (i.e. it is no longer visible). When I save it re-appears (very strange). I have double checked to make sure it is not referenced in any other views and it is not.
Thank you for the linkโIโll try to get it updated.
I cannot explain the behavior youโre getting when attempting to delete the virtual column. I encourage you to engage support@appsheet.com directly, as it may be a bug or some corruption of your app config.
Thanks, I have sent an e-mail to support.
Iโve overhauled the Virtual Columns doc. Feedback welcome.
When you create a Ref type column you will get a Virtual Column automatically generated in the Table being Refโd.
For example, I have a WorkOrders Table that has a Ref column to select a Customer from the Customers Table. AppSheet will automatically generate in my Customers Table a Virtual Column named โRelated WorkOrdersโ.
This actually works in my favor because I donโt have to do a thing to get the list of Orders a Customer has placed. Its already there!!
I donโt think you can remove them. They should do not harm.
Huh. I had the same behaviour and Iโve fixed it using a weird workaround. Solution: In the ref_rows formula in the virtual column that keeps reappearing, change one of the parameters to a typo โ just mess up the value. Save. The virtual column then disappeared.
Edit: spoke too soon. If I refresh the page after saving, the virtual column pops up again.
You can use a show if expression to hide them
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |