I’ve run into a new problem with a key column.
The app is not deployed yet and I have a table that uses a column as key that has a spread sheet formula in it. It works just fine.
The problem is, that everytime I save the app, the key changes to the rownumber column (at the top). Then there comes an error that it is not a suitable key column.
Then I set the cross again to the spread sheet formula column and it works again. Until I save the app again.
Why is that? Can’t I use a spread sheet formula column as key? And if yes, why does it work if I don’t save the app.
Thanks in advance.