I am trying to use a page in my app (frontend) to register users into my backend system. I have a spreadsheet that records user info which is then passed through to the backend via cloud functions on the Google Cloud Platform.
Ideally, if the current logged-in user hasnโt been recorded in the table yet, then an โAddโ action would be present such that they can register with their info. If the current user however has registered prior, an โEditโ action would be present such that they can change whatever info they previously inputted.
This is similar to a question that I had asked previously, namely this but the solution here doesnโt seem to work anymore. That is, Iโm using
ISBLANK( FILTER( table , [email column] = USEREMAIL() ) )
for the โAddโ action and
ISNOTBLANK( FILTER( table , [email column] = USEREMAIL() ) )
for the โEditโ action. But this only seems to work with the โEditโ action on not the โAddโ. In other words, if a user is brand new to the app, they canโt register their info. Any particular reasons as to why this may be happening?
Your help is appreciated!
Solved! Go to Solution.
@Steve Thanks for the info.
I switched to a card view and that seems to have solved the problems. The method of having actions with conditions such as
IF (IN(USEREMAIL(), alpaca_keys[user_id]), true, false)
or those described in the post I linked earlier all work for this situation.
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |