how to write the condition of pdf generation

[berrylimore]

Hey community. I am new to appsheet.

currently I use appsheet to create a inventory record

Here is my table 1

Then I want to generate a pdf with automation with all items on the same month ("MM") and same year "YY" by using a single button or question- Like Y/N

Then I tried to create another table (table 2) with a data - generate report? (Y/N)

In order to do that, "MM" from table 1 as a "ref", while "MM" in table 2 will be Enum in order to obtain all data with the same month(MM) from table 1. And Yes, it can.

However, when i add a new item into table 1 from appsheet

MM only show my initial value --- index(
LIST("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"),Month(Today())
), or new, which will direct to my table 2 (generate reports form)

As a result, what i need to write on condition in order to create pdf with all item in the same month?

[SkrOYC]

I'm not absolutely sure about how to solve everything, but at first sight you are not using strong key columns.

What is a key? - AppSheet Help