General

Greetings All, As I am very impressed with what I have seen with Appian and its strong community and marketplace, I am interested in getting a license. We are a new startup currently with four employees.  Over the next 12 months we will probably get to something like 10 employees and over the following year we will probably add another 10 employees.  So in roughly May of 2023 we should be at about 20 employees total. I was in a different forum asking about Appian pricing and an Appian Reseller told me there is a license program where the ability to use Appian would cost $1,000.00 per month. Can anyone kindly provide me a link that discusses the details of this offer? Is there a setup fee? How much would I pay for additional licenses for Infrequent Users and External Input? I understood that I would need a reseller to assist me with this.  Is there a German reseller reading this that can support the pricing as discussed by the other partner? Thanks very much!! Paul

How to add line break after formLayout contents , before buttonLayout. I have tried <br/>, and char(10), but none seemed to work. Thanks in advance

I just ran accross an interface that throws errors when I try to test it.  I noticed that it is running a!queryEntity so it should be an expression rule.  Is there an easy way to change it from an interface to an expression rule?

Hello,  Using Export Data Store Entity to Excel is there a way to be configured to not erase the current applied styles and formatting of the Excel File which is updating ? Currently of there is some kind of colors set-up it eliminates everything. 

I am trying to use import excel to database smart service for importing my data from excel into appian table. In my CDT i have columns of text and integer type. But when trying to use the excel file with integer column as blank it is throwing me error as:Incorrect integer value: '' for column `Appian`.`testBT`.`palletqtyno` at row 1??? where testBt is my tablename and palletqtyno is my column name whose data type is defined as integer in CDT

How do we call an interface with 6 user type and 2 group type in another interface.

In a!start process how do we call 2 user and 2 group type parameters from PM. Do posts code.  

I have created an interface with 3 tab(A, B,C)...using chose function have configured it . My doubt is:: 1) if am filling all the value in tab A and move to tab B then value entered value in tab A should become blank. In tab A have fields of text type and user type for user picker.

Hi All, Has anyone tried LDAP authentication with AD on cloud (AWS / Azure)? If so, may I know the challenges / steps to configure and establish trust b/w cloud AD & Appian app please? - Thanks.

I've configured Azure AD SAML SSO for Appian application.  In Azure AD SSO, SAML Signing Certificate setup, will have to provide the Signing option and Signing algorithm as shown below. There are three different signing option available on Azure AD, not sure which one is the right choice for Appian App? I tried every option from the list, unfortunately every option is returning an error as shown below. - Could someone please suggest where to find the signing option on Appian application?. Sign SAML assertion2021-05-12 12:03:32 [ajp-nio-0.0.0.0-8009-exec-232] ERROR com.appiancorp.security.auth.saml.SamlTestServlet - Unexpected exception during SAML authentication test: Signature was either invalid or signing key could not be established as trustedorg.opensaml.messaging.handler.MessageHandlerException: Signature was either invalid or signing key could not be established as trusted Sign SAML Response and assertion2021-05-12 19:52:03,795 [ajp-nio-0.0.0.0-8009-exec-280] ERROR com.a

Hi all, I've configured Azure AD as my idP source. My user account on Azure Ad and Appian application exactly matched with case. Still I get this below error when I test my saml authentication from Appian. i.e. Test this configuration. /suite/saml/AssertionConsumer page displays below error. Authentication was unsuccessful.Reason: The user tested with was invalid.Close this window and return to Appian Administration Console. I've checked with SAML trace on Firefox, saml attributes looks fine no mismatch on user detail attributes.  The user's password on native appian and Azure AD matches too.  The Username attribute was correctly configured but does not contain a valid Appian user as its value did not match any usernames within Appian. Please note that usernames are case sensitive. See KB-1450 for how to gather a SAML trace to identify the Appian username shown in the SAML assertion. https://community.appian.com/support

Nesse latest version URL requested

Hi, Have registered in Appian forum from my previous employer. Since I have changed employer, How can I transfer my userid to my new employer? Thanks in Advance.

We are having couple of opportunities where Appian Contact center is a requirement, I got to know that we don't have contact center as separate product. Can any one guide me if it is in built in with platform and how to get it.

I have a CDT with field 1 as text data type and field 2 as integer data type I am trying to import data from excel to database by using import excel to database smart service. Excel file have same columns as field 1 and field 2. But If I am trying to use excel having field 2 value as null smart service is giving me error as : incorrect integer value : for column "field2" at row 1 can someone please help ?

Hi Team, Need your help to solve the problem -  1. I have created CDT and added some fields. But I got error while publishing the CDT. So, created second one with different name and same field .It published successfully. 2. In Process model, used second CDT in User input task input node.  3. When I run the process, It throw exception - "An error occurred while evaluating expression: analProblemSolvingAbility.technicalOrSkillArea:AC!analProbSolvAbl.analyticalTechnicalOrSkillArea (Invalid index: Cannot index property 'analyticalTechnicalOrSkillArea' of type Text into type IM_Interview_Analytical_Problem_Solving_Ability?list) (Data Outputs)"  

Hi Team, Need your help to resolve the problem -  Problem -  Getting this error while executing the query entity code - Expression evaluation error at function a!queryEntity [line 3]: Cannot apply operator [IN] to field [id] when comparing to value [TypedValue[it=3,v=1; 2]]. Query Entity code - a!localVariables( local!panelId:"1; 2",a!queryEntity( entity:cons!IM_INTERVIEW_PANEL_DSE_POINTER, query: a!query( selection: a!querySelection( columns: { a!queryColumn( field: "name" ) } ), filter: a!queryFilter( field:"id", operator:"in", value: local!panelId ), paginginfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ) ).data.name)

Can some one please tell me why I am not able to access the below url:https://forum.appian.com/suite/ getting error as : Error 401 - Unauthorized Sorry, your request could not be processed. is there any specific permissions/settings required to access this ?

Can someone please help me with how to disable the draft option in process start form.

Greetings All, I am looking for some experiences with interfacing with CRM systems.  Our team has looked at Salesforce and Microsoft for CRM, but they are asking us to dive deeper to find out what is out there that might be integrated with Appian or at least have some better off-the-shelf integrations. One that we happen to like is Creatio CRM.  It obviously has its own BPA capabilities.  But it does not have key features important to us.  So I am thinking INTEROPERABILITY with Creatio CRM via Appian workflows or possibly some other CRM? Thanks for your thoughts!! Paul

Hi Experts, I have a local variable which store list of array, I need to get the col2 value where col1 is "RF", Kindly help with the expression as when i tried below expression but its not returning the correct value. localVariable( local!a: {{col1: "TX", col2: "Gaurav Singh"}, {col1: "Civil", col2: "Gaurav Singh"}, {col1: "RF", col2: "Gaurav Singh"}}, local!RF:  index( index(local!rows,"col2",{}), wherecontains(  tostring( index( local!rows, "col1", {}  )  ),  "RF" ), {} ))) Kindly help

Hello All, does anybody know how can I export text from DSE and preserve the formatting defined by HTML tags? The use case is following: 1) I have a grid with fields where text can be formatted (bold, italic, underline, strikethrough text) 2) Formatted text is added thru the component richTextField from plugin created by Appian, which provides with a simple editor for rich text. 3) Formatted text is saved in DB as HTML text and it is converted to Rich Text display field only for displaying. 4) Customer is requesting the function which exports the data to Excel file and also preservers the formatting. 5) The export process works fine, but Excel does not correctly interpret HTML tags used for formatting. It is imported as a pure text. This is the process model that I use. Any advices on how to solve this case? Thank you, Michal

Hi I am having issues with the following sql running too slow so that the Tempo report using it fails. CREATE    OR REPLACE VIEW TCAP_PROPOSAL_RECORD_VW ASSELECT DISTINCT S.SECURITY_ROLE AS SECURITY_ROLE    ,Z.ID AS ID    ,Z.COLLEGE_CL_CODE AS COLLEGE_CL_CODE    ,Z.COLLEGE_CL_DESC AS COLLEGE_CL_DESC    ,Z.TYPE_OF_CHANGE AS TYPE_OF_CHANGE    ,Z.LEVEL_OF_CHANGE AS LEVEL_OF_CHANGE    ,Z.PROPOSAL_TITLE AS PROPOSAL_TITLE    ,Z.PROPOSAL_FOR AS PROPOSAL_FOR    ,Z.ACADEMIC_FAN AS ACADEMIC_FAN    ,Z.ACADEMIC_NAME AS ACADEMIC_NAME    ,Z.INITIALISED_BY AS INITIALISED_BY    ,Z.INITIALISED_BY_NAME AS INITIALISED_BY_NAME    ,Z.STATUS AS STATUS    ,Z.FOLDER_ID AS FOLDER_ID    ,Z.COURSE_TOPIC_CODES AS COURSE_TOPIC_CODES    ,Z.UNRESOLVED_COMMENTS AS UNRESOLVED_COMME

How to Improve Performance of Query expression?

How to write a code to get even numbers between 1 to 100?