Hello, we would like to create a new HubDB table and then connect it with Contacts that we already have in the system (using HUTK or something). We will be sending questionnaire as part of a newsletter every month, and we would like to save every questionnaire data on submit (via Form API) - this will be saved into our new HubDB table - we will also have HUTK number at this point. So in the end the table would look something like this:
contact | q_points | q_answers | q_month (columns) hutk1 | 5 | abcde | jan18 (rows) hutk2 | 8 | aaaaa | jan18 hutk1 | 14 | bbbbc | feb18 hutk2 | 12 | aabca | feb18
We would like to connect those questionnaire answers for each Contact, so that we can use this data in Contacts - for example see the data in Contact’s Activity tab.
Thank you for the answers!