However the event is never triggered. When I look in the test of the workflow I see neither the before or after is set. … so the condition always fails.
If I trigger the event manually then the email is sent as expected.
For what reason might
[_THISROW_BEFORE].[email]
and
[_THISROW_AFTER].[email]
The start page is a customized home page based on a special table. The user always starts on that page because its view is set as the starting view.
I just changed the virtual column to a real column with useremail() as its formula. I changed the event filter to use that column instead of the virtual one.
I am not sure precisely what you mean by launch page, but if you mean, the inbuilt one then yes it will appear once only for a new user. This is not anything to do with my issue.
The starting view, my start page I refer to, is displayed to the user as the first view as set in the options you mentioned, and appears every time a user enters the app … which is what I want.
Now I was hoping to use that view/associated table to trigger the email. I can understand why a virtual column may not be recognized (and only assumed it was ok because appsheet itself recommended the event formula). so how to do this?
The starting view, my start page I refer to, is displayed to the user as the first view as set in the options you mentioned, and appears every time a user enters the app … which is what I want.
Your response is confusing. I am stating a fact not an intent. I set the start view and that is the view the user sees when they start the app (except the first time, when they may see the inbuilt launch page with terms and conditions and so on). What else could they see?
It is a detail view. useremail() definitely evaluates because it is visible on the view. I can confirm the virtual column with useremail() as its formula, also does evaluate according to the test mode,
but as you imply the physical column with useremail() as its formula, does not seem to evaluate. So I( suppose that it requires some kind of further user action?
but as you imply the physical column with useremail() as its formula, does not seem to evaluate. So I( suppose that it requires some kind of further user action?
So in summary it is not possible to recognize a user has gone to that view (or indeed any other) unless there is some action they do that can be used to trigger the event. Is there any way around this?
Let me ask the question in a different way … Since appsheet pricing is based on distinct users how can I easily and quickly know when such a user logs into the app?
how can I easily and quickly know when such a user logs into the app?
You can see all sync events in the Audit Logs. This is neither “quick” nor “easy”, if you ask me, but there is no other way. (also check out the “Usage Statistics” on the same page)
Yes I can see the app sync – Start with an email buried in the hundreds of sync events. As you say not quick or easy.
BUT … the usage statistics do indeed show Unique app user emails in alphabetical order, but no obvious way of detecting a new one since this would be over a month. But I see on the core plan I can get individual app users per day. This would probably give me what I was looking for.
Thanks for your help, I think this will do for now.
