Update Multiple Multiple Rows for multiple users

AppSheet AppSheet Q&A
1

Scenario,

I have classes that can be taken/Recorded. Doing so as a user is no issue.

However, How, as an admin would i go about updating multiple users at once? Updating one by one would take to long.

What i want to accomplish is

  • when i select a class, from a course taken table, and

  • i then select 5 users to add the class to,

  • 5 rows would appear in the course taken table. One for each user.

I have a enumlist with base type ref pointing back to the user table from the Course taken table as well as the class to be taken as just a ref pointing back to the class table ,

Selecting the multiple users only adds a list of users to a single row. Thats not what i am looking for.

Any Suggestions?

2

For the User table, create an action–potentially with an INPUT function for you to select a class at runtime–and then bulk select multiple users and invoke the action.

1 Like
3

Thank you. I will have to work through this.

4

I messed with this over and over to Failure.

Not sure if this is what you meant but I tried something different Today and it is working.

I created a separate Table for admin that updates the course taken table using values from the class table.

I created one class in this table and then changed the table to update only.

I have an action to update rows in course taken based on the column values of this new admin table.

Because it can only have a single choice, it is working as designed.

Process:

Go to admin table and set the class parameters.

Go to personnel, bulk Select, Run the action.

The Course taken Then updates with whatever was run at the time.

Is this sort of what you were referring to?

5

Glad to hear it!

Yes. The approach you landed on of using an additional table is one of multiple ways to accomplish what I referenced by the following:

2 Likes