Discussion Categories

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

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.

Hi,  Can some one let me know what needs to be done for the below error? System tried to sync on nightly basis and failed and didn't provide any details on the same. Tried to look into the sync history but it didn't provide any details. Note: There was not change in the data in the past day.

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

Hello everyone, I have appian servers in main site and i want to built DR for the servers, i am planning to replicate the servers by replication tool called ZERTO from main site to the DR site and i will change the servers IPs in the DR, and once the issue happened to the main site, i will power on the servers in DR and work from there; So, is it workable solution. Thank you

"I am working with the MS Graph Email Poller plugin to read emails and save attachments as .eml files in an Appian document folder. However, I am having difficulty locating the SCS external system key and the correct JNDI name. Could someone please guide me on how to set these up?"

Cannot find AA Registrar site.

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 ?

Hello everyone, I have appian servers in main site and i want to built DR for the servers, i am planning to replicate the servers by replication tool called ZERTO from main site to the DR site and i will change the servers IPs in the DR, and once the issue happened to the main site, i will power on the servers in DR and work from there; So, is it workable solution. Thank you

Hi all, I have a requirement as: I have table in read-only 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 disabled 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 status of A is in approved then any of A status is  preliminary approved then button will turn to grey and link also gets disabled. now for B1 same cycle goes and if A1 status is approved  and B1 , B2, B3, B4 status is either pending approval o

I have a grid based on record, this record has defined user filters.  The client asks me that when he selects a filter and clicks on the details of a case and then returns to the main screen, the filter selection is not checked. Is there a way to reset the filters of marked users without manual action by a user?

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 all  related to the apache avro serialisation of data , wherein i got an error in integration in the result saying 500 status code and integration failed and avro serialization error.

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

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.

Hello everyone! I am having an issue with a write to records. "Escribir Cliente" is not updating the records accordingly. But if I execute it manually it works, or even if I put a input task after it works just fine. I also created variables in the ouput of "Escribir Cliente" to store the Error Occured and Error values to validate that there is not any errors. I even tried to save the variable on itslef again used to update that is why there is "Set Cliente" and "Set Id Cliente". Any ideas of what is this happening?  Thank you so much in advance!

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?