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

expressions
(John Henry Joseph) #1

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) #2

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

(John Henry Joseph) #3

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

(Aleksi Alkio) #4

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

(John Henry Joseph) #5

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

(Aleksi Alkio) #6

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 Joseph) #7

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

(Aleksi Alkio) #8

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

(John Henry Joseph) #9

@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…

(John Henry Joseph) #10

@Aleksi_Alkio This is the error part.

(John Henry Joseph) #11

@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) #12

Remove the extra comma :slight_smile: check my sample above.

(John Henry Joseph) #13

@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.

(Aleksi Alkio) #14

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

(John Henry Joseph) #15

Thanks

(John Henry Joseph) #16

@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) #17

What field it doesn’t find?