User Experience Design

Hello! I´m having some trouble trying to save my values in an editable grid. The first 6 columns are read-only (data from a local variable, query of a record) and the 7 one is an editable column (user introduces quantity) My values are not saving correctly into my rule input "RecordLineasRecepcion" Could you please tell me how can I save the values of each column? I think I cannot use fv!item in the saveInto parameter of the six first columns because the user is not interacting. Should I use an (or some) a!save functions? Can that work with more than one row? This is an example of what I want to do: 1) Show the value of the selected field of my local variable 2) Save the value to another record With my code code, no data is saved when I click "Submit" I leave my code below (I know that if there is no user interaction data will not be saved when using the SaveInto of each field directly, but I´m not sure how to be able to save the values): a!

is there any way to improve the Look &feel of our appian interfaces by adding Html & Css from external Sources.

Hi, I ahve a gridField setup like shown below: (just a excerpt of full interface code) local!posiciones: a!forEach( local!posicionesBDI, { cod_descripcion: fv!item.cod_descripcion, estado: fv!item.des_estado, tecnologia: fv!item.des_tip_tinst, topologia: fv!item.des_conf_posicion, num_calle: fv!item.num_calle, juego_barras: fv!item.cod_matricula, afectada: if( a!isNullOrEmpty(ri!expCon), "-", if( contains(ri!expCon.codigo,tostring(fv!item.cod_descripcion)), "SI", "No" ) ) } ), a!gridField( label: if(isnull(ri!expCon),"Posiciones del parque afectado por el informe","Posiciones del parque afectado por el expediente"), data: local!posiciones, columns: { a!gridColumn( label: "Código", value: a!richTextDisplayField( value: a!richTextItem( text: fv!row.cod_descripcion, style: if(

Hi! I have created an editable grid in which the user can add a quantity to the "Cantidad Recepcionada" field.  This value is saved in two records (Field: CantRecepAcum) After this, I wanted that, each time the user runs the process and saves a new quantity, the value is added to the previous existing value of the field "CantRecepAcum" In order to do this, I configured the following code in the interface (I save the value of fv!item in my rule input each time. Every time a user enters a value, there is a sum between the curren value of the ri! and the new value of fv!item, for the field "CPF_Lineas_Pedido_CantRecepAcum": In the interface, when I click the submit button, it is not acumulating OK (I´m going to try to explain. If I put 1,0 in the rows, both fields increment +1. If I continue with 1,0, its a +1 for each field too. But when I change and put 2,0, then the first field goes a +2 up and the second a +1. If I repeat then with 2,0,

I want to use the toggle button (highlighted below) in my user interface - similar to that used in the Profile Settings --> Email notifications interface. Is this available anywhere or on the Appmarket? Thanks!

I have a page where the label I am dynamically passing from database. I have a dropdown menu with 3 values and I want to make sure when I select any of the values and click on submit, my selected value should be updated on the Page label. The problem I am currently facing is for every refresh I am able to see the update value and can't we make it possible without any page refresh??I already used refreshVariable but didn't work. Please let me know your inputs. Thanks.

Hi all, We're on Appian 23.2 and have noticed an issue where when we have a disabled dropdown field, the dropdown list will appear if the user clicks the field and then enters a key stroke. See the screenshot below: Does this look like a bug with Appian or could it just be in our code? It's reproducible for all of our dropdown fields. The value doesn't get changed if you select one in the dropdown list but I don't think the list should be appearing. Thanks!

Hi All, We have observation from our VA testing team, that while uploading file it should not contain double extension like as shown below: FileUploadBypass.php%00.xlsx Currently Appian is allowing to upload the file in to application because of extension .xlsx but VA testing team suggested us to file name should not contain double extension. Any suggestions on this, how to validate this kind of observation? Regards,Sandeep

i want to ask about editable grid that i have some problem with it 1- the first one is when upload the first document when upload another document it will duplicate the document again  2- how can bring the document id for the document that i uploaded , please answer quicly 

Hi, I have a case where we have nested cdts, I need to call integration only when nested cdt value changes,  Value referring like - ri!products[ri!index].loan.loanType inside this loan we have other fields also like payment source etc. applied refresh variable -  refreshvariable(value: rule!callIntegration(), refreshonreferencedVarChange: true), This value will be updated by dropdown selection, what is happening if i change another dropdown paymentSource, It is still calling integration. Kindly guide me why is this happening, how this can be resolved? Thanks in advance.

I'm facing an issue that the column name is not showing in the placeholders outside the graph. The image is attached. The value of the columns are not showing.

i have a problem when add the new record using the record action , when i want to add the new record the record does not added to data base and the grid please help { a!sectionLayout( label: "", contents: { a!billboardLayout( backgroundMedia: a!webImage( source: "https://static.pointcheckout.com/16cd7c7425e54498/original" ), backgroundColor: "#f0f0f0", height: "MEDIUM_PLUS", marginBelow: "NONE" ), a!gridField( label: "", labelPosition: "ABOVE", data: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit', columns: { a!gridColumn( label: "Deposit Id", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{c27cd643-e617-46e3-a4dd-c16df94bbed2}idDeposit', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{c27cd643-e617-46e3-a4dd-c16df94bbed2}idDeposit'],

Hi! I have created an editable grid with previous data (stored in my local variable) To create an editable grid from scratch, I used to put "fv!item..." in the value and saveInto parameters (so that when the user interacts, the value was saved).  But in this case, I just want the grid to show the data of my local variable and save it in another record/ruleInput/localVariable How can I configure my code in order to manage this? Should I use the a!save function? Should I "point" to each field/column of my local variable without using the "fv!item"? How? I leave my code here. I think that I could omit the operations between columns in "Cantidad", "Precio Unitario" and Importe, because I´m querying the values directly with my local variables (my local variable is created by quering a previous editable grid). But for me the most important thing is being able to point to my local variable and save correctly the values wi

hi  can someone provide me with example codes about Editable grid with record types ? all of the examples use dummy data and not record types and i am struggling and don't know how to replace the data with record types without getting errors.  for example, here is a code , i need to link it with a record type and then get the appian id doc. and the document name , then save them in their fields.   but when replace [Record Field for Document Name], with my actual record type it does not work  and keep getting invalid indexing types errors.  a!localVariables( local!document: Data of Record Query, { a!gridLayout( totalCount: count(local!document), headerCells: { a!gridLayoutHeaderCell(label: "Document" ), a!gridLayoutHeaderCell(label: "Name" ), a!gridLayoutHeaderCell(label: "Classification" ), a!gridLayoutHeaderCell(label: "Updated By" ), a!gridLayoutHeaderCell(label: "Updated On" ), }, columnC

Hi! I have an editable grid made of existing data (stored in my local variable, in which y query another record), and I don´t want this data to be touched (like read-only).  Now, I would like to add to my local variable another extra-column with no value, and make this column able for the user to put values Is this possible? How can I manage to do this? I leave my code here (It is not finished yet, but I would like to know in which part of the code should I act and the considerations) a!localVariables( /*mirar para incluir columna extra en variable local*/ local!DatosLineas: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido', fields: { 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{fcfa4b36-4398-4430-8055-ecfa59daf13a}idLineaPedido', 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{71427dbb-12db-4f83-bd99-f625bf9af271}idPedido', 'recordType!

Hi! I have a doubt with the approach of my application and I would like to know your thoughts! In my case, I have a summary view of PO in which I have a read-only grid with the PO lines. I created a related record action to "recepit" the PO Lines ("Recepcionar Pedido", which will link to a process model), and now I want to create an interface with the following conditions: 1) I must show the same information/table with the PO Lines (I just need some of the fields). Not need to add new rows 2) I must be able to create an extra-column to introduce manually  In order to do this, I thought several options: 1) Create an editable grid based on the data of a record (like a read-only grid, same values, but with the posibility to manipulate it) 2) Convert the read-only grid in an editable grid (i dont know if its possible or complex, I know the configuration are totally different) How can I manage to do it? If it´s not a good approach, I would like to h

hi i am trying to save the value of "Account Balance" to calculate the dollar equivalent field.  i wrote the code below and tried to save the value of "dollar equivalent" in a local variable but the value stays NULL, i also tried to replace with rule input but that did not work.  any suggestions?  local!USD:ri!record['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.fields.{48c2c2cc-59fa-42cc-a496-c512f51c25bf}dollarEqu'], local!USDBALANCE: ri!record['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.fields.{a26624aa-6c8b-4ad4-b696-f52169531873}accountBalance'], local!dollar:ri!record['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.fields.{48c2c2cc-59fa-42cc-a496-c512f51c25bf}dollarEqu'], a!floatingPointField( label: "Dollar Equ", labelPosition: "ABOVE", value: a!match( value:local!Curre

Hey there!  I am working with a selectable grid,  the user is supposed to select a row and then the account number of that row should appear in the text as shown in the image.  the thing is that i tried to used "index" with the variable "selectedEmployee- where i save the selection" but the value still does not show in the text.  What am i doing wrong? how can i fix it?  a!sectionLayout( label: "", contents: { a!gridField( label: "", labelPosition: "ABOVE", data: local!info3, columns: { a!gridColumn( label: "Account Number", value: fv!row['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.fields.{afb4d4c6-e193-4650-8165-83cfacf7b5df}accountId'] ), a!gridColumn( label: "Account Balance",

Hi Appian community , i want to help me to make a editable grid that have on it multi field like a document field the name of this field and the classification field , ok this editable must connect with record (document) in name document i must put the name of the documnet that i uploaded it  please help me give me a code for that 

Hello, In a interface using process model I'm generating the Report in Excel using Export Data Store Entity To Excel Smart Service on Monthly and daily basis, and in smart service inside filter field I'm providing filters to filter the data. Now the requirement is that I need to take inputs from user like the From Time and To Time, and based on this I need to filter the data from the database and generate report in excel which is present between the time period provided by the user in interface.  Thank you.

Hi, I am using a record type for creating the readonly grid, I am trying to change the language of the filter label once the user interacts in the parent interface. As per current design, we cannot pass rule inputs to the record type. I tried refreshing the child interface using a!refreshvariable(), however the problem still persists and label value doesnt change.

Hi! I have created an editable grid with data of a record. To store the data, I created a local variable whose value is obtained by querying the record (local!DatosLineas)  Now, I would like to configure two things: 1) By now, the values of the grid are saved in the SAME RECORD (to which I executed the query). I want to show the values of the previous Record (CPF_Lineas_Pedido) but I would like to save the values in another record (f.e. CPF_Lineas_Recepciones). How can I do this? 2) I would like to add a new column, which must show no info (empty) and be filled in manually by the user. I want this values to be saved in the same new record as the point 1) (CPF_Lineas_Recepciones) ¿How can I add a new empty column to my local variable or to the grid? I have doubts because it is something "apart" from the query, independent. And I want the values to be saved in another record.  My code is below: a!localVariables( /*mirar para incluir colum

Hi All, How to validate an email address for users which are in same organization. If I am working in a abc organization and I want to validate that if users is not a part of an abc organization should show me invalid email address in textfield object in appian and if it is a valid user of that organization doesn't show me an error. Example: 1. hdhdh@abc.com 2. xyz@abc.com 3. adrfer@abc.com From above examples that users who is a part of abc organization then in textfield show me invalid email address. So my point is in one organization I need to validate users if it is valid no error should show in interface if it is not valid user then show me an error. Please guide me how to achieve these in a!textfield() function under appian 22.2 version?

Hello, I have an issue with the card choice layout. Consider the following code: a!cardChoiceField( label: "What's the number of possible answers?", labelPosition: "ABOVE", data: { a!map( id: 2, icon: "dice-two", primaryText: "2", secondaryText: "Two" ), a!map( id: 4, icon: "dice-four", primaryText: "4", secondaryText: "Four" ) }, cardTemplate: if( rule!UNI_FN_getPageWidth() = 1, a!cardTemplateBarTextJustified( id: fv!data.id, primaryText: fv!data.primaryText, secondaryText: fv!data.secondaryText, icon: fv!data.icon

Please find the below screenshot of dropdown, in this dropdown we have few values (ex: "a","b","c","Other"). Whenever I select "Other" option in the initial time it is allowing me to Save. but after Save, whenever I'm trying to Select second time in different dropdown as "Other" option then it is throwing below error. Can anyone please help me with this?   Error: Interface Definition: Expression evaluation error at function a!forEach [line 521]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!dropdownField [line 622]: A dropdown component [label=""] has an invalid value for "choiceValues". Duplicate items are not allowed in the choiceValues array, but choiceValues was [id=, name=Casing & Cementing, point=1, fluidPoints=1; 1; 1; 1]; [id=, name=HSE & Environmental, point=1, fluidPoints=1; 1; 1; 1]; [id=, name=Logistics, point=1, fluidPoints=1; 1;