I’ve built a database of grants and funding opportunities, and a survey that asks users the questions to determine their eligibility for the various grants. I have a table that lists the grants and how the various questions have to be answered to det...
Likely because my understanding of database structure is pretty elementary, and I haven’t stopped of thinking about this all like a giant Excel workbook. Which is what the minimum version of the tool was. Between your comment and Adam’s, I’m starting...
Thank you!
So the table I created that includes the grant names, survey questions and required answers would become lookup fields in the table with the information about each grant. Ok… I’m realizing that how I’m thinking about data organization may ...
Hmm… I think it would have to be a script using this method, because the survey includes questions for all grants, but all grants don’t require the same conditions. Therefore any string coming out of a survey response would contain relevant and non-r...
