Discussion Categories

Hello everyone, I am working on a project and need assistance with segregating output values. Specifically, I want to segregate the values and only retrieve the ones corresponding to a particular column. Can someone guide me on how to achieve this or suggest a solution within Appian to isolate the values from a specific column? Any help would be greatly appreciated! Thank you in advance!

Just wanted to know whether Appian Market is shrinking? Looks like we have fewer Appian openings in job market these days? What is community experience on this?

Hello Community, We are currently using Appian for BPM-related processes, but recently we have started utilizing Appian as a backend service to handle multiple API requests in one of our services. We've defined REST services in Appian, and our clients are now calling these APIs, essentially treating Appian as a web server. However, we are facing some performance challenges, including timeouts and long response times. We also conducted load testing, and the results were below our expectations in terms of performance under heavy loads. My question is: based on your experience, is Appian designed to handle high API request loads in this manner (i.e., functioning like a web server)? Should Appian be used for such purposes, or should this approach be avoided due to potential limitations in handling large-scale API traffic? Any best practices, optimization tips, or insights on the suitability of Appian for this use case would be greatly appreciated! Thank you in advance!

I have a Record Type with this "Sync Expression": if( a!isNullOrEmpty(ri!idRecord), {}, a!queryRecordType( recordType: 'recordType!{5608cfad-fc67-4a81-93b5-722c9b55f2c5}MIN Prueba API', filters: a!queryFilter( field: 'recordType!{5608cfad-fc67-4a81-93b5-722c9b55f2c5}MIN Prueba API.fields.{af91da05-b274-48ee-b4f1-c7332fac38ff}id', operator: "=", value: ri!idRecord ), pagingInfo: a!pagingInfo(1, 1) ).data) ,where idRecord is an Integer rule input. When I test the expression it works properly: List of MIN Prueba API - 1 item MIN Prueba API id 3(Number (Integer)) title "Powder Canister"(Text) category "beauty"(Text) discountPercentage 18.14(Number (Decimal)) price 14.99(Number (Decimal)) rating 3.82(Number (Decimal)) stock 59(Number (Integer) I've created a process model with a smart record synchronization service. I'm passing a fixed&nbsp

I am encountering an issue with completing the Document Extraction Reconciliation Task in the Acme Doc Classification and Extraction model from the "Automate Your Business Tasks with AI Skills" course. I have tried the following steps: Cleared the browser cache Tried on a different browser Re-checked if the PDF is valid Any advice or assistance would be appreciated.

Hi there. Is there any way to take out the "Summary" icon when I see the Summary record? I have exploring the Views section in the Record Type but I don't know how to set this feature to remove the Header: Thanks in advance!

Hi, I run some SAS Programs manually. Is there a way, That I can schedule the run of SAS codes via Appain . Please help

Hello Team,I am using Appian version 25.1. I need to use JWT plugin function createdocusignrsajwttoken , but I am getting below error when used in an integartion:Expression evaluation error : smartTestPane.errorInfo.inFieldBodyThe function 'createdocusignrsajwttoken' is unavailable.I have updated version of jwt plugin  Let me know if its not compatible or what could be the issue?

Hi, I am working through the developer course and I am up to the Query Your Data part. In this section it references a record AA_Get Vehicles that was meant to be created earlier, but I can't work out where this was created? I don't have this record and I have been back through everything and can't find where I am meant to have created it. Thanks Haleigh

Hi, Ex: I have 10000 rows in record, and have to create user filer as Assigned to so for that i have to fetch the data from the record and need to show in user filter, as we know we can get the 5000 rows at a time from record then at the time i will get only 5000 values but i need 10000 values based on that i can use union operation , i wil show only 50 to 100 user id in the assigned to user filter. is there any best approach for this. thanks! 

Hi everyone, I’m running into an issue with one of my process models in Appian. The process is supposed to trigger automatically based on a record event, but sometimes it just doesn’t start. There are no errors in the logs, and when I manually start the process, it works perfectly. I’ve already checked the record event settings, confirmed the security permissions, and verified that the process model is published and active. Could this be related to caching, background job scheduling, or something else I might be overlooking? Thanks! If you're looking for top-quality concrete services, take a look at: Concrete Contractors Richmond VA

Hi everyone. I have a json providing by a WebService like this : [{ "id": 1, "title": "Essence Mascara Lash Princess", "reviews": [ { "rating": 2, "reviewerEmail": "john.doe@x.dummyjson.com" }, { "rating": 2, "reviewerEmail": "nolan.gonzalez@x.dummyjson.com" }, { "rating": 5, "reviewerEmail": "scarlett.wright@x.dummyjson.com" } ], "returnPolicy": "30 days return policy"},{ "id": 2, "title": "Eyeshadow Palette with Mirror", "reviews": [ { "rating": 4, "reviewerEmail": "liam.garcia@x.dummyjson.com" }, { "rating": 1, "reviewerEmail": "nora.russell@x.dummyjson.com" }, { "rating": 5, "reviewerEmail": "elena.baker@x.dummyjson.com" } ], "returnPolicy": "30 days return policy"}] I want to create a

Hello all, I am currently working on an interface that includes an editable grid. Although the backend processes the percentage field modifications correctly, the site displays incorrect values, particularly in some other rows.

Hi All,          I m trying to delete the old versions of interface and expression rules using Delete Rules/Constant version Smart service in Content tools plugin. I have passed the folder id(folder where interfaces and rules are present), number of versions to keep (10) but after executing the smart service, no versions got deleted. So, could anyone who used this plugin suggest what exactly i should do? Thanks in Advance, Pradeep

I need to execute two delete record smart service from one saveinto.  Evidently, this is not possible as it throws an error. " An error occurred while executing a save: Expression evaluation error : Attempted to run a second smart service, but only one smart service can be run per expression evaluation." Here is the business issue. I have an interface where Parish managers can specify if they have a preference as to the type and the languages spoken my missionaries that speak at their church.  This is one in the Parish Profile screen and the profile is saved year after year.  The current parish manager can change the preferences that were set last year.  There are two record types that hold this information, Parish Profile Language Type and Parish Profile Speaker Type.  The local variables in the interface that holds this data are local!speakerPreference and local!languagePreference.  They both are types as their respective record types and can h

Hi, I have a very simple robotic process that works fine. It opens and reads an Excel file stored in specific local folder and reads some cells values. The path of the Excel file is stored in an Apian Constant and I use the "Open or create Workbook" Appian service to open this file. My new need would be to make the selected folder path dynamic because I need a user to be able to select a directory from an Appian Interface before to call the robotic process. I've tried to use the a!fileUploadField fonction to select my Excel file, but I don't see how to get the local directory (the component gets only the filename and the new document ID). Is there any way to get this local file path? Otherwise, does a best practice could be to not use a local path, but to save the Excel file in the Appian repositiory first (the Robotic process would open the Appian document, and not the local file) ?My scenario does not need to store the Excel file in Appian, so I

In the image below, the labels are shown as 0, 10K, 20K on y-axis. How can I change this in Appian? I searched, but there is no field in the a!columnChartField(). I want to do this in a column chart. Please give me a solution.  

I'm setting the Record-Level Security and I have this Expression: if( a!isUserMemberOfGroup(username: loggedInUser(), groups: cons!MIN_Administrator), /* Show all records */ null(), /* Show only records that belong to the particular company*/ a!queryFilter( field: 'recordType!{5608cfad-fc67-4a81-93b5-722c9b55f2c5}MIN Test API.fields.{d1b51e83-1de8-430a-8d7c-e6e433601ad4}company', operator: "=", value: "*CompanyNameAsAParameter*" )) If the current user belongs to the Administrators group, they'll see all records; otherwise, they'll only see those whose "company" field has a specific value ("*CompanyNameAsAParameter*"). This value will vary depending on the logged-in user. Is it possible to pass this parameter from the interface, or is there a workaround?

Hi,     Anyone here has worked on appian to salesforce integration in latest projects. Doesn't latest version of salesforce connected system covers almost all integration needs with salesforce ? like writing/updating to salesforce objects etc. Is it still recommended to use salesforce connector functions like a!sfcUpdate()?  For a brand new project, Is there still any reason to consider salesforce connector ? What are the pros & cons of using connected system versus connector regards to security , support etc ? What are connectors actually ? Are they native to Appian ? In my view , connectors seems to be outdated and better to use connected system and use salesforce SOQL/SOSL to integrate. Your thoughts & any real time experiences on this will be really appreciated. Regards, Mike

Normally when a new application is released there is this guided tour "clicked here to do this", "clicking here does this" if the new user wants to continue, they keep clicking and if they want to they have a choice to exit that tour. Does Appian have any such feature to record such a feature for an application developed/released in Appian? 

I have a Record Type with a large data. When I add it to a Site I can see all the records but I want every user see only their related data using a particular field ("user"). I'm using the showExportButton and showSearchBox properties and if I filter the RecordType I lose them. Is there any way to filter the data for every user and continuing using all the parameters of the Record Type? Thanks!

As you can see, I'm creating a new Record Type from a Webservice. I get de data properly. But when I try to sync the data in the Record Type I get the following error: Type could not be inferred due to inconsistent types for field(s): discountPercentage I think the format is ok. Do you why I getting the error? As you see bellow in the Expression Rule commented code, I map the fields formating the decimal fields but I don't to do so because I would map all the fields. Any idea to solve it? Thanks!

Hi All,         I m trying to delete old versions of rules using Delete Rules/Constants smart service in Contents Tools plugin. But i m not able to get the id for the rules folder which is a mandatory input. So is there any way to get this folder ID or any other way/plugin to dynamically delete old versions of rules(As there are more than 200 rules(expression/Interfaces), doing it manually will be time consuming). Request for your suggestions. Thanks in Advance, Pradeep

hi, i am using a!forEach to create a list of variants and wanted to return the iteration item as Array/List itself for eg, a!localVariables( local!testVariable: { "A", "B", "C;D" }, local!valuesAsArray: a!forEach( items: local!testVariable, expression: if( length(split(fv!item, ";")) > 1, split(fv!item, ";"), fv!item ), ), local!valuesAsArray) Above expression is returning results as {"A", "B", "C", "D"} Instead i wanted the results as {"A", "B", {"C", "D"}}. Any suggestions on how to achieve this

I had a query regarding Dollar() function. We are using Appian 24.3 version, so we planned to upgrade to 25.1 version. if I see deprecated functions, I can see Dollar() function as well but currently we are using this function. If upgraded to 25.1 Dollar() function wont anymore or it will work for some version (upcoming). Please help us to understand till when it will work. Thanks