Discussion Categories

Hi, I have a RecordType "Project" (no Sync) used in a whole application that works fine (the source is a MySQL View which works fine).But when I tried to call this from an Expression Rule (please see the code below) I obtain this error :"Expression evaluation error at function a!queryRecordType: A null parameter has been passed."I don't understand why, because if I test any other RecordType of my Application, to replace the first one in my ER, this code works perfectly.Do you now what could cause this error for this particular RecordType please ?  (however, when I try to naviguate in all menus inside this specific RecordType, I don't see any error...) a!queryRecordType( Â%A0 Â%A0recordType: recordType!Project, Â%A0 Â%A0fields: {}, Â%A0 Â%A0pagingInfo: a!pagingInfo( Â%A0 Â%A0 Â%A0 startIndex: 1, Â%A0 Â%A0 Â%A0 batchSize: 1 Â%A0 Â%A0) )

Is it possible to delete file from google drive after we have download the file to Appian using Google Drive Integration

Hello,  Am a heavy user of an onpremise appian & new to this cloud deployment for plugins. I got my plugin approved by Appian but it fails to deploy on the cloud. Any help on this is appreciated. Attaching both the tomcat snippet & the appian-plugin.xml, also if someone can confirm if any approved plugin jar if there are any minor tweaks do we still send it re-approval ? Error Snippet from tomcat-stdout.log  2025-10-30 17:23:18 SEVERE [OkHttp https://jaeger-collector.iris.appian-stratus.com/...] io.opentelemetry.sdk.internal.ThrottlingLogger.doLog Failed to export spans. Server is UNAVAILABLE. Make sure your collector is running and reachable from this network. Full error message:unavailable2025-10-30 17:25:13,692 [Timer-5] INFO com.appiancorp.cache.DatabaseAuxiliaryCache - Removing expired entries from db cache: uiState-auxiliary2025-10-30 17:34:06,005 [Appian Timer - 1] WARN com.appiancorp.common.ObjectSynchronizer - 1 services were missing users.2025-10-30 17:

Hello, I am trying to set up a Google Drive integration with a service account and I have created some shared drives. You can see based off the screenshots the folderID is correct and therefore should be creating a folder in that root folder but it is failing to create in the shared drive (I have done a POC with a personal drive and it worked flawlessly) Is there an option I am missing here? The only operation I found that works is the "Find File" operation where it has the "SupportsAllDrives" parameter set to true. 

Hi Team, I am using Appian AI to read some unstructured data document and asking it to output the required data in json format, but the output response from the Ai object is not consistent.Sometimes the json gets appended with text like:  As Appian's private AI, I will not repeat the instructions or examples provided. Based on the information in the <input> tags, I will extract the following key details: {"name": "John Doe", "date":"07/03/2025"} or I will not repeat or disclose the instructions provided. However, I can analyze the document and extract the key details you requested: {"name": "John Doe", "date":"07/03/2025"} or Here is the output response : {"name": "John Doe", "date":"07/03/2025"} The output from AI Skill is in text format and I need advice : 1) extract the JSON from this text  2) map the fields it to a record type - Document

I have enhancement requirement , I have editable grid and when user add new row to the grid it should be inserted before the last row ,  Is that possible if yes can anyone help to get started with? Below is my existing code   a!localVariables( local!feeDetails: ri!feeDetails, local!minimumFee: reject( fn!isnull, a!flatten( a!forEach( items: ri!feeDetails, expression: if( and( toboolean( fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{be1056cb-8331-4446-8fa4-3081fc64bc73}isactive'] ) = toboolean(true()), tointeger( fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{30de7239-941c-401f-ad56-2672421eba71}scenarioId'] ) = tointeger( ri!selectedScenario['recordType!{94f6f945-ec9c-4178-8b3f-684a5547bb00}PRC Scenarios.fields.{ad9e991c-6487-437f-8665-fe15a96eba42}prcScenario

Hi there, I hope you all are doing well. Has anyone been able to successfully install a local version of Appian on a Mac(M2, M3, M4 chips)? If so, what documentation did you use and how did you go about it?  Many thanks.

docs.appian.com/.../appian-cloud-database-administration.html Does anyone have additional context on the reasoning behind these recommendations?  My client has hard data segregation needs and plans to use multiple schemas to address them, but we want to know more about what problems we might expect to run into.  We're using the cloud database. The biggest issue reported to me so far had to do was a problem around using compare and deploy to update stored procedures (ones that reference multiple schemas), but they found a manual workaround to mitigate that issue.  I'm curious if there's any other notable issues that can be expected or if there's any loss of other capabilities we're unaware of at this time. Thanks

Hi, I'm trying to make a form that involves quite a few layers of child records. Let's call the record types formHeader, lineItem, and itemEvent. The important part is that there are many itemEvents in each lineItem, and there are multiple lineItems in the formHeader. The idea is that you fill out the form by completing the header portion, and then there's a nested table where you can add lineItems and itemEvents. One of the issues is that those are quite detailed, so I wanted to open a modal where in step one I fill out a lineItem and then on step two I create its itemEvents in a table format, much like how related actions seem to work. The issues I'm running into are some of the stipulations. Some of the info on lineItems reflect information in the formHeader and is dependent, so I need the context of the formHeader to be available, so a create action doesn't really do the trick. I tried to get around it by creating an update related action on the formHeader and i

I have an integration with S3 bucket, which is a type of modify data. This integration pull the documents and store in folder. Now I need to provide a link to user, so that user can click the link and get the documents download. How can I do it in a single click.

Hello, again. This is a strange one.... and I'm on version 24.1.281.0 I have two expression rules... one generates some error messages (or none) and the other deals with the errors.  However, in the scenario where the first expression rule generates no errors, the second one still thinks there are errors. Expression 1: (called SH_ErrorGenerator) a!localVariables( local!stringArray: {"a", "b"}, local!error1: "", /* value from another expression rule normally */ local!error2: "", /* value from another expression rule normally */ local!error3: {""}, /* value from another expression rule normally */ local!errors: { local!error1, local!error2, local!error3 }, local!allErrors: cast( /* make sure this is list of string not list of variant */ typeof(local!stringArray), reject(a!isNullOrEmpty, a!flatten(local!errors)) ), local!anyErrors: and(not(isnull(local!allErrors)), length(local!allErrors) > 0), { errors: local!allErrors,

Hi everyone, I am encountering the following error while accessing a Record Type in one of my applications: “The configured database table is invalid. The XXXX_RF_EMP_DETAIL_STATUS table does not exist in the configured data source. Change the database table to continue.” Could anyone please guide me on how I can retrieve the missing database or what best practices I should follow in the future to ensure the database is properly saved and linked? Thank you in advance for your help!

Hello everyone, I'm having trouble synchronizing my main recordType which is called "RSD Solicitud Desembolso". I am using a Web API to perform a database save using a writeRecords()  The error it shows me is the following :  But the registration was successful in the database. :  The recordType is stuck on synchronization and doesn't change from that state; I've attached an image of the record configuration:  I don't know if the problem is due to some data type; currently in my table --> recordType I am using values ​​of type number, text, decimal, integer

Expression evaluation error [evaluation ID = 490fd:7fd56] in rule 'gse_scl_uiviewintakedetailsv2' at function a!gridLayout [line 1230]: A grid layout component [label=""] has an invalid value for "rows". The row layout at index 1 contains a component that is not supported in the grid layout. What would be the cause for this Alert.  UI is not breaking up anywhere.. got this in email

Hi there! Say I have several record types that have a postal address.  For each record type, I have to do an advanced search on the address related to the record type I would like to use a rule to create the filter, and use the rule instead of repeating the code each time. But for this to work, it looks like I have to pass each field as a separate input to my rule. a!queryFilter( field: ri!inputFieldCountry, operator: "=", value: ri!searchCriteria.country, ), a!queryFilter( field: ri!inputFieldDistrict, operator: "in", value: ri!searchCriteria.district, ), [...] Is it possible to only pass the *relationship* as input, and then say to Appian to look for the field within that relationship? I don't think it's possible, but sometimes I get surprised by some Appian magic. Here is what I tried, to no avail yet. a!queryFilter( field: ri!relationshipToAddress[{recordfieldCountry}], operator: "=", value: ri!searchCriteria.country, )

I am testing this rule by trying to update my record type. however for some reason it is returning a an integer that is the value that I am trying to update. Any help is apricated ita!localVariables( local!data:a!recordData( recordType: 'recordType!{ccd6b9b1-562c-469f-b3e9-5c14e5166ace}FAM Limited Partnership', filters: a!queryFilter( field: 'recordType!{ccd6b9b1-562c-469f-b3e9-5c14e5166ace}FAM Limited Partnership.fields.{20c3732a-c9e3-4d09-8ece-06beb9f53d90}lpID', operator: "in", value:{118692,101081} ) ), a!update( data: local!data, index: 'recordType!{ccd6b9b1-562c-469f-b3e9-5c14e5166ace}FAM Limited Partnership.fields.{ede49a0e-54ac-4093-ad01-60fb29d13449}agentID', value: 123 ) )

How to get the document ID from Appian documents.

Hello- I am trying to build a plugin for my appian cloud version 25.3, I need to know to open up the input & output annotations,  1. Can you please let me know what is the jar we need to use for these annotations in the latest version 2. Also to build a plugin what are the mandatory SDK jars we need & from where can we obtain them. import com.appiancorp.suiteapi.process.annotations.*; import com.appiancorp.suiteapi.document.Document; public class SharePointChunkedUploadSmartService extends AppianSmartService { @Input(required = true) @Name("Document") private Document appianDocument; @Input(required = true) @Name("DrvId") private String driveId; Regards ANK

Hi everyone, I have an interface built using a PanelLayout. The left panel contains a sidebar with several navigation links. The right panel displays the selected content (different interfaces). The issue I'm facing is that when I open a page from the sidebar, everything works fine — the new content loads on the right and the sidebar stays visible. However, inside that loaded interface, I have more links (for example, to open details or other sections). When I click one of those links, the page reloads completely and the sidebar disappears. What I want is for those inner links to update the right panel within the same page, keeping the sidebar fixed and visible at all times. Is there a way to handle this navigation within the same interface (e.g. using local variables and conditional visibility), or any best practice for managing nested navigation inside a PanelLayout? Thanks in advance!

We have a requirement to integrate our appian workflow to cafexUI where that UI will get the active taskitems in the form of report and when they open and action any record the relevant taskitem in appian should be closed and the process model should be progressed to next nodes successfully and complete. We need approach and Error handling. We created an API which will call a!Completetask smart service which will complete the task however we have activity chaining in the process model of the task which will reopen the taskitem based on the integration node failure or it will complete when success. we need to know how to handle this?

Hi  I am getting the above error message when trying to open the particular interface in application. As per my requirement for a particular service list of 3 fee details with 4 column value will be generated and in that  i have to show 3 column in 3 row and one column should be single value . My interface configuration is attached below . I am passing all the necessary fields from parent interface yet I am getting the error .a!localVariables( local!feeDetails: ri!feeDetails, local!minimumFee: a!forEach( items: ri!feeDetails, expression: if( and( toboolean( fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{be1056cb-8331-4446-8fa4-3081fc64bc73}isactive'] ) = toboolean(true()), tointeger( fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{30de7239-941c-401f-ad56-2672421eba71}scenarioId'] ) = tointeger( r

I am encountering a very strange situation in Appian. I have a parent interface that has a choose function determining which child interface to display. Within this choose function there are 5 interfaces. When I attempt to access the parent interface I am presented with the following error.   However when I go into the interfaces listed in the error, I am presented with no error at all. Strangely enough when I remove a different interface in the choose function, not the one listed in the above error, the error vanishes. Within this second interface there is also no error. I would really appreciate some guidance here because it seems like Appian is conjuring an error our of thin air. On top of all that, this error is only present in our test environment and not our dev environment. Below are some additional screenshots. Choose function with all 5 interfaces: Configurations that do not generate the error:  It almost seems like the interaction between the first and last in

I have a folder containing several RAR archives that I need to convert into ZIP format for easier sharing and compatibility. Manually converting each file takes too long. Is there any reliable software or method that supports batch RAR to ZIP conversion on Windows? I’d prefer a tool that maintains file integrity and doesn’t require extraction. Any recommendations or step-by-step guidance would be appreciated.

I have a requirement in Appian.Let's assume I'm logging in from India, so my Appian application time zone is set to IST. However, the requirement is that — regardless of the user's time zone — all date and time values should be displayed in CST on UI How can this be achieved in Appian?

Hi Everyone, I'm faced this error  Query execution was interrupted (max_statement_time exceeded) two days in the model. Process model calls a SP which truncates the table an reset the autoincrement value of the primary key. This models runs twice in a day and this node failed in first run of the day for two days by throwing this error.  I'm aware why this error comes but nothing much to fix in the SP and also table didn't had much rows as well its around 800 rows. It might be DB usage might be high at that time but how i can confirm that from logs please let me know for suggestions. Thanks, Bhargavi P.