Discussion Categories

Hi Everyone, I am handling the task assignment through database tables. But when two users will click simultaneouly on the link which will start the process model. How to ensure that only one user should be given the task.

Hi Team,I have One Requirement that isi want to display data in read-only grid from records and that data i want to download in CSV Format also if i want to upload new data i want to upload in CSV format,if it is possible please help me with it,those import and export options i have to display in buttons.

We have a form with multiple collapsible sections, and in some of these we also have subsections. When user clicks on submit, there might be errors in the subsections that are not visible to the user because the parent section does not have the "This section contains errors" warning. I've come to discover that it's because other subsections don't have any errors. Here's an example where this happens: Here both the parent and child show that there are validation erros. The moment I add a section without validation errors, the warning disappears on the parent:   I feel like this should not be the standard behavior and is something Appian should fix on their end. The only workaround I can think of is to have validations at section level, on the parent section. But that would display a red message box on the section that for me is not desirable. Any help here is appreciated.

Hi All, There is a requirement to a get document from the third party system, Can someone suggest a way what is the best way to get the document from the third party system? Below is the implementation that I know, Apart from these any plugins or any other things? 1. Third party systems will return url where the file is located. As soon as user clicks the document can be downloaded into the local system. 2. Thir party systems will return the document in binary format and Integration can convert binary to document from the respsonse.   Apart from this Do we have any other way to get the document from the third party systems? My Next question is  If other systems want to post a document into appian, how exactly web appi will configure it, how the request hader document format will be? Thanks in Advance!

Hi, In our Application, we read an email box and for each email - we should check if it has any attachments and uncompress them. We have a requirement from business to uncompress zip, eml, msg, rar files upto 3 levels in depth and extract data and attachments. Is there a plug-in to achieve this? Any help here would be appreciated. Thanks, Keerthi

Well, how am I supposed to reference the properties of this query in another process model? It is a dictionary, however I cannot reference a dictionary in a process model, so would it be supposed to convert the query to a map or what? By the way, it contains some wierd properties like c0, c1, c2...dp0, dp1, dp2... How could I cast this dictionary into a map then? Thanks in advance

I'm currently exploring all the possible ways to insert record in a record type (for e.g. StudentDetails is my Record Type) but I have String fields as process variables. one way I know is (i) Gave Input Variable of StudentDetails type and in Script task Output  mapped the values from process variables  and used write records.

Hi Everyone, Is there any smartservice or utility in appian to convert docx files to pdf ?

Consider a scenario where we have two entities: Books and Chapters, with a one-to-many relationship (i.e., each book can have multiple chapters). I currently have a read-only grid that displays records based on the Book entity. One of the columns in this grid is called "Chapters", which displays all associated chapters in a bulleted list. Since a book can have more than 10 chapters, I'm currently fetching all chapters into a local variable and indexing them based on the Book ID to display in the corresponding grid row. This approach works fine for now. However, I'm concerned about performance if the chapter count increases more than 5000 Does anyone have suggestions on how to handle this scenario more efficiently?

Team, want to check on these 2 aspects, which we are attempting to leverage in our Appian solution implementation.   1) We are building a solution to retrieve specific data using XPATH from an XML and mapping it to a target location.                 We will be using the "xpathdocument" function in Appian to fetch the value from XML.   2) We will also be leveraging the below function to obtain our XML. i) Convert the json data we have into an Appian object ii) Then convert the Appian object into XML.   --- something like this ---   local!apoPbj: a!fromJson(ri!ipJson)   local!xmlObj: toxml(local!apoPbj, true, "xml") --- something like this ---   3) Data will be fetched from XML using the 'xpathdocument' method as we mentioned above.   This looks working good when tested. Question: 1) But I see currently "xpathdocument" method supports only

Hi all, We have a requirement to have custom fonts on specific interfaces... I read through the documentation and understand that this is not an OOTB feature. Admin console typeface will also not solve this issue as the fonts will be applied across all applications and cannot be referenced in specific components. How can we add custom fonts to specific interface components? Is this able to be done via a plug-in or some other means?

Hi All, we have Content Tools plug in version of 1.11.1 in that we are using function called generateuuid() in our application but recently content tool upgraded with new version of 1.3.0 in that generateuuid() function is not available. could you please suggest any one have alternative functions for this.   Thanks!

Hi, I have a task with a requirement for a robot to be able to skip captchas. I have installed Chrome extensions for the bot to skip captchas, but that extension does not work on some types of captchas, as it does not skip text captchas and requires that text to be typed correctly. I have tried to follow the image recognition steps taking into account the calculator's number recognition practice (Tutorial: Use Image Recognition (RPA)), but it fails me as it is not able to recognize it. Could someone help me or can you think of another alternative regarding bypassing captchas?Thank you very much.

Hi All, We are getting below error in tomcat logs but unable to find out the root cause since process ID is not there. Please suggest how we can rectify this? ERROR com.appiancorp.storedprocedure.fn.ExecuteStoredProcedureFunction - Error executing stored procedure for data source [jdbc/businessds] com.appiancorp.storedprocedure.exceptions.MissingInputsException Thanks, Amita

Hello Team, We have a requirement to populate data into an excel template which will spawn for multiple sheets. This would be in a process model as we fetch the data to populate from a rest service. We were able to achieve populating data into the excel template using the using "Export Data Store Entity to Excel Smart Service". It works fine for regular mapping. But we are stuck with these 2 requirements.  1) We are were not able to dynamically insert rows into output excel sheet in this flow, when needed. There is a requirement to dynamically insert and populate rows in certain places (in the template), which we are not able to get through. 2) Also we are looking to see if there are any plugins or ability to dynamically delete redundant sheet from the output excel. Appreciate any inputs and suggestions.

It is regarding image recognition I store image of 8,+,5,= so as per pdf it should be excused in calculator and answer would be 13 but it is not executing and that why I am not able to complete this lesson Facing the issue after completing the all steps provided by Appian Document Anyone Guide me how can we resolve this....

I am an SQL Server Database Administrator and I will be migrating the Appian database from a stand alone SQL 2019 server to a clustered SQL 2022 server that has Always On Availability Group.  The Availability Group will be stretched across two subnets and will employ a listener for the application to connect. My question are: A: Do you see any problems with the configuration I am proposing for the SQL server set up - SQL AG and listener B: What features do I need to have installed on the SQL Server. C: Do I need the Client Tools SDK feature installed on my SQL server - I found it installed on the existing server D: What SQL Database permission are required for the Appian user that connects the app to the SQL server.  I like to work on the least privilege concept Please if you have the answers to these question or if you have a document that illustrates my SQL settings I would appreciate it I look forward to hearing from you Jeffrey

Hi Appian Community I am using a web service to fetch the records I have synced all the records successfully but, in the list, there are less records available.  Sync successfully for 10046 records but only 6549 available in the list

Hi everyone, I'm having this issue and trying to find some help/ recommendation.  I'm having this process report that contain 1 row of data. But when I run the expression rule to query it with 2 different user account, I get different results, even though the 2 accounts are in same All Users group and that group has Viewer level security in my report.  With my main user account, when I run the query I get that 1 row of data back as output - expected With my test account, I get null value as output - Even though when I open the report I can still see data displayed.  Is there any other areas apart from security level that I should look at?  This is my code snippet, I just input in the context process model and report if( ri!isMissingMinimumInputs, if( ri!doReturnData, {}, a!dataSubset() ), a!localVariables( local!columnConfigs: if( not(rule!GBL_isEmpty(ri!columnConfigs)), ri!columnConfigs, a!queryProcessAnalytics(

How does RPA agent connect/communicate with orchestration server ? Is there any specific ports need to open - considering the agent is internal to company's infrastructure and the appian is in cloud..

From the Grid Layout list i need to add to the other Selected List which is Related Record Data. So when calling this grid interface i am facing issue in the Parent Interface that. When I am selecting more that one item from the list it throwing me the below error. Please let me know how to rectify it Interface Definition: Expression evaluation error [evaluation ID = 033a4:c74b3] : An error occurred while executing a save: Expression evaluation error: Cannot update List of DIL Product User Trans; length of assign value list (2) does not match length of the list to update (1) 1. No Error while selecting 1 item from the list 2. If select more that on item from the list it throwing the below error

Hi All,       What is the Maximum number of nodes in Process Model?  Process Models contain no more than 50 nodes (limitation from Appian side). But i heard, maximum number of nodes is 38 in latest Version.can you pls confirm and send me the link.  Thanks in Advance!  Thanks, Kanna.R  

or( and( rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{8435c94d-c75d-4250-b60c-267fa8e9fe8c}locked']=false, a!isNullOrEmpty(rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{6586c1e5-e5c7-4f5b-8a42-04f5c067aab3}utenteLocked']), a!isUserMemberOfGroup(username: loggedInUser(),groups: cons!SLC_GRP_VERIFICATORE_INFRATEL), contains(cons!SLC_INTS_ID_FASI_PROGETTO_DI_CONNESSIONE[3],rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{12f3ca11-6e56-437c-a111-0188f3e80076}idFase']) ) ), or( and( rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{8435c94d-c75d-4250-b60c-267fa8e9fe8c}locked']=false, a!isNullOrEmpty(rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{6586c1e5-e5c7-4f5b-8a42-04f5c067aab3}utenteLocked']), a!isUserMemberOfGroup(username: loggedInUser(),groups:

Hi, How we can create dropdown using record data?

Hello, I'm creating a process model to synchronize a database with a record type.In the process, I created a node that uses the "Sync Records" smart service.According to the documentation, synchronizing more than 1,000 records requires a loop.I've followed the steps, but the "Sync Records" smart service doesn't return anything inthe "ac!RecordsUpdated" variable, which should be used to avoid an infinite loop.Here are some screenshots of the configuration and docs link. docs.appian.com/.../Sync_Records_Smart_Service.html The import to the database is successful, but the record type is not synchronized.