Call a webhook where the URL is set in user settings

AppSheet AppSheet Q&A
1

Hello,

I’m trying to trigger a webhook to call out to a users specific website (Wix) to send a triggered email to a customer they have in the AppSheet App.

Each user has their own website, so the URL endpoint that would need to be triggered by the webhook will be different for each user (at least the domain name will be different, the rest of the URL path can be standardized.) Is it possible to set the Url of the WebHook based on data in the user’s settings or from a data table? I’ve been trying to figure this out but I cannot find any information on it.

Thanks.

2

USERSETTINGS will not be available as it runs server side.

1 Like
3

Ok, is there a way to do this via some kind of template or by pulling the URL out of a database or google spreadsheet?

4

Can’t you use USEREMAIL() to look up the url?

1 Like
5

Can I use that in some kind of formula in the Webhook URL field? b/c I’ll have to take only the portion after the @. How would I do that?

6

Yes, you can use a concatenate function (and other functions to access values in rows) to formulate your url.

1 Like