Can we replace google form with appsheet in making Q/A forms

[eldderri]

Hi friends,

   Is there any way to replace using google form with appsheet in making question and answer forms sent via email ?The app should include:

1. Table for themes
2. Table for form 
3. table for responses
4. table for employees data

If there is a way please give me a sample form

Best regards,

[AleksiAlkio]

Do you think this for public or does it need an authentication?

[eldderri]

I need to use it inside my company which of course requires authentication as employees are in the same domain

[AleksiAlkio]

In that case, yes you can defenitely do that.

[eldderri]

Can you give me some guidance based on the tables I have already mentioned in my first post?

[AleksiAlkio]

Little bit difficult to know how you are going to use Theme table. I assume Form table is meant to have different queries and their questions.

One way to build this and if you are not changing your questions in the Form table.. In the response table read the question based on the Form record selection with the Display name option. Set the Form column as Enum (base of Ref) and then you can read the question with each columns like LOOKUP([_THISROW].[Form],Form,ID,Question1).

[MultiTech]

You might find the following app I put together helpful, it can demonstrate to you how to use your Theme table as a template for your Form table - though I doubt you're building things the same way.  (And I should mention, this app is very non-standard in it's data scheme; I wouldn't advise copying it.)

This app can show you how to use actions, references, formulas, etc. to take the details from one set of records and use them in another set of records.

https://www.appsheet.com/start/a952b233-6957-45ba-aa8a-33e441c13757?refresh=1&platform=desktop#vss=H...