Formula problem

[Zurdic]

Hi,

We have apicall from our website, everything works fine but i need 2 things which I believe can be done in API before save formula script.



this is for example website



destination should be berlin

Brand should be testclub

[Stefan]

In formula script, this can probably be done if there is a pattern how the URLs of the websites are constructed (I assume it's not always "berlintestclub") . Or if there are a manageable number of city names or location names that can be searched for in the URL.

[Zurdic]

I have list of cities and their code for example Berlin BRN (idk if its correct), can it somehow helps? also i need to post table somewhere that everytime when destination will be set it will automatically search up in table and in field lets say.... c3LETTERS = BRN, and no, it can be testpartyclub etc.