Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

i HAVE THE FOLLOWING CODE: "Set(varcmbtrialvisible, false); Set(varcmbservicevisible,…

  1. User

    i HAVE THE FOLLOWING CODE:

    "Set(varcmbtrialvisible, false); Set(varcmbservicevisible, false); Switch( varDialogueBox, "addService", Set(varcmbtrialvisible, false); Set(varcmbservicevisible, false); ForAll( cbAddService.SelectedItems, Relate( paramSelectedPlan.'DOT Tasks', Patch( 'Outsourcing Tasks', Defaults('Outsourcing Tasks'), { 'Task Type': 'Task Type'.RFP, Service: ThisRecord, Trial: First(colSelectedTrials)

                }
            )
        )
    );
    
        ClearCollect(
            colPlanTasks,
            Filter(
                'Outsourcing Tasks',
                'Outsourcing Plan (dot_OutsourcingPlan1)'.'Outsourcing Plan' = paramSelectedPlan.'Outsourcing Plan'
            )
        );
    UpdateContext({locWaiting: false});
    Reset(cbAddService);
    Reset(cbAddTrial);
    ,
    "addTrial",
        Concurrent(
            Collect(
                colPlanTrials,
                cbAddTrial.Selected
            ),
            Relate(
                paramSelectedPlan.'DOT Trials',
                cbAddTrial.Selected));
            
        
    
    
    UpdateContext({locWaiting: false});
    Reset(cbAddService);
    Reset(cbAddTrial);,
    
    
    
    "duplicateService",
    ForAll(colSelectedTrials,
    Concurrent(
        Collect(colPlanTrials, cbAddTrial.Selected),
        Relate(paramSelectedPlan.'DOT Trials', ThisRecord)
    )
    

    );

    ClearCollect( colPlanTrials, Filter( 'Outsourcing Trials', !IsBlank(paramSelectedPlan) && 'Outsourcing Plan'.'Outsourcing Plan' = paramSelectedPlan.'Outsourcing Plan' ) );

    ForAll(
        cbAddService.SelectedItems,
        Relate(
            paramSelectedPlan.'DOT Tasks',
            
           Patch(
                'Outsourcing Tasks',
                Defaults('Outsourcing Tasks'),
                {
                    //General Information OP
                    'Task Type': 'Task Type'.RFP,
                    Service: ThisRecord,
                    Trial: First(colSelectedTrials),
                    'Subject Matter Experts': varSelectedTask.'Subject Matter Experts', 
                     Supplier: varSelectedTask.Supplier,
              
    
                    //Users in OP
                    
                    'CTA Contract Owner': If(IsBlank(varSelectedTask.'CTA Contract Owner'.'Azure AD Object ID'),Blank(),
                    LookUp(Users, 'Azure AD Object ID' = GUID(varSelectedTask.'CTA Contract Owner'.'Azure AD Object ID'))),
    
                    'LoB RFP responsible': If(IsBlank(varSelectedTask.'LoB RFP responsible'.'Azure AD Object ID'),Blank(),
                    LookUp(Users, 'Azure AD Object ID' = GUID(varSelectedTask.'LoB RFP responsible'.'Azure AD Object ID'))),
    
                    'Outsourcing Lead': If(
                    IsBlank(varSelectedTask.'Outsourcing Lead'.'Azure AD Object ID'),Blank(),
                    LookUp(Users, 'Azure AD Object ID' = GUID(varSelectedTask.'Outsourcing Lead'.'Azure AD Object ID'))),
    
                    'Outsourcing Support': If(IsBlank(varSelectedTask.'Outsourcing Support'.'Azure AD Object ID'),Blank(),
                    LookUp(Users, 'Azure AD Object ID' = GUID(varSelectedTask.'Outsourcing Support'.'Azure AD Object ID'))),
    
                    'Corporate Procurement Contact': If(IsBlank(varSelectedTask.'Corporate Procurement Contact'.'Azure AD Object ID'),Blank(),
                    LookUp(Users, 'Azure AD Object ID' = GUID(varSelectedTask.'Corporate Procurement Contact'.'Azure AD Object ID'))),
                    
                    'Subject Matter Experts Contacts': If(IsBlank(varSelectedTask.'Subject Matter Experts Contacts'.'Azure AD Object ID'),Blank(),
                    LookUp(Users, 'Azure AD Object ID' = GUID(varSelectedTask.'Subject Matter Experts Contacts'.'Azure AD Object ID'))),
                    
                    //Users in Task module
                    'Contract Owner CPS/TM': If(IsBlank(varSelectedTask.'Contract Owner CPS/TM'.'Azure AD Object ID'),Blank(),
                    LookUp(Users, 'Azure AD Object ID' = GUID(varSelectedTask.'Contract Owner CPS/TM'.'Azure AD Object ID'))),
                    
                    
                    //Datefields in OP
                    'Start up WO sent to supplier':varSelectedTask.'Start up WO sent to supplier',
                    'Start up WO sent to supplier NA':varSelectedTask.'Start up WO sent to supplier NA',
    
                    'Start up WO signed': varSelectedTask.'Start up WO signed',
                    'Start up WO signed NA': varSelectedTask.'Start up WO signed NA',
    
                    'Initiate RFP': varSelectedTask.'Initiate RFP',
                    'Initiate RFP NA': varSelectedTask.'Initiate RFP NA',
    
                    'RFP Submission': varSelectedTask.'RFP Submission',
                    'RFP Submission NA': varSelectedTask.'RFP Submission NA',
    
                    'RFP Questions from Supplier': varSelectedTask.'RFP Questions from Supplier',
                    'RFP Questions from Supplier NA': varSelectedTask.'RFP Questions from Supplier NA',
    
                    'NN RFP Reply Date To Supplier': varSelectedTask.'NN RFP Reply Date To Supplier',
                    'NN RFP Reply Date To Supplier NA': varSelectedTask.'NN RFP Reply Date To Supplier NA',
    
                    'Proposal from Supplier': varSelectedTask.'Proposal from Supplier',
                    'Proposal from Supplier NA': varSelectedTask.'Proposal from Supplier NA',
    
                    'Internal Proposal Review Meeting Date': varSelectedTask.'Internal Proposal Review Meeting Date',
                    'Internal Proposal Review Meeting Date NA': varSelectedTask.'Internal Proposal Review Meeting Date NA',
    
                    'Bid Defence/Clarification Meeting': varSelectedTask.'Bid Defence/Clarification Meeting',
                    'Bid Defence/Clarification Meeting NA': varSelectedTask.'Bid Defence/Clarification Meeting NA',
    
                    'Supplier Selection Award': varSelectedTask.'Supplier Selection Award',
                    'Supplier Selection Award NA': varSelectedTask.'Supplier Selection Award NA',
    
                    'Contract Signed (WO/SAC)': varSelectedTask.'Contract Signed (WO/SAC)',
                    'Contract Signed (WO/SAC) NA': varSelectedTask.'Contract Signed (WO/SAC) NA',
    
                    //Considerations in OP
                    'Assessment Needed': varSelectedTask.'Assessment Needed',
                    'TPR Risk Due Diligence Score': varSelectedTask.'TPR Risk Due Diligence Score',
                    'Rationale for sending RFP to chosen suppliers': varSelectedTask.'Rationale for sending RFP to chosen suppliers',
                    Note: varSelectedTask.Note
               }
            )
        ) 
    );
    
    
    
    Concurrent(
        ClearCollect(
            colPlanTasks,
            Filter(
                'Outsourcing Tasks',
                'Outsourcing Plan (dot_OutsourcingPlan1)'.'Outsourcing Plan' = paramSelectedPlan.'Outsourcing Plan'
            )
        ),
         ClearCollect(
            colPlanTrials,
            Filter(
            'Outsourcing Trials',
            !IsBlank(paramSelectedPlan) && 'Outsourcing Plan'.'Outsourcing Plan' = paramSelectedPlan.'Outsourcing Plan'
        )
    )
    );
    
    UpdateContext({locWaiting: false});
    Reset(cbAddService);
    Reset(cbAddTrial);
    ,
    "",
    "removeTrial",
    "",
    "deleteService",
    ""
    

    ) "

    Can you modify the code so that it behaves similar to the following code with regards to "; Concurrent( ClearCollect( colSelectedTaskSuppliers, varSelectedTask.Suppliers ), ClearCollect( colSelectedTaskSMEs, varSelectedTask.Users ) ); Concurrent( ForAll( colSelectedTaskSuppliers, Relate( vaNewTask.Suppliers, ThisRecord ) ), ForAll( colSelectedTaskSMEs, Relate( vaNewTask.Users, ThisRecord ) ) );"

    "UpdateContext({varCopyButton: !varCopyButton,locWaiting:true}); UpdateContext( { vaNewTask: Patch( 'Outsourcing Tasks', Defaults('Outsourcing Tasks'), { Service: ComboBoxServiceDialog.Selected, 'Task Type': varSelectedTask.'Task Type', 'Task Name': varSelectedTask.'Task Name', 'Task Status': varSelectedTask.'Task Status', 'Outsourcing Lead': varSelectedTask.'Outsourcing Lead', 'Outsourcing Plan (dot_OutsourcingPlan1)': varSelectedTask.'Outsourcing Plan (dot_OutsourcingPlan1)', 'Outsourcing Support': varSelectedTask.'Outsourcing Support', 'CTA Contract Owner': varSelectedTask.'CTA Contract Owner', Supplier: varSelectedTask.Supplier, 'Subject Matter Experts': varSelectedTask.'Subject Matter Experts', 'LoB RFP responsible': varSelectedTask.'LoB RFP responsible', // 'Initial budget currency': varSelectedTask.'Initial budget currency', 'Initial Budget': varSelectedTask.'Initial Budget', ' rationale for sending REP to chosen suppliers': varSelectedTask.' rationale for sending REP to chosen suppliers', 'Assessment Needed': varSelectedTask.'Assessment Needed', 'TPR Risk Due Diligence Score': varSelectedTask.'TPR Risk Due Diligence Score', Note: varSelectedTask.Note, // 'Corporate Procurement Contact': varSelectedTask.'Corporate Procurement Contact', 'Contract Owner CPS/TM': varSelectedTask.'Contract Owner CPS/TM', 'Start up WO sent to supplier': varSelectedTask.'Start up WO sent to supplier', 'Start up WO signed': varSelectedTask.'Start up WO signed', 'Initiate RFP': varSelectedTask.'Initiate RFP', 'RFP Submission': varSelectedTask.'RFP Submission', 'RFP Questions from Supplier': varSelectedTask.'RFP Questions from Supplier', 'NN RFP Reply Date To Supplier': varSelectedTask.'NN RFP Reply Date To Supplier', 'Proposal from Supplier': varSelectedTask.'Proposal from Supplier', 'Internal Proposal Review Meeting Date': varSelectedTask.'Internal Proposal Review Meeting Date', 'Bid Defence/Clarification Meeting': varSelectedTask.'Bid Defence/Clarification Meeting', 'Supplier Selection Award': varSelectedTask.'Supplier Selection Award', 'Contract Signed (WO/SAC)': varSelectedTask.'Contract Signed (WO/SAC)' } ) } ); Concurrent( ClearCollect( colSelectedTaskSuppliers, varSelectedTask.Suppliers ), ClearCollect( colSelectedTaskSMEs, varSelectedTask.Users ) ); Concurrent( ForAll( colSelectedTaskSuppliers, Relate( vaNewTask.Suppliers, ThisRecord ) ), ForAll( colSelectedTaskSMEs, Relate( vaNewTask.Users, ThisRecord ) ) ); ClearCollect( colPlanTasks, Filter( 'Outsourcing Tasks', 'Outsourcing Plan (dot_OutsourcingPlan1)'.'Outsourcing Plan' = paramSelectedPlan.'Outsourcing Plan' ) ); UpdateContext({locWaiting:false})"

  2. Assistant

    Here's the modified code:

    UpdateContext({locWaiting: true});
    Concurrent(
        ClearCollect(
            colSelectedTaskSuppliers,
            varSelectedTask.Suppliers
        ),
        ClearCollect(
            colSelectedTaskSMEs,
            varSelectedTask.Users
        )
    );
    Concurrent(
        ForAll(
            colSelectedTaskSuppliers,
            Relate(
                vaNewTask.Suppliers,
                ThisRecord
            )
        ),
        ForAll(
            colSelectedTaskSMEs,
            Relate(
                vaNewTask.Users,
                ThisRecord
            )
        )
    );
    
    UpdateContext(
        {
            vaNewTask: Patch(
                'Outsourcing Tasks',
                Defaults('Outsourcing Tasks'),
                {
                    Service: ComboBoxServiceDialog.Selected,
                    'Task Type': varSelectedTask.'Task Type',
                    'Task Name': varSelectedTask.'Task Name',
                    'Task Status': varSelectedTask.'Task Status',
                    'Outsourcing Lead': varSelectedTask.'Outsourcing Lead',
                    'Outsourcing Plan (dot_OutsourcingPlan1)': varSelectedTask.'Outsourcing Plan (dot_OutsourcingPlan1)',
                    'Outsourcing Support': varSelectedTask.'Outsourcing Support',
                    'CTA Contract Owner': varSelectedTask.'CTA Contract Owner',
                    Supplier: varSelectedTask.Supplier,
                    'Subject Matter Experts': varSelectedTask.'Subject Matter Experts',
                    'LoB RFP responsible': varSelectedTask.'LoB RFP responsible',
                    //
                    'Initial budget currency': varSelectedTask.'Initial budget currency',
                    'Initial Budget': varSelectedTask.'Initial Budget',
                    '  rationale for sending REP to chosen suppliers': varSelectedTask.'  rationale for sending REP to chosen suppliers',
                    'Assessment Needed': varSelectedTask.'Assessment Needed',
                    'TPR Risk Due Diligence Score': varSelectedTask.'TPR Risk Due Diligence Score',
                    Note: varSelectedTask.Note,
                    //
                    'Corporate Procurement Contact': varSelectedTask.'Corporate Procurement Contact',
                    'Contract Owner CPS/TM': varSelectedTask.'Contract Owner CPS/TM',
                    'Start up WO sent to supplier': varSelectedTask.'Start up WO sent to supplier',
                    'Start up WO signed': varSelectedTask.'Start up WO signed',
                    'Initiate RFP': varSelectedTask.'Initiate RFP',
                    'RFP Submission': varSelectedTask.'RFP Submission',
                    'RFP Questions from Supplier': varSelectedTask.'RFP Questions from Supplier',
                    'NN RFP Reply Date To Supplier': varSelectedTask.'NN RFP Reply Date To Supplier',
                    'Proposal from Supplier': varSelectedTask.'Proposal from Supplier',
                    'Internal Proposal Review Meeting Date': varSelectedTask.'Internal Proposal Review Meeting Date',
                    'Bid Defence/Clarification Meeting': varSelectedTask.'Bid Defence/Clarification Meeting',
                    'Supplier Selection Award': varSelectedTask.'Supplier Selection Award',
                    'Contract Signed (WO/SAC)': varSelectedTask.'Contract Signed (WO/SAC)'
                }
            )
        }
    );
    Concurrent(
        ClearCollect(
            colSelectedTaskSuppliers,
            varSelectedTask.Suppliers
        ),
        ClearCollect(
            colSelectedTaskSMEs,
            varSelectedTask.Users
        )
    );
    Concurrent(
        ForAll(
            colSelectedTaskSuppliers,
            Relate(
                vaNewTask.Suppliers,
                ThisRecord
            )
        ),
        ForAll(
            colSelectedTaskSMEs,
            Relate(
                vaNewTask.Users,
                ThisRecord
            )
        )
    );
    ClearCollect(
        colPlanTasks,
        Filter(
            'Outsourcing Tasks',
            'Outsourcing Plan (dot_OutsourcingPlan1)'.'Outsourcing Plan' = paramSelectedPlan.'Outsourcing Plan'
        )
    );
    UpdateContext({locWaiting: false});
    

    Note: In the modified code, the UpdateContext({locWaiting: false}) has been moved to the end of the code to ensure it is executed after all the other operations.