I have a child/transaction table which contai...

[John_Henry_Jose]

I have a child/transaction table which contains few ordinary fields and 3 image fields. These 3 image fields are optional.

When i develop a workflow/report, i want to have all records which has images. How to write a select expression please?

Thanks.

[Aleksi_Alkio]

Something like… OR(ISNOTBLANK([Pic#1]),ISNOTBLANK([Pic#2]),ISNOTBLANK([Pic#3]))

[John_Henry_Jose]

Thanks

[John_Henry_Jose]

@Aleksi_Alkio When i try to use “SELECT” in transaction table in workflow, system throw a error that particular field is not found. Can you please advise?

[Aleksi_Alkio]

What field it doesn’t find?

[Aleksi_Alkio]

So… the problem is solved. The correct syntax was… <<Start:

SELECT([Related PMS Checklists][Checklist Code], OR( ISNOTBLANK([Photo-01]), ISNOTBLANK([Photo-02]), ISNOTBLANK([Photo-03])))>>

[John_Henry_Jose]

Exactly Mr.Aleksi… That’s what you already suggested It was my mistake to put a space between

[Aleksi_Alkio]

You could try… SELECT([Related PMS Checklists][YourKeyColumn],OR(…))

[John_Henry_Jose]

@Aleksi_Alkio If you see the attached file, it’s working fine. But in “Related PMS Checklist” there are pictures. I want to print them as separately as “Media”. Therefore, after "<>, i put the code as per above attached. getting error that “photo-01” photo-02, photo-03 not found…

[Aleksi_Alkio]

Instead of PMS Code column, you should use the key column which is Checklist Code.

[John_Henry_Jose]

@Aleksi_Alkio This is my expression…

<<Start: ORDERBY(SELECT([Related PMS Checklists],[PMS Code], OR(ISNOTBLANK([Photo-01]),ISNOTBLANK([Photo-02]),ISNOTBLANK([Photo-03])))) >>

[Aleksi_Alkio]

Remove the extra comma check my sample above.

[John_Henry_Jose]

@Aleksi_Alkio My apologies. Now system says “PMS Code” not found… For both table “PMS Code” is a reference from Master to Transaction. Attached column specs for your kind reference please.

[John_Henry_Jose]

@Aleksi_Alkio This is the error part.

[John_Henry_Jose]

@Aleksi_Alkio Sorry to bother you… now system says unable to find column “Checklist Code”

[Aleksi_Alkio]

Send me an email with your account ID and app name aleksi@appsheet.com. I will check your app later today.

[John_Henry_Jose]

@Aleksi_Alkio Thanks lot Mr. Aleksi, I sent all information to you.