Hi there,
I have experience in several NoCode platforms, but I am fairly new to Softr. But I like the block setup in softer for gaining speed in development. But I need some best practices how to approach the following use case, using Softr Database.
I want to have my users to periodically fill in a simple survey (multi step form) of 9 questions. 3 question per category. This I have managed in a rather basic database structure using a surveyResponse table. This table has fields for the user that submits the survey, submission date and a field for each of the nine questions.
But I want to calculated a weighted score for each category, so I was thinking to add a formula field for each category score. Is that the right approach or should a use a seperate score table?
Next I want to show Insight on a dashboard page about how each the score of each category evolved over time like for example a increase or decrease of score in percentage. How should I approach this? Is it possible to use formula to calculated the increase decrease in score compared to the most recent precious survey submission category scores?
At last based on the current scores In want to show some feedback or advice.
For example. A user clicks on a category score card. It goes to a page where I fetch/select a predefined advise record from the database.
This advice record can be devided in multiple sections, and potentially a video should be shown that explains the advice(section) in detail. I noticed that I can embed a video in the side panel.of a multi step form, so I was wondering If I could use that block for this purpose (just providing information in a multi-step layout, without submitting something)
I hope I described it clearly enough. Thanks for the insights