How to add multiple forms but each entirely differ...

Homerthis · 09-16-2019 02:40 AM

Hey!

I try to create an app for communicate between the office and the agent outside on intervention.
I made multiple forms for the 20 client I have. For each the form is personalize because there is multiple possibilities but not the same for each.

My problem is that I want in my app have the choice of wich form I do but for now I only can have one single form

Thanks for helping me and sorry for all the mistake I’m not english

Aleksi

So you have 20 different form views and you would like to create a view that you can trigger all of them?

Homerthis

Hello, Thanks for the help!

I can try to eplain better but yes (I just don’t understand form “view” )
I work with horses, Agents go to horse club (20 clients) and see one or multiple of horses (15 horses for each clients)
When they do something with one horse I want they complete a form

But how they can have the choice of 20 forms to choose the right client

Aleksi

You have 20 different tables in your app? One table for one client? (or maybe little more for other purposes).

Homerthis

If “tables” significate google form
Yes !

Aleksi

When you add a Google Form as a source to your app, it creates a table into your app.

Homerthis

Ok!
Can we add differents form in source of a single app?

Aleksi

You would need to add them through the response sheet. Better option is to create one spreadsheet with 20 sheets and then add those sheets one by one to your app.

Homerthis

OK, I got it
I will test and see if it work

Thanks

Homerthis

And Maybe, there is a exemple app adapted for this ? For now I choose field service, it’s the one ?

Aleksi

That’s fine. Have you thought about if there could be a chance to use the same form for all clients? It would be much simpler if there would be only one table as a data source.

Homerthis

Yes but I’m afraid the form will be too big and lag. Because I need for all client a list of all horses. And I need data go to separate calc for exploiting them

Aleksi

Is the difference between these clients only how many horses they have?

Homerthis

No the name of horses is different, the number too, and for facturation we need to classify the client and the horses for each

Aleksi

Have you thought to use related table structure where the client is a parent record and the horse is a child record?

Homerthis

No!

There is a tutoriel for learn how do that ?

Aleksi

Please check this article…

How to add multiple forms but each entirely different?