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]

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

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.