Discussion Categories

I am using the Export SQL To Excel smart service (plug-in) and need to have a link to the summary view in the excel sheet generated by the smart service for all the respective values in the "Record ID" column. How to implement this?

Title:Appian Plugin Deploys Successfully but No Modules Appear in Admin Console (Expression Function) Question: Hello everyone, I am developing a simple Appian expression function plugin using Java and Maven in Spring Tool Suite (STS) for Appian 24.1 On-Prem. The plugin deploys successfully in Admin Console, but the Modules column is empty, so the function does not appear in the Expression Editor and cannot be used in an Expression Rule. What I have done so far: Created a simple Java class: package com.example; import com.appiancorp.suiteapi.expression.annotations.Function; import com.appiancorp.suiteapi.expression.annotations.Parameter; public class HelloPlugin { @Function public static String hello(@Parameter String name) { return "Hello " + name + " from plugin"; } } Created appian-plugin.xml: <appian-plugin key="hello-plugin" name="Hello Plugin" description="S

Hi Team,Is there way to get all the tables structure present in the appian db. I mean DDL queries for the all the tables present in Appian.Just exploring if this is possible or not, If there is a way to export all tables structure for creating them.Thanks in advance.

Hi, I've found in an existing code application this function called with 5 parameters (please see below). But the Appian documentation says that the Property function must have 3 parameters only. This code works, but throw an error in Design mode (exactly like the "if" function which can take more than 3 parameters).  How would you replace this code ? with additional if conditions ?  property(  local!availabilityResponse,  "body",  "resources",  "type",  null)Regards

Hi All, I have self joined Record type. Write records plugin, smartservice both are getting successful, but persisted records are not  getting sync. Even though I manually sync, the data is not reflecting. See below What could be the root cause? Thanks Madhu

We have a dynamic array containing lists of data. Dynamic here meaning data1, data2..etc could be any length. We need a screen that allows users to reorder this data and we are attempting to do this with a gridLayout with allowRowReordering = true. When attempting this example below, we are seeing the error Expression evaluation error at function a!gridLayout [line 15]: A grid layout component [label="data1"] has an invalid value for "rowOrderData". The value must be a list of records, a list of maps, or a list of dictionaries. a!localVariables( local!map: { "data1", "data2" }, local!data: { data1: { { sortOrder: 1, label: "A" }, { sortOrder: 2, label: "B" } }, data2: { { sortOrder: 1, label: "C" }, { sortOrder: 2, label: "D" } } }, a!forEach( items: local!map, expression: a!gridLayout( label: fv!item, headerCells: { a!gridLayoutHeaderCell(label: "Checklist Sections") }, rows: a!

Hey Folks, I am using an excel tools plugin for converting HTML to CSV. Now, there is a new requirement for converting PDF to CSV, and walking through the discussions and searches I haven't found any good match or solution. Can anyone help me with this? It would be highly appreciated.

Hello, Im using the Smart Service Merge PDF and Im trying to use a record were I saved the documents (CO Documents). Im having trouble to put the existing document and Documents. Can someone help me?

Hello All, I have a requirement where user can open the ui and redirects to the url that was mentioned in the ui and can change the data in the new tab.After changing the data. we are giving an buttonwidget in the ui to refresh a variable to know whether data had changed or not. It returns true or false based on the actions done in the different tab. But the problem I am seeing button is not working as expected. Below is the codea!buttonWidget( label: "REFRESH", value:ri!refresh, saveInto: { a!save( ri!refresh, rule!SD_IsDataChanged( )id:ri!id ) },On the above i am getting the data from the database to check data is updated or not and storing in the refresh variable. the problem here is first when user clicked on the refresh , refresh variable is storing the expected value. but later if i change the data and click on the button again it still having the same value. i doubt whether button save is working or not beacuse when i open the actual rule its giving the correct boo

can we configure human task where api kicks appian process which ahs doc extraction ai skill in case doc extraction fails

I am trying to create a personal account, but I am receiving an error saying that an account already exists. I forgot my password, and when I try to use the “Forgot Password” option, I am not receiving any reset link to my personal email ID. Should I create a support ticket to resolve this issue?

First of all, AI Doc Center is fantastic (3.1.3 installed).  Love the way it is easy to set up and version classification and extraction, so much right out of the box. I think I'm missing something in the documentation though on AIA Extraction Instance's status in a 'real' extraction. I see some constants in the AIA app and can infer in a different app that a status of 2 or 4 means a particular thing that might send me to my custom interface for reconciliation of the instance, which in turn would trigger a model to save to data fabric if reconciled and not abandoned / canceled by an end user.  But, I'm getting off track... I guess I'm asking what is the best practice to see the AIA Extraction Instance's notion that accuracy / precision / validation rule fail on an extraction would drive the decision to send a custom user reconcile task.  At the moment, I would be cobbling together a big 'Or' to see if any reconciliation should be

Hey all, new Appian developer here! From what I have learned so far, Appian dev teams don't usually follow the branch->merge workflow, but rather work inside the single dev environment. I have no problems with this system and think it is the ideal approach for 99% of cases. However, in a situation like a refactor, where you are changing some of the architecture and breaking a few parts of the system as a side effect, I can see how branching off to make these changes would be safer, cleaner, and not prohibit other developers who need to use the parts that are being changed.Is there any version control (or hacky workaround) that could solve this in these rare situations? Thanks!

Hi Team, I am working with the documentsChatField in Appian. After uploading a document, I want to pass it to the chat field for verification. If the verification is successful, I need to save the document details in the database. Could you please guide me on how to achieve this? Is it possible to trigger document verification immediately after upload and then conditionally persist the document metadata based on the verification result?

We recently upgraded to version 25.4 yet we can't find the Agent Studio or option to build new AI Agents in Appian Designer. Is there any additional permission /configuration needed to enable this object type? 

We display the groups a user belongs to in a read-only grid, and the data appears correctly in the UI. However, when a basic user exports the data using the default record export, the group names are not visible in the exported file.

I requested the transfer of my credentials, Community and Academy achievements, Academy historical training data, and Community activity history a couple of days ago. However, the transfer has not yet been completed. Typically, this process is finished within two working days, but it seems to be taking longer than expected. Could you please let me know how much additional time it will take? Also, is there a toll-free number I can contact for assistance? Additionally, I would like to know whether it is okay to leave the organization before the transfer of my credentials, Community and Academy achievements, Academy historical training data, and Community activity history is completed. If so, how can I continue to receive communications that are currently being sent to my organization email after I leave? Is there a way to update my email ID in the community profile so that all future communications can be redirected to my personal email address? Could someone please assist me with this?

Hi everyone, I’m working on an interface where the user needs to upload an Excel file with the .xlsx extension. My goal is to validate the file extension directly in the interface, before enabling the "ACCEPT" button. In my current setup, I’m using the disabled parameter of the a!buttonWidget() to check two things: That the variable local!excel is not null or empty. That the uploaded file name (converted to string) contains the .xlsx extension, which I have defined in a constant (cons!CEDT_CONS_EXTENSIONES_DOCUMENTOS). When I use touniformstring(local!excel), it only returns the file ID (a numeric value), not the original file name. Because of that, I can’t compare it with the extension constant to validate the file type. Here I’m attaching a demonstration of the interface when I upload a file that is not an Excel type.  Is there any way to retrieve the original file name (or its extension) from the uploaded file in the interface, so I

I am having two Signature Documents. i want to compare both the documents and i have to return the matching score percentage of how similar two of the signatures.

Hello All, Below is the code snippet from Ruby. Digest::SHA256.base64digest('') I need to generate the same in Appian and pass it to the integration header parameter, please let me know if anyone has done this before. Thank You, Sneha.

We’re experiencing recurring high memory usage in our Appian Cloud DEV environment that is leading to emergency restarts. This typically occurs outside of normal development hours, when there is little to no active user activity. As part of troubleshooting, we have: Cleared all processes that had stopped due to exceptions Removed older versions of process models and interfaces Reviewed for obvious runaway process instances Reviewed guidance in KB-2011 Despite this cleanup, the memory spikes continue. Has anyone encountered similar behavior in a DEV environment with low user activity? If so: Were scheduled processes, integrations, or unattended background jobs the root cause? Are there specific logs or metrics in Appian Cloud that are most helpful for identifying memory drivers? Does exporting and removing older, inactive applications from DEV meaningfully reduce memory consumption, or is memory primarily driven by actively executing objects? Any guidance on deep

Hi Team, I’m unable to see the new Appian 26.1 release in my Appian Academy learning environment. It still shows the older version, and the new release content isn’t appearing for me. Has anyone else faced this issue? Could someone check and let me know if the release is available on your side, or if there’s something I need to do to get it updated? Thanks in advance!

Hi  I'm currently exploring Case Management and wanted to check with the community whether it's possible to use Google Mail (Gmail) to set up case creation via email. If this is supported, could you please share any guides or documentation on how to configure it? In the documentation I reviewed, it seems that case creation via email is mentioned only for Microsoft email (Outlook). I would like to confirm whether Gmail can also be used for this purpose and what the recommended approach would be. Thanks  Rahul Gundu

I need to add more than 10 quick filters to the report, but the option is disabled. Is there a way to add more filters?

I am using a read-only grid to show data for reports. I need to export the data to excel but the grid has more than 50 columns. I have already tried default export to excel feature and a!exportDataStoreEntityToExcel() function but none of these worked. FYI: Data is in SQL. Appian version is 23.2. Columns cannot be merged or it's count can't be reduced Is there any way I can export the data to excel?