I am trying to extract an ID number from a URL field. The number is at the end of the URL.
I have tried MID, RIGHT & LEFT but no luck.
The formula will need to:
get the number only
Ignore other numbers in the URL
Get the number right of the last ‘...
I am trying to combine two fields in a base. Both of these fields are Linked Records. Is there a way to combine the two fields and retain the records. Currently I am getting text if I use CONCENTATE or ‘&’
Here is a demo base with the example https:/...
Great thanks for the reply. I am thinking now that it might be best to have one table called stakeholders with ‘Internal’ or ‘External’ as a single select. I can create a view for each. That way I can reference Internal or External or both.