Matches and match log

[tadeloach22]

I have two data tables, one is matches, and the other is a log of the matches completed.  The first question of the log is a reference to the Match named in the match table.  Is there any way I can have the match selection for the log only show matches less than thirty days old, and matches in the future?

Example, in the Matches, I have a Match listed for last week and one for 2 months ago

In the Match log, when I go to select a match and record gear used, I don't want the 2 month old match to be an option.

[graham_howe · Accepted solution]

Something like this?

select(
  matches[Match], 
  ([match_date] >= today()-30)
)

By the way you might want to extend that further and exclude any matches that have already been recorded in the log.

[tadeloach22]

I will give this a look.  Where do I put this since this is a reference column?  In the formula part?

[graham_howe]

Is it an Enum column so that it presents as a drop down? If so then use the expression in valid if or suggested values.

[tadeloach22]

No, it's not an enum. It's a REF that shows as a drop down.

[Marc_Dillon]

https://help.appsheet.com/en/articles/961346-date-and-time-expressions

[tadeloach22]

I saw that page, but I couldn't figure out how to use it, especially since
it is going in a row set to reference?

[Marc_Dillon]

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if