The only way to accomplish what you want to do with ACF is to create a radio field that lets the user select the type of link, for example internal or external and then to have a page link or URL field that are both conditional base on the radio field.
Then where you’re getting values on the front end you check the radio field and then get and display the value for the link from the right field.
The other choice is to give them a text field that they can enter whatever they want into it. but the first option also allows you to set up if the link should be opened in a new tab.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We've just released ACF 5.12.3 with a security fix to prevent arbitrary file uploads to forms with ACF fields.— Advanced Custom Fields (@wp_acf) July 14, 2022
Now that we've released this update, we recommend updating your sites as soon as possible.
© 2022 Advanced Custom Fields.