Forecasted Grants

[ClaireValdivia]

Why is this issue important?

Partner request and key area where grant finder returns less results than grants.gov as we don't include Forecasted grants in results. This is important to partners because it can take a lot of time to build a team to apply for a grant and pull the application together, so having as much lead time as possible increases the chances of an applicant being able to apply and secure the grant.

Current State

No forecasted grants are ingested to grant finder and therefore are not included in search

Expected State

Issue 330 exists for ingest

Figma designs

Search Drawer

• When creating a new search or editing an existing search, the field "Opportunity Status" should show an additional option for "Forecasted" that displays to the left of "Posted"
• For any new search, Forecasted should be defaulted to be checked

Results Table - General

• On the results table that shows on My Grants and Browse Grants tabs, in the "Status" column, "Forecasted" should appear for any grants with that status
• Other statuses should be updated so the first letter is capitalized for consistency (i.e. Closed, Archived, Posted, Forecasted)
• When you click "Export to CSV" from the grants table, in column E of the file, the relevant Opportunity status should display (i.e. Closed, Archived, Posted, Forecasted)

Results Table - Open Date and Close Date Note that this includes changes to more than the forecasted open/close dates, but we want to make the changes together to be consistent.

• If opp status = forecasted, then display the Estimated Post Date in the "Open Date" column. Anytime this field is updated in grants.gov, we should expect to see the change reflected in Grant Finder.
• If opp status = forecasted, and Estimated Application Due Date has a date entered in grants.gov, then display "est." and the date from Estimated Application Due Date field in the Close Date column of the results table (i.e. "est. 12/20/2023")
• If opp status = forecasted and Estimated Application Due Date is blank in grants.gov - then display "Not yet issued" in the Close Date column
• if opp status = Forecasted, and Estimated Application Due Date is anything other than a date or blank in grants.gov, display: "see details" in the Close Date column. "See details" should display like a link (blue text, underline on hover). Clicking the link (or anywhere in the whole row) should bring the user to the grant details page.
• When the opp status changes from Forecasted to Posted, the Posted Date should display in the "Open Date" column with the current value for that field, and the Close Date should display according to the rules below for posted grants
• If close date is blank AND opp status = posted - then display "Not yet issued" in the Close Date column
• if opp status = Posted, Archived, or Closed, and Close Date is anything other than a date or blank, display: "see details" in the Close Date column. "See details" should display like a link (blue text, underline on hover). Clicking the link (or anywhere in the whole row) should bring the user to the grant details page.

Grant Details Page For any forecasted grants:

• The "Opportunity Status" field should display "Forecasted" for any forecasted grants
• Estimated Post Date should display in the "Open Date" field (i.e. Jul 6, 2024)
• If Estimated Application Due Date has a date entered in grants.gov, then display "est. [date]" in the Close Date field (i.e. est. Sep 20, 2025)
• if Estimated Application Due Date is blank in grants.gov, display "Not yet issued" in the Close Date field
• If Estimated Application Due Date is anything other than a date or blank in grants.gov, display the full content of the field with text wrapping in the Close Date field
• When a grant changes from Forecasted to Posted, the Open Date field should display the Posted Date from grants.gov, and the Close Date field should display the Close Date from grants.gov

Implementation Plan

The following functions need to be added...

Relevant Code Snippets

No response

[ClaireValdivia]

@caitlinwinner fyi that I scheduled a meeting next week to discuss this one with me, you, and Pari, but flagging for you here as well in case you have initial thoughts on the open questions listed above

[ClaireValdivia]

Next step on this issue is to add design mock-ups and update requirements on the issue accordingly

[caitlinwinner]

Designs : https://www.figma.com/file/N1wuvwvciNhdKZNSdomTqn/Forecasted?type=design&node-id=0%3A1&mode=design&t=XfCrk3DmM98qakJR-1

[ClaireValdivia]

acceptance criteria needs to be fleshed out and compared with #2066

[ClaireValdivia]

@TylerHendrickson this one is ready for implementation details!

[ClaireValdivia]

Need to add details on how 'est' dates will sort Also confirm that "see details" dates shows at the end when sorted *designs need to be updated to show current grant details page & ensure that requirements align