context:I have 3 interfaces that communicate with each other, What I need to do is give users the ability to open a project and from the project detail interface have a button in related action that opens another interface that allows the user to add employees to the project.This is the path they take:"GP_ProgettoInterfaccia" > "GP_ProgettoSummary" > "GP_CreateOrUpdateGPprogettoAnagrafica"here all in order:
{ a!gridField( label: "Read-only Grid", labelPosition: "ABOVE", data: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto', columns: { a!gridColumn( label: "Id Progetto", sortField: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{12b0ed52-af54-4516-ad01-422172a014d7}idProgetto', value: a!richTextDisplayField( value: { a!richTextItem( text: if( fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{12b0ed52-af54-4516-ad01-422172a014d7}idProgetto'] < 100000, text( fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{12b0ed52-af54-4516-ad01-422172a014d7}idProgetto'], "#00000" ), fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{12b0ed52-af54-4516-ad01-422172a014d7}idProgetto'] ), link: a!recordLink( recordType: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto', identifier: fv!identifier ), linkStyle: "STANDALONE" ) } ) ), a!gridColumn( label: "Nome Progetto", sortField: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{4c571114-dc17-4cb7-9cae-f256857b2dd1}nomeProgetto', value: a!defaultValue(fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{4c571114-dc17-4cb7-9cae-f256857b2dd1}nomeProgetto'], "–") ), a!gridColumn( label: "Stato", sortField: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{ae2bed28-b1cb-444a-8008-abcbd989b094}stato', value: a!defaultValue(fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{ae2bed28-b1cb-444a-8008-abcbd989b094}stato'], "–") ), a!gridColumn( label: "Data Inizio", sortField: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{20611d9e-21a0-4497-bc84-37e768c5279b}dataInizio', value: a!defaultValue(fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{20611d9e-21a0-4497-bc84-37e768c5279b}dataInizio'], "–"), align: "END" ), a!gridColumn( label: "Fine Prevista", sortField: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{cc1be718-0a3e-4c1a-a962-c2b09f9f8d93}finePrevista', value: a!defaultValue(fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{cc1be718-0a3e-4c1a-a962-c2b09f9f8d93}finePrevista'], "–"), align: "END" ), a!gridColumn( label: "Responsabile Progetto", sortField: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{eea3b672-3780-440a-bc8d-89d92504abe5}responsabileProgetto', value: a!defaultValue(fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{eea3b672-3780-440a-bc8d-89d92504abe5}responsabileProgetto'], "–") ), a!gridColumn( label: "Budget Stimato", sortField: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{75974526-6a4f-458a-8ed3-0edb52dc4fab}budgetStimato', value: a!defaultValue(fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{75974526-6a4f-458a-8ed3-0edb52dc4fab}budgetStimato'], "–") ), a!gridColumn( label: "Budget Utilizzato", sortField: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{99f657b3-f498-452b-a78c-b24f7495ef5c}budgetUtilizzato', value: a!defaultValue(fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{99f657b3-f498-452b-a78c-b24f7495ef5c}budgetUtilizzato'], "–") ), a!gridColumn( label: "Tipologia Progetto", sortField: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{9b2de3d5-3bf8-4f7d-a109-f4caa26f1369}tipologiaProgetto', value: a!defaultValue(fv!row['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{9b2de3d5-3bf8-4f7d-a109-f4caa26f1369}tipologiaProgetto'], "–") ), a!gridColumn( label: "Azioni", value: a!recordActionField( actions: { a!recordActionItem( action: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.actions.{39be7659-f2e7-492f-a8f1-d24ac55093a8}updateGP_Progetto', identifier: fv!identifier ), a!recordActionItem( action: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.actions.{c2f9adb4-5545-4622-8c77-f718da8d5710}deleteGP_Progetto', identifier: fv!identifier ) }, style: "LINKS", display: "ICON" ) ) }, validations: {}, refreshAfter: "RECORD_ACTION", showSearchBox: true, showRefreshButton: true, recordActions: { a!recordActionItem( action: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.actions.{2bbeb44d-a777-4ebb-893d-6c9cb92657a7}newGP_Progetto' ) } ) }
a!localVariables( local!dipendentiCoinvolti: a!queryRecordType( recordType: 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica', fields: { 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{773fcd0d-c7bf-4fe9-bc80-a27c5d7357f7}id', 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{9fdf83e4-1b1f-40c6-b878-99bd5bda8392}idSchiavo', 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{6809df48-58df-436d-9cc3-0da920e95eef}idProgetto', 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.relationships.{b2f93650-a4e2-4c46-b4b2-b9ef407bc518}anagrafica.fields.{eff4af01-e0c0-4afe-b6e0-973153a4727b}nome', 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.relationships.{b2f93650-a4e2-4c46-b4b2-b9ef407bc518}anagrafica.fields.{ad2258e8-3c76-4da3-b11c-6982fb303f96}cognome', }, filters: a!queryFilter( field: 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{6809df48-58df-436d-9cc3-0da920e95eef}idProgetto', operator: "=", value: ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{12b0ed52-af54-4516-ad01-422172a014d7}idProgetto'] ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ).data, a!headerContentLayout( contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!sectionLayout( label: "Dettagli", labelSize: "MEDIUM", contents: { a!cardLayout( contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField( label: "Descrizione", value: { a!defaultValue( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{c9c2cc7e-ba7e-4a48-8b60-6dca7f37d411}descrizione'], "–" ) } ) } ), a!columnLayout( contents: { a!richTextDisplayField( label: "Cliente", value: { a!defaultValue( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{e05fab1e-0d7e-4b90-b101-f40e11237589}cliente'], "–" ) } ) } ), a!columnLayout( contents: { a!richTextDisplayField( label: "Stato", value: { a!defaultValue( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{ae2bed28-b1cb-444a-8008-abcbd989b094}stato'], "–" ) } ) } ) } ), a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField( label: "Data Inizio", value: { if( isnull( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{20611d9e-21a0-4497-bc84-37e768c5279b}dataInizio'] ), "–", { a!richTextIcon( icon: "calendar", color: "SECONDARY" ), " ", a!richTextItem( text: text( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{20611d9e-21a0-4497-bc84-37e768c5279b}dataInizio'], "mmmm d, yyyy" ) ) } ) } ) } ), a!columnLayout( contents: { a!richTextDisplayField( label: "Fine Prevista", value: { if( isnull( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{cc1be718-0a3e-4c1a-a962-c2b09f9f8d93}finePrevista'] ), "–", { a!richTextIcon( icon: "calendar", color: "SECONDARY" ), " ", a!richTextItem( text: text( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{cc1be718-0a3e-4c1a-a962-c2b09f9f8d93}finePrevista'], "mmmm d, yyyy" ) ) } ) } ) } ), a!columnLayout( contents: { a!richTextDisplayField( label: "Tecnologie Utilizzate", value: { a!defaultValue( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{c067078f-bf52-4f5b-bc29-86d38aef7fe0}tecnologieUtilizzate'], "–" ) } ) } ) }, marginAbove: "STANDARD" ), a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField( label: "Responsabile Progetto", value: { a!defaultValue( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{eea3b672-3780-440a-bc8d-89d92504abe5}responsabileProgetto'], "–" ) } ) } ), a!columnLayout( contents: { a!richTextDisplayField( label: "Budget Stimato", value: { a!defaultValue( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{75974526-6a4f-458a-8ed3-0edb52dc4fab}budgetStimato'], "–" ) } ) } ), a!columnLayout( contents: { a!richTextDisplayField( label: "Budget Utilizzato", value: { a!defaultValue( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{99f657b3-f498-452b-a78c-b24f7495ef5c}budgetUtilizzato'], "–" ) } ) } ) }, marginAbove: "STANDARD" ), a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField( label: "Tipologia Progetto", value: { a!defaultValue( ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{9b2de3d5-3bf8-4f7d-a109-f4caa26f1369}tipologiaProgetto'], "–" ) } ) } ), a!columnLayout( contents: { a!buttonArrayLayout( buttons: { /*a!buttonWidget(*/ /*label: "Aggiungi Dipendente",*/ /*icon: "plus",*/ /*style: "SOLID",*/ /*submit: false,*/ /*link: a!startProcessLink(*/ /*processModel: cons!GP_PM_CreateGP_progettoAnagrafica,*/ /*processParameters: {*/ /*idProgetto: ri!record['recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{6809df48-58df-436d-9cc3-0da920e95eef}idProgetto']*/ /*}*/ /*)*/ /*)*/ }, align: "CENTER" ) } ), }, marginAbove: "STANDARD" ) }, shape: "SEMI_ROUNDED", padding: "STANDARD" ) } ), /*Tasti Azione*/ a!gridField( label: "Azioni", labelPosition: "ABOVE", data: local!dipendentiCoinvolti, columns: { a!gridColumn( value: a!recordActionField( actions: { a!recordActionItem( action: 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.actions.{e41d76f9-91ae-43b4-9c0e-60be7027affa}updateGP_progettoAnagrafica', identifier: fv!row['recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{773fcd0d-c7bf-4fe9-bc80-a27c5d7357f7}id'] ) } ) ) } ), /*Lista di Dipendenti Coinvolti*/ a!gridField( label: "Dipendenti Coinvolti", labelPosition: "ABOVE", data: a!recordData( recordType: 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{6809df48-58df-436d-9cc3-0da920e95eef}idProgetto', operator: "=", value: ri!record['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{12b0ed52-af54-4516-ad01-422172a014d7}idProgetto'] ) }, ignoreFiltersWithEmptyValues: true ) ), columns: { a!gridColumn( label: "Nome", value: fv!row['recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.relationships.{b2f93650-a4e2-4c46-b4b2-b9ef407bc518}anagrafica.fields.{eff4af01-e0c0-4afe-b6e0-973153a4727b}nome'] ), a!gridColumn( label: "Cognome", value: fV!row['recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.relationships.{b2f93650-a4e2-4c46-b4b2-b9ef407bc518}anagrafica.fields.{ad2258e8-3c76-4da3-b11c-6982fb303f96}cognome'] ), a!gridColumn( label: "ID schiavo", sortField: 'recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{9fdf83e4-1b1f-40c6-b878-99bd5bda8392}idSchiavo', value: a!defaultValue(fv!row['recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{9fdf83e4-1b1f-40c6-b878-99bd5bda8392}idSchiavo'], "–"), align: "CENTER" ), } ) } ) } ) }, backgroundColor: "#fbfbfb" ) )
a!localVariables( local!progetti: a!queryRecordType( recordType: 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto', fields: {'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{12b0ed52-af54-4516-ad01-422172a014d7}idProgetto', 'recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{4c571114-dc17-4cb7-9cae-f256857b2dd1}nomeProgetto'}, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100) ).data, local!anagrafiche: a!queryRecordType( recordType: 'recordType!{f19d0d12-bbdb-458f-8aa6-0f5fabb7b37f}GP_Anagrafica', fields: {'recordType!{f19d0d12-bbdb-458f-8aa6-0f5fabb7b37f}GP_Anagrafica.fields.{eff4af01-e0c0-4afe-b6e0-973153a4727b}nome', 'recordType!{f19d0d12-bbdb-458f-8aa6-0f5fabb7b37f}GP_Anagrafica.fields.{ad2258e8-3c76-4da3-b11c-6982fb303f96}cognome', 'recordType!{f19d0d12-bbdb-458f-8aa6-0f5fabb7b37f}GP_Anagrafica.fields.{83b35302-2b52-494b-8a10-6344f34b0276}idUtente'}, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100) ).data, a!formLayout( titleBar: a!headerTemplateFull( title: if( ri!isUpdate, "Update GP_progettoAnagrafica", "Create GP_progettoAnagrafica" ), secondaryText: if( ri!isUpdate, "Update details for the gp_progettoanagrafica", "Enter details for the gp_progettoanagrafica" ) ), isTitleBarFixed: true, contents: a!columnsLayout( columns: { a!columnLayout( showWhen: a!isPageWidth( { "DESKTOP_WIDE", "DESKTOP", "DESKTOP_NARROW", "TABLET_LANDSCAPE" } ) ), a!columnLayout( width: "WIDE", contents: { a!sectionLayout( contents: { a!cardLayout( contents: { a!radioButtonField( label: "Progetto", labelPosition: "ABOVE", required: true, /* * Utilizza i dati dalla variabile locale per le etichette. * Si accede prima alla proprietà ".data" del risultato della query, * poi al campo specifico del record. */ choiceLabels: local!progetti['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{4c571114-dc17-4cb7-9cae-f256857b2dd1}nomeProgetto'], /* Utilizza i dati dalla variabile locale per i valori. */ choiceValues: local!progetti['recordType!{e6560fa0-b22b-4951-b906-4af7f958d195}GP_Progetto.fields.{12b0ed52-af54-4516-ad01-422172a014d7}idProgetto'], choiceLayout: "COMPACT", choiceStyle: "CARDS", value: ri!record['recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{6809df48-58df-436d-9cc3-0da920e95eef}idProgetto'], saveInto: ri!record['recordType!{db5d3a05-e970-4817-a254-5969b22ff4a1}GP_progettoAnagrafica.fields.{6809df48-58df-436d-9cc3-0da920e95eef}idProgetto'] ), /* * Campo modificato da dropdown a multipleDropdown per consentire la selezione di più dipendenti. * Le scelte sono popolate dalla query definita in a!localVariables. */ a!multipleDropdownField( label: "Dipendenti da aggiungere al progetto", labelPosition: "ABOVE", placeholder: "--- Seleziona uno o più dipendenti ---", required: true, marginAbove: "LESS", choiceLabels: a!forEach( items: local!anagrafiche, expression: fv!item['recordType!{f19d0d12-bbdb-458f-8aa6-0f5fabb7b37f}GP_Anagrafica.fields.{eff4af01-e0c0-4afe-b6e0-973153a4727b}nome'] & " " & fv!item['recordType!{f19d0d12-bbdb-458f-8aa6-0f5fabb7b37f}GP_Anagrafica.fields.{ad2258e8-3c76-4da3-b11c-6982fb303f96}cognome'] ), choiceValues: index( local!anagrafiche, 'recordType!{f19d0d12-bbdb-458f-8aa6-0f5fabb7b37f}GP_Anagrafica.fields.{83b35302-2b52-494b-8a10-6344f34b0276}idUtente', {} ), value: ri!dipendentiSelezionati, saveInto: ri!dipendentiSelezionati ) }, shape: "SEMI_ROUNDED", padding: "MORE", style: "NONE" ) }, marginBelow: "MORE" ) } ), a!columnLayout( showWhen: a!isPageWidth( { "DESKTOP_WIDE", "DESKTOP", "DESKTOP_NARROW", "TABLET_LANDSCAPE" } ) ) } ), buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: if(ri!isUpdate, "Save", "Create"), submit: true, validate: true, style: "SOLID" ) }, secondaryButtons: { a!buttonWidget( label: "Cancel", submit: true, validate: false, saveInto: ri!cancel, style: "OUTLINE", value: true ) } ), backgroundColor: "#fbfbfb" ) )
The record types involved are:
>>.
The problem is that once I get to "GP_CreateOrUpdateGPprogettoAnagrafica," I can't populate the multipleDropdownField.
In the standalone interface, I can populate it without any problems, but as soon as this interface is called by the related action, I can't populate the field anymore...
I know it's all confusing, but I really don't know what I missed during the process.
Related Action:
Process Model DocumentPDF
Discussion posts and replies are publicly visible
I want you to try this quick changes mostly your issue will get solve:
Wrap your queries in a!refreshVariable() with refreshAlways: true :-local!anagrafiche: a!refreshVariable( value: a!queryRecordType(...).data, refreshAlways: true)Do this for both local!progetti and local!anagrafiche. Then add null checks in your multipleDropdownField:-choiceLabels: if(a!isNullOrEmpty(local!anagrafiche), {}, ...)choiceValues: if(a!isNullOrEmpty(local!anagrafiche), {}, ...)This forces the queries to execute when called through the related action and prevents errors from empty data.Let me know if that works.