Discussion Categories

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

Hello everyone! Just a quick question,  how should I prepare for it? Is retaking the Appian Developer Learning Path quizzes enough, or should I practice with other types of tests as well? Any advice would be greatly appreciated! Thanks in advance!

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

I'm having trouble generating process objects in the "Compose your application plan" screen. When I click "Generate Process" in the Process tab, it shows loading but then nothing happens - the tab remains completely empty and no process is generated. And because process tab is empty I'm unable to generate objects from composer Has anyone encountered this before? What could be causing this issue? Appian Version: 25.4

Hi everyone, When I exported data using "Export Data Store Entity to Excel" from a proprietary Excel workbook that contains formulas, the Excel formulas get corrupted. Is there any limitation on the Excel workbook version that can be used with "Export Data Store Entity to Excel"? I am using Excel 365. Symptoms: (1) Formulas are shown as text and no longer calculated, for example:_xlfn.VSTACK({""}, _xlfn._xlws.FILTER(category!J2:J1001, TRUE, ""))IF(A9=0,,SUM(A9:B9))(2) Japanese phonetic (furigana) information appears in the same cell.

I have found information regarding a 5MB limit when my Appian application uses an Integration Object to call another API hosted on an external system. However, if my Appian application is exposing a WebAPI, so that an external system can make a GET request to my Appian application, is there a size limit on the JSON payload that my Appian WebAPI can return to that external system?

Hi Team, I want to make three axis graphs in Appian, so is it feasible in Appian? 

In UI I have option to add data using addRowLink. Once I select one name consider h1, then I click on addRow then there I can write any alphanumeric code and I am storing that in backend. but if I am selecting multiple names(2) then if I click on addRowLink 2 new row boxes are being displayed. In UI even if I select multiple names only one row should be displayed and in backend the code should be updated for all selected names. no submit button is available in that interface saveInto: { a!localVariables( /* Build one new row per selected partyId (no duplicate prevention) */ local!newRows: if( a!isNullOrEmpty(local!selectedInsuredId), {}, a!forEach( items: local!selectedInsuredId, expression: a!localVariables( /* Find the index of this party to resolve its applicationId */ local!idx: index(fv!item, wherecontains(fv!item, local!insuredParty['recordType!{f953bbb6-0363-40ce-afe7-4fd0315e1fc0}UWG Party.fields.{19291ea5-16a7-4ddb-9fc9-dbd77b0f9b3e}id']), null() ), /* Construct a new UWG MIB

I have a multiselect dropdown with names h1, h2 and there respective ids are 123,456. the interface is to update the codes in site.But when I am selecting both values from dropdown and adding the code, code is not getting added for both the values. It is only getting added for the first value(h1) which I selected initially in the dropdown(h1)

Service backed records sync configured .  Sync by Identifier Expression configured  Webapi configured  when external system hits appian webapi it gets synced with identifiers and able to see it on Records -> Data Preview But issue is we are not able to see it on Grid while configuring it using a!recorddata. And also sync data not showing up on view records list (default records preview) 

Dear community, Asking for help is easy, but only one side of the coin. Giving a great answer is the other, and not that simple. In our recent podcast episode, we discuss what it means to give great answers, and what it needs to make this a satisfying experience for everyone. In case you are not happy with the answers you get, or how questions are asked, maybe our conversation gives you some inspiration. Appian Rocks Podcast Episode 13: How to Get Your Questions Answered Let's rock the digital transformation, together! Cheers, Stefan.