Hi all,
We’re building a form builder and have a question about best practices, especially regarding excellent database architecture and performance.
For a form builder, of course, all types (single input, multi, email field…) have to be available in an RG or Group, and we only show the right type that matches the current question’s type.
Now we are wondering, is it better to create all possible answers on the “answer” data type, meaning a separate text field for a Single input, one for a Multi-input, one for an Email, one for a Link, etc.? This way, we can set it up as 1 workflow. However, 90% of this Data type’s fields will always be empty. Nevertheless, we believe this is the best practice, and we think it doesn’t matter that they remain empty.
Or would it be better to have just 1 simple data field, “text” on the data type answer that stores any text values? And potentially create 10+ “make changes to…” actions, where each step has its type linked to it? So step one would be Text = Single input’ value, 2 would be Text = Email input’s value, and so on. I think this approach can get messy more quickly, but the database is way more clear
Thanks!