Create custom input form based on field value in a master table

AppSheet AppSheet Q&A
, ,
1

Hello All,

I’m trying to create input form. The purpose of this form is a quality form when I receive return product.

we have dozens of different types of product and each type of product has different quality controls.

For instance:

  • For Product type 1, I do controls A, B, C,…
  • For Product type 2, I do controls A, D, E,…
  • …

I’ve a created a master table(read only) with 3 colunms: Product (product1, product 2,..) , control (A, B, C, D, E,..) , input type (Yes/no, text, number,…) in order to define the different cases possible

I wanted to use this table to display custom input form based on it and save to results in another table (RETURN_TABLE: add-only)

Looks like, i don’t know how to make it work.

Do you have any idea how i could handle it ?

If it cannot work do you alternative solution ?

In davance, thanks for your help

PG

2

when the table is “READ ONLY” how do you make entries (I mean Input types) ?

Usually values are pulled from master table by means for initial value settings.

If you want to create a record/entry in another table by using this values this table.

there is action called :

Capture 2.PNG
Capture 2.PNG693×170 9.32 KB

3

Many Thanks @jaichith .

My issue is not on adding record to a new table. my issue is to create the customized form

4

Few questions.. can the number be what ever or are they like less than 10? How many different controls do you have? What is the max control quantity for one product?

5

please elaborate your need.

6

Hello @AleksiAlkio ,

We have about 40 differents type of products and about 200 different type of controls. Overall, as of now, we have 1000 combinaisons used.

Thanks

PG

7

@jaichith ,

today I manage the controls on paper form: 40 different templates :disappointed_face:

I have about 40 differents type of products and about 200 different type of controls. Overall, as of now, we have 1000 combinaisons used.

I would like to integer this step (QUality check) in my app but i would like to avoid to create 40 differents tables, 40 differents forms,… that’s why i’m looking for a dynamic form where only the controls to be done for a given product would be displayed.

8

But what is the max qty of controls one product can have?

9

Some how I am getting you. can you please post some forms sample and test data? I have done something similar to your requirement.

10

This is the approach I have used with few clients. Lets assume you have max 40 different quality controls for the product.
#1 - The Master table has Product type, 40x (Control name and InputType columns)
#2 - In the “Controls” table, you will have 82 columns, Product (Text), ProductType (Ref) and 40 ControlA (Text) columns and ControlB (Y/N) columns
#3 - Both Control columns read the Control name for the Display name with the deref like [ProductType].[Control1]. It can also read the Input type for the user like [ProductType].[Control1]&“( “&[ProductType].[Input1]&”)”
#4 - You can also check with the Valid_If if the value is properly filled based on the Input type.
#5 - Based on the number of Controls you have for the Product type, you can hide Control columns one by one with Show? option using ISNOTBLANK([ProductType].[Control1]).
#6 - If the input type is Text or number, show just the ControlA, and if it’s Y/N, show only the ControlB.

1 Like
11

Many Thanks!

I’m going to try it

Thanks

PG

12

You’re welcome!