Hi. Am new to app sheet and am trying to do ...

(Dorji Yeshi) #1

Hi. Am new to app sheet and am trying to

do a

office stationaries/furniture/other material REQUISITION APP. So ,any help on the following will be highly appreciated:

1.My appsheet

requires sign in using the google (gmail) 2.I have a inventory of all stationaries/furniture/electronics (in google sheet) which are there in office normally.

3.My users should be able select every item thay want (from a list of over 50 items) and specify the quantity.

So i I want to capture the email address of the user (who have submitted a request) in the google sheet. How to capture the email address?

Thanks.

(Aleksi Alkio) #2

#1 - Security > Require Sign-In > Require user sign-in > ON and choose the correct provider #2& #3 - Create an additional “Stationaries” table with all of your items. You can then call them with the Stationaries[Item] formula (add that formula into the Valid_If).

You can capture the email address with the expression USEREMAIL().

(Dorji Yeshi) #3

Thanks @Aleksi_Alkio I could capture the email address.

(Dorji Yeshi) #4

@Aleksi_Alkio Another doubt. I have in my sheet column named StoreApproval and StoreApprovalDate . 1. I want to record the datetime

as and when there is anything updated on the StoreApproval column. I tried using changeTimestamp to record datetime of approval, but would not record.

(Aleksi Alkio) #5

Are you saying… when ever you change the StoreApproval value, the ChangeTimestamp field is not updated?

(Dorji Yeshi) #6

@Aleksi_Alkio Yes Aleksi. Translate

(Aleksi Alkio) #7

What is the app name and account ID if it’s okay for you to open your app?