URL field that's clickable / defaulted for all and new records

Hello, I feel like this is so simple but I've attempted a few different ways to do this with no luck. Every time I input a new record into my projects table, I have to confirm an agency associat...