Discussion Categories

I tried upload the template(Doc) many times after editing those not working fields plenty of times  but still the fields seems like above

Hi All, Why do we get this type of error in Process Model while writing to the data base? How Do I Check this issue in more detail, When  i don't have system logs to check the logs? Can SomeOne Please suggest ,It would be more helpful if anyone replies and Provide me the solution. Thanks In Advance.

Hi all, I have a requirement as: I have table in readonly grid where there are different site we can name it as A1, A2,A3,A4 , B1,B2, B3, B4 and each one has status as pending approval . and there are action button as approve and reject if user click on approve button on A1 status then its status is changing to preliminary approved and button color remains as green and user again click on approve button of A1 then status changes to approved and button changes from green to grey and link gets disbaled when user click on approve button of A2 then status changes from pending approval to preliminary but here button color changes to grey and link gets disabled since A1 is in approved status , it means if any of the sttaus of A is in aproved then any of A status is  preliminary approved then button will turn to grey and link also gets disbaled. now for B1 same cycle goes and if A1 status is approved  and B1 , B2, B3, B4 status is eather pending approval or

All nodes and sub-processes are completed but this process instance somehow got cancelled, can anyone advise what could be the cause?

Geeting this error when used SP that returns datasubset for populating grid. Can someone provide more info on why this issue is coming up. UI Code a!localVariables( local!variableName, local!selectedSource, local!selectedCategory, local!pagingInfo:a!pagingInfo( startIndex: 1, batchSize: 10 ), local!categories:index(rule!OMS_getPreSelectCategories( ),"data",{}), local!sources:index(rule!OMS_getPreSelectSourceTypes( ),"data",{}), local!mdmVariableList: a!refreshVariable( value: rule!OMS_SP_getPreSelectVarsByFilters( variableName: local!variableName, source: local!selectedSource, category: local!selectedCategory, pagingInfo: local!pagingInfo ), refreshOnVarChange: { local!variableName, local!selectedSource, local!selectedCategory } ), a!cardLayout( style: "TRANSPARENT", contents: { a!columnsLayout( columns: { a!columnLayout( contents: a!richTextD

We have created entity backed record using database table. That time length of column was 50 character later we update to 100 but source field is not taking 100 it still shows 50.Anyone knows how to update column length?

Hi All, I have a record type process variable  - MAC User (list), This record type contains the list of users and their information like name, email, last name etc.  I'm trying to create the users within appian with the Create User Smart Service, but since its a list is not allowing and its throwing an error, do I have to do a loop for this? I was thinking the smart service could create more than one user at the time. If looping is the only option - can someone recommend what would the best way? thanks in advance

Hello Folks, I am getting this error while write to Data store entity.:"An error occurred while trying to write to the data store. No values have been written. Details: org.hibernate.PropertyValueException: not-null property references a null or transient value :" Can anyone help me on this? Actually I want one column in a table is non nullable that is also behave as a foreign key. Thanks

Good day experts!  I am attempting to merge two maps and have gone thru many examples from the forum but can't seem to get those solutions to work for my use case. I have two maps that have different key value pairs that I want to merge into one map.  The example in my code shows that the maps are related by participantId.  I was able to get the key and value for one of the keys in the queueMap to update into the participantMap.  However I am struggling with getting all of the keys and values in queueMap to update into the related particpantMap. Here is my successful attempt at just getting the first key value from queueMap to update into participantMap: a!localVariables( local!participantMap: { a!map( participantId: 3402, blockId: 881, policyNumber: "VF80U16350", policyEffectiveDate: fn!date(2023, 9, 25), dateOfBith: null, firstName: "Bill", lastName: " Johnson", middleInitial: "W", ssn: "123456789",

Hi team ,recently I have created a new account to learn Appian again, its a free version, in this I  am not  able CDT, DSE objects and also not able  to create them. Also not able to access the MySQL Database.

a!columnLayout( contents: { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Next", size: "LARGE", style: "SOLID", saveInto: { if( len(ri!checklists) > 1, { a!save(ri!steps, append(ri!steps, "name")), a!save(ri!nextStep, 3) }, { a!save( local!showAddChecklistErrorMessage, true() ) } ) } )

Hello everyone, Please have a look at below code:local!array1: { a!map(id: 1, name: "Name1"), a!map(id: 2, name: "Name2") }, local!array2: a!forEach( items: enumerate(10), expression: concat("key", tostring(fv!index)) ), here i want to extend array1 map key from array2, which is dynamically generated through array2 and values should be the value of id from array1. so i am expecting the new array would be like this: { a!map( id: 1, name: "Name1", key1: 1, key2: 1, key3: 1, key4: 1, key5: 1, key6: 1, key7: 1, key8: 1, key9: 1, key10: 1 ), a!map( id: 2, name: "Name2", key1: 2, key2: 2, key3: 2, key4: 2, key5: 2, key6: 2, key7: 2, key8: 2, key9: 2, key10: 2 ) } any easiest way to do this. Thanks in advance 

Hi all.  The Appian Designer/Plug-Ins tab shows a long list of plugins that are installed on my cloud instance. I would like to create a list of the plugins that are actually used by my application. I tried searching the forums and found several answers that suggested exporting my application then searching through the xml files to find the plugin names. After exporting my application, I found a file "/META-INF/plugins.txt". Does this list the used plugins? None of the answers I found talked about this file, but they were several years old, so its likely things have changed. thanks Matt

Hello, I am developing a small application in which employees of a company can book their desks/seats in the office. I have started designing our office seating arrangement using an interface where I used rich text icon to display the desktop and chair. As it's normal in any office that the seating can be facing towards any direction. To visualize it, I have to rotate the icon I'm using now. I googled it out but it's of vain. Appreciate your suggestions. Regards Nehemiah /resized-image/__size/640x480/__key/communityserver-discussions-components-files/13/_B930AF30EA30FC30F330B730E730C330C830_-2024_2D00_10_2D00_23-153805.jpg

lets say im passing the id as 1 to 1000 range for example , as there is no document with that id it will show error right 

Hi,  I am trying to generate a pdf using the pdf from doc smart service, but once the pdf is generated the header is not being present. Can someone please help me out on what the issue could be ? Attaching the ss of my process model for reference

Hi everyone, I was tasked with creating a process model to rename users using the rename users smart service. I only have the Start Node, the Rename Users node and End Node. I have multiple questions that I need answered that can hopefully help me get started as I am unable to find the guidance I need in documentation and other threads. Here are my questions: What other nodes do I need/should I have? When configuring the Rename Users Node what do I put for "Value" and "Save Into" for Inputs? For the Rename Users Node how should I configure the Outputs? I would also appreciate any other reference material you all might think is helpful. This is all I've found so far, and it wasn't enough to help me get started: Rename Users Smart Service - Appian 24.3 

Requiremnt: When user clicks on "Add Grid" then an editable grid should be added and when the user clicks on "Add Row" then a row should be added to the respective grida!localVariables( local!count:1, local!data:a!forEach(items: enumerate(local!count)+1, expression: {{a!map(text1:"",text2:"")}}), a!sectionLayout( contents: { a!forEach( items: enumerate(local!count)+1, expression: a!gridLayout( label: "Grid"&fv!index, headerCells: { a!gridLayoutHeaderCell( label: "H1" ), a!gridLayoutHeaderCell( label: "h2" ) }, columnConfigs: { a!gridLayoutColumnConfig( ), a!gridLayoutColumnConfig() }, rows: a!forEach( items: local!data[fv!index], expression: a!gridRowLayout( contents: { a!textField( label: fv!i

Hi,  I am running a process model and I want it to write/update record information after an input task. If they hit accept, the write records data service works perfectly but if they hit the reject button the write record service throws the following error: "Some referenced Items could not be found". What am I doing wrong? I'll share the buttons' interface code:  buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Aprobar", saveInto: { a!save( ri!record['recordType!{cef91250-961d-44c5-a3d4-47f5dd11ce8e}W1181S Solicitud.fields.{8765b93b-701f-4834-a1fa-466d22579f09}clausuraFecha'], today() ), a!save(ri!record['recordType!{cef91250-961d-44c5-a3d4-47f5dd11ce8e}W1181S Solicitud.fields.{52961fd0-4d58-4b78-a648-5fe0de023217}personaDecision'], loggedInUser() ), a!save( ri!record['recordType!{cef91250-961d-44c5-a3d4-47f5dd11ce8e}W1181S Solicitud.fields.{c9e90275-1a59-4f5c-a413-b7ed27eed6b1}idEstadodeSolicitud'], 3 ), a!save( ri!decisionDeAp

Hi , I am trying to implement: On Click of Dynamic Link displaying one Grid, But AS per the requirement This needs to be displayed as side By side, As of Now On click of Link the grid is displaying but How would I make side By side grid, Since grid has box Layout and Grid Field ,Ui is throwing error . How would I make change in this code -On click of link grid has to be displayed. a!localVariables( local!priority: false(), { a!linkField( /*label: "Link Field",*/ links: { a!dynamicLink( label: "Audit History", value: local!priority, saveInto: a!save(local!priority, true()) ) } ), a!sectionLayout( contents: { rule!CR_APP_SC_auditDetails( cif_int: ri!cif_int, sectionName_txt: cons!CR_APP_TXT_AUDIT_SECTION_NAMES[1] ) }, showWhen: local!priority ) } ) 

I have inactive some value from table because of that this error is showing i want only active data in choicevalue i don't want inactive value. inactive value is showing because some inactive data is already save in somewhere so how we can handle this error i have already query data with isActive true.because i want only isActive data not inactive

Hi!Is there a way to check when and by whom an API Key was deleted from the Admin Console Web API Authentication?

H, Does anyone know if there is multi-factor authentication via SMS to access an Appian site? Or are there only SAML authentications?

Hello, I'm working with a custom picker that should allow one selection. A different selection should be made by removing the first selection.  Currently, when a user types, makes a selection, and then keeps typing, the input is filled with 50 seemingly random selections. These selections do not save. When typing slower and allowing the dropdown to fully load, it works as wanted. Any ideas on how to fix this? Thank you a!pickerFieldCustom( label: "Name", labelPosition: "ABOVE", placeholder: "--- Select a Name ---", saveInto: local!selectedPerson, suggestFunction: rule!AST_GETNAMES, selectedLabels: if( a!isNullOrEmpty(local!selectedPerson), null, index(rule!AST_GETUSERFROMARRAY(suggestionText:local!selectedPerson), "data") ), value: if( a!isNullOrEmpty(local!selectedPerson)

Hi, I'm using excelreadcellsbynumber to read excel file excelreadcellsbynumber( excelDoc: ri!template, sheetNumbers: {1} , columnNumbers: { 7 }, rowNumbers: {7,8,9,10} ) it returned null value from row 8, 9, 10,  which is not correct Because when I use readexcelsheetpaging, it returned the correct values readexcelsheetpaging( ri!template, 0, a!pagingInfo(1,100), 8, "", 0 ),