from two dimensions to one

hughstearns

I'm sure that this question is frequent. I wasn't sure how to define it well enough to do the search.

Concept: The concept is basic. How do we gather information in a two-dimensional table and put it into a single line of data?

Context: We are a residential design firm. We have a database with all of our clients and their data in it. We want to send a survey to our clients asking them about the people and pets in their home and we want multiple pieces of information about each such as DOB, name, and gender. The logical way to approach this is to set up a report with rows and columns, which would work if we wanted to set up a separate table for every client, which we do not. Is there a way to make this happen?

Andrée Starå

Hi @hughstearns

I hope you're well and safe!

I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

hughstearns

I'm not following how that would work. Not sure if it is germain but I am trying to add information to an existing line.