Foundation

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;

Actually I am having editable grid which is shown below .. contains components  dropdown and  file upload field and Text Field  I want to preload the required values of dropdown , when user opens the page he should see the grid with selected dropdown values. as shown below  all other functionality of grid will work as it is .. like removing adding new row .. please find the code-snipet attached (in the snipet Local!required Documents .. is just an id label we are storing in lookupref Table  so we can get from there) local!selectedDocuments: if( a!isNullOrEmpty(local!data), { 'recordType!{e5935b72-2349-43df-bd15-908d316468be}PRO Lead Documents'() }, local!data ), local!requiredDocuments:{198,199,191,193}, a!gridLayout( label: "", headerCells: { a!gridLayoutHeaderCell(label: "Document Type"), a!gridLayoutHeaderCell(label: "Document"), a!gridLayoutHeaderC

Hi all, I'm trying to see what is the best way to assign a minimum character number for a text component in a interface?

Hi  I want to create an interface in which a user can click on a button which will open the editable child interface and the edited values can later will be saved into the parent interface. how can i achieve this.

Hello! I am trying to figure out the best way to manage the Breadcrumbs Pattern, but I can't seem to grasp the way it is intended to be used. { a!localVariables( local!currentNodeId: 4, /* This variable would normally be retrieved with a rule like rule!getBreadcrumbsForIdentifier(identifier: local!currentNodeId). */ local!nodes: a!forEach( items: enumerate(local!currentNodeId) + 1, expression: choose( fv!item, a!map(name: "Home", identifier: 1), a!map(name: "My Documents", identifier: 2), a!map(name: "Strategy", identifier: 3), a!map(name: "2018 Road Map", identifier: 4) ) ), { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!forEach( items: local!nodes, expression: if( fv!isLast, a!richTextItem(text: fv!item.name, style: "STRONG"), { a!richTextItem( text: fv!

Hii ,  I want to add value but getting erroe like - Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = PBWBF] : An error occurred while executing a save: Expression evaluation error at function 'todecimal' [line 285]: Could not cast from Record Field to Number (Decimal). Details: CastInvalid how can i resolve ? here is my code - a!localVariables( local!application: rule!GAI_getApplication(applicationId: ri!appId).data, local!grantorProjectActivityEval: ri!grantorProjectActivityEval, local!yaProgTypeId: cast( typeof(5), ( index( rule!GAI_getRefProgramType(programTypeAlias: "YA").data, 'recordType!{9d188bef-069b-4767-9d00-29432411f0cc}GAI Ref Program Type.fields.{4c3d4dd0-1f33-4086-9aee-27a44d619e83}programTypeId', null ) ) ), local!refGrantorProjActivities: rule!GAI_getRefGrantorProjectActivity(fkProgramTypeId: local!yaProgTypeId, ).data, local!metricTotal:rule!GAI_Add

Hi! I´m trying to do the following query with the "query database" smart service: UPDATE CPF_LINEAS_PEDIDOSET FACTURADA = true where ID_PEDIDO = ac!pedido and MATERIAL = ac!Material The variable ac!Material can be multiple (f.example Material 1, Material 2). This is because in a previous step in the process model, the user can enter several rows. Because of using a list of string in the clause "WHERE" (I´m using it as a filter), I think I´m returning the following error: How can I fix this? Thanks a lot!

Hi! I have created a process model in which the user can add new rows.  I´m saving the value of the different materials (pv!Record....material) in a process Variable ("MaterialesDefi") In this pick, you can see the value adquired and saved in the process variable. In this case: zz;vv The fact is that I want to use this materials in a WHERE clause (SQL syntax),and it is not working. Even though I tried to use a function like SUBSTITUTE() when assigning the value, trying to substitute the ; for the ",", the result of the pv is always the same I know that to use it in a where clause, I must use the operator "in" and also the string should be (string1,string2). But I haven´t managed to do so, the value of the pv! remains like untouchable What can I do?

I need to make a gridLayout with several fields per row, in which the row number is what I indicate with a local variable, so that when saving in a rule input I can update what is already in it with what I add to the call the interface for the second time initialized again so that it does not show what is already there.I thought I could use the id of the GridRowLayout to identify each row, but it doesn't take it, and starts the rows at id = 1.Has something similar happened to anyone?

What are the features that can be obtained to use Appian in the cloud and "on premise"? My company is partner. Thank you.

Hi! I have created the following editable grid: Appart from the fields shown in the editable grid, I would like to create for each row a CONCAT() from two fields (idPedido, Material), BUT NOT SHOW IT IN THE EDITABLE GRID, only saving it into my local variable  I´ve tried with the following code but when I try to add a new row an error appears: fv!item not detected (line 189). Is my approach of trying to save it in the append correct? In case it is correct, how can I fix the code and the fv!item? If not, which is the best way to save it in the local variable or another way? Thanks a lot! a!localVariables( local!LineasPedido: {}, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!

Hello, I need to configure a schedular which should run Monthly on first Monday. I'm not getting what to configure in month field. Please can anyone help me. Thank you.

Hi! I have an editable grid in which the user can add new rows. I have a problem with the field "Clave Única". Its value is the concat() function of other two fields of each row 1) It appears correctly written in the editable grid  2) It seems not to be flowing correctly to my local variable What can I do to fix this? Is my code wrong? My code is below (line 60 is where I configure the value and saveInto for the field): a!localVariables( local!LineasPedido: {}, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"),

How to append time constant to today's date so that I can compare it with now() which is of datetime type?

Hello, I want to implement schedular in start node which will run Monthly on 1st Monday. How to implement it and want value should be passed to month field. Thank you.

Hello team, I tried to set up user input task reassignment via escalation following this logic: 1. I have a User Input task which is assigned to a group called "Processors". 2. The escalation is set up as recurring every 1 hour     2.1 If the user input task was not accepted by anyone from processors group members nothing will happen     2.2 If the user input task was accepted (owner is not null) then the timer will fire and in 5 minutes it will reassign the task back to processors queue I have set it up following way, but when the timer conditions are not met, the task is paused by exception and nobody is able to access it. Any advice there please? Thanks Timer conditions, where if the owner is not null it will return true(), if it is null (so not accepted) it will return false(). c10 represents the Owner column pv!contract.contracId is the identificator for the specific task not( rule!GBL_isBlankOrEmpty( index( a!queryProcessAnalytics(

Hi! I´m trying to plan an approach for my application and I would like to hear your recommendations In my case, I have a record of Purchase Orders (PO) and Purchase Order Lines (POL) In my summary view for each PO, I can see the header data (PO) and the lines (POL) as it is shown in the image below: Now, I would like to use a button to "receipt" the PO lines. A pop-up should appear, with the same purchase order lines (the table from the record POL), and I want an extra column for the user to write the quantity and do different checks. I was thinking about using a related record action, connected to a process model with an user input task as the start form. The user input task should use an interface with an editable grid which has THE SAME VALUES of the PO lines (like, by default), and then I can add the new column in the interface I don´t know if my approach is correct or if is there a better way to re-use the same read-only grid and transform it into a table wi

The pagination element in Appian in HTML code is composed of two <span> tags. One of those <span> elements contains the aria-describedby attribute, and I need to remove it as there are duplications in the tag's content. How could I address this issue?

Hello, I've encountered an issue with an Appian form where a text field disappears when I try to fill another one. I've checked for visibility rules, read-only settings, and browser compatibility, but the problem persists. Has anyone else faced a similar issue, and if so, how did you resolve it? Any insights or troubleshooting tips would be greatly appreciated. Thank you!"

We are having embedded interface experience where in the interface we are trying to use the startprocesslink() on the hit of a button. We are facing issue of passing parameters when calling the interface in the startprocesslink() due to embedded interface experience.  Hope any one has faced similar issue and how you were able to resolve this issue

Hi, I'm having difficulty finding the best approach to updating a list of checkbox options on a parent record using related record associations. Essentially, I am exploring the ability to save multiple selections (child rows) on the "create" of a new record and ability to "update" those persisted selections through an update process. I have a simple example expressed below through the use of local variables for clarity but hoping a few insights will help me understand how to apply at a recordType level with related record data. The content related to post# 22489 was very helpful but not fully understanding how we can add new items and also remove (inactivate the unselected items). The end result would be the use of a checkbox or multipledropdown field where a user can add new rows (isActive: true()) by selecting and unselect saved rows (set isActive: false()) to write back to the record table. Sample code:a!localVariables( local!s

Hello, I have an Interface. Within this interface user uploads excel file containing some emails. Next user submits excel and process model is started.  Interface is published on a website.  When user uploads excel and clicks submit interface looks exactly the same, no message if the process was successful or anything. I would like to create new popup window or some message when user submits and run process with uploaded excel.  I tried using onSuccess but it didn't work. Do you have any tips?  My code looks like this:  a!localVariables( local!cancel, local!WczytanePlik, local!NazwaPliku, local!Pracownicy: if( a!isNullOrEmpty(local!WczytanePlik), {}, rule!EA_TEST(local!WczytanePlik) ), a!formLayout( label: "Wczytaj plik", contents: { a!sectionLayout( contents: { a!textField( label: "Nazwa pliku", labelPosition: "ABOVE", instructions: "Wprowadź nazwÄ™ pliku",

HI Team I have a scenario , where I have to read User login logs daily and save into database. Solution: > I have created a process model to run in a scheduled manner i.e, daily once , In that I have used readcsvlog( "login-audit.csv." ) It is working fine when i debug process model. Issue: when the process model triggers in scheduled manner, it is unable to read csv file. Getting empty data Please feel free to advice any solutions