Inspection points based on product HELP!

[Julian_Garcia]

Hi please help me,

i have a quality check app, the problem is not all quality check have the same point, by example:

product1   have 3 points to check,  decay, scar, break

product2  have 2 point to check decay and color

how can i create diferent inspection form base on product?

[Aurelien]

Hi @Julian_Garcia 

You can:

- use different forms, based on the product category (quite advanced...)

- use as many columns to check as you need, and use a Show_If condition for each column (easier to implement)

I suggest you go with this one.

You can use another table for, depending on each product type, display the items you want to check.

[Julian_Garcia]

use as many columns to check as you need... look great the problem i need to generate a report with check points and i dont want the unfilled points, what can i do?

[Aurelien]

Which point is your question about? Report template or app form ?

For the report, as the one you are displaying, you will use a template with this condition:

<<If:ISNOTBLANK([SkinBreakdown])>><<[Count_SkinBreakdown]>><<EndIf>>

or

<<If:[Count_SkinBreakdown]>0>><<[Count_SkinBreakdown]>><<EndIf>>

this way, if there is no value then no element will be written.

[Julian_Garcia]

if i do that the table header will hide too?  because i will have about 15 checks point options, and each product have 3 or 4, so i dont want all the headers in the table

sorry for my bad english

[Aurelien]

yes.

If you display all the products in a "table" view type, you will have all the headers. 

When you create a new checklist, because you set Show_If condition on some columns, these won't be displayed in a Detail view type or Form view type.

If you wish to display items homogenously, I suggest you create categories of items, with their appropriate check-list columns.

[Julian_Garcia]

create category of items are not an option because they will 30 combination or more. maybe my logic is wrong they are another way to make this?

diferents products have diferents check points, each product have 3 or 4 check point from a list of 15 check points

[Aurelien]

Ok, then you may want to add your checklist display options in your product table as well. 

Here is my suggestion:

Table PRODUCTS, with columns:

- key ==> Type Text, Property Key ON

- description ==> Type Text, Property Label ON

- display_Check1 ==> Type Yes/No

- display_Check2 ==> Type Yes/No

- ...

- display_CheckN==> Type Yes/No

Table CHECKLIST_LOG, with columns:

- key ==> Type Text, Property Key ON, initial value expression UNIQUEID()

- Product ==> Type Ref, source table PRODUCT

- check1 ==> (any type you need), Show_If expression: 

[Product].[display_Check1]

- check2 ==> (any type you need), Show_If expression: 

[Product].[display_Check2]

- ...

- checkN ==> (any type you need), Show_If expression: 

[Product].[display_CheckN]

This way, you tick once and for all if your column option should be displayed or not.