Foundation

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 have consistent header for all interfaces on site through which user should be able to select status option. for any customize interface I'm able to achieve it but for record type and related actions I'm not able to maintain that consistency. is there any way to achieve same for record type ?   The second option for same reason I'm looking if possible to add a menu at site level and have status options on it. and once click on any status trigger a process.  Please let me know if you are aware of anyway to achieve any of above two options

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

I just wanted to configure a Textbox to Take SSN number as a input in the format 123-45-6789. And also I wanted to be greyed out(###-##-####) once I moved out my focus.

a!localVariables( local!customerName, a!pickerFieldCustom( label: "Enter Customer Name, placeholder: "Type to select the employee's state of residence", maxSelections: 1, suggestFunction: rule!CP_AAACUSTOMER( filter :_ , ), selectedLabels: local!customerName, value: local!customerName, saveInto: {local!customerName} ) ) a!localVariables( local!matches: ( a!queryEntity( entity: cons!CP_AAA_CUSTOMER, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "name", operator: "includes", value: ri!filter ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: false ) ), a!dataSubset( data: local!matches

In the dropdown field “Tiene discapacidad?” if I select “SI” then the dropdown field “Tipo de discapacidad” should be enabled if I select “NO” then the dropdown field “Tipo de discapacidad” should be locked

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,

Hi Team, I have a process model like below:- Now, Search Window input task is having an interface which looks like below- Also, Results Interface user input task looks like below- Now I want that, if user clicks on 'Go Back' button at the top, he should be back to the second node so that he can again see the Search Window Interface. I am new to Appian. Could you please help ?

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? 

Hi Appian Pals,I want to list all the members of a group and store them to a local variable to show them in a grid.Please let me know Is it possible and how?

Hi All, I am using gridRowLayout to display data in UI. The requirement is I have to highlight a row when the user changed a value in that interface rule. Any suggestions to achieve this. Thanks.

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,

Hi team, I have a use case where I am calling an API -> Saving the data to appiancloud db -> fetching data to interface. I am calling an API which might take 1 to 2 minutes to send response and after that I will be able to store that in db and then I will be able to render it on interface. Now my question is, can I show a full page spinner until the data comes in the interface instead of loading the top loader bar ?

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

In this grid i have first name ,middle name, last name, these three variables while submitting i want to store it in one rule input. Example :John jackie smith  (it should display like this) can anybody help me on this

Hi team, I just need a UI similar to shown below in Appian. Could u pls help me, how to create it ?

there is 16 digit card no which in text format like { 2567893025367892} want the output as {2567-8930-2536-7892}.

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