"Show If" beetween Form & Detail View ?

Jerome_TSC

Hello Dear Community !

I have a "Site Inspection" App, where I allow up to 5 pictures to be taken (not mandatory) per submission. So I have 5 column in my Database (Photo1, Photo2, Photo3...etc)

For "ease of use", upon technician inspection I "Show" another photo field, only if there is an image taken on the previous slot...

I use as formula in "Show-IF" :

IsnotBlank(Photo1) // for Photo2 Column.
IsnotBlank(Photo2) // for Photo3 Column.
IsnotBlank(Photo3) // for Photo4 Column.
...etc

This is OK for the "form view" which is used for the inspection....Wanted behavior.

But I also Use this database to report to Customer. And in the "Detail View" which is used to render images, If there is for example 3 photo, the 4th image field is appearing and is empty...

Logical Behavior, but not really wanted..

Could you please help me on how to resolve this ?

Many thanks !

TeeSee1

Try

IF(
 CONTEXT(ViewType) = "Form",
 ISNOTBLANK([Photo 1],
 ISNOTBLANK([_THIS])
)

for Photo 2 and so on.

yasarcan

Hi Why don't you work with a reference table?