Discussion Categories

Hi there, I have a scenario where i need to change the display name of a record field value. Is it possible to do that while configuring 'Reporting Record Types' ? ex. my record filed has the value 'SME' but i need to display it as 'Subject Matter Expert' (there is no related table to fetch the expanded value) on the frontend while we display the report. Is it doable in EUR? Thanks in Advance!

Hi, I have a read-only grid that displays real-time data, populated through a local variable from an API. Users have requested an "Export to Excel" button. Is it possible to enable this functionality without storing the data in a database table?

Hii, In my case i have to edit the multiple Dropdown field value: My value is Record type. Eg: [ "Product 1,Product 2"] Choice value  is Array. Eg: ["Product 1","Product 2","Product 3"] the value from my record type is like  :  "Product 1,Product 2". So, value is not matching with choice value. How to resolve this, I tried converting the value to list of text using split but still it is not working.

Hello,  I'm trying to figure out how to integrate an external web site with Appian. I have a JAVA war file that contains JavaScript files. The war was produced by another organization, and I expect to have occasional updates. I have the war hosted and running on its own server. What I would like to do is push a button on an Appian form that launches the web page created in the war. The user then selects different options in the popup and hits submit. The external web site produces an XML string and sends it back to Appian. Appian then displays the processed XML on the form. Later, when the Appian form is completed and submitted, Appian saves the XML to the DB. I've tried using Web Content Field. It displays the button and launches the external web page. I have no idea how to send the XML back to Appian. Web Content Fields don't retrieve data as far as I can tell. I also thought about setting up an Appian Web API for the external site to call and send the data

Is it advisable to do the following on a task script node? It hasn't given me any problems so far. Suppose I have two variables pv!variable1 and pv!variable 2 In my first custom output I have 1+1 saved in my pv!variable1and in my second output I have pv!variable1 + 5 saved in my pv!variable2 . When using the two variables in my outputs, could there be a problem that it does not finish saving or executing correctly?, assuming that it could be a more complex rule, or a query in my first output. My specific question is whether these outputs are executed in sequence, always waiting for the first one for the second to begin.Is there any certainty about the order of execution of the inputs and outputs of a script task?

I want to publish all process models using a single user. Is there an efficient way to publish all of them at once, rather than publishing each one individually?

Hello! I'm getting this error while setting up my integration. I have a couple of integrations in my application that allows users to archive and download documents from a SharePoint and they both use the same connected system that I have in this one. The one I'm showing is for my own testing purposes. I'm using this integration to see if I can retrieve any folder metadata but I keep getting this error. The connected system says it's connected and I'm using Entra ID. My question is am I doing something wrong here or does it look like I have everything set up correctly? Trying to find out if there's something missing on the Appian side of things or if there's something missing on the Azure side.

for a particular record type object getting following error message : Expression evaluation error [evaluation ID = HGT9M] : Could not find driver for MariaDB.since we are using mysql but getting error on MariaDB

Hi, I am using bigint for storing codes, account numbers(as they can go upto 15-20 digits) in SQL. I need to use them in Appian. Is there a way to map tis data?

Hi All,              I'm trying to send email using Appian after submission of a process to either users or functional mailbox based upon the requirement conditions. When email sent to users it is received by the users correctly, whereas when email sent to functional mailbox address there is no error in the send email node but email didn't get received by the functional mailbox. So, request your suggestion on what's the reason for this behavior and how to fix it? Note: i have used toemailaddress function in the To address field of email node configuration. Thanks in Advance, Pradeep.B

Hello, I just started creating the SPX Launch Tracker app and when attempting to create the HTTP Connected System, I enter the name as instructed in the Step 2 of the Build a Low-Code App course, but it the error comes up saying "Name Already Exists". I am unsure when or how the name already exists even the app creation has just started. The SPX Connected System Image is not also coming up.  Any advice is appreciated

HI All , I have ModifiedDt stored in MSSQL Server with DateTime format , when i query the same Date in Appian it shows a slight difference in millisecond . I am guessing Appian round's off this value ? Is this correct ? Does anybody else observed this issue ? Examples below - Database Appian

can we make one user filter dependent on other. For example if we select category user filter then only corresponding sub category values should be shown in sub category user filter.

I'm getting the errorExpression evaluation error at function a!recordActionField [line xxx]: Cannot compare incompatible operands of type Null and type Boolean.I'm not sure why this is occurring.Code: a!gridColumn( value: a!defaultValue( value: ri!recordActions, default: a!recordActionField( actions: { a!recordActionItem( action: relatedAction1, identifier: fv!identifier ), a!recordActionItem( action: relatedAction2, identifier: fv!identifier ), a!recordActionItem( action: relatedAction3, identifier: fv!identifier ), a!recordActionItem( action: relatedAction4, identifier: fv!identifier

We have several Appian applications with records backed read-only grids which our business users can quickly search, filter, page through to access record instance data. One of the main gripes (over the years) with Appian is that while paging and taking an action on a record, the user has to page back through a series of data sets to arrive where the user initially started the action from. Honestly, it's a bit surprised a paging cache feature hasn't made into a default platform offering in Y2024 but would the Appian community be able to provide examples of how we can implement a "cached paging paradigm" to improve user experience. It's definitely a slight annoyance platform-wise but I'd prefer to hear your opinions and implementation thoughts on how best to improve a one-less-click experience.

Hi All, We are looking to grant read-only access to users along with access to monitoring tab. Is there a way to achieve this? Does Appian even allow this? Thanks in advance

While receiving file using smart service "Receive File Over SFTP", I am getting error as "Error copying the remote file to disk. See application server log for more details. Error Message: The message [filename] is not extractable!". It worked fist time and from 2nd time I am getting error. Also I tried next day but still getting same error. I am using plugin "SFTP Smart Services" with version 2.2.1. Can you please suggest solution on this? 

I'm looking to configure a filter in a!queryRecordType() that's similar to checking for null values on the outer side of a relationship that behaves like an outer join. For example, I have a data structure as described below. The table Invoices is managed by an Appian application and we have a synced record type based on that table. The table SAP Documents is updated by an external source and we have another synced record type based on that table. There is a many-to-one relationship configured in our record type from Invoices.SAP_DOCUMENT_ID to SAP Documents.SAP_DOCUMENT_ID. Invoices ID (PK) a bunch of other fields SAP_DOCUMENT_ID (FK) SAP Documents SAP_DOCUMENT_ID (PK) a bunch of other fields I need to query the Invoice records and return those where there is a value in Invoices.SAP_DOCUMENT_ID and where there is no corresponding row in SAP Documents - and I need to combine this with some other query filters, so this is not the only co

Currently we have a site that has several pages at the top in the Header bar. However, one user is unable to see these pages unless they are in incognito mode indicating this is not a permissions issue on Appian's end but a chrome setting that must be hiding these tabs.  We tried opening the site in both chrome and edge and both fail to load the site pages. The whole Navigation bar shows up for that user including the Logo, we are just unable to see the site pages at the top. I am Creating a post to see if anyone knows of this issue and a potential fix?  Thank-you so much for your time. 

what is the main difference and what to use where

When we execute the API Endpoint to load the data in DB, we get Generic Error Message " 500 There was an error writing to the data store"  Is there a way to capture the Actual Error message and Return it as a message instead of the above? Example:  Details: javax.persistence.PersistenceException: org.hibernate.PropertyValueException: not-null property references a null or transient value Following is the code :onError: a!httpResponse(statusCode: 500,headers: {a!httpHeader(name: "Content-Type", value: "application/json")},body: a!toJson({error: "There was an error writing to the data store"}))

How to convert Unicode characters to emojis. Our process saves the emojis to Cloud DB as "utf8mb4_general_ci". I want to show them as emojis on the richTextFieldWithTables

Hi I am using PDF from single Docx ( with fonts ) to generate PDF from a docx document. Everything is working fine, i.e. the pdf is generated and can be opened. But there is 1 small issue wherein the generated pdf  document is not showing bold characters. I have also attached the Arial Bold TTF file to the smart service ( since all my text is in Arial ) but still there seems to be difficulty in displaying bold characters Docx Document containing bold characters  Generated PDF  If you see the table heading as well as table column headings are not in bold in the pdf but the word doc seems to have bold text  Can anyone please help me to get the text bold ?

Hi  I am using PDF from single Docx ( with fonts ) to generate PDF from a docx document. Everything is working fine, i.e. the pdf is generated and can be opened. But there is 1 small issue wherein the generated pdf  document is not showing bold characters. I have also attached the Arial Bold TTF file to the smart service ( since all my text is in Arial ) but still there seems to be difficulty in displaying bold characters Docx Document containing bold characters  Generated PDF  If you see the table heading as well as table column headings are not in bold in the pdf but the word doc seems to have bold text   Can anyone please help me to get the text bold ?

Hi I am using the PDF from Single Docx ( With Fonts ) Smart service to convert my docx file to PDF. Everything is working fine, my document is getting generated and all, but there is one issue i.e I am not able to display text in bold even though the docx have the text in bold. I tried including the Arial Bold ttf font file to the smart service, but it doesn't seem to work ( I had attached arial bold file because my entire contents in the docx file is in Arial font and I have made some parts of it bold )  Docx File with bold text :  The generated pdf :  If you see the heading of the table as well as table column headings are not bold  Can anyone help me understand how to make the text bold ?