User Experience Design

Hello everyone! I need to display 5000 rows of editable rows in the grid - it’s about 2mb of data. First thing I have thought of is to fetch data from database with batches - to set a start index and a batch size and pass it to query entity expression, and then provide that result data subset to editable grid with implemented paging option (clicking back and next will trigger an update to a start index as well as a new batch to be fetched from database) And I’m facing a problem finding an approach to update that data in the database after editing on the form when switching pages. Most probable storing 5k items in a local variable along with other data will cause memory issues while manipulating it for example Is there any approach to achieve a desired goal?

Hi all, i want to select a speficic color for this pie chart, for example if the status is "DA RIASSEGNARE" the related colour is orange and so on.  Here is the code, and in attachment the pie chart. Thank in advance.a!localVariables( local!save, local!save2: a!refreshVariable(value: local!save,refreshInterval: 0.5), local!array, local!record2: 'recordType!{2def5f7f-c651-48be-9fce-fe502682f30f}GEC_Dettaglio_Task', a!sectionLayout( label: "", contents: { a!pieChartField( data: a!recordData( recordType: 'recordType!{2def5f7f-c651-48be-9fce-fe502682f30f}GEC_Dettaglio_Task' ), config: a!pieChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2def5f7f-c651-48be-9fce-fe502682f30f}GEC_Dettaglio_Task.fields.{6d87248b-9f66-495a-b736-3e539bcad481}STATO', alias: "vehicleMake_primaryGrouping" ), measures: {

Hello All, I need your guidance and assistance regarding the creation of a cascading dropdown interface that supports an unlimited or variable number of levels. The purpose of the interface is to display data retrieved from a reference database table, where the values of the child level dropdowns are determined by the parentId field in the table. The cascading dropdown interface will be used to present hierarchical data from the reference database table. Each dropdown level represents a different level in the hierarchy, with the child level options being dynamically populated based on the selected value of the parent level. The goal is to enable users to navigate through the hierarchy seamlessly, regardless of the number of levels it comprises. The database table looks like this . ParentId is FK refer to Id field. Id, level parentId 1   l1v1      null 2   l1v2       null 3   l1v3       null 4

Can we show Uploaded file in same interface, {Transition files saves in TEMPORARY KNOWLEDGE CENTER, we can't pull back from there}, So is there way, to show uploaded file right beneath it??...

Hi All, I have designed a read-only grid which will be used as a child interface in other interface ,But I ma facing one issue here,Sometimes the grid is pre-selected with a single row automatically.How to handle this.Thanks in Advance, SSP

my requirement is to show the line in between two components (As below sample pic) I have tried with section layout but does not  suits for my requirement, Any inputs  ...

Hi All, I need to export record to excel file  by default export option in another interface and store it in rule input, so that I can pass same ri!document to process model and can attach in email.Please let me know is there any way to achieve this. Thanks in advance.

I am using a custom picker. Fetching names from a group. And i want to pass a name using rule input. Then that name should not be visible in custom picker.How can i do it ?

I want to export data from editable grid to excel file without storing data to database. How can I achieve this?

I have an interface where am uploading  image files by using a!fileUploadField() and I need to preview that uploaded  file. How we can display that uploaded  files preview  in the interface. Can any help me about it.

Using the below code to trim the character count and limit the characters below 65000 in a paragraph as the character count in the interface is different from the character count when we paste the same in the word document.please suggest changes and attached the screenshot of interface count and character count if( local!isEdit, a!paragraphField( value: fv!item.body, saveInto: fv!item.body, characterLimit: 65000, showCharacterCount: true, height: "TALL", validations: if( len(fn!trim( fn!substitute( fv!item.body, char(10)," ") ) ) > 65000, "The communication you are trying to send exceeds the character limit allowed. Please send a modified version of the letter to not exceed [65000]", null )

Hi I have writeToMultipleDataStoreEntities in my interface, I wanted to retrieve only the primary key values when insert happen.  onSuccess:a!save(local!emplEntity,fv!storedValues) 

Hi  I am trying to refresh my Data stored in the expression. There is link which stores true, false in local!refreshBool and I want to refresh the data based on that. This expression rule pulls data from Integration. But the Data is not getting refreshed. When I TEST interface the data is refreshed but not when I click on link  local!data: rule!TA_getAndFormatRandomUser(), local!refreshBool, local!refreshData: a!refreshVariable( value: local!data, refreshOnReferencedVarChange: local!refreshBool ),

Hi Everyone, i had a requirement to display Number (Integer) value  inside donut (piechartfield)

I want to create below boxes dynamically for example if I receive 5 values from DB then there should be 2 rows and 3 columns, 1st complete row and 2nd row with 2 items

I'm trying to implement google maps in my UI but I want to show the pin marker on logged in user's current location

Hi, I am facing one challenge to sort a list of addresses into particular order. The appian sail expression should match the sorting order as in our C# equivalent using orderby and thenby. My SAIL expression is not giving same results as C# code(Expected one).Kindly provide suggestions. in c#: sortedAddresses.AddRange(addresesList.Where(x => x.AddressId != primaryAddress.AddressId).OrderByDescending(o => o.EndDate).ThenByDescending(o => o.EffectiveDate).ThenBy(o => o.AddressType.Name).ThenByDescending(o => o.IsActive).ToList()); in SAIL: todatasubset( todatasubset( todatasubset( todatasubset( remove( local!7sortedaddresses, wherecontains( touniformstring(local!primaryAddress.addressId), touniformstring(property(local!data, "addressId", "")) ) ), a!pagingInfo( startIndex: 1, batchSize: - 1, sort: a!sortInfo(field: "endDate", ascending: false()) ) ).data, a!pagingInfo( startIndex: 1, batchSize: - 1, sort: a!sortInfo( field: "effectiveDat

Hi, I currently have a a!gridField() that is being used to add a list of samples. We have made the grid list selectable so that all rows can be selected, however there is a current request to have all rows in the grid selected without having to page to the next set of samples in the list when selecting the checkbox to select all rows. I wanted to see if this is even possible to configure in Appian? 

and when I click on cancel for this 2nd interface , I need to get 1st interface again with  3 buttons hiding the comment form(above form)Can someone help me with the code please

I have a text field which is for Password.I want to show asterisk symbols when entering a password.

Hi  I am working on the scenario in which I am using the milestone component. Step 1, Uploading CSV file through the file upload component then click the next button of the milestone component. In Step 2 I want to fetch data from a CSV file and want to show it on a read-only grid. So If anyone knows how to fetch data from a CSV file and upload it to a read-only grid please let me know. Many Thanks in advance.

Hi, I am new to Appian. I need help in the below task. I am trying to display a field in my current interface which is residing in a different interface. Please help me with this.

I have a grid as below. The thing is it is populating the country(s) column wrongly. India should be in third row, Mexico should be 2nd row and Saudi Arabia and Bangladesh should be in first row. The data we are passing is stored in the local variables and rule input correctly. But something is going wrong with the code to populate the grid column value. The code for grid column to populate Country(s) is below. Please help me in storing the correct values in to the grid. a!gridTextColumn( label: "Country(s)", field: "country_txt", data: if( rule!APN_isBlank(index(local!gridData, "data", {})), {}, tostring( sorttextarray( stringArray: stripwith( split( index( index(local!gridData, "data", {}), "country_txt",

Hello, I am exporting a table on a button click and I want to give download link for the latest exported excel document. So when I click on "Generate Excel" button, It should export a table and then update the download link for the latest document. How can I achieve this on one interface.  Thanks in advance!

Hi, I want to add a Safelink in buttonWidget, is there anyway to do this?