Partition expression - USERSETTINGS()

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 :

Kayphy_0-1657201519129.png

And when I try to use it, here is the error:

Kayphy_1-1657201595123.png

Kayphy_2-1657201663382.png

I don't understand why it includes the "DocId" as the table only contains the "Contrat 1" and "Contrat 2"

 

0 6 181
6 REPLIES 6

I believe the user setting to be retrieved must be enclosed in double quotes:

USERSETTINGS("Contrats")

 

That's right. Here's the reference, @KayphyUSERSETTINGS() - AppSheet Help 

Hi Willow and dbaum,

I also tried it, it's the same error:

Kayphy_0-1657284892600.pngKayphy_1-1657284953623.png

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?

Steve_0-1657289317380.png

Show? must be enabled or have an expression.

Hi Steve!

Yes it is set to Show :

Kayphy_0-1657289612521.png

 

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?

Screen Shot 2022-07-08 at 5.47.05 PM.png

Top Labels in this Space