Copying formula output into URL field type

[BrucePPV]

I'm a video editor, creating a client portal in Softr. On the Video Details page I want to embed the video player review page (external). If I use a URL field for the embed code, Softr is fine with it. However, I set up a Formula field to concatenate the first part of the embed code, then the url of the review page, then the last part of the embed code. The formula works, but as mentioned, Softr doesn't like Formula fields. I set up a URL field, but just need to figure out how to get the results of the formula into it so I can embed it on Softr. How would I automatically/dynamically copy the results of the formula into a URL field?
Thanks

[Dimitris_Goudis]

@BrucePPV, did you try to copy the formula result on the URL field using automation?

[Mike_AutomaticN]

Hey @BrucePPV!

As mentioned by Dimitris, you'll want to stamp the URL field with an automation that works in the following way:

1. Trigger: When a record is updated (specifically the formula field);
2. Action: Update a record. On this action block. you'll want to:
(i) Select the Record ID of the record which triggered the automation as the record to be updated;
(ii) Map the value from the formula field found on the trigger block to the URL field.
Please note that you could also use "When record is created" as trigger, depending on your use case.

I could hop on a 5 min call if you need some more help!

Below you can find screenshots of the suggested automation:

Mike, Consultant @ Automatic Nation