Foundation

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"),

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.

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

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, Is it possible to have radio buttons in a grid column of a read only grid?  Thanks in advance

Here is a very rough ERD: Each case has many subcases; each subcase deals with a software and each software has a status  I have a Rule Input "dcmCaseID" that is populated with the parentCaseID for the Case entity.When the query is run, I get data for all the subcases that are linked to the case ID The query looks something like this:a!queryEntity( entity: cons!DSE_SUBCASE, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "case.parentID", operator: "=", value: ri!dcmCaseID ) }, ignoreFiltersWithEmptyValues: false ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ), fetchTotalCount: false ).data, I need to modify the query to return only subcases where the software statusID is null. Using a queryRecordType either breaks the process completely, or returns no subcases at all. Any help will be greatly appreciated! Blessings Stephen

If there is a change of DB, how can we deploy the changes made in DB in the deployment stage

i am trying to update constant with same data type. it shows below error com.appiancorp.suiteapi.knowledge.Community cannot be cast to com.appiancorp.suiteapi.rules.Constant can you provide me the format for updating a constant using screenshots can anyone provide the solution please

Hi! I have created an interface which allows the user to create PO Lines (shown below). The information is saved in a Record Type ("CPF Lineas Pedido"): Additionally, I have a previous interface in which the user fills "global" or "header" PO fields, like the id, supplier, total price, etc. This values are saved in a different record ("CPF Pedidos") In my site, the user can see the record list of CPF Pedidos (the basic fields). And, when they click in one of the PO, a summary view appears with the information of the PO Lines. In order to do this, I added to the summary view a read-only grid, filtering by PO. Now, I would like to bill each PO. For this, I created a related record action "Facturar Pedido", which initiates a process model and has another two interfaces: 1) Interface 1: Header fields of the invoice. The fields of the PO such as the PO identifier, supplier... must appear automatically (extracted from the PO information/ rec

Hi all, I currently have a process model that uses a HTML template to send a list of users, but since my list is saved in a process variable it eliminates any breaks between the names of the users. Write now when I sent the email the list looks like this: name1; name 2; name3; name 4; name5; and so on. But I would like to display the list in a vertical format so is easier to read for the person who is receiving the email. I have tried an expression, scripthml, but nothing seems to work. Does anyone know how can I over come this? maybe editing the template? but I dont think appian lets you iterate over a HTML template.

Hello, I'm preparing to take a certification exam, and I'm struggling to find a use case that would help me better understand functions reduce() and merge(). Can you help a brother out?

Hi All, Is there any way to get the logged-in user's  Site URL? We are using multiple sites in my application and I Just to confirm which Site user is currently logged In. Thanks in Adavance. Regards,

Hi, I am using doc extraction smart service by AI skill to extract the data from pdf , I have multiple files to extract and reconcile . Is there any way to assign all reconcilation tasks in a singel node?

i have date column in database  it holds the values like  01/02/2024 06:29 GMT+00:00 17/03/2023 17:59 GMT+00:00 but i have to fetch only date which is equal to today date how can i achieve that

Hello everyone, I need a bit of help for an accessibility task in Appian. I require a parameter that identifies an element as a <nav> tag and an Aria-label type parameter when viewing the code of the 'Site' in the HTML console. I've tried with parameters like 'accessibilitytext' and 'helptooltip' but it translates to <div> and without that essential parameter, 'Aria-label.' How can I achieve this?

Hi! I was trying to pass a local variable values (editable grid in which you can add several rows) to a process model, so that I can use the Write Records Smart Service At first, I did it this way: But I would like to know how to transfer this and save into my record (probably best way via process model) The entire code is: a!localVariables( local!grid, { 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: "Factura"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"), a!gridLayoutHeaderCell(label: "Precio Unitario"), a!gridLayoutHeaderCell(label: "Cantidad"), a!gridLayoutH

A cancel button has to save one rule input and one local variable value. If we click on the button once only the rule input changes but the local saving happens only after 2 nd click. If we remove the rule input then it is working. But we need both ri and lccal variable to save its respective values at the first click of button. PFA for the code snippet. Help me on the solution a!buttonWidget( label: cons!PHSREC_BTN_LBL_CANCEL, style: "NORMAL", value: 3, saveInto: { local!currentPage, a!save(ri!buttonAction,cons!PHSREC_BUTTON_ACTION[6]) }, validate: false, showWhen: local!currentPage = 1 ),

I have a card layout as below. Can anyone help If there a way for the button to not have that extra space before and after the rich text no matter what magnification or resizing of the screen is shown. a!columnLayout( contents: { a!cardLayout( tooltip: "Only Assigned Status Tasks will be processed", contents: a!richTextDisplayField( align: "CENTER", value: { a!richTextItem( text: "ACCEPT TASKS", color: "ACCENT", style: "STRONG",

Dear Community, Good Afternoon.. I have built a case management app based on a tutorial named "IT Ticket Journey". But, due to some issues, i was unable to create a record. Attached screenshot of the error for your reference Request you to kindly look into this and guide us to a solution and also where i went wrong during this  process ?

Hi all, I'm trying to use a single dropdown list to add multiple users to my grid, right now when I Select one it saves it, but if I select the dropdown again it will overwrite my first selection, how can I over come this? Basically I want to select -> save , select again -> save and so on.

Hi All, Is Spell check is possible in Appian? Regards,Sandeep

Hi All, I'm getting an error when I'm trying to write multiple rows to the database at the same time. When I only give one item to the process variable it works just fine, but when is multiple it throws this error. Details: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table . I have everything correctly set up to accept multiple already, such as the process variable and the write to database smart service. any ideas of what could it be?

I am working on a project where I want to use or() function. While using the or() function I found one bug when you write any word starting with the letter "T" in the or() function you will get a true return and for any other word then "T" returns false. I am adding some images for more clear discussion. in this, I used random words starting with the letter "T" using words other than the "T"