General

Hi, every one Does Appian have any experience migrating Java applet-based systems to Appian's server-based systems? If Appian does not have any experience, please let us know about it. Thank you .

Hi everyone,  We have a need to clean up documents in our lower environment as it is consuming a lot of disk space. We identified two folders whose contents aren't needed currently. However, I would like to back them up just in case it's needed in the future. However, when I download the folder as a zip and subsequently unzip it, the folder hierarchy is different than how it is on Appian. It might not be a big deal for us but I did want to ask the community if they know of a way to preserve it? Following is the difference in hierarchy Hierarchy in Appian FY 2020 Report 1 12. September 9/30/2020 Report 1 9/29/2020 Report 1 9/28/2020 Report 1 Report generated per day 11. August 10. July 09. June 08. May 07. April 06. March 05. February 04. January 03. December 02. November 01. October Report 2 12. September 9/30/2020 Report 2 9/29/2020 Report 2 9/28/2020 Report 2 11. August 10. July 09. June 08. May 07. April 06. March 05. February 04. January 03. December 02. N

Any plans to expand a!submitUploadedFiles() beyond portals? I have use cases where this could be useful in a standard application.

Hello, Do you know how Appian dates are formatted?   I created a transaction at 5:01PM CDT and it appears on the database as 2022-08-12 22:01:18.070 Thanks

Hello, I have a requirement to export a grid data to excel. The data like, I have 5 Regions and each reason have 3 Groups and each groups have 9 stages and each stage have data of 6 columns. so I have  to export below table. Can any one suggest which smart service can I used for this. Group-1 Group-2 Group-3 Region-1 DD/MM Daily Weekly Target Differ DD/MM - 1 DD/MM Daily Weekly Target Differ DD/MM - 1 DD/MM Daily Weekly Target Differ DD/MM - 1 Stage-1 11 1 4 15 11 10 11 1 4 15 11 10 11 1 4 15 11 10 Stage-2 8 0 4 15 11 8 8 0 4 15 11 8 8 0 4 15 11 8 Stage-3 8 0 5 15 10 8 8 0 5 15 10 8 8 0 5 15 10 8 Stage-4 10 3 5 15 10 7 10 3 5 15 10 7 10 3 5 15 10 7 Stage-5 6 0 4 15 11 6 6 0 4 15 11 6 6 0 4 15 11 6 Stage-6 5 0 2 15 13 5 5 0 2 15 13 5 5 0 2 15 13 5 Stage-7 4 0 2 15 13 4 4 0 2 15 13 4 4 0 2 15 13 4 Stage-8 3 0 1 15 14 3 3 0 1 15 14 3 3 0 1 15 14 3 Stage-9 4 2 1 15 14 2 4 2 1 15 14 2 4 2 1 15 14 2 Group-1 Group-2

Hi All, I have a requirement that have to show "ID" along with status ("Active"/ "In-Active") in record title, and only the status color should be changed as per status value. When the status set as "Active", the record title for status shows in green color and for "In-Active" its in Red Eg:- "10024 | Active" or "10024 | In-Active" Can any one help me on this how can I change half of the record title color ?

I am trying to apply sorting on the primary key, while getting data is batches its breaking when the data returned from the query entity rule is null. If sorting based on any other fields its working fine, with or without data Code used:  a!pagingInfo( startIndex: 1, batchSize: 5, sort: a!sortInfo( field: "agendaItemIdPk", ascending: true() )) If we get the data we batch size -1 its working fine. Has anyone faced this issue if yes then whats the way around?

Hello, I have a requirement to export a grid data to excel but I am confuse which smart service to be used for this. The Data is like, I have 5 reason and each reason have 3 groups, each group have 9 stages, each stages have 5 column data. the CDT/ Table fields are: Id (Primary key) Reason group stage data1 data2 data3 data4 data5 Reason-1 Group1 Data1 Data2 Data3 Data4 Data5 Stage-1 stage-2 stage-3 stage-4 stage-5 stage-6 stage-7 stage-8 stage-9

HI All, I am trying to set the length of 2 fields as VARCHAR(1200) but I am getting an error like max length of row reached. What is the max length of a field in mariadb.And I can see datatype "Text" as well,what is the difference between "text" and "varchar".If I use text then can i set my 2 fields length to 1200? Thanks In Advance, SSP

Hi, I am trying to create an email where I can use process variables in the email smart service of Appian. How can I use the process variables in email ? Can u pls help? The process model looks like below -  Thanks in Advance,

Good Day Everyone, Can someone tell what is the passing grade for Appian analyst certification? How many correct answers does one need out of 60 to get a passing grade, to obtain Appian Analyst certification? 

I have a validation on a dateField that I am trying to use a rule inside of the if statement. See below.validations: { if( and( rule!someRuleThatDoesntWorkHere(a, b, c), rule!someRuleThatWorks(a) ), "message goes here", {} ) } I get a "Cast Invalid Could not cast from Rule or Function Reference to Boolean" when I  add the first rule. Is there something I should look for specifically.

CAn any one tell how can I do the following in Interface, 1. I want a multiple selection option on a grid, having submit,cancel button on the bottom. 2. Another grid below the above one to get the data populated in this grid based on selection made on above grid after clicking submit button. 'Please help me, i am new please provide detail solution I would very helpfull. Thank you for understanding

Hi Community, One of our new project ask is to have Appian support branching, merging and deployment basically to set up complete CI/CD. How can we do that? We need more than one developer working on the same object and then merging them like using git version control. Any suggestions will be appreciated. Thanks,

I have a requirement to dynamically generate a word document from a template and will need at a certain point to insert images in different places.i have a list of assessments and for each assessment will need to generate a map picture of the location of the assessment (the number of assessments can vary and is not static) i was able to bring the list of assessments information but have no idea how to bring for each assessment the right map image generated ? i have attached the following screenshots for more clarity  When i try [#list logo as logo] ... [/#list] it insert all the images in one column like the following Please any suggestion how to solve this issueThanks

I was able to trace this issue down to the interface object. The new error from the design view when I click the EDIT link is: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!dropdownField [line 454]: A dropdown component [label="Relationship to Child"] has an invalid value for "choiceValues". Duplicate items are not allowed in the choiceValues array, but choiceValues was 4; 15; 54; 23; 27; 28; 29; 37; 41; 42; 43; 40; 44; 1; 2; 3; 4; 5; 6; 7; 8; 46; 9; 10; 11; 12; 13; 14; 15; 47; 16; 49; 48; 17; 18; 19; 54; 50; 51; 52; 53; 55; 20; 21; 56; 78; 39; 22; 57; 58; 59; 60; 23; 24; 25; 26; 61; 62; 63; 27; 28; 45; 29; 64; 65; 30; 77; 70; 66; 67; 68; 69; 31; 32; 33; 34; 71; 72; 35; 73; 74; 36; 37; 75; 38. item: a!dropdownField( label: if( local!isDependent, "Relationship to Parent", "Relationship to Child" ), placeholder: "Plea

Hello, I receive the error below when trying to edit a case: Expression evaluation error [evaluation ID = 8bac2:ea07c] : [Lcom.appiancorp.core.data.Dictionary; cannot be cast to com.appiancorp.core.data.FieldAddressable Any ideas will help. Thanks

Hi All, I want to create a process report which will return all the processes with status "Processes With Errors" but unfortunately that status is not given in the status field in the process report filters.Is there any alternate way to achieve this. Thanks in Advance,SSP

Hi everyone, when ever we create any Appian objects, will it create any column or row in database referring to that object? Thank you all in advance! Regards, Kiran Sajjan

I want to create an link which should redirect to process activity apart from any environment dependency? is there any function?

Hi, I've been trying to convert datetime from any set time zone to ET. Like, if in my profile settings I've time zone set as GMT, I'm using the below code, and its working fine for GMT to ET conversion, but if I'm going with MDT or IST, it's not returning the current time as per ET. Does any one happen to know how I could achieve this conversion from all time zones to EST ? datetext( local( ri!datetime, "America/New_York" ), "MM/dd/yyyy hh:mm a" ) & " ET"

Hello Everyone,I have encountered I don't know if it is already bug but I have experienced when answering the activity in UI/UX advanced course. I wasn't able to submit the answer when I refresh it I can't go back and retake the activity. Right now I couldn't acquire the certification for this specific course. I'm looking forward to your answer. Thank you in advance. On the first image the status is in progress button showed that I can resume but I wasn't able to retake the activity. If anyone experienced this issue I need your help. Thanks.

I have the requirement where i need to change the image in card layout dynamically. Can someone help

We have developed a interface that just displays information on a monitor for employees to review.  Does Appian offer an option where that interface will not log out and require someone to log into it daily?

Use case- User wants to upload data via Excel where Columns of excel are not static and can be changed frequently. Now with static template, it can consume and validate the data and loads the table via Data store / CDT into table. But if Excel template is not static then what could be the best solution via Appian? Altering the Table can be done via Stored proc etc but what about CDT and verification process.