I’m currently trying to make an overgrown app sync more quickly by consolidating more-or-less redundant tables in the Google spreadsheet. On the AppSheet side, I’m using slices from the same table for different views. So far, this seems to have the desired effect of greatly speeding up my sync times. I have one problem though. I can’t seem to get ref columns to work between slices if there is only one table in the Google spreadsheet. I suspect that this simply isn’t possible, as linking two slices from the same table wasn’t the original idea of a ref column, but I’d like to double check. In order to get ref columns to work, do I need to have two different tables in the spreadsheet or can views based on different slices from the same table be linked via ref?
By the way, I know how to connect views based on different slices from the same table via actions. It’s just that the ref connection has a different appearance that I was hoping to take advantage of without creating a separate table.
Also, when ref columns don’t work, the AppSheet editor doesn’t do much to help a confused user like me understand what’s wrong. Everything seems fine until you actually test out the app itself and see that there you don’t have a link where you were hoping to have one. I’ve found this to be frustrating in the past too.