User Experience Design

Hi Do we have any plugins for below requirement, Tyre Data Table: Columns: TyreID (Primary Key), PartNumber (Foreign Key) Country Restriction Table: Columns: ID (Primary Key), PartNumber (Foreign Key), Country Name, IsActive (Boolean)These tables have a one-to-many relationship. For example, if we have a tyre with TyreID 1, there could be 150 entries in the Country Restriction Table for this tyre. Let's say for TyreID 1, it is active in India and the US. In this case, the IsActive column would be 1 for India and the US, and 0 for all other countries. Requirement: We need to export the data in the following format: Part Number|Country1|country2|.......country150 12345 | 1 | 0 |................|1|

I have requirement where I need to export data of the editable grid but issue here is I will be able to it in read only grid with help of parameter showexport but how to do it in editable grid.

hi , we are not able to get email alerts when site page got error.do we need to enable manullay or it will send automatically to administrators. when site page got error. In 24.2 appian released this feature -Site email alerts will be sent to site object administrators  I have administrators acces for  all objects in my application but when site got error during that time I'm not able to get mail from site page. We are currently using 25.1 version could you please let me know any have idea on it Thanks

I have 2 dropdowns type and courses type will be premium, free and courses for premium java, c++, and also for free also I have java , python like this . i need to display all the courses when in default and when type selected as premium it will only show that category courses. but java is in both category it displaying 2 times by default . In db they have mapped with thier unique type ids only. I tried with union but choice values and choice values length varies because of that. Can anyone help me ?

Hi team, I have one field in the database for the budget. Sometimes the value may exceed 100 crores, so for storage purposes, I am storing it as text. However, I want to compare that value with an integer. When I tried to convert it into number   in Appian, it rounds the value by default. Any idea how we can achieve exact value?

Hi Team , The requirement is to add dropdown filters to all fields between the header label and the first row in Readonly grid . Is this possible in Appian?

Requirement: How to implement a logic similar to the refreshAfter field in a!dateField as we do for a!textField? We would like the page to refresh when the DOB field is clicked again, and a different date is selected. a!dateField( label: "DOB", labelPosition: "ABOVE", value: ri!input.dob, saveInto: ri!input.dob, showWhen: cons!PARAMETER[2] = tostring(local!input), required: true),a!textField( label: "Address Line 1", labelPosition: "ABOVE", placeholder: "Enter Text ...", value: ri!input.addressLine1, saveInto: ri!input.addressLine1, refreshAfter: "KEYPRESS", showWhen: cons!PARAMETER[2] = tostring(local!input))

I have two interfaces 1. Home screen display all orders 2. summary page From page 2 i click on an record action to copy where a process triggered and on completion of order.  the new window closes and still the old summary page is dispalyed on the other tab. Example. when record action for copy is been triggered from order 1. new screen for order creation order 2 created and after completion. still order 1 summary page displayed on other screen unles user clicks on the menu for home page and navigate to new  order order 2 the requireemnt expects the home screen should be displayed or order to be displayed after completion  is there a way. 

We have one record type on database View. Record type is configured with Filter applied to 3 columns only i.e. "Limit search to selected fields" GRID with Record type source is showing Data with paging=50 in UI and able to see data in next page as well. User sees data with some mandatory Input filter on selected column.  GRID is configured with showSearchBox option. Now if user is entering some value in default searchbox(this value is applied with the record filter configuration which is again on 3 columns) with record type then getting below error- An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.  I need to understand the sequence of the search value applied to the data- 1- Will this apply to whole data(10000 rows) available to view without any User mandatory filter or only to the data coming in the Grid(with user filter applied) for e.g. 2000 rows(with pagination 50 per page)

We are facing issue like the value is Number(Decimal) when user enters - 1595739.56 it gets round of to – 1595740. Which is a concern here. Also any number which is of 7 or more than 7 digit are getting round of. We understand appian recommends the uses of ‘text field’ instead of floating point field, but this will lead to the column type changes in Database because those decimal columns can either be calculated in appian or in database stored procedures, hence as converting the column from decimal to varchar will required us to type cast them from varcharToDecimal before doing any calculation s and those are many fields which are used in calculations. Any urgent help/suggestion is really great help to me to progress.

Well, there is the reference of a!cardChoiceField. https://docs.appian.com/suite/help/25.1/card-choices-component.html The component itself is amazing. However it has one big defect, which is: you cannot (at least easily) change its card's background color. I would like to be able to keep the interface's background color on its default (as it is), and change the choice card background color to gray, black, blue, etc. So only, the card choice should get the customization. I've searched a lot and I didn't find any hint or previous usage on this. Does anyone have any idea in mind on what to do about it? I would like like this to be possible and if it's not, it should be implemented on a next version of the component. This is for UX/UI purposes.  Thank you in advance for any hints on this.

Hello dear Appianistes,  I have a gap between how my app reacts in development tools (build) and in the site, Site : After using AJOUTER button : Builder : After using AJOUTER button : Any guesses ?  buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: if(ri!isUpdate, "Enregistrer", "Ajouter"), saveInto: { /*sous-periode*/ a!forEach( items: local!sous_periode, expression: { a!save( ri!sous_periode[fv!index]['recordType!{77c00203-ec59-4d91-815a-0f6334649b51}alan_r_sous_periode.fields.{38d14ae2-8fd9-40ee-a277-dbc90afc6266}dateDebut'], local!sous_periode[fv!index]["deb"] ), a!save( ri!sous_periode[fv!index]['recordType!{77c00203-ec59-4d91-815a-0f6334649b51}alan_r_sous_periode.fields.{368c8cd0-aeff-4d35-b85f-e83787ea7fa8}dateFin'], local!sous_period

I used if() to check the condition in Value() parameter of dropdown which is working fine from front end, but the value is not saved when i use the same logic in SaveInto() parameter of dropdown. Logic used in Value() parameter:  if( and( ri!eventType = cons!INS_INT_EVENT_TYPE_ID_ANZ_ARREARS, ri!policyNo = cons!INS_TXT_MULTIPLE ), "Contact Centre Outbound", if( and( ri!eventType = cons!INS_INT_EVENT_TYPE_ID_ANZ_ARREARS, ri!policyNo = cons!INS_TXT_SINGLE ), "Contact Centre Inbound", index(ri!application, "incomingSource", null) ), ) Logic used in SaveInto() parameter:  { if( and( ri!eventType = cons!INS_INT_EVENT_TYPE_ID_ANZ_ARREARS, ri!policyNo = cons!INS_TXT_MULTIPLE ), a!save( ri!application.incomingSource, "Contact Centre Outbound" ), if( and( ri!eventType = cons!INS_INT_EVENT_TYPE_ID_ANZ_ARREARS, ri!policyNo = cons!INS_TXT_SINGLE ), a!save( ri!application.incomingSource, "Contact Centre Inbound" ), ri!application.incoming

Hey,I am exploring some thing new in Appain functions,Supose if user enter 1+2+3+4+5 in a text box then is there any function to evaluate this and give me the sum of all those numbers as 15.Thanks in advance.

Hey guys,I am exploring the validations stuff in the interface in appian.I have 2 text fieds in the interface, I have set up validation on the 2nd text box, if the 1st text box value is equals to Hi then I am showing a validtion on the 2nd text box.So here, If I enter Hi in the 1st text box then validation is showing up only when I enter something in the 2nd text box. Validation was not showing whenever I enter Hi in the 1st text box and levaing the 2nd text box empty.Let me know If I am missing anything here.Thanks in advance.

Hi everyone, I need to build a team dashboard for managers and directors, where the team data is stored in a single record type. This data includes fields like username, personal number, manager's personal number, and email ID. I’m currently passing the email ID to fetch the personal number of a user, and then using that personal number to find the manager's personal number in order to get a list of employees under that manager. This process is repeated for up to five levels, as directors report to managers and each manager can have multiple employees under them. However, after implementing this approach, the performance of the UI has slowed down significantly. Can anyone suggest a more efficient alternative to improve the performance while maintaining the same functionality?  Below is the code for your reference. 

Hello Everyone, I need to build a team dashboard for managers and directors, where the team data is stored in a single record type. This data includes fields like username, personal number, manager's personal number, and email ID. I’m currently passing the email ID to fetch the personal number of a user, and then using that personal number to find the manager's personal number in order to get a list of employees under that manager. This process is repeated for up to five levels, as directors report to managers and each manager can have multiple employees under them. However, after implementing this approach, the performance of the UI has slowed down significantly. Can anyone suggest a more efficient alternative to improve the performance while maintaining the same functionality? Below is the code for your reference.

Hi Everyone, We have a editable grid with dropdown fields, second drop down(Evidence category) choice values purely dependent on first dropdown (Therapeutic area) selected value.I have configured the code like this but getting the above error. Can you please help me a!sectionLayout( label: "", contents: { a!gridLayout( label: "", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Therapeutic Area"), a!gridLayoutHeaderCell(label: "Disease State"), a!gridLayoutHeaderCell(label: "Evidence Category"), a!gridLayoutHeaderCell(label: "Evidence Need"), a!gridLayoutHeaderCell(label: "Priority"), a!gridLayoutHeaderCell(label: "IEP Code"),

Hi Everyone, We have a editable grid where we placed 2 drop down values. Second dropdown choice values and choice labels purely dependent on first drop down selected value.But we are getting the error. a!dropdownField( Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 label: "Therapeutic Area", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 placeholder: "---Please Select---", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 choiceLabels: index(local!therapeuticArea, "name", {}), Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 choiceValues: index( Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A

Hi Team,I have One Requirement that isi want to display data in read-only grid from records and that data i want to download in CSV Format also if i want to upload new data i want to upload in CSV format,if it is possible please help me with it,those import and export options i have to display in buttons.

We have a form with multiple collapsible sections, and in some of these we also have subsections. When user clicks on submit, there might be errors in the subsections that are not visible to the user because the parent section does not have the "This section contains errors" warning. I've come to discover that it's because other subsections don't have any errors. Here's an example where this happens: Here both the parent and child show that there are validation erros. The moment I add a section without validation errors, the warning disappears on the parent:   I feel like this should not be the standard behavior and is something Appian should fix on their end. The only workaround I can think of is to have validations at section level, on the parent section. But that would display a red message box on the section that for me is not desirable. Any help here is appreciated.

Consider a scenario where we have two entities: Books and Chapters, with a one-to-many relationship (i.e., each book can have multiple chapters). I currently have a read-only grid that displays records based on the Book entity. One of the columns in this grid is called "Chapters", which displays all associated chapters in a bulleted list. Since a book can have more than 10 chapters, I'm currently fetching all chapters into a local variable and indexing them based on the Book ID to display in the corresponding grid row. This approach works fine for now. However, I'm concerned about performance if the chapter count increases more than 5000 Does anyone have suggestions on how to handle this scenario more efficiently?

Hi all, We have a requirement to have custom fonts on specific interfaces... I read through the documentation and understand that this is not an OOTB feature. Admin console typeface will also not solve this issue as the fonts will be applied across all applications and cannot be referenced in specific components. How can we add custom fonts to specific interface components? Is this able to be done via a plug-in or some other means?

I have an odd problem.  I have a read only grid what shows a value one way on the interface, but differently in the excel download. Here is what you see in the interface vs the excel spreadsheet. Here is the offending code in the Grid. a!gridColumn( label: "Residential Status", value: rule!CMS_GetCurrentResidentialStatusId(fv!row['recordType!CMS Clergy Member Status Report.fields.clergyId']) ), Here is the expression rule. a!localVariables( /* * Get list of current resendential type addresses for clergy member * ordered by start date */ local!residentialAddressData: a!queryEntity( entity: cons!CMS_ADDRESS_CLERGY_ASSIGNED_ADDRESS, query: a!query( selection: a!querySelection( columns: { a!queryColumn( field: "clergyAddress.residentialStatus.status" ) } ), logicalExpression: a!queryLogicalExpression( operator: "AND", logicalExpressions: { a!queryLogicalExpression(

I need to execute two delete record smart service from one saveinto.  Evidently, this is not possible as it throws an error. " An error occurred while executing a save: Expression evaluation error : Attempted to run a second smart service, but only one smart service can be run per expression evaluation." Here is the business issue. I have an interface where Parish managers can specify if they have a preference as to the type and the languages spoken my missionaries that speak at their church.  This is one in the Parish Profile screen and the profile is saved year after year.  The current parish manager can change the preferences that were set last year.  There are two record types that hold this information, Parish Profile Language Type and Parish Profile Speaker Type.  The local variables in the interface that holds this data are local!speakerPreference and local!languagePreference.  They both are types as their respective record types and can h