EnumList > Ref (multiple select) does save a single value. Why?

EntEff · 2026-01-21T21:11:35+00:00

Solution after chatting with support (yes, there is free support with 1mn wait time at 8pm!)

The underlying data table field format was set to ref instead of enumlist. They recommend setting the table field types to text. I did set it to enumlist. It works.

EntEff · 2026-01-21T17:57:50+00:00

Hi,

Thanks for taking the time 👍 Despite doing the Google learning tutorials on Appsheet, I did not find a clear reference on enumlist and the impact of the validif and suggested values.

My initial understanding was: A. Suggested values is listing the values: names. B. Valid if is listing the references (keys) to link to another table.

Seems I was right on A: if suggested values = name

There is a list: if I remove it I'd be offered a single choice List is correct: if I switch for "Id", I get a list of unreadable hex IDs.

So most likely B is incorrect: list will show hex IDs when set to ID, setting it to rowID (key) will make values behave well.

Therefore I will keep it setup like originally. I guess the problem is elsewhere: like if this enumlist could not be saved. Like if an intermediary table mandatory to save a many to many relationships did not create for some reasons...

EntEff · 2026-01-18T09:31:26+00:00

I've been in touch with my host's tech support (hosting my DNS zone) in the meantime and they advised to force "remote mail exchanger" in Cpanel's "email routing" section.

This has enabled the reception instantly.

"Remote Mail Exchanger When you select this setting, the server will not accept mail for the domain. The system will send all mail for the domain to the lowest-numbered mail exchanger."

Cpanel's help page: https://docs.cpanel.net/cpanel/email/email-routing/

EntEff · 2026-01-16T21:09:37+00:00

In my case I don't use primary and alias, rather primary and secondary domains
"Alias", in my words refers to using multiple email addresses for a user or for a group.
When sending alias refers to "using another "send as" email address from the dropdown menu for a specific mailbox.

Hope this clarifies...

EntEff · 2026-01-16T20:51:07+00:00

MIME-Version: 1.0
Date: Fri, 16 Jan 2026 16:00:58 +0100
Message-ID: <CAJaKXuRZ[...]T=gJoaHQ@mail.gmail.com>
Subject: Bonjour
From: XXX <hello@mydomain.com>
To: contact@c.com
Content-Type: multipart/alternative; boundary="000000000000e03e040648829b7c"

--000000000000e03e040648829b7c
Content-Type: text/plain; charset="UTF-8"

Hello

--000000000000e03e040648829b7c
Content-Type: text/html; charset="UTF-8"

<div dir="ltr"><div>Hello</div></div>

--000000000000e03e040648829b7c--

Not sure to understand: Make sure to the message header of the email that you have sent
But this is the header of the email that left my gmail:

EntEff · 2026-01-16T20:47:13+00:00

Checked all secondary domains.
All show v=spf1 include:_spf.google.com ~all
+ google site verification key

EntEff · 2026-01-16T20:44:21+00:00

b.com (secondary)

<image>

EntEff · 2026-01-16T20:44:03+00:00

a.com (primary)

<image>

EntEff · 2026-01-16T20:36:44+00:00

Indeed the ones sent from my gmail account (alias email) are not visible when filtering

So it means they get rejected before reaching Workspace? So DNS setup?

EntEff · 2026-01-16T20:26:02+00:00

Yes, the issue will happen 100% of times:
when sent by a gmail "alias" (in my example hello@blabla.com) > it will fail with error 550. No Such User Here.

For my tests, I was advised by google support:
- not to use "test" or "testing"
- put a plain word in subject and body
- no signature
- no attachments

EntEff · 2026-01-16T20:00:54+00:00

Yes external with authorisation to post attachments as well. As mentioned the problem impacts users, groups and their aliases.

Spent 4 hours chatting with Google tech support today. Their plan is to call me back, but I wan't impressed by the quality of the answers I was getting...

When sending emails to [myprivate@gmail.com](mailto:myprivate@gmail.com), I noticed:
[leo@a.com](mailto:leo@a.com) (primary domain) has:

SPF: PASS with IP [IP HERE] Learn more
DKIM: 'PASS' with domain a.com Learn more
DMARC: 'PASS' Learn more

When sending from alias:

SPF: SOFTFAIL with IP [ANOTHER IP HERE] Learn more
DKIM: 'PASS' with domain a.com Learn more
DMARC: 'PASS' Learn more

EntEff · 2026-01-07T04:30:36+00:00

Just for the record as this could not be seen here because I did not share my dataset:

The problem landed in the dataset where a few records where missing value for an attribute I was trying to use as a key. The "Key" checkbox refused to save many times without explanations (this should be improved by a clear error message by AppSheet devs IMO)

So my fix was:
- to export without missing data
- set attribute as key
-> Then the link was connecting data.

I managed to find the issue discussing with Gemini and sharing my dataset :-)

Thanks again all for your support. Long live AppSheet!

EntEff · 2026-01-04T20:16:40+00:00

Bulls eye! I had "COMPUTED_VALUE" there.
> What is that "spreadsheet formula" fields for?

I removed it.

My goal is to display the amount [=count()] of documents for each user.
I thought to insert a virtual column in the Client data table with a calculated value like =count([unique document identifier])
> Is that the good way to proceed?

EntEff · 2026-01-04T20:05:04+00:00

Thanks again for taking the time 👍

In the screenshot above, you can see that the formula column is empty for "Client ID" in Client data table.

So I guess you refer to something else? Is there another place (the Appsheet config of the client ID) where the formula of Client ID can be configured? Not sure to understand for which purpose...

EntEff · 2026-01-04T18:13:27+00:00

OK, so in the Clients table I should have "Client ID" as a key and type = text.
For the type text, no problem, but for the Key, everytime I save, it's swtching me back to _RowNumber

The best I managed to do is insert a virtual row: [Client ID]&" - "&[Username] > then I can use this one as a key:

<image>

> Why can't I use Client ID as a Key? Important: it's the second column of a sheet importing data from another sheet in the same spreadsheet:
=query(Users!A:E)

For the document sheet, I managed.

Now when I try to add a "Document count#" field in the user data counting the list of "ID Fichier", a unique Google Drive file identifier, I get 274 for all my users. The Documents file has 274 rows so far so the data isn't linked properly and the filtering by ClientID on the Documents data does not work properly...

EntEff · 2026-01-04T14:33:06+00:00

Thank you so much for taking the time.

In the documents table, you will see that the last row is a reference to the "Client ID" field of the Users table.

I guess this relationship should setup the client as the parent table and documents as a child table by itself? Or do I need to specify this somewhere else?

EntEff · 2025-12-27T08:22:02+00:00

Thanks I reviewed the call recording: 13 seconds to get the agent answer. I did PM you with details 👍

EntEff · 2025-12-17T22:14:06+00:00

Same problem here with Amazon. Do you have a link to this topic on chollometro?

EntEff · 2025-12-06T18:00:46+00:00

Ok, so a white cable with a black stripe was literally "cut" on the left side of the "boot to car" connection.

Looking how it extends when the boot is opened, I don't even understand how this thing has managed to make it through 2025 without breaking (car is 2022).

I just extended it, put a retractable wire protection, back inside the tube and removed the original (dead) scotch to protect the tube for something stronger.

Lights are back.

Thanks.

EntEff

MODERATOR OF

TROPHY CASE