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.
Something like… OR(ISNOTBLANK([Pic#1]),ISNOTBLANK([Pic#2]),ISNOTBLANK([Pic#3]))
Thanks
@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?
What field it doesn’t find?
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])))>>
Exactly Mr.Aleksi… That’s what you already suggested It was my mistake to put a space between
You could try… SELECT([Related PMS Checklists][YourKeyColumn],OR(…))
@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…
Instead of PMS Code column, you should use the key column which is Checklist Code.
@Aleksi_Alkio This is my expression…
<<Start: ORDERBY(SELECT([Related PMS Checklists],[PMS Code], OR(ISNOTBLANK([Photo-01]),ISNOTBLANK([Photo-02]),ISNOTBLANK([Photo-03])))) >>
Remove the extra comma check my sample above.
@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 This is the error part.
@Aleksi_Alkio Sorry to bother you… now system says unable to find column “Checklist Code”
Send me an email with your account ID and app name aleksi@appsheet.com. I will check your app later today.
@Aleksi_Alkio Thanks lot Mr. Aleksi, I sent all information to you.
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |