Discussion Categories

Hi All, We have below requirement, please read and assist me on this. We have 2 Event data:                                1. Request Event data                                2. Task Event data We need to merge above 2 dataset and show details in a single page with using Event Timelines patterns/components. Can you please check and assist how we can achieve? When we are taking Event Timelines patters with selecting records type then, we can select only one record type as a time under Event Timeline components but we need to take both records type and then make the relationship on script level. Please provide solution for achieving above. Thanks in advance. 

Hello,  I am new to Appian, wanted to check if we can create a record type from an excel table. For example, the excel table has over 22 columns and this is should be reflected in Appian Record Type. 

Hi All,I am working on AI skill document extraction with semi structured documents. While working, I am getting the below attached error almost after every click.FYI, I have already tried: 1. clearing cache 2. login logout3. different Appian environment4. incognito windowThanks in advance.

Hi everyone, I’m facing a behavior in Appian that I wanted to confirm is expected or not.I have a List of Text String, and when I use it directly inside an if() condition, it seems to always returns the first item in the list.Here’s a simplified example: a!localVariables( local!boolenArr: { false }, local!texts: { "A", "B" }, if(local!boolenArr, {}, local!texts) ) Is this expected behavior in Appian? I was expecting it to return all the items in local!texts. Just want to confirm if I’m missing something or if this is something we should be cautious about in expressions. Thanks in advance!

In the objects view we have this option called "Unreferenced Objects" which will show unused objects of the types mentioned below: Is there a way to get a list of the unreferenced process models in the application so that they can be removed from the application?

Hi everyone, I want to implement a custom date range in a dropdown menu, similar to record filters. If you have any ideas, could you please share how I should proceed?

I am facing the issue while accesing the reconciliation task. This is the error message "An unexpected error occurred while displaying the pdf for the run [docExtractionId=435]."

I have to create the master data in my new app. That's it, Countries, Cities, Genders, Languages, etc. Where do I have to create this kind of data? In an external database? And how can I get the data from the app?: CDT, REcordType, etc? Thanks!

Hi everyone, I'm encountering an error while trying to display user information in a grid column inside an interface. I have attached the code and error. I would appreciate help in order to fix this. a!headerContentLayout( contents: { a!columnsLayout( columns: { a!columnLayout( showWhen: a!isPageWidth({ "DESKTOP", "DESKTOP_WIDE" }), contents: {} ), a!columnLayout( width: "WIDE", contents: { a!sectionLayout( label: "Details", labelSize: "MEDIUM", labelColor: "STANDARD", contents: { a!cardLayout( contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField( label: "Make", value: {

I have an expression rule, PMSO_getClergyMemberRecordbyClergyMemberID, that returns a record type. I'm using this in an a!save() function.  How do I refer to just the clergyFirstName field?  I don't want to write expressions to return a single field from a single record. I get an error with this type of expression. local!parishPastorFirstName: rule!PMSO_getClergyMemberRecordbyClergyMemberID(local!parishProfileRecord['recordType!PMSO Parish Profile.fields.pastorClergyId'].['recordType!PMSO Clergy Member.fields.clergyfirstname']),

I have a problem, I have to create a process that, going to retrieve a series of ids through a query, for each retrieved id goes to create a folder called activity main + id number, then retrieve the folder id, and save it to the database in a special column. I can retrieve the activity id, then I can't go further. Thanks to anyone who will help me

The CMS Module release notes state that the CMGT base application version must be 1.5 or higher. How can I tell what version of CMS I have? Thanks!

I'm creating a new interface object to display several pie charts. The data for the charts is stored in a local variables in the parent interface object which references my children interfaces. In terms of performance, what is the most efficient method to access the data required for the pie charts? Create a rule input on the children interfaces and pass the local variables data from the parent interface or query the data separately in the child interface to avoid passing it from the parent interface?

Hi , I have one base record in that one i'm forming three relationship two one-to-many and one many-to-one. now i want to typecast data fields from base records and related records in one CDT. can anyone please explain how i can achieve this using for each as i want to cast data for each id of base record.

I'm developing a Help Desk application and need to create a column chart for priority. When a priority is clicked, its ID should be stored and passed to a drilldown grid but the current code is displaying the ID as the label instead. a!grouping( field: 'recordType!HD Request.fields.priorityId', alias: "priorityID ) If I use 'recordType!HD Request.relationships.priority.fields.value' directly in the field, it throws an error. Any suggestions on how to display the label name? Thank you!

Hi All,We faced one issue during deployment to production. We have an API which triggers a process model and we are saving into database using write to records. Yesterday we added a new column to that record and it was getting deployed. During that deployment window, we received some cases via API. Details were getting written to database but while trying to query data, no data was being retrieved. The record was being updated and sync was occuring during that time. This is the first time we are facing such issue. Has anyone faced similar issue? Any reason this might have occured??

Hi Team, I'm using the Document Classifier to distinguish between Medical Certificates and other document types (e.g., doctor prescriptions, blood reports, etc.). My goal is to extract data only from Medical Certificates after classification. I am using the AI Classifier Skill, which returns a list of classified documents in the following format:  The output of this is a list  say : [classifiedItem=325673, type=Medical Certificate, confidenceScore=94, errorMessage=],[classifiedItem=325672, type=Medical Certificate, confidenceScore=95, errorMessage=]  To process the classification result, I wrote the following expression to match each classified document with the corresponding uploaded document and then extract data only from Medical Certificates: However, I have noticed that even when the classification result contains multiple values, Appian is treating the entire list as one single value, instead of iterating over each item properly. (Screenshot below) a!loca

I have the local variable called "encargo" to get a single record from a RecordType filtering by an id key. I want to get all the fields of the record type. Is there any way to tell it to the "fields" parameter or have I to list all of them instead?: local!encargo: a!queryRecordType(  recordType: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian',  fields: {    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{48d20aa7-6bfb-42ac-9ea0-0396fafa7ffd}fechasolicitud'  filters: a!queryFilter(    field: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    operator: "=",    value: ri!id  ),  pagingInfo: a!pagingInfo(startIndex: 1, ba

Hi, We are using a styled text editor for the email body. Once the "Send Email" button is clicked, the email is sent, and an EML file is created. The emails in both Spanish and Portuguese are being sent correctly, with proper spacing and special characters appearing as expected in the translations. However, when generating the EML file, we encounter an issue where special characters are replaced with question marks or empty boxes. Additionally, spacing and line breaks are not preserved; instead, the content appears as a single paragraph when the EML file is opened. We are using the "Create EML File from  OOTB Poller" Smart Service to create EML File. In English is working properly and we are facing issue in Spanish and Portuguese

Felw amount fields i have created as DECIMAL in Database, but it got mapped as INTEGER in Appian record. How to get decimal as a datatype in Appian as well? What should be the source field datatype to achieve this?

I have a excel sheet where the cell values are refered from different location as highlited below Here the value 4.00% we are getting from different document, if i try to extract this data using  function - excelreadcellsbynumber() I am getting below error. How can I extract such kind of data?

We have few process model to trigger with email, these process models are triggering even if we activate maintenance window in admin console.  What can we do to hold these mails to trigger the process model until maintenance window is deactivated. We can use gateway/is deployment flag constants to divert the flow, can we do anything other than this

Hi, I am checking whether any deprecated functions are used in our application objects using expression search. When I search for the deprecated function buttonWidgetSubmit, all process models with user input tasks are displayed. However, these process models and interfaces in user input tasks are not actually using this function. I also created a new process model from scratch and applied the same search criteria, which listed the newly created process model as well. Can you help me understand the issue behind this?

Hi Everyone, I'm facing an issue with importing my application to target envt. I'm using manual export and import option here. I have even tried to put the ai skill object alone in a separate package and tried to import and getting the following error :  An error occurred while creating aiSkill [uuid=00c07df7-3153-40dc-a697-e8a8afa54afe]: An error occurred while calling another system. Try again later. (APNX-1-4569-008) (APNX-1-4071-007) Note : The source and target environments are in same version(24.4) Thanks in advance!

Hi All, Is there any way to automate Appian Application (App Server, search Server, data Server and Engines) shutdown and start for Appian on premise? Thanks