Foundation

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, 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 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 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

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)

In a section, I used a pane layout with two panes. In that interface, I don't see any space in the bottom of the pane. But when I call the Section which has pane in the Main form and I add a buttons below that more space is being displayed. I analyzed and I don't see the cause. Attached image of the Main form.

I need a custom record field, of which the value is the result of query, can we do any query in custom record field

We use a smart service called "Append Text to File" from the "Text File Utilities" plug-in. It seems to have stopped working since the latest release a few days ago. Are there any alternatives?

Hi Everyone, I have Appian with version 21.3 connecting to MS SQL DB FCI, i want to migrate the DB FCI to Always-on setup is that supported by Appian to work with MS SQL Always-on

Hi  I have a requirement where in I am creating a word document from a template using the DOCX From Dynamic Template smart service And then convert this word doc to a pdf doc using the PDF from DOCX smart service The thing is the first smart service works, i.e. I am able to successfully generate the word doc. But then when I feed this word doc to the next smartservice to convert to pdf I am getting this error: org.apache.xmlbeans.impl.values.XmlValueNotSupportedException: Could not get a Java numeric type from a Schema string type Can anyone help me with this ?

I have a write data node in process, input is: output is: Process detail showing pv!originalRecords has value, but the result of update() somehow not saved to pv!updatedRecords Can anyone advise what could be the cause?

For a list of integers, I need to check the desired value by calling a service. I would like to stop calling the service, only I get the desired output. Any suggestions, please. 

Interface Definition: Expression evaluation error at function a!hierarchyBrowserFieldTree [line 31]: A tree browser component [label=""] encountered an error for "nextLevelValues" when fv!nodeValue was [id:0,name:JobType,description:Description for node roleType,details:I have 1 child node,type:FOUNTAIN_PEN,numberOfChildren:2,isDrillable:true]. The following error was returned: Expression evaluation error at function 'enumerate' [line 39]: Cannot enumerate non-scalar. When I am trying to use enumerate in nextLevelValues using foreach getting this error. Please let us know any suggestions on this. Thanks in advance.

Can we call a!startprocess or any other smart service function from within any interface component saveinto  apart from button saveinto.

hi   i was getting this error in the site when the user try to generate the document  or click on save in uat this issue was not found in dev this save button has a process model that write the data to db this error is not occuring every time

Hello, I am following the tutorials from the Appian Dev learning path. In the chapter about Sites and Portals, one of the steps in the exercise requires creating a Service Account, but in the portal configuration panel, the button to create it does not appear, and the text field is not editable either. I checked, and I have admin permissions on the app I’m working on. I'm taking the course through the Appian Community Edition platform. Can someone help me resolve this issue? Is there another way to create the service account to grant the portal access to the data, or am I missing something that is preventing me from creating the service account?

I am creating a vehicle rental application. I wanted to change the rental status of the application after the supervisor accepts the task Here in this process model, how do I get the value after supervisor (supervisor change status node) accepts a task. I want to use write records to change the value of rental status to false.  Could someone help me with this.

Need to enable certain dates to be selectable based on the logged in user. So the dates to be enabled and disabled for each user and it should be dynamic based on certain business rules. Is it possible to achieve this in Appian?

Hi, My Requirement is to update selected checkbox(Multiple selection checkbox) row data and status by selecting dropdown to the table. Firstly I am querying data from the table and By multiple selection trying to update the data to the table via Status. Steps: 1.I have multiple checkbox selection . 2. Once Checkbox selected ,which ever is selected as checkbox using Dropdown trying to update to the same table. But Attached code is not working ,if Someone Suggests for solution that would be more helpful.  a!localVariables( local!crAppDynamicChecklist_cdt: rule!CR_APP_QE_getDynamicChecklistByFilters( cif_int: ri!cif_int, sectionType_txt: cons!CR_APP_DYNAMIC_CHECKLIST_SECTION_TYPES[1] ), { a!gridField( data: local!crAppDynamicChecklist_cdt, columns: { a!gridColumn( label: cons!CR_APP_TXT_ACTIVE_COMPLETED_DOCUMENTS_LABELS[1], sortField: cons!CR_APP_TXT_ACTIVE_COMPLETED_DOCUMENTS_LABELS[1], value: joinarray(

Hi Everyone, I am trying to achieve multi selection checkbox but its not working as expected a!checkboxField( label: "", choiceLabels: cons!CR_TXT_CHOICE_LABELS_YES_NO[1], choiceValues: cons!CR_APP_INT_CHOICE_VALUES[1], value: if( contains( cons!CR_APP_INT_CHOICE_VALUES[1], tointeger(local!selectionFlag_int) ), tointeger(local!selectionFlag_int), null() ), saveInto: local!selectionFlag_int, align: "LEFT" ),Currently, If I select one checkbox it is selecting all checkbox ,But I want to select multi checkbox ,How would I achieve this, can anyone correct this code . Thanks in Advance.