Discussion Categories

I am getting the following error when running a process model executed by a record action:  Details:  Unable to write to or delete from the source due to a data integrity violation. Error Details: (conn=673325) Field 'VECTOR_CREATED_BY' doesn't have a default value I have tried assigning a default value in the table, changing the default value to a different data type, mapping the field in the record type, and have now dropped the field from the table and the error persists.    Any insight would be appreciated 

Requirement is to display single color for first bar in each row and for 2nd bar in each row it show change dynamically as per status of the field. We are trying implementing timeline chart for one of the use case in which it should display 2 Bars in each row. One bar's color is fixed and another should be changing based on status. But when we try to implement logic then color is not coming properly using colors{} inside timeline chart. Output is not coming properly. Using two different loops for two bars in each row but it's not reflecting in the chart : googleTimelineChartField(chartColumnData: {{type: "string",id: "Name",rowDataKey: "name"},{type: "string",id: "Title",rowDataKey: "title"},{type: "date",id: "Start Time",rowDataKey: "start"},{type: "date",id: "End Time",rowDataKey: "end"} },chartRowData:{a!forEach(items:index(local!ccatAssesment,"data&q

Hi, I am new to Appian-Locust, I have installed Appian Locust, executed a login script for Appian URL and I am getting this exception "Login unsuccessful, no multipart cookie found, only found <RequestsCookieJar[<Cookie JSESSIONID....". I checked my credentials and they are working fine when login manually. I have tried executing the same Appian URL via generic Locust and there is no such exception shown. Can anyone help here.

hi, is there any function that we can check  is .csv file is corrupted or not? note:-.csv.file will receive from external system  suggest me best approch?

Good morning. I am trying to deploy an application that contains records synchronized with integration. This is the first deployment of the application, and I am using the compare and deploy option. When creating the package, all elements of the application are included, but not the records synchronized with integration. The records are in the application, as are the calls to the synchronization services. However, these elements are not included. I have tried adding them to the package after the option appears, but when I check again, it still indicates that the elements are not included.What could be the problem, and how could it be solved? Thank you very much and best regards. Translated with DeepL.com (free version)

We’ve created several reports for business users in Process HQ and made them available on our site. By default, the AI Copilot feature is appearing in those reports, but the client does not want this feature enabled. Is there an option in the Admin Console to disable or hide it, or should we raise a support ticket with Appian to get it removed?

Hi everyone, do we have any workaround to check for an Appian record which is null(does not have any key)? One way is check for a!keys and then check if empty, any other way? So basically we had a use where there are multiple grid but they being sourced from the same record, let's suppose it be a room. So parent interface has parent room record variable and in child interface(contained each grid based on room type) we are sending parent by indexing the types. For deletion case, we are saving "null" in the same variable if it is new and if something already exist in db then update the isActive flag to false. Before saving the parent room record(which has all type of rooms) we were doing a reject to remove all the nulls. This used to work before and the "null" which we saved was still a null but now it is becoming a record type of null. Not sure if Appian fixed something on this behavior from there end or not.

Hello Everyone, its working for the first when i upload file and file name when remove file and uploading the new one getting the error.Thanks in advance for your help. Thanks & Regards, Srikanth.

We're planning to implement end-to-end automation using Selenium and are facing challenges due to missing IDs on DOM elements for each control. Typically, web applications have unique IDs assigned to each control, which facilitates automation by allowing scripts to find and interact with controls to perform actions like clicking and sending keys. However, we haven't found a way to achieve this in Appian. Any guidance or assistance would be greatly appreciated.

Hello, I've noticed that the newer version of a!fromJson() parses DataTime value differently, which results in receiving a different date value than the one received. I am looking for a bullet-proof way of setting the correct timezone and receiving the original date. For example, the integration returns DateTime value like: "dateOfBirth":"1955-08-03T00:00:00+02:00" When using a!fromJson(), the resulting Map gets the value: dateOfBirth=02/08/1955 23:00 I've tried playing with local(), but the dates still get switched up if the hour values are close to midnight. The a!fromJson19_r2 still returns the correct date. Thanks for ¨your help!

I have a process model that stops running without any apparent reason. When I click on the node where it stops, a pop‑up appears saying: "No errors were encountered at this node." Has anyone seen this behavior before? What could cause a process to halt without logging an error, and what steps should I take to troubleshoot it?

Hi, I was wondering what the best way would be to get row data from one or more uploaded excel files and to create new entries/rows in a specific record type (not cdt) from this data. Would the 'Import Excel to Database' plugin be a good start for this?

Hey, I am having below use case and I just wanted to know how I can achieve this in appian.Outlook process -- If anyone sends you a email then you can reply back on top of the email. The old conversation will be seen below in the lastest email that you sent/received as a thread.In the similar way, I am sending an email in the process model when a request is been created from the UI. Upon certain time if I don't get response back from the email which I sent earlier, Then I need to reply to the same email which i sent earlier instead of sending a new email.I want the mails to be threaded as similar to the Outlook/Gmail.I have followed the below discusson and tried the solution, but no luck. I have appended "Re: ___" to the same subject line which i have sent initially upon request creation.[mention:2283fcb4f92743158057945acee45483:f586769b0822468ab7f3a94d480ed9b0]Any response on this would be greatly appreciated. Thanks in advance.

Hello everyone!I started the Learning Path recently and I'm having trouble in Step #3 (version: 25.4 Build an Application: Step-by-Step #3). When I try to create a New Group (W#SA Supervisors, W#SA Registrars and W#SA Mechanics), it always says "Name already exists", for all 3 of them. However in the objects I only have the groups W#SA Users and W#SA Administrators1.Did anyone have the same issue? How can I fix it?Thanks :)

Hi All, i have floatingpoint field in my UI, i want to restrict user from typing values upto 2 decimal point and Below is my expected results If the user enters 12, it will be rounded off to 12.00 If the user enters 12.1, it will be rounded off to 12.10 If the user tries to enter 12.678, it will not be allowed. The entry will be cut off at 12.67 but what is the issue am facing is its allowing me to enter more values after decimal point and also if i give round values it's not taking .00 value.below is my code a!floatingPointField( label: "Dental Premium (Annual)", labelPosition: "ABOVE", value: ri!intakePreminumDetails['recordType!{4d82eb7f-ba46-46a2-a7dc-969f4ffcf344}GSE_SCL Intake Premium Details.fields.{cef89c65-a133-4766-bbb5-93cbcceddcab}dentalPremium'], saveInto: { a!save(ri!intakePreminumDetails['recordType!{4d82eb7f-ba46-46a2-a7dc-969f4ffcf344}GSE_SCL Intake Premium Details.fields.{cef89c65-a133-4766-bbb5-93cbcceddcab}dentalPremium'], if(a!isNotNullOr

I am downloading database script through record types data model' generate database script. It gives both create sequence and create table scripts . In the create sequence the sequence structure is TABLE_NAME_sq. The sq value is in lowercase . But if check in the record fileds primary key edit option it's showing in Uppercase like SQ. So which one should I consider when generating scripts for deploy to other environment. The things the application I'm about to deploy in completely new and we use oracle database which I'm not familiar with so I'm confused.

Has anyone experience with Connecting on premise Dynamics CRM system with Appian Cloud instance ? Can it be readily done ? If not what are the pre-requisites to be completed . The On-prem system moreover is on local ADFS authentication.

I have a record picker component in my form which show records of another application, and i have a record type filed relatedrequest in my application record type so when i select and save into relatedrequest field of my application request filed for multiple values it's showing not available, is it not possible to save multiple values . The fields is type of text and length of 4000 . I tried with integer field that time it only takes one value. Why it's happening even though the component have multiselect options we can't save it. 

Hi Team,I’m getting a 403 Access Denied error stating “You don't have permission to view this page” — can someone help me understand why this might be happening?Note:  We have already checked the Process Model, Record Type, Site Objects Security settings — all users have Viewer access and are part of the required group.

I have a requirement where I'm having 5 dropdowns, based on the values (Multiple Selection) in first dropdown, the remaining dropdown values need get auto filtered out (Cascading Dropdowns). Is it possible to achieve? The one way of implementing is after multiple selections in first dropdown we need to keep a button and on click of button we can pass to next dropdowns. But without having button is it possible to achieve.

Hello, I'm trying to create a relationship between two records in Appian. In the database, I have already defined the primary keys, foreign keys, and constraints correctly. However, when I go to the record type view to create the relationship and select the field from the table that contains the foreign key, I’m unable to select any field from the related record. The primary key field does not appear as an available option. Could you please advise on what might be causing this issue? Thank you.

Hi team, I have a question regarding accessibility and semantic markup compliance. In several interfaces, users can enter information or interact with components such as radio buttons and dropdowns. For accessibility reasons, these interactive elements are required to be contained within a <form> element. Is there a way to achieve this without using a Form Layout?Currently, the top-level structure of the interface is built using a Header Layout, and I’d prefer not to refactor the entire layout if possible. Has anyone encountered a similar requirement or found a clean approach to handling this? Thanks in advance.

Hi, Here I am having one dropdown if I select Exclusion there then category,type and add exclusion button will be visible. But when I click on add exclusion button in next category and type are getting duplicated I dont want that I want to select other exclusion and Type differently . How can I achieve it? Code: local!set: if(a!isNotNullOrEmpty(local!exclusionList), index(local!exclusionList.set,1,{}), {}), saveInto: { a!forEach( items: local!exclusionList, expression: a!save( local!exclusionList, append( local!exclusionList, a!map( set: local!set, coveragetoRoleId: ri!basCoverageToRole['recordType!{33c2cbea-4c4e-4288-9d10-d6107f847a76}UWG Coverage To Role.fields.{c8b1b4ee-b5f4-494d-bcf3-763d83073e71}id'], standardUWSupportCodeRefId: null, exclusionText: "" ) ) ) ) },

I was getting this error Expression evaluation error [evaluation ID = 2f483:71082] : Appian object error. Details: Failed to execute query in thread for: EntityBackedQueryExecutor []  when i open a task 

Hi, We have a code where a view data we are showing in a grid and user have to download the report but while downloading user is getting following error: In the code we are using a user filter on a varchar field because of which there is data issue. Interface Definition: Expression evaluation error [evaluation ID = 325b2:2a9f5] : An error occurred while executing a save: Expression evaluation error at function fn!createfilterfromrecord_appian_internal [line 24]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: error converting typed value TypedValue[it=1980,v={ASSESSMENT MI REPORTs,Assessment Report in MI Reporting,Qm7Kig,{81,,10d2b745-9e94-474d-928a-c623c6e7ca8a@_a-0000eccb-82f8-8000-9c64-011c48011c48_16707690,0},#"SYSTEM_SYSRULES_recordGridField