Discussion Categories

if( not(ri!executeWhen), { data: a!dataSubset( startIndex: ri!pagingInfo.startIndex, batchSize: ri!pagingInfo.batchSize, sort: ri!pagingInfo.sort, totalCount: 0, data: {}, identifiers: {} ) }, a!localVariables( local!employeeList: cast( typeof( { 'type!{urn:com:appian:types:INO}INO_employee'() } ), ri!employeeDataSubset.data ), local!staffList: index( local!employeeList, where( a!forEach( items: local!employeeList, expression: and( tointeger(fv!item.designationId) = cons!INO_DESIG_ID_STAFF, ) ) ), {} ), local!employeeIdList: index(local!staffList, "internalEmpId", {}), local!operationsCodeIdList: index(local!staffList, "operationsCodeId", {}), local!dateList: if( isnull(ri!selectedDateList), {}, todatasubset( a!forEach( items: ri!selectedDateList,

Hello, We are installing a freshly new windows appian installation and when trying to generate the temporary licence to finish the setup we get the below licence error :  No k4.lic file exists. Any ideas ? Thank you

I have a requirement where we need to send data from tables to PUB/SUB API in JSON formate . for this i tried fetching data from tables using queryentity then converting data to json .While sending we also converting that data to encodebase64string  and touniformstring . here the issue is we are unable to send large amount of data because encodebase64string has limit on characters . Is there any alternate way  to send data . Thanks,

In the grid there are tag fields for different values, initially the values are null as well. For null, the tag field is not working

i want to create a read only grid with selectable rows. the use case is whenever a user selects a row a modify button comes up the interface and after that with the fields autopopulating from the selected grid values. the user can update the required values and they can be updated into the database. how can i achieve this.

Hello! I wanted to build an Admin Tools section using the Charcoal Scheme. I like it overall, but how can I make objects such as dropdowns follow the theme? It just looks a bit out of place when interface objects are still white, and I can't figure out how to change this.

Hi! I´m trying to make a list of elements (local!ListadoMateriales) to use in a dropdown. To make this list, I´m querying a database (CPF_LineasPedidos) and applying a filter (only materials where the idPedido is equal to the selected in a previous interface) The fact here is that my filter is failing (the value must not be null or empty), I think that the "idPedido" value is not flowing from the process model into my new interface 1. Capture of the code. The ri!recordFact refers to the database in which I have the idPedido This is what I want to do: First interface (idPedido selected): Second Interface (the one I´m editing, referred with the code in the end of the post). I want the list to make a dropdown in the "Material" column values. I add that the values Factura, Pedido and Proveedor are SAVED from the last interface referring them inside the function append (line 206) Thanks a lot! This is my code: a!localVariables( local!Lineas

Hi All, AM facing an unknow issue on send email node. In our lower environments the response body is configured as attached below Deployed the same process model in PROD, but i could see additional html tags are added in response body section as shown below This is not happening in send email nodel where response body in wrapped inside expression. Can anyone suggest why this is happening? I deployed the same PM from dev to test to prod... But prod is showing differently. Thanks in advance

Hi Team, I have a column(Assignees) in a record type, there in the filter I'm thinking to write a logic like below a!queryFilter( field: 'recordType!Record Details.fields.assignees', operator: "=", value: loggedInUser() ), id, Assignee(text) ----------------------- 1, "user1;user2" 2, "user2" if the user1 login, record 1 should be displayed in the grid if the user2 login, record 1,2 should be displayed in the grid

Hello. I created a maintenance interface. When I do releasing, all the link are pointing to this maintenance interface. like interceptor, blocking all the link. How to do ?  Thanks.

Hi all, I have two records: Employees and Managers. Each manager has multiple employees (One to many relationship) Manager table is like this: ID NAME LAST NAME Employees table is like this: ID Manager ID Name Last Name When I'm updating the Manager record I want to be able to edit that manager Id of the employees table, since sometimes some employees might change manager or might not have a manager at all. So first , I'm trying that when the user is updating the manager record when they  click on a dynamic link(icon) on the name of the employees under that specific  manager, they can set that to NULL, so basically make that employee no longer have that manager. What is the best way to reference this if I'm using a rule input of type manager in my interface.

Hi! My process Model gives me the following error: When I searched into the process start form and rule inputs, I viewed the yellow message of the map. I don´t understand what is happening exactly Can someone explain me why is this error caused and what can I do to solve it? Thanks a lot!

Hi! I´m trying to create a dropdown field inside an editable grid, based on a list I have created the following list (the choice labels and choice values appear correctly) But the problem appears when I try to add the dropdown field value:  Interface Definition: Expression evaluation error [evaluation ID = 02S6W] : An error occurred while executing a save: Expression evaluation error: You must specify a variable to save into, such as ri!name << fn!sum. Received: Text. My code is the following (problem located around line 71): a!sectionLayout( label: "LÃ%ADneas Factura", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de factura correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Factura"), a!gridLayoutHeaderCell(label: "Factura"), a!gridLayoutHeaderCell(label: "Pedido"),

Hello, We've been using the MSGraph Mail Poller plugin, which has been running frequently with no issues for a few months now. Over the last couple of weeks, it's been intermittently erroring once a day, this process is ran every 10 minutes.  The node is returning true for errorOccurred but the errorMessage is always either null of 'Error executing this request' with no other information. The node itself is not erroring so the process from an Appian perspective is running as expected.  We've haven't found any errors in the logs or from the mailbox side when it's being polled.  Does anyone have any information on what could be triggering the plugin to error, or any thoughts on a way to find more information?  Thanks!

Hi! I´m having a problem related with data. The data in my record preview does not suit with the data in the cloud database. When compare my site (page created by a record list) and the admin console, it seems to be OK, but the record data preview is not equal. What can be happening? 1. Correct Data (Cloud Database) 2. Correct data (record list page of my site) 3. Incorrect data (the problem is that the second "idPedido" value is one that should not exist, I used it in previous ocasions but was deleted). It should appear idPedido = 2 It seems like the "Data Preview" is saving previous idPedido that were deleted What can I do? Thanks a lot *Extra: I added another row and same occurs. When I click in the table source (record-->data model --> edit data source), it also appears OK, but still wrong in the preview. I uploaded a pic in order to see it in an easy way

Hi, I want to put a condition that text field only accept Hebrew charecter, I tried to find correct regex to validate hebrew text, but did not find. Please suggest where can i find regex for hebrew text or is there any other way to do the same. Thanks & Regards, ShreeKrishna Tiwari 

Hi! I have an editable grid which is filled by the user (possible to add new rows), like in this example: The editable grid values are saved in a Record, and they all have a common field for each grid created (for example, Employee Set 1, even though it is not shown in the example it should be another column) Now, I would like to "copy" the created matrix into a grid in another interface, being able to create new columns but  without the possibility of adding extra-rows (I mean, without the "Add Employee" dynamic link) To be clear, my idea is to re-use the data in another grid, and add a column to identify the data for a new purpose Thanks a lot!

We have various Appian applications, and generally we want all our developers to have view access to each others applications for transparency and knowledge share. Now, I am the developer and owner of an application and I have created a Record Type for an entity, generated the SQL script and database table, and all the process models that allow the manipulation of that data through my Record Type. Effectively my application and it's objects are the "owners" of that data, and should be the only objects allowed to modify the data. How do I stop another developer from simply creating a Record Type in his application, pointing it to my database table, and then using his new Record Type in his application to modify the data in my database tables ? I don't want other developers to simply be able to create applications that can modify data that my application should own and manage.

Hi, I have a question, I need to evaluate two dates, one I have already solved, the one I have solved is like this: I have a date, and I have to validate with a boolean that must receive a data from 3 months to here, if it is more than 3 months, it is already an invalid date, but the part that I have not solved is, that I mark an invalid date from tomorrow. I have compared it with an or, but it gives me true, I have this code, and it returns a true if( local!tipoComprobante = "INVOICE", a!localVariables( local!extraeFecha: substitute(right(local!fechaRecibida, 9), " ", "-"), local!mes: rule!months(month:extract(local!extraeFecha, "-")), local!fechaValida: concat(local!mes, "/", left(local!extraeFecha, 2), "/", "20", right(local!extraeFecha, 2)), or( today() <= edate(local!fechaValida,3), today()+1>local!fechaValida) ), false ) this code block is inside an if, could I get some suggestions? my local variable

I need  to attach more then  10 pages in the site , Is there any alternative way to add more then 10 pages in site

Hi! I created an editable grid in which the user can add new rows. When the user adds a new row, a number is auto-generated (1 for the first row, 2 for the second one, etc).  My problem here is that, when I run it in the process model, the first time I add a row, a number "2" appears by defect. If I delete the created row and add new ones, then it works in a correct way. What can be happening with this default value? How can I correct it? 1. Error when I first add a row 2. After deleting the row and adding new ones, it works properly About my code: 1.Configuration of the first column 2. Function used to auto-generate the values (inside the append function) My code is the following one: 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 d

Hi, We have a particular business requirement, in which large number of documents will be generated on daily basis, and these need to be stored for a relative longer period of time, around 7 years. Which tool can we use to integrate with Appian for storing the generated documents. Please suggest. Regards, Chetana

I have two interfaces. In the first interface, an employee will submit his details. After submitting, it will go to the supervisor interface and if supervisor select need more info option. Supervisor will write in need more info paragraph, it will go back to the first interface. But this time, need more info paragraph  which is in supervisor interface should also display in 1st interface. How can I do that?

Hi All, I have a site which has home page. On Home Page we have a grid populated from Record List, when a user clicks on a record link it takes user to record summary. On record summary, we have record action which opens in the Dialog box. The requirement is that when user clicks on a button on this dialog box, he should be taken back to the Home page in the same window. Is this possible? any workaround or suggestions?

Hi All, Is it possible to have radio buttons in a grid column of a read only grid?  Thanks in advance