Discussion Categories

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

I was looking at Appian edge program but is not able to access it. Can anyone check this from [mention:cce87b321768440ab78d43d51ce0bbe9:e9ed411860ed4f2ba0265705b8793d05] forum.appianportals.com

Hi Team, I am working on integrations to post data to another system. After posting the data to another system, I have to get the id from body. But the body is in text format and the id, success are concatenated. How to getch the id from body by any direct function without hampering the performance? Please suggest. Thanks in advance.

Hi  I have related records : Purchase Orders - item code, qty Items - item code Pricing - item code, price, effectiveDate An item can have multiple prices so there is a 1 to many relationship. I am wanting to use the custom record field on the Purchase Order record to calculate the cost of the Purchase Order ( Purchase Order. qty * latest pricing for the item) I have an expression rule that returns the latest price for an item however the custom record fields does not allow us to use expression rules. Also, since an item can have multiple prices, I am not able to get the latest price from just using the . notation from the related records. I need to have the cost in a custom record field , as I need to aggregate the cost by supplier. Please advise on a way to achieve this. Thanks

Hi, I'm using email to trigger process model. By setting public events in process model, I'm able to get data into process variables. When I'm trying to write it Records, I'm getting below error. The input "Records" refers to an invalid record type. The record type does not exist, has been deleted, or the user does not have sufficient privileges to access the data. I understand that record types doesn't have permissions. But how to provide permissions is what I need know. Thanks in Advance. Thanks, Sadhu Surendra

We have a record with a large complex Security Expression defined in Record-Level Security. When querying this record using an a!queryRecordType, the query takes ~1,500ms (90 rows, ~ 16 columns) When querying using a!recordData in a gridField, the query takes over 13,000ms To make the test fair, we have have kept just 1 column in the grid showing the ID of the record, and have not defined any sorting, no filters are applied for either query When the record level security is turned off,  a!recordData in a gridField takes 253ms to run. What might be causing a!recordData to perform so much worse when record level security is turned on?

Hello Community, I want to use this plug in. Just wanted to know if the document uploaded gets deleted after our operation is done? Because we don't get asset id to delete the document uploaded afterwardsI tried to find this in the plugin documentation but was unable to do so. Please let me know if anyone has any updates.

Hi everyone, Does anyone know how model weights are stored in Appian after training the AI document classification wizard? Is it some internal, non accessible table or the developer has some access rigths over that data? Is that as far as it goes, or is there a way to fine-tune the model further with more detailed, low-level adjustments? Also, can you integrate or pair it with other AI tools to create more accurate models than what Appian’s skill offers on its own? Thank you.

Hi, I'm using a record action to open an interface in a new tab. When the new tab opens it shows a Sumary button upside the content, which is not possible to hide, but as an alternative I would like to know if I can show the same interface when pressing the button. Right now when pressed it shows a blank interface as in the image. Thanks!

Hi, how we can send the case id to user via send email smart service and if user click the case id from mail then it should re-direct to case summary. could you please suggest the possibility's. thanks in advance! 

I ran a health check the other day and under the # of large SAIL interfaces used in record views, related actions, start forms, process tasks and reports section, there were a few lines that say: I searched but haven't found what this might mean in terms of a health check. Does anyone know if these lines are actionable? TIA

I am using the Extract From Document AI tool to read data from a pdf. In addition to text fields, the tool is also extracting a data table, and I'm using the Reconcile Doc Extraction smart service to train the AI to find the data in the table. After running this a few times, the Extract From Document tool has started to bring in data extracted from the table as well. Using Extract From Document, the confidence scores for the text fields are easily visible as an output of the node, but there doesn't seem to be a way to view confidence scores for the table or its text values within it. Are confidence scores used in data table extract, and is there a way to view them?

I have a new install of version 24.2.  When I start tomcat, the log file is filled with "[INFO] Setting Entity Expansion Limit to 100".  Is there a way to stop this line from getting written to the log?

Hello!  Does anyone know why a Null Exception Error is happening at this page? (see video) This is a form that's using a very simple logic for the text field. I checked the logs and didn't get anything there, so I tried remapping the record fields. That didn't work. The logic for this text field is very simple so I'm confused why it would give an error like this, see below. Thanks for any help in advance! Also, let me know if you need any details on this, I'll be happy to provide them! Code: