I am not so good at explaining this, but it is rather simple I believe.
In short, on my website, I have an embedded questionnaire, that is linked to a google sheet that makes calculations and changes according to what the respondent answers on the questionnaire. There is a specific cell in the google sheet (let's call it A1) with the result, which is a URL address.
My goal: That my website will redirect the respondent to the URL that A1 got. So, in other words...
step 1 - respondent clicks 'submit' after filling the questionnaire that is embedded on my website. Google sheet is updated/changes and the specific A1 cell in that sheet changes and gets a URL. So far so good.
step 2 (here is where I am stuck) - I want that after the respondent clicks 'submit' in the questionnaire, he or she will be redirected to a URL on my website, according to A1 cell in that google sheet. How can I do it? I don't have a knowledge in coding, but it seems not so hard. Can someone please help me with this?😪