User Experience Design

In a!fileUploadField , I gave validation in sucha way that it allows only .xlsx format.., now my other requirement is that ,,,if the uploadedexcel doc is empty(if no data exists in cells),want to show no data available message how to acive this

I am try display only the date and time without the timezone like this  02/01/2022 10.22pm but it coming like this  can anyone help to resolve this

Hi Devs,I want to use to services in my rich text part, in this on the click of the link and the csv document will be downloaded in the system as an export file,Simultaneoulsy I want to start the process on that click only to delete that csv document that is created internally by appian, so that my app does not pile up with time in the futureAttaching the snip for your reference:

I have Millions of records in a table, I need to show it in a report but Its not loading in interface. How to resolve this?

Hi,  I am using multipleDropdownField as filter for Grid data to populate. When I select one or more value, it is working as expected. But when I remove or de-select all selected values using the cross button visible in multipleDropdownField, it should make the underlying rule input or local variable as null but it is not doing that. Expectation is, whenever user de-select everything, grid should show all the details.  As a work around, I have added an IF condition, to check if count of local!selected variable is 0, save null to local!selected for grid to show all the details.

Currently have 3 buttons that show and hide 3 separate sections of code. If I click button 1 I want to disable button 1 and leave button 2 and 3 enabled. If I click button 2 after clicking button 1 I want button 1 to reset and for button 2 to be disabled. Appreciate the help in advance!a!localVariables( local!buttonTierOne: false(), local!buttonTierTwo: false(), local!buttonTierThree: false(), local!buttonRest: true(),a!formLayout( label: "Label", a!sectionLayout( contents: { a!sectionLayout( label: "", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!boxLayout( label: "", contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextItem( text: { "Submit Tier 1 " }, size: "MEDIUM_PLUS" ), char(10), a!richTextItem( text: { "Service Output Form" }, size: "MEDIUM_PLUS" ) }, align: "CENTER" ), a!buttonArrayLayout( buttons: { a!buttonWidget( lab

So currently I have a forEach loop that calls a picker field, dropdown, and 3 button elements in a interface and it iterates over a dictionary of data passed through by a expression rule. I am getting the following error with the interface: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!forEach [line 237]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!forEach [line 245]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!pickerFieldCustom [line 263]: A custom picker component [label="Producing Country"] has an invalid value for "value". The value and selectedLabels lists must be the same length. The code is as listed as follows: countryProducerInterfaceLayout:{ a!forEach( items: rule!countryProducerInterfaceFieldData(ri!map), expression: a!localVariables( local!items: fv!item,

Hi I want to convert the number to 8 digits for example if the ID equals 19 the result should be 00000019 by adding six zeros before the value.can I solve this proplem using for each  ? 

Hi All, In My interface I am exporting the data story entity to csv using "exportdatastoreentitytocsv" . once export is done, I am giving an option to download that exported file using documentdownload link in a card interface (I used card layout to make it effective).Now when this document is downloaded I want to update a rule input  at the same time ( When user clicks on the card layout ,document download and rule input updating should happen at same time ), but I am not able to do it.Can any one suggest how can I do that. Thanks in Advance, Siva Surya. 

Hi,  The datetext function returns incorrect date with different locale settings. Please refer below:  datetext(ri!dateInput, "dd MMM YYY")  Input Date: 12/29/2021 - English/United states  as locale -> 29 Dec 2022  Input Date: 29/12/2021 - English/United Kingdom as locale -> 29 Dec 2021 - this is correct.  The dateInput is sent as a rule input of type 'Date' to the expression rule. 

Hello newbie here I have a task that I need to compare the current values to  updated values . Once the Coporate Name and Merchant Name have a difference it will pop up a confirmation messager after clicking submit. I hoped you can help me. Thank you ♥

I had been using documentViewer() component to make an inline view for pdf files. But when Excel/PPT files are uploaded it just gets downloaded, unable to have a inline view for it. Is there any other component or any other way to achieve it? Thanks! in advance. 

Hi, my requirement is to set the default document so i have taken value from my database which i have already uploaded and i used those values into the linkfield with  a!documentDownloadLink but still i unable to see the document can you please help me where i went wrong, Below is my code. a!localVariables( local!text:"Please refer these document and send your reply soon", local!newGrid:'type!{urn:com:appian:types:SHA}SHA_receivedDocuments'(), local!emailSubject:"Sending mail regarding Property Documents", local!document:40915, local!docName:"Dummy Document", { a!sectionLayout( label:"", contents: { a!richTextDisplayField( labelPosition:"COLLAPSED", value:{ a!richTextIcon( icon:"file-text", color:"ACCENT", size:"LARGE" ), a!richTextItem( text:"Document", color:"SECONDARY",

Hello, I am trying to simply display a document image as a billboard. I have added the document and created the constant but when I try to call the constant inside the document image I get an error: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!documentImage [line 3]: Could not cast from DocumentImage to Document. Details: CastInvalidCould not cast from DocumentImage to Document. Details: CastInvalid here is the code we are using: { a!billboardLayout( backgroundMedia: a!documentImage( document: a!documentImage( document: cons!G6EGAF_KPMG_HOWYOUGROW1) ), backgroundColor: "#f0f0f0", overlay: a!barOverlay( contents: {} ) ), the image is a JPG because that is what appian likes. I am out of ideas. Please help

Hi All, I have a simple audit form as interface used for auditing between members. I am trying to configure as below,     When details are entered and pressed on submit that need to save the details in database which is happening successfully except a column regarding balance left. which will be calculating the balance left with the previous row. example: Money = 1050price in row 1 = 50; balance_left in row 1 = 1000; price in row 2 = 100; balance_left in row 2 = balance_left - price= 900price in row 3 = 100; balance_left in row 3 = balance_left - price= 800 Please let me know how can we configure this in interface when clicked on submit button

Hello, I've just developped a simple application thats will be used on mobile and on desktop computers, and I am facing some strange behaviour related with a dynamiclink. On desktop, the link always work as expected, on mobile browser it always work fine as well, but on the appian app, sometimes works fine and many times the link just won´t fire any actions. You hace to tap several times on the link unitl it comes into action and the works as expected. No errors in any case. Appian app v 21.3 Tested in Galaxy A8; Android 9; Kernel 4.4.111-22305650. Best regards

Hi, I have to display a caption on a icon that shows to dates on it, and I want to display one of them per line. So I need a way to insert a line feed on caption text. I've already tried putting a char(10) in between both dates, and also with char(13), even "<br>", no luck so far. Any help will be appreciate. Regards

How to copy the latest email body to one of the columns on reply back from end user? Please let me know how to achieve this..., 

How to have customized column/field configuration to display when creating a Query based on the selection of fields while creating a category

Hi All , I have an editable grid from where i am populating data from the db object and also i have an option to add new column . When a user change on existing column then i have to update modified by in database . can u please tell how can i achieve this 

Hi  I have an editable grid like below. The customer wants to move from 1A to 1B on click on 'Enter' instead of 'Tab' press. Is this possible.    A B C  Row 1        Row 2        Row 3       

can anyone Check If the following code is correct .The final output is not displaying in the required field. It is for calculating loan interest a!formLayout( contents: { a!sectionLayout( contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!integerField( label: "Amount Of Loan required", labelPosition: "ABOVE", value: ri!LM_CustomerDetails.loanid.amountOfLoanRequired, saveInto: { ri!LM_CustomerDetails.loanid.amountOfLoanRequired, a!save( ri!LM_CustomerDetails.loanid.loanRepaymentPerMonth, if( and( not(isNull(ri!LM_CustomerDetails.loanid.amountOfLoanRequired)), not(isNull(ri!LM_CustomerDetails.loanid.interestRate)), not(isNull(ri!LM_CustomerDetails.loanid.repaymentPeriod)) ), ((ri!LM_CustomerDetails.loanid.amountOfLoanRequired * ri!LM_CustomerDetails.loanid.interestRate)/ri!LM_CustomerDetails.loanid.repaymentPeriod), {} ) ) }, refreshAfter: "KEYPRESS" ) } ), a!columnLayout( contents: { a!floatingPointField( label: "interest rate"

I want to have the gridcolumn header fixed while scrolling down. while scroling down grid header automatically goes up but want something like excel. I've suggested clients to restrict the paging to small number but they dont want that, they want excel like feature   An editable grid where you an scroll the columns but leave the first one frozen (like you can in Excel).   Please help, TIA

Is there a way to know which input field is in focus in Appian. i.e., the cursor is inside it.

Hello, I posted a couple of minutes ago about a dropdown field doing something similar to this except now it is a custom picker field. I put the code below although you cant test because it has a rule in it. If you want you its just countries so you can use USA, UNK, GER etc. The issue is that I need to save the value into the local variable array. Every time I select a option it just deletes the option and I have surmised it comes out of the issue of list of text vs list of null because list of null sets it to be blank and you can pick but list of text fills it with blanks regardless of null value being present in list of text.  Here is the code: a!localVariables( local!pubProdCtry: cast(typeof({null}), repeat(4, null())), local!dataProdCtry1: cast(typeof({null}), repeat(4, null())), local!count: 1, local!datacount: 1, local!primary1: repeat(4, null), local!primary2: repeat(4, null), { a!cardLayout( contents: { a!forEach( items: