Using a Button to create a URL

[Huw_Jones]

Hi,

I’m pulling what little hair I have left out trying to search for an answer to my problem. Any advice would be very gratefully appreciated.

I am trying to create a button that will create a custom url based on the following:

https://random.company.co.uk/crsc/api/status/?dateOfBirth=<DD/MM/YYYY>&s
urname=&hasAgreedTermsAndConditions=true&organisationName=&employeeSu
rname=&employeeForename=

The elements will be referenced from our airtable.

Any clues as to where to start will be met with whoops of joy.

Thanks,
Huw

[Huw_Jones]

Thanks again, I’ve ammended the formula but it’s still giving me error messages. Any pointers as to where I’m going wrong?

“https://random.company.co.uk/api/status/“&{something}&”?dateOfBirth=”(DATETIME_FORMAT(&{Date of Birth}&, “DD/MM/YYYY”))&“&surname=”&{Surname}&“&hasAgreedTermsAndConditions=true&organisationName=&Tidal Supply&employeeSurname=&employeeForename=Jones”

[Mohamed_Swella1 · Accepted solution]

I can see the problems , the below formula should work

"https://random.company.co.uk/api/status/"&{something}&"?dateOfBirth="&DATETIME_FORMAT({Date of Birth}, "DD/MM/YYYY")&"&surname="&{Surname}&"&hasAgreedTermsAndConditions=true&organisationName=Tidal+Supply&employeeSurname=employeeForename=Jones"

[Huw_Jones]

Amazing! Thank you so much Mohamed!
Huw