I have a custom form that gathers a lot of data which is then fed into a formula (in the same table) to provide a specific code (think Myers-Briggs personality type “INFP”). On submission of the form I would like to use that calculated code to determine which page to show the user - a report based on their input.
I haven’t found a way to use a formula value in this way. Any suggestions? Is there another way I can structure the pages/table data to do this?
Thanks.
Cleaner solution.
Create a table called “personality types” that stores all of the data points and info for each personality type combination.
On form submit, and calculations done and stored on the user record, direct the user to a page where you have a details block. That details block will point to the personality tyles table you created and add a conditional filter on the results to only show where the record in the “personality type: tables matches the logged in users personality type.
One block, all outcomes.
Original response.
On form submission, direct the user to your “results” page. On that page, have 1 block for each outcome that you would like to display information from and set the visibility of each block to match the criteria needed.
In your example of Myers-Briggs, the results page would contain 16 blocks (one for each personality combination). When a user completes the form and your perform the calculation on the backend, store the outcome in a field called “Personality Type”. Back on your results page, configure the block level visibility for each block to only show the personality type that matches the users result.
While not conditional based on the form itself, and a bit of a brute force solution, still achieves the end result.
Thank you. I’ll give it a try. 