Jul 31, 2023 08:41 PM - edited Jul 31, 2023 09:12 PM
Is there a way to mirror information from a lookup field into an adjacent long text field?
I'm using Diagram Automator and the "insert image" function can't read/populate a URL from lookup field only a text field.
Maybe a formula or script that could be used as an automation?
Solved! Go to Solution.
Aug 01, 2023 07:19 AM
Thanks for the input @TheTimeSavingCo! I kept knocking away at it last night and built an automation that works using a "when record is updated" (trigger) "update record" (action) targeting the long text fields to be updated with trigger field value.
Aug 01, 2023 03:06 AM
Hmm, perhaps try creating a formula field that'll check whether the lookup field value is equal to the long text field value, and then make an automation that'll trigger when it's not equal
The action would then be to paste the lookup field value into the long text field
Aug 01, 2023 07:19 AM
Thanks for the input @TheTimeSavingCo! I kept knocking away at it last night and built an automation that works using a "when record is updated" (trigger) "update record" (action) targeting the long text fields to be updated with trigger field value.
Nov 26, 2023 12:41 PM
Would you mind providing a screenshot of this automation? I've been attempting the same thing but can't figure out how to get it to work.