What I am trying to accomplish is to have a variable created based on the month/year of the report being used. On the website there will be a list of reports with different months of activity. I want the selector to use the date variable to find the selector that will choose and ultimately enter that report. Below is an example, so if the date is 01/2021, I want it to select the button to the left of the CR number.
Cost Reports
| CR num | Status | POS Begin | POS End | Total$ | %Est$ | Cumulative %Est$ | %Time | |
|---|---|---|---|---|---|---|---|---|
 |
PM PTB 0002AA-003 | Submitted Late | 1/1/2021 | 1/31/2021 | $44,285.95 | n/a | n/a | 14.22 % |
|
PM PTB 0002AA-004 | Submitted On Time | 2/1/2021 | 2/28/2021 | $1,597,991.93 | n/a | n/a | 27.49 % |
|
PM PTB 0002AA-005 | Submitted On Time | 3/1/2021 | 3/31/2021 | $1,334,981.63 | n/a | n/a | 42.18 % |
|
PM PTB 0002AA-006 | Submitted On Time | 4/1/2021 | 4/30/2021 | $1,705,289.04 | n/a | n/a | 56.40 % |
|
PM PTB 0002AA-006 | Working | 6/1/2021 | 6/30/2021 | $0.00 | n/a | n/a | 0.00 % |
fvalencia
hentsou_mamy