Skip to main content
stephenk0001
Known Participant
Nov 5, 2024 10:10 AM UTC
Question

Changing data for rows NOT selected in a read-only grid

Hi team

I'd greatly appreciate some assistance with this issue please

Table setup:

  • Table 1 - CMC
    • case type 1 (Onboarding Case)
    • fields
      • onboarding case id
      • onboarding case parent id
      • milestone id
  • Table 1 - CMC
    • case type 2 (Onboarding Subcase)
    • fields
      • onboarding subcase id
      • milestone id

  • Table 2 - Onboarding Case
    • id
    • case id = CMC onboarding case parent id
  •  Table 3 - Onboarding Subcase
    • id
    • case Id = CMC onboarding case id

Note:

  • Each onboarding case can have multiple subcases.
  • Each subcase represents a product to assess.

The flow goes roughly like this:

show list of products -----> select one product -------> update selected product milestone -------> start assessment process

This part works fine but I need to find a way to update all the unselected rows so their milestone value can be changed.

Any ideas?

Blessings

Stephen

4 replies

stefanhelzle0001
Brainy
Nov 5, 2024 10:39 AM UTC

Sure. Query that unselected items, modify them, and write them back to the DB.

somasundaram.d
Employee
Nov 6, 2024 6:57 AM UTC

You can use the deselectedRows variable to capture and update the related entries

manjunathb153343
Participating Frequently
Nov 6, 2024 8:13 AM UTC

Create record relationship with each  other table, select check box "update related records" while creating relationship.

stephenk0001
Known Participant
Nov 7, 2024 6:54 AM UTC

Thanks, the relationships are set up already.

Blessings

Stephen