Help with approach to a problem?

[Michael_Millett]

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.

[Rifad]

Copy Row along with child records Tips & Tricks 💡

It should have been recognized that the coping row including the child table/rows are currently not supported and possible. However, I did find one way to do it. It works perfectly. Before you read this post, make sure a prerequisite to use this tip is that you are on the business plan holder where you have access to Appsheet API. What is behind the trick? Basically, the trick is to retain the row ID of the original row and keep this id within the new row which was generated after the actio…

This approach might help you.

[Yogesh_laddha]

Hi,

Appsheet recently introduced a new function called INPUT(), which combined with Action “Data: set the value of some columns in this row” can easily solve your problem.

I made a quick sample app to show how it works.
I hope this helps and answers your question.