0

Transfer Data from Multiple Choice dyn to Other Table ?

 I have a Multiple Choice dyn field, for example select Concep Design and then display the 5 elements, and I select one Feasibility Study, is posible to transfer this data to another table ?

Part of code 

[" GROUP 1: ARCHITECTURE – CONCEPT DESIGN PHASE";{id: 600,caption: "🏛️ Concept Design"}, if contains(numbers('Project Classification'), 600) then{id: 601,caption: "  → Feasibility Study"}end, if contains(numbers('Project Classification'), 600) then{id: 602,caption: "  → Project Brief / Requirements Program"}end, if contains(numbers('Project Classification'), 600) then{id: 603,caption: "  → Site Analysis"}end, if contains(numbers('Project Classification'), 600) then{id: 604,caption: "  → Initial Sketches and Concepts"}end, if contains(numbers('Project Classification'), 600) then{id: 605,caption: "  → Conceptual Models"}end, " GROUP 2: ARCHITECTURE – PRELIMINARY DESIGN PHASE";{id: 610,caption: "📐 Preliminary Design"

 

These code is on Multiple Choice dynamics

2 replies

null
    • Rafael Sanchis
    • Rafael_Sanchis
    • 3 days ago
    • Reported - view

    for id in numbers('Project Classification') do

     let r := (create Table1);

     r.('ID Class' := id);

     if id = 601 then

      r.(Engineering := "CONCEPT DESIGN PHASE");

      r.(Group := "Feasibility Study")

     end;

     if id = 602 then

      r.(Engineering := "CONCEPT DESIGN PHASE");

      r.(Group := "Project Brief / Requirements Program")

     end;

     if id = 603 then

      r.(Engineering := "CONCEPT DESIGN PHASE");

      r.(Group := "Site Analysis")

     end;

     if id = 604 then

      r.(Engineering := "CONCEPT DESIGN PHASE");

      r.(Group := "Initial Sketches and Concepts")

     end;

     if id = 605 then

      r.(Engineering := "CONCEPT DESIGN PHASE");

      r.(Group := "Conceptual Models")

     end

    Enf

    • Fred
    • 3 days ago
    • Reported - view

    You can also use the switch command:

    for id in numbers('Project Classification') do
    let r := (create Table1);
    r.('ID Class' := id;
        Engineering := "CONCEPT DESIGN PHASE";
        Group := switch id do
            case = 601:
                "Feasibility Study"
            case = 602:
                "Project Brief / Requirements Program"
            case = 603:
                "Site Analysis"
            case = 604:
                "Initial Sketches and Concepts"
            case = 605:
                "Conceptual Models"
            end
        )
end
Login to reply

Content aside

  • Status Answered
  • 3 days agoLast active
  • 2Replies
  • 31Views
  • 2 Following