Ask Questions and Find Answers

My company is thinking about using Liferay forms for one of its applications. We have about 20 different forms it needs to produce and a lot of them are very complex. Therefore I have some questions.

1. First of all, the form itself can be complex. For example, on one form, the last field is a set of data points. The section is called "Resource Summary" and each row on the form looks like this:

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10. Resource Summary:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Resource                  |     Resource ID    |      Date/Time Ordered         |         ETA            |      Arrived           |         Notes (location/assignment/status)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Patrol Car                 |     ECPD-18         |      08/22 8am                       |    08/22 10am    |          x                 |        none
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(LINES REPEAT FOR MULTIPLE INPUTS)

Therefore, each row of data is an array of fields that points to a singular object. What this means is that in the database, these five data points should be able to stored in an array in a single cell of a column. Especially since there are 9 other field sets that collect various data points prior to this one question. Is this possible within the form builder?

2. Like I said, there are up to 20 different forms. All these forms may relate to a singular case. Can the forms be connected through a shared primary/foreign key?

3. The way the application works, let us say a user clicks on a location on a map. The user should then be able to choose the form they want to fill out and press submit, and then exit the location. In the future, the user should be able to click on the same location again, click on the form once more, and this time the form comes up already populated with the data that was inputted previously. The form should look identicle as it did previously (except for the populated data of course). The user should be able to edit this data and save it. Is this a possible functionality?

4. Jumping off of the previous question: is it even possible to display for submissions on the front end dynamically?

Thank you