Hi All. Please advise possibility of below, a...

Hi All. Please advise possibility of below, and how to if possible.

In the case of building a data collection app, is it possible to apply specific survey/questionnaire to specific logins?

Eg. I have 15 employees and 3 questionnaires. 7 people apply to questionnaire 1. 3 people apply to questionnaire 2 and 5 people to questionnaire 3.

I need to allocate specific questionnaire to login, is this possible in appsheets?

0 2 299
2 REPLIES 2

You can have a table โ€˜employeesโ€™, where you keep employee information including email, as well as a column โ€˜questionnaire_numberโ€™. Then you have 3 tables; questionnaire_1/2/3.

For each table, you make a view , and for each view you have to edit the Show_if to: LOOKUP(USEREMAIL(), employees, email, questionnaire_number) = 1/2/3

Thanx Paul. I will try this.

Top Labels in this Space