How to link a mp4 video file in base

I’ve been looking for how to create hyperlinks in base but haven’t found out how to link to files. Does anyone know of a way to create a clickable field in base to open an mp4,pdf,doc. I know how to link and embed photos but thats not what I’m looking for.

Thanks,
Chris

LO doesn’t currently have a URL aware control, the only way to do this is via macro :

https://bugs.freedesktop.org/show_bug.cgi?id=51203