Discussion Categories

Hii,   I have created a read only gird and added my record. So, now I would like to use record action for multiple rows at a same time. Eg. I my grid for now I could able to approve only one row at a time , but now I need to approve them Bulk.

Integration returns: HTTP/1.1 302 Date: Wed, 04 Jan 2023 16:05:55 GMTServer: Apache/2.4.41 (Win64) OpenSSL/1.1.1cX-Content-Type-Options: nosniffX-XSS-Protection: 1; mode=blockLocation: /MyWeb/CreateNoteContent-Length: 0Set-Cookie: MYSESSIONID=ABCXYZ123456; Path=/MyWeb; HttpOnlyVia: 1.1 myserver.dev.comKeep-Alive: timeout=5, max=100Connection: Keep-Alive I want to cal this integration via a link or a button from an appian interface.

I would like to rename the source field name for a field in one of my record types ('source field name' is the field in the database table, holding the record type). In the record type, screen Data Model > Configure Fields, I am allowed to change the record field name (the field name visible in Appian), but the source field name is readonly! In this particular case, I would like to change "workzonecaseid" to "WORKZONE_SAGS_NR": Here's the current situation in MariaDB:

Hello Team, Please, can you confirm if the service_manager.conf file generated in one server will be copied across other server nodes in a load balance setup as highlighted here --> https://docs.appian.com/suite/help/22.3/High_Availability_and_Distributed_Installations.html. The documentation states : As part of a distributed installation, it is a requirement to copy the service_manager.conf file located in /services/conf/ across all machines in the distributed environment, for it is necessary to enable authorized connections to the service manager and the engines across machines. Since running the password script will generate unique password for each server; will a service_manager.conf file generated on one server work for other servers in the load balance setup? Also, will I run the password script on all servers in the load balance setup? Your prompt response will be highly appreciated. Thanks

I want to create a date filter with the following options. 1. This month 2. Previous month 3. This Year 4. previous Year.

Hi, I have created an interface where I am tracking some details which even has a Links column so I have created a paragraph/text field to receive the user's inputs (External URL links), now after the links are inserted, submitted, and saved. I am showing them up on a Record view using the links field > a!safeLink. If one link is updated by a user then it's okay its working fine and opens the window in a new tab see image 1: But if a user is updating more than 1 link then it's not differentiating between multiple links and assuming the entire entry as a single link, I tried using commas, semi color between links but nothing is working, see below: Could someone please help me with this? Best, Mohammed Khaiserulla

Hi in my project there is a requirement to read the polled email data. I used the Poll Email plugin to poll the mail in to the folder. The body is polled with a .EML file extension. The body of the mail is unstructured and I need to poll the body in text format in to a table. Any suggestions??

How to configure smart service "Load CSV File To Database" in process model ?

The team is using the automated import plugin to perform database upgrades. Flyway produces logs that the team can retrieve by pressing the link on the information page that appears after the deployment. Is it possible to retrieve the logs at a later time?

Hi Everyone, I have the requirement where the excel file is to be read by IDP. But I am not sure if IDP can extract data from excel file. Can anyone please help me out if it is possible through IDP or any other alternatives? Thanks, Shubham

how i will use Any type datatype

Plzz suggest me the alternate of getdatasubsetdownloadlinkfromrule

Hi Gurus, The Appian documentation (https://docs.appian.com/suite/help/22.4/record-type-relationships.html )states: If you use a process model to delete a Customer from the database table, any Orders referencing that Customer would have an invalid foreign key. Therefore, the database will either cause the delete operation to fail and nothing will be deleted, or it will delete both the Customer and all Orders associated with that Customer. If the delete operation fails, no sync is needed because data has not changed. If it succeeds, Appian will immediately sync the deletions from both record types. We defined a one to many relationship in the record type and a cascading delete in the database (mariadb) however data in the Orders table is not synced, do I miss something here? Btw not having a cascading delete in the database leaves the Orders records orphaned. Any ideas?

I'm using pp!id of a process instance value as orderId field for my db, As I  thought it is unique for all process instances, but when I checked It was not. I was wondering is it really unique?

Hi community, I have a PPT document, is there any way to convert it into PDF file ? Even converting to DOCS would be fine then I can convert DOCS into PDF easily. Thanks

I am creating a Summery View based on a record with multiple one to one relationships that I want to use to display data in the view as well. However, I can't get the data to show up in the view by just referencing the relationship (although the relationships, and their associated fields, do show up as options when selecting the record field to be used). I can use a!queryRecordType to successfully access the data, but I don't want to have to make a query for each relationship if I can avoid it, since there are about 24 relationships and that would probably have an impact on the performance. I have created a local variable that just tries to call data from a relationship, but all it returns is null. When I change it to call data from the source record it work perfectly. I have also verified that there is data in the row being called, and the relationship works properly when used in the record type (shown in the second image). Below is the local variable that is mentioned above,

Hello, Anyone know how this can be achieved? docs.appian.com/.../High_Availability_and_Distributed_Installations.html Shared files The following directories must be shared across all servers that run that component. All servers that run the given component need both read and write access to these directories. omponent Name Folder Name Application Server APPIAN_HOME/_admin/accdocs1/ Application Server APPIAN_HOME/_admin/accdocs2/ Application Server APPIAN_HOME/_admin/accdocs3/

It's a new year, and your last chance to take the Appian Developer Productivity Survey! Please consider taking 5 minutes to tell Appian product managers which feature are speeding you up, which areas of the platform are still tripping you up, and more! 

Hi Team,When I am trying to edit record type > Edit Record List>Image Columns.Below steps:the Image column by following the steps below: ● Under Columns, click Image. ● Under Display Value, click Display Options. ● Select Document Image. ●Under Display Value, click Image. ● Under Images, click Document Image. ● Under Document, click a!EXAMPLE_DOCUMENT_IMAGE(), and clear everything in the Expression Editor. ● Enter the expression: if(isnull(fv!row[recordType!AX Vehicle.fields.vehicleImage]), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row[recordType!AX Vehicle.fields.vehicleImage]) Getting below error: Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 55]: Invalid Content IDDue to this error record type is not loading, if i am not adding image column

I'm  trying to store array of files in database since it does not picks blob as a datatype any work around would be much appreciated.

I am creating a bar chart with two measures: GST and TotalBill. If I use normal stacking both the values get on top of each other. like if GST = 20 and TotalBill = 100  then the bar length will be 120 as shown in the attached image. But I want the bar length to be 100 and GST measure inside that.

Hi Team, I have built an application in Appian. In my interface, I make a tab called comments. When a user is giving any link(e.g:- www.google.com) on the comment. it is coming as an plain text. There is no hover or hyperlink on it. How to keep a hover on a link automatically? Could you please suggest?

Hello, I am not able to view the summary view for a record type (Rental Customer) I checked the security for record type and interface for summary view, still it is not visible What could be the reason? Could someone please help me

I am new to Appian and I am evaluating the Appian RPA. I have already completed "Appian Robotic Process Automation (RPA): Learn to Develop Bots" course. I want to learn the process automation using Appain RPA so could you please suggest any course with detailed explanation? Thanks in Advance!!!

Hi, when I try to store dictionary as a custom id in a grid row layout, the system throws 500, what can I do?