How to design the Airtable for an RFP use case

I would like to ask how to best setup the airtable base for the following use case:

Our business is an evaluation platform, where the client weights the importance of about 100 questions/features, and about 10 vendors would submit their answers based on how their product covers the questions/features.

We could therefore have as a result the clients target profiling, and the various vendors available profiling.

Each answer would be weighted to points, which then can be scored.

I am wondering if those 100 questions should be fields of a same record, or rather 100 seperate records… basically horizontal vs. Vertical design.

The important point is that the client and vendors would need to have a form to submit their answers.

Best case, we could have 80% of the vendor’s input pre-filled from previous RFP answers, so their input process would be optimized.

I intend to have a user interface and portal by Stacker, and the forms by typeform.

Anyone have some thought on the fundamental design of the data structure?

Many thanks

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.