About kalmen_chia

kalmen_chia · 06-05-2021

Hi, I wish to find out, I have set up a webhook and it gets triggered when the user adds a new record to their Mobile app and sync to the Google spreadsheet, Now, if I do it the other way round, I will create a NEW row at google sheet first, so my qu...

kalmen_chia · 05-17-2021

Hi, I am trying out to use the sample app, Field Delivery, and there is a Driver and Job sheet. I saw the other examples everywhere in order to get login user to view their own data is to use the [EmailColumn]=USEREMAIL() and set them in the Security...

kalmen_chia · 05-17-2021

Hi, I have a column “Order Status” which is ENUM [Pending,Started,Finished,Cancelled], and I wish to block the user to save record when user change from Pending to Finished, or change from Started Back to Pending, or change from Finished to Cancelled...

kalmen_chia · 05-17-2021

thanks @Marc_Dillon , to take a look at my question, I am trying to check whether this is possible, LOOKUP(USEREMAIL(),"Driver","Driver","Email" ) = USEREMAIL() at security filter, is there any advice for this way, I saw this message “Note, this expr...

kalmen_chia · 05-17-2021

Thanks all for the help.

kalmen_chia · 05-17-2021

Hi Aurelien, thanks for the advice and idea, Aurelien: SWITCH([Order Status], "Pending", LIST("Finished"), "Started Back", LIST("Pending"), "Finished ", LIST("Cancelled "), LIST("Finished","Started","Pending") ) what works for me is as follow, SWITCH...

My Stats

kalmen_chia's Bio

Badges kalmen_chia Earned

Recent Activity

Will webhook still works if we create rows at google sheet 1st?

Filter own data by driver id not by USEREMAIL() during login?

How to prevent user to change status back to old value?

Re: Filter own data by driver id not by USEREMAIL() during login?

Re: How to prevent user to change status back to old value?

Re: How to prevent user to change status back to old value?