Skip to main content

Hello community

Again faced with this, hope to get a simple workaround for this where I can get a formula that extracts URL from a text field. 

Thanks

You can use regex for this.  Try a formula field with the following:

 

REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')

 

You can use regex for this.  Try a formula field with the following:

 

REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')

 


Yeah it works, 

Thank you

You can use regex for this.  Try a formula field with the following:

 

REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')

 


is there a way to remove the error message from the empty field

is there a way to remove the error message from the empty field


You could make the REGEX formula @TheTimeSavingCo  provided above conditional on whether or not there is an attachment in your "Display attachment" field.  Try this (adjusting the field names as necessary):

IF({Field name}, REGEX_EXTRACT({Field name}, '\\((.*?)\\)'))

Reply


Terms & Conditions