Discussion Categories

I want to calculate cycle time -difference between received date and closed date in days which includes only business days Exclude weekends and public holidays  Using recordtype-new custom record field I wanna to achieve as I need to use in process hq reports Thanks, Priyadharshini. S

I want to calculate cycle time -difference between received date and closed date in days which includes only business days Exclude weekends and public holidays Thanks, Priyadharshini. S

Hi Everyone, I am facing an issue with isUserPasswordValid() of the Credential Management plugin. It’s not working for me and is always returning false, even for a valid username and password. Is it working for anyone else? I am using an Appian Cloud environment. Please share your inputs. Thanks!

Hi, my use case is I want to provide an excel template for users to download and fill out. Some of the information the user is filling out is dependent on data in a ref table that updates occasionally, so before the user downloads the document, I run Export Data Store Entity to Excel smart service in a process to update the document, so when the user downloads the document, it'll have the most updated ref data. Here's the issue I'm running into - the excel template has two sheets: - Sheet 1 is where the user fills out info. This sheet has data validation rules to make it more user friendly, most notably vlookup functions and data validation dropdowns that pull from Sheet 2 - Sheet 2 is where the ref data lives, and what the Export Data Store Entity smart service updates However, after the smart services runs, the excel template that gets generate has no data validations - no dropdowns or excel functions. I'm imagining even though I'm only having the smart service up

After upgrading version of SFTP Plugin to 4.1.1 and using SFTP Send File new smart service file permission issue is occuring.Note - Previous we were using Send File Over SFTP (Basic Credential).Please provide the information why it is occuring this is on priority for me

Hi all,I am trying to open tomcat log file from system logs. But I am getting Error 403 - forbidden. Your request could not be processed. Can anyone let me know what might be the reason for this issue??TIA

Hi, Im trying to filter the daterange,when I select the date range its automatically displaying the previous date. I have selected 2nd may to 8th may but it is automatically taking the filter as the previous day

We are currently using Appian Case Management Studio (CMGT) as a base application in our organization. On top of this, several separate applications have been built for different business sectors. The issue is that each of these applications appears to be using a copied version of the “My Cases” module rather than extending or reusing the core CMGT “My Cases” functionality. This has resulted in multiple duplicated implementations of essentially the same case listing and interaction layer, each diverging slightly per application. We are trying to understand the best practice for handling this pattern in Appian: How can we properly extend or customize “My Cases” functionality per application while still relying on the same base CMGT module? Is there a recommended approach for reusing the CMGT case views (e.g., configuration, overrides, or parameterized interfaces) instead of duplicating the module? What is the cleanest architecture pattern to avoid mu

Is there any way in Appian to capture the previous state?I have a form with a couple of dop downs where the user selects different assignees for different tasksI want to able to send an email only to the changed users. Is there any way to compare old user values with new ones to see if changes happen?

Hi Community, I have prior experience working as an Appian Developer for about 1 year, and after a career break, I have recently revised the Appian tutorials and refreshed my knowledge. Could you please share some commonly asked Appian interview questions that reflect current industry practices (for example, on record types, queries, process models, activity chaining, and best practices)? This will help me prepare more effectively for upcoming interviews. Thank you in advance for your guidance!

I have a requirement where need to generate the PDF document. if i add text which is more that 4000k then text gets overflow the screen and it comes in single line. How to add a line break so that the text should be in paragraph itself.

Are there any upcoming Appian Dev Days? I've been to a couple in the past. One in NYC and on in Jersey.

Hello everyone, I hope you are doing well. I am currently facing an issue while sending a SOAP request through an Appian Integration. The request body contains a document that must be sent as Base64 inside the XML body. I have been researching possible solutions, and according to the Appian documentation, automatic Base64 conversion only seems to work when using a Data Type (CDT) with automatic XML conversion enabled. However, in my case, the XML structure required by the service contains specific namespaces and a custom structure, so when I tried using a CDT, the generated XML did not match the expected format and the service returned a 500 status code. I also found some plugins that convert documents to Base64, but my requirement is only to convert the document temporarily and send it in the request body. I do not need to store the Base64 value in the database. Another alternative I considered was creating an Appian Web API that returns the Base64 content and then consuming that res

When user logs in using SAML, they face 403 access denied error. We checked the users ID and they have the required access levels. When checked on tomcat-stdout logs we see the following issue 'Cannot request SAML Assertion for SBAF Authorize Click since user is not valid for SBAF'. Any leads on this?

Hi All, I am looking for best way to extract meta data of all documents that exist on an environment. This I need for migration purpose. My requirement is to store document details(document id, doc name, parent folder, kc name etc)  from all over the environment. This would require traversing through each KCs and find folders and documents recursively.  Has anyone faced such requirement and is there a provision for this to be done OOTB or any best way which won't hamper the environment running status. Thanks in advance!

Hi all, We recently upgraded to Appian 26.3. During regression testing using Appian Selenium API, our scripts are failing while reading grid data. The getGridContents() function is not able to read the grid label, although it is able to read the rows and columns. The same script works as expected in Appian 25.4. Has anyone else faced this issue? I would appreciate any inputs or insights. FYI, our libraries are up to date. Thanks in advance.

Okay, I have a process flow that goes like this: a person enters an interface to reassign a case, maps the emails, etc. Then they enter a synchronous subprocess that connects to an API. Depending on the validation (whether the user clicked "assign" or "reassign"), an asynchronous process runs that sends an email notifying them that the case has been reassigned. The requirement is that after this is done, the user returns to the main screen. The flow works when the email isn't involved, but when the email is, even though it's asynchronous, the activity chaining breaks. Could you help me find a solution for this, or suggest other options? Thanks!

Hi all, Seeking some help, our current Fitnesse for Appian implementation has been signing into our application via credentials entered in a SetUp wiki page - | login with username | fitnesse.user | and password | examplePassword | This works as expected and allows the automation user to sign in. I am trying to switch to using the provided configs/users.properties file to sign in with a key/value pair, however the password never ends up getting retrieved from the configs/users.properties file? # Users used for | login with username | fitnesse.user | fitnesse.user=examplePassword | login with username | fitnesse.user | As you can see, the result of our setup script is as follows (and it stops here) Site is on 25.4 using SAML, Fitnesse for Appian version 23.4 Fitnesse start.bat script is:  java -jar lib/fitnesse-20230503-standalone.jar -p 8980 -e 0 -f configs/custom.properties Has anyone experienced this same problem and been able to resolve it?

How to disable all the remaining checkboxes while we select one checkbox in Editable grid ?

Our client has transitioned from Microsoft to Google Workspace and no longer provides Microsoft licenses, meaning end users can no longer open the .xlsx files generated by our current Excel Tools v2.10 implementation. We need to convert our data export functionality to a format native to Google so users can access their reports without needing Excel. What is the recommended workaround to replace the Excel tools plugin smart service? We are looking for an alternative that avoids physical Excel files entirely to ensure a seamless experience for our users.

I have a document generation use case in Appian where I maintain a Request table and a separate Letter table that supports multiple versions of documents per request. For each letter version, I store selected template components such as header and footer (single selection) and multiple paragraphs, which are mapped through a separate association table to maintain order. These templates are stored in reference tables and contain placeholders in the format [placeholderName], which can appear anywhere within the text. In the first task, users select the required header, footer, paragraphs, and optional sections like privacy policy or guarantee content, and those selections are saved against the letter record. In the second task, based on the selected template content, I combine all the text and  for each placeholder I need to fetch values from different data sources (for example, customer name from a customer table, address from another table, sender details from a user table, etc.),

Hi, I am using Query database smart service in the Process model to get the data from the external data source which is in DataMart. Due to some access restriction, we were not able access external database. So, we have added the source in the admin console, and we are using it in smart service. I am getting 1000 rows of data, and I am storing it in a Process variable which is of CDT type. I want to fetch all the rows like I have more than 4000 rows of data. But I am able to fetch only 1000 rows. Is there any way to fetch all the rows. This is my current configuration. We need to display the data in an interface grid which will be viewed in Site

We are facing an issue with Process Upgrade and CDT versioning in active process instances. Context We have a process model that contains a process variable of type Comentarios. Recently, we added a new field to the Comentarios CDT. As a result: Existing/running process instances still have the process variable using an older CDT version, for example Comentarios^4. New process instances use the latest version of the Comentarios CDT. We are trying to upgrade the old running process instances to the latest process model version using the Process Upgrade approach / Upgrade Processes From Version smart service. Problem The upgrade fails because the source process instances have the process variable using Comentarios^4, while the target process model has the same process variable using the latest Comentarios CDT version. The error indicates that the process upgrade is not compatible because the CDT type/version is different. From the official Process Upgrade documentation, I understand th

How to control drone through Appian?

 Expression evaluation error at function a!isNullOrEmpty parameter 1 ???null???: Invalid index: Cannot index property 'x' of type Text into type List of Variant.   This error is faced by user when opening record action. This is only faced by a specific user. when I open the same request, I am not getting this error. Also in design error log only highlights the process which calls the interface. This error looks very high level and not highlighting the object name clearly. Does anyone faced any similar kind of issue? Please let me know if there is way to debug this.