EnumList with ref not saving because of sync error

[Atxeco64]

Hello,

I have a table "joueurs" and a table "equipes" which has a EnumList column to store 1 to n players names. My problem is when I save the team, i have a sync error no matter if I select 1 or more players.

Here is the setup for the EnumList Column

Here is the selection dropdown, which is exactly want I want

I really don't understand why I have this sync error. 

Here is the pending change where the values selected are shown.

Can  anyone help me ? Thank you in advance

[Aurelien]

Hi @Atxeco64 

You must add a list in the Valid_If section of your column. 

Here is an example on my blog article: Faire une liste déroulante - Codergo

Note that this is an example: you must provide a list of id, using FILTER() expression or something like:

TABLE[id-column]

[Aurelien]

I read a little too fast: sync error is not supposed to happen after a change.

From your screenshot, I would suggest to file a ticket here: https://support.google.com/appsheet/gethelp

[Atxeco64]

Thank you for your answer Aurelien.

The problems seems to be only when adding a new player in the list. Removing works without any error. And the sync message says "Unable to ass rows to table 'equipes'. -> Invalid request provided to AppSheet database."

When I add a new teams with players directly in the database, i can see it correctly in the App. But, I cannot change the values 😞

As you proposed, i will file a ticket, maybe it is just a Key/Label problem

[Steve]

Please post a screenshot of the sync error screen.

Are you using AppSheet Database as your data source? Database has many problems and shouldn't be used. Use Google Sheets instead.

[Atxeco64]

Here are the screenshots

Yes, I use AppSheet Database.  Will try usind Sheet and let you know if it works better

[Aurelien]

I agree with @Steve , hoewever I would stick with the ticket and use a copy of your app with Sheets.

AppSheet dev team NEEDS to make this AppSheet Database working 😊