Newbie - button in a layout with a script trigger which dynamically changes - how do I do this?
Hi, here's my dilemma. I have a layout, which has a field which contains various company project numbers, which change (depending on which project is being looked up.) What I'd like is a button that contains a script trigger, which opens the project URL. This I've done. The tricky part, which I can't figure out, is how to get the script in question to change. Let's say:
1. I have five project numbers.
2. I have five "open URL" scripts.
How can I get the script to suddenly "change", based on what project number's been called up? I've looked a bit into conditional formatting, but am not sure if that's going to provide my solution (or, if my approach is all wrong.)
Any help is much appreciated!