I have a problem to solve, and I’m having trouble developing the right approach.
I have a table with a list of jobs. There is a column for status, install date and install crew among others.
I would like to bulk select a group of these “jobs” and then input an install date & install crew once and have it update the multiple rows, assigning the same date and crew to each and updating the status.
It would be easy if I could hard code the crew and dates, but that varies, and I need a way to imput those once, and apply to each row selected.
I realize this is not easy to do without some kind of work around, but I’m willing to try anything to do a blanket update like this.
Thanks in advance for any suggestions.