(This is a similar question to a previous thread I post, but here I am strictly getting all the info from Xano)
I want to define a risk group of an array based on a pretty simple Xano table. See below:
Based on the specialisations selected I need to store a variable with an array of all these selected specialisations, based on that we can identify the risk group. All specialisations and their risk group can be seen in the screenshot above . If any of the selected specialisations in the array has a risk group of 99, the risk group is ‘99’. If no 99 is selected, the lowest risk group should be displayed.
I am already fetching this list to generate the specialisations that can be selected on my page so I need to know how to create an array based on the selected specialisations and then how to define the risk group based on those selections. Both need to be stored as separate variables