How to add user's information at form button

Ask for Help
1

hello, there.

i want to find “username” from “user” sheet for using SPECIAL VALUES “user’s email” at form button.

“product” sheets have these items.
oooooooooooooooooooooooooooooooooo
productname
pencil
apple
oooooooooooooooooooooooooooooooooo

and “user” sheets have these items.
oooooooooooooooooooooooooooooooooo
usermail username
aaa@aaa ken
bbb@bbb james
oooooooooooooooooooooooooooooooooo

i made “product” tab from “product” sheet,
and i added form button.

i want to use “username”,
when i push the form button.

can i get “username”?

i want to find username from “user” sheet for using SPECIAL VALUES “user’s email”

2

Are you trying to show the the username on the form or are you trying to get the username in the form response sheet? If you just want the username in the form response sheet after submitting the form, then you can save the email special value to the sheet, then create a relation column to link the email in the form response sheet to the email in the user sheet. Then create a lookup to get the username from the relation.

3

thank you for your answer.
i wan to show the the username on the form.

i want to display user name every pages.

for example product page , or form or everypase.

for example ,
“james is login now”

(james from user sheet from using login user mail)

4

I think that might be really hard to do at the moment. You would have to have a duplicate page for every user where the row has their email address. Then you could create a relation and lookup to the user sheet to get their name. But again, you would have to duplicate everything, so each user would have to have their own Pencil row and their own Apple row, etc.