Report Generator Valid If

[Nadhirah]

Hi everyone, I need help on making report generator.
So this is my setup database in AppSheet for the report generator table

I only used Valid If for this table from Schedule table(as below) for the dropdown. 

Select Frequency --> Schedule[Frequency]
Select PPM --> Schedule[Task Type]
Select Month --> Schedule[Month]
Select Preferences --> Schedule[Format Date]

Select Trade is unused.

However the result for the dropdown does not follow selected data only for Select Preferences.
Result:-

The Select Preferences is not following the other dropdown at all. Can you guys help me on this? Thank you so much!

Schedule Table

ID

Task Type

Frequency

PPM Scheduled Start Date

Day

Week No

Month

Job Status

Checklist done

Total Checklist

Percentage Completion

Colour Code

Service Type

Format Date

Year

Month Text

Timestamp

Tech's Department

Attended By

Tech's Contact No

Tech's Signature

Inspection Report/ Remarks

Tech's Comment

Task Complete

Completion Time

Task Checked

Checked By

Checked Timestamp

Engineer's Signature

Engineer's Comment

Acknowledge By

Acknowledgement Timestamp

Verifier's Signature

Verifier's Comment

Status

Softscape-Daily-03-06-2025

Softscape

Daily

3-Jun-2025

Tuesday

23

6

No Action

0

1

0.00%

Red

Landscape

03-06-2025

2025

5-May

No

Planned

[Suvrutt_Gurjar]

Please try with     SELECT(Schedule[Frequency], TRUE) ,  SELECT( Schedule[Task Type], TRUE),   SELECT(Schedule[Month], TRUE) and SELECT( Schedule[Format Date], TRUE)

[Nadhirah]

Do i put this in each valid if accordingly?

[Nadhirah]

I tried putting it in each valid if accordingly but the result is still same

It should only return date in month 11 but instead it is showing all dates

[Suvrutt_Gurjar · Accepted solution]

Oh, got it, sounds that you are looking for "dependent dropdowns" feature?  Meaning when first option is selected, next fields should show only options applicable for first selection? It is not coming out clearly in your description because you also mentioned so as below

---

@Nadhirah wrote:

The Select Preferences is not following the other dropdown at all

---

Anyway, if yor are looking for dependent dropdown behavior, you may want to double check your Schedule table data structure. 

Please take a look at the following help article and especially sample app for understanding 'Dependent drop down" data structure. Also please ensure your columns are next to each other in the Schedule table.

Dependent drop-downs - AppSheet Help

[Nadhirah]

I see, thats why its not what i expected it, thank you so much

[Suvrutt_Gurjar]

You are welcome.