User Experience Design

Hi! When using embedded interfaces and use the url appian-site/url /suite/tempo/ui/sail-client/embedded Bootstrap.nocache.js on the external site, where is defined the interface that will be embeded? what does this url contains? Do I have to change something?  And it's available to use when using appian on premise right?

I am using appian version 24.4 and made a user filter for a record that is populated by a lookup table. I deleted a couple of rows from the table because they were unwanted, but they still show up in the filter. If I look at the table in the db or the record for the lookup table, both show that the entries are missing, but no matter what I do, the deleted rows show up in the dropdown.  This is the table: This is what the dropdown shows: "In draft" shouldn't be there and there is a duplicate which was removed, but both remain. I saw a similar post Here but I am not sure it's the same bug or not and the post seems to suggest that this issue was solved with version 24.1. Any help would be appreciated 

Hi community, I have a question about a functionallity that appears on the SAIL Design System Documentation. https://docs.appian.com/suite/help/25.1/sail/ux-site-branding.html#dialog-shape In this page, we can see a section that says that the dialog shape can be configured, but not how to achive it. Could someone guide me? Thanks in advance.

I have(had) an issue with a Selectable Editable Grid and I don't know if this is a bug or not. BUSINESS USE CASE I actually have two grids.  The Use Case here is to have the user assign a speaker to a parish for a parish event. One grid shows unassigned approved speakers and the other shows parishes that do not have a speaker.  There are two local variables that are loaded with this data; speakerEvents and parishEvents.  The user selects the Speaker, then selects the Parish before submitting the data. Here is the JSON for one of the grids. a!gridLayout( label: "Unassigned Approved Speakers", labelPosition: "ABOVE", emptyGridMessage: "There are no Unassigned Approved Speakers for this Event.", headerCells: { a!gridLayoutHeaderCell(label: "Speaker"), a!gridLayoutHeaderCell(label: "Type"), a!gridLayoutHeaderCe

Hi, I am trying to generate a CSV file from HTML(convert HTML to CSV plugin), but in the plugin's smart service, there is a parameter called 'CSS query' (text type). I am confused about what to put in that. Can anyone help with this? You will see this parameter in data --->input section

I have two or more dropdown component and I hope that these dropdown components can share one choice list. For example I have a list like {choice 1, choice 2, choice 3, choice 4,...} In dropdown 1 the choice list should be  {choice 1, choice 2, choice 3, choice 4,...}, when I choose choice 1 in this dropdown, the choice list of other dropdown should be  {choice 2, choice 3, choice 4,...},  when I choose choice 2 in dropdown 2, the choice list of other dropdown (expect dropdown 1 and dropdown 2) should be {choice 3, choice 4,...} Can appian do like this?

Sure, here's a clearer and more structured version of your text: Hi Everyone, I have a requirement involving two tables: 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(all remaining rows). Export Requirement: We need to export the data in the following format: PartNumber Country1 Country2 … Country150 12345 1 0 … 1

Hello, I have this interface where there is a grid that shows uploaded attachments and a button to refresh the grid whenever there is a new attachment uploaded. I am running into an issue where if the user clicks on "Refresh existing attachments" when the grid is empty, then uploads an attachment, the refresh button no longer refreshes. But if they upload an attachment and click refresh after utilizing the action, it functions as expected and the attachment shows on the grid. I am trying to cover this scenario in case a user for some reason decides to click refresh before uploading and the grid is empty. Thoughts?  a!localVariables( local!readonly: a!isUserMemberOfGroup(loggedInUser(), cons!FRR_viewerGroup), local!existingFolderId: if( isnull(ri!requestId), null, rule!FRR_GET_requestFolder(requestId: ri!requestId) ), local!existingAttachments: a!refreshVariable( value: if( isnull(local!existingFolderId), null, folder( l

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.