I am trying to add a Partition accross many files/sources. The goal is that I have many tables from diffirent worksheet and they all have the same Data structure which is complex. So I want to partition it and to not have to configure all of it everytime I add a table. The problem is that I am unable to find the right USERSETTINGS(). I configure the User Setting :
And when I try to use it, here is the error:
I don't understand why it includes the "DocId" as the table only contains the "Contrat 1" and "Contrat 2"
I believe the user setting to be retrieved must be enclosed in double quotes:
USERSETTINGS("Contrats")
That's right. Here's the reference, @Kayphy: USERSETTINGS() - AppSheet Help
Hi Willow and dbaum,
I also tried it, it's the same error:
I saved and all with the change and it is exactly the same error..
Thank you
Is the Contrats column in User Settings set to display?
Show? must be enabled or have an expression.
Hi Steve!
Yes it is set to Show :
Thank you
Ok, I think the USERSETTINGS error is a red herring. It seems the real issue is with some partition settings you have inserted on a Table definition of the same name.
I think the partition error is preventing a successful build of the app and therefore AppSheet cannot properly find the app USERSETTINGS
Do you have a table named Contrats? If so go to the Table tab for that table and then expand its "Scale" section (see image below). Do you have partitioning turned on? If so, do you need it? If you do then what is your expression in the property name Partition Expression?
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |