Iโm trying to make a workflow that notifies all users when someone inserts a new entry.
I have a table that includes all users (name, email, etc.), so instead of writing the email addresses one by one, I want to make an expression for that.
SELECT(Users[Email], TRUE) - doesnโt do the job.
Any idea?
If you use this SELECT(โฆ) formula as a formula, not as a text, it should work. Users[Email] should work as well.
Mmmโฆ it doesnโt work.
I have 5 users (5 rows in โUsersโ table).
It sends the notification just to meโฆ
It sounds that you havenโt deployed the app yet. In prototype mode it sends all emails to app creator.
It is deployed.
What is your account ID and app name if I check your app?
Itโs Private, but you can check โSimplex Flightsโ
Sorry, I couldnโt find any app with that name. If itโs private, you can send your account ID and app name directly to aleksi@appsheet.com
Turns out that Users[Email] is not working.
With the SELECT() function, it did notโฆ strangeโฆ
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |