Is there a recommended way of storing dynamic form data within a Quickbase table?
Hi there,
I am working on a development project where we are looking to store form data submitted via a website into a Quickbase table. There will be multiple forms which share a set of pre-defined fields but will then have a set of 4 or 5 additional questions fields that vary from one another, for example:
Form 1:
First Name (text)
Last Name (text)
Email Address (email)
Date of Birth (date)
Which sports do you play out of the following? Rugby, Football, Cricket, Golf (multi-select)
Form 2:
First Name (text)
Last Name (text)
Email Address (email)
Date of Birth (date)
How many days a month do you exercise? (number)
We will not know what these questions are in advance as the client will be able to add these questions dynamically per page and so pre-defined columns aren't an option.
We have managed to create a user token and successfully post data for the predefined fields via the api and store it in the table, however, we were wondering if there was a way to dynamically create new fields based on the data that is passed to the api, almost like a key value store, as opposed to having to predefine columns such as 'Question 1', 'Answer 1', Question 2', Answer 2'.
Any help or suggested ways of handling the dynamic forms would be much appreciated.
Kind regards,
Nick
I am working on a development project where we are looking to store form data submitted via a website into a Quickbase table. There will be multiple forms which share a set of pre-defined fields but will then have a set of 4 or 5 additional questions fields that vary from one another, for example:
Form 1:
First Name (text)
Last Name (text)
Email Address (email)
Date of Birth (date)
Which sports do you play out of the following? Rugby, Football, Cricket, Golf (multi-select)
Form 2:
First Name (text)
Last Name (text)
Email Address (email)
Date of Birth (date)
How many days a month do you exercise? (number)
We will not know what these questions are in advance as the client will be able to add these questions dynamically per page and so pre-defined columns aren't an option.
We have managed to create a user token and successfully post data for the predefined fields via the api and store it in the table, however, we were wondering if there was a way to dynamically create new fields based on the data that is passed to the api, almost like a key value store, as opposed to having to predefine columns such as 'Question 1', 'Answer 1', Question 2', Answer 2'.
Any help or suggested ways of handling the dynamic forms would be much appreciated.
Kind regards,
Nick
