Discussion Categories

What are the challenges You people faced while developing ? How did you resolved it?

Hi All, How to enable the dropdown field based on gridLayout selection? actually i am trying with the below code but it is not working as expected: Please help and suggest logic so that i will try to test it. a!gridLayout( headerCells: { a!gridLayoutHeaderCell(label: "Dropdown") }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE") }, rows: { a!forEach( items: ri!data, expression: a!gridrowLayout( contents: { a!dropDownField( disabled: if( and( rule!APN_isNotEmpty(ri!selectedid), contains(fv!item.gfcid, ri!selectedid) ), false, true ) ) } ) ) } )

Hi All Good morning! Can you please let me know if anyone has used the  googleGanttChartField or timelinechartfield plugin in Appian to create a gantt chart using dynamic data, (i.e) data from a record type. If so , can you please providing the guidance or a sample code snippet to configure the same ? Thanks for your help! Regards Soniya PS

What would be a good way to aggregate data records (or data record types) to display in a list? Appian supports the aggregation of record types in charts - I wonder if there is an easy way to display aggegration results in tables.

I have requirement That One question with multiple answers using poll option Can we do polling in Appian. Thanks, Divya

We are attempting to create an SSIS package for our on-premise MSSQL Database to create a connection to the Appian Cloud Maria DB. Is it possible to create an ODBC connection to facilitate this integration? Unfortunately, we cannot utilize the built in Connected System for integrating MSSQL due to our VPN being outbound only.  Thanks!

Just Installed Appian on Linux (Centos) But the site is not redirecting to /suite page. What am I missing? I get the error below when I load the site Any help will be appreciated. Thanks

Hey guys! is there any way to make this cleaner? I have to many OR and probably there is a better way to do this, so what i need is:  OR to go to a path in case it finds a status or the other one if it doesn't find it then i need that in both cases it goes back to the script contador that its just an index+1 and iterates

I encounter with the question "join performs on 3 table and each table has many rows and queries, it returns many responses". live data not required and 2 hours refresh allowed?? which option we use and why?? options:--store procedures or materialized view

Just Installed Appian on Linux (Centos) But the site is not redirecting to /suite page. What am I missing? I get the error below when I load the site Any help will be appreciated. Thanks

my data is storing in the data base in the formate of customer number :"F123"  i have serch filter when i search with F123 it is returing the related data but now if i search with customer number with padding (0) like "F000123" it shoud return the data whic have returen for "F123", the customer number is passing to stored proc and getting the out put so my queery is before sending input to the stored proc i need to remove the padded values then need to send to stored proc please me with solution  so how can i remove the padded (0) from the value where i am searching

Is There Any Smart Service For Download DDL scripts In Appian

Hi All,         I have used date field components.In that   I have two buttons with it like submit and cancel. When ever I enter invalid date and cancelled it and I again edit it it showing the invalid date as a default even though it is not storing in any of the localvariables. Any leads can be really helpful .. Thanks & Regards Divya

After creating 11 Step I got error like this when I entered AX Vehicle Record type beside the icon The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = :] at function a!recordList: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 49]: The image at index 1 in an image gallery component [label=""] has an invalid value for "document". "document" must not be null. (APNX-1-4198-000) can any one help me how to solve where I get this error what to chage

Hi ,I have created a interface in which when I selected a product in "Add product in Cart", It should be populated in Picked products and will show quantity input field. But I don't know  how to store the quantity input  values for different quantity fields, for example If I give quantity value 12 for Soaps it is showing 12 for all product's quantity.Thanks in advance.Code for the same below:a!formLayout( label: "Buy Products", contents: { a!sectionLayout( contents: { a!richTextDisplayField( label: "User", labelPosition: "JUSTIFIED", value: user(loggedInUser(), "firstName") ) } ), a!sectionLayout( label: "Add Products in Cart", contents: { a!sectionLayout( label: "", contents: { a!pickerFieldRecords( label: "Pick Products", labelPosition: "ABOVE", maxSelections: 20, recordType: 'recordType!{886fbcf9-c44b-4cc9-bb6e-76529b93d6e5}TS_RecordType_Product', value: ri!productsSel

i want to display image in interface but i am unable to do that one can anyone help me for that,

How can i change date picker default format to DD-MMM_YY format default format is mm/dd/yy.

When I am trying to save a filter on the record, getting the below error, or if there are any existing saved filters on the record, the same erorr is being generated and blocking the users to perform any actions on the record. Has anyone faced such kind of issue

Hello All, The requirement is to send the entity data with the header and footer. Header and footer contain dynamic data. Header is not columns name; columns name will be the 2-line code. The file needs to be csv Pipe separated file. Sample file. H|2022-11-16|Filename Name|Age|City|Department Sahil|26|City1|Dept1 IBM|27|City2|Dept2 Appian|28|City2|Dept3 T|2022-11-16|Number In the above sample file data, the bold one is the header and footer. Thanks in advance

a!formLayout( label: "View Document", contents: { a!sectionLayout( contents: { a!documentViewerField( label: "Document Viewer", labelPosition: "ABOVE", document: 5080, height: "MEDIUM" ) } ) }, buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", submit: true, value: "Submit", saveInto: ri!buttonvalue, style: "PRIMARY", loadingIndicator: true ) }, secondaryButtons: { a!buttonWidget( label: "Back", submit: true, value: "Back", saveInto: ri!buttonvalue, style: "NORMAL", validate: false ) } ) ) I want to see the document  in the interface with the help of this code but  I am not able to do this. Its directly download the document how can I see the document ?

In version 21.4,   Export To Excel button is exporting only 1000 records from data base view where we have more records in DB view.  And also the number of records data shown in the grid is not same as the data exported into excel. what could be the issue ? How can we resolve this issue ?

Hi, i am getting this error but there is no further information on which expression rule might be causing this. Checked the tomcat logs but the stack trace does not show any further useful information either. Error evaluating UI expression Expression evaluation error [evaluation ID = 43f47:2469d] : Invalid index: Cannot update value of length 5 by assigning value of length 1 Anyone can advise on how to troubleshoot this error further?

Hii All, I have one  dropdown field in my interface , which is consists of 12 items in those 12  for 5 items , if i select particular item one integer field should be visible . the thing is if anyone of the item selected in those 5 items the common integer field is to visible ,  if we select remaining 7 items in drop down the integer field should not visible note only single integer field is used in interface  we need to map 5 items in the dropdown out of 12 to a single integer field to give visibility based on selection  IN 12 ITEMS : 2 OR 3 OR 7 OR 8 OR 10  is selected then only the integer field should visible or else  disable the visibility  please help me on this thanks 

In the cloud database, a value with the row id is stored. I have this read only grid, I want to change the row id value instead of another field of the row In the following read-only grid image, the value of the row id "3" appears in the column "Grupo/Empresa"  I want to change that value to a text to facilitate identification In this case the row id "3" belongs to "CORFOPYM QUITO" In the read only grid should appear " "CORFOPYM QUITO" instead of "3"

Hi Team, I recently took Appian Associate Developer certification got my certificate. There is a name mismatch between the last name I provided in my Profile and the certificate I got. Could anyone please tell me how to correct this name or whom should I contact. I have contacted Examity support but they told that they doesn't have controls over it. Thanks in Advance