Discussion Categories

Hi, I am having an issue where if I log out of an environment and log back in again, the screen I am presented with is tempo as opposed to the site page that I have configured in the user start pages section of the admin console. There are no other pages (tempo included) configured in the admin console except for the one that I want. I have tried removing all users from the tempo users group but that does nothing. This is happening for all users. I don't know of any other way to configure user start pages other than the tab in the admin console. Does anyone know anything about this and any way to fix it? It is going to be an issue for end users in a live system where we do not use tempo at all. Many thanks

Hi Team, I’m encountering an issue while uploading a file as part of the integration. The upload works fine for PDF files, but when I try with a .rtf.gz file, I receive a 403 Forbidden error. Interestingly, when I upload the same file to the same URL using Postman, it works without any problem. Could someone please look into this integration issue and help me resolve it? Thanks in advance.

Hi,  I want my alphanumeric field with the below condition. if the text is asdf45 I want the output total as 10 digits with Zero's in the front. How can I do that? When I try doing text(asd45,"0000000000") --> this is not considering the strings present.Thanks!

Hi, I am using Appian Version 25.4, I have created an Interface with Grid in it. Grid is just expected to read data from Record Type and display it on the Grid. But I only see headers on Interface when I am previewing it. What am I doing wrong here? I am including code here and the output of the Preview. I am new to Appian and appreciate your help here. { a!localVariables( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 20 ), a!gridField( label: "Portfolio", labelPosition: "ABOVE", data: a!queryRecordType( recordType: 'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated', fields:{ 'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{85555feb-8c36-4fce-9eff-2ef66aaab755}loanId', 'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{c4b7627c-131b-475a-8901-54d34623f0

Hi, I am managing an Appian app across multiple environments and need to monitor licensing usage. I need to be able to identify users who have not logged in the past 90 days and need to do this analysis by user group. However, I cannot find any 'Last Login Date' field anywhere. Interested to know how other people have approached this. One very manual solution would be to process the audit log file daily to compute and maintain manually a 'Last Login Date' field, but I am hoping to find a more elegant/sustainable solution. Additionally, the audit log file does not indicate the user group(s). How can I include / Where can I find this information? Thanks for your suggestion. Much appreciated!

Hello, We have recently upgraded to 25.4 version. The deprecated plugin 'Execute Stored procedure' is removed, and Appian inbuilt function is used to execute the stored procedure to load the data in cloud DB. However, the node is failing with error - Query execution was interrupted (max_statement_time exceeded). Kindly help what is missing and if the 25.4 version has any specific config to set the max statement time. On some of the node receiving following error - ORA-01013: user requested cancel of current operation https://docs.oracle.com/error-help/db/ora-01013/. The node configuration is same in both the cases. Regards, Nirupama

I have a editable grid.  I have to select only one row at a time.  Based on the selected identifier, I am displaying another grid in the side.  How can I select only one row at a time?

I am getting below error in a node where export CSV "Export data store entity to csv" we are using to export from view. I have checked the view performance ( which is good) and the table data its having only 3800 rows . I am not able to find out the reason of failure as this error is not captured in the tomcat.stdout log. Error accessing data store entity: OutputView. Please contact a system administrator for additional details. (APNX-1-4505-026) Any pointer to check any other thing which I have not think of will be helpfull.  

No warning or error message is displayed when the user uploads a file containing duplicate advisor code and Line of business. I need validation message when I am uploading more than 1 entry with same data. that is if the excel consists same line of business and advisor code then I need this validation messagea!forEach(items: local!constructData,expression: if(count(index(fv!item[local!constructData.advisorCode],wherecontains(fv!item[local!constructData.lineOfBusiness],tostring(local!constructData)))) > 1,"Duplicate Line of business",null)),

Can we modify "search term" in excel after downloading to custom text?

No warning or error message is displayed when the user uploads a file containing duplicate advisor code and Line of business. I need validation message when I am uploading more than 1 entry with same data. a!forEach( items: local!constructData, expression: if( count( index( fv!item[local!constructData.advisorCode], wherecontains( fv!item[local!constructData.lineOfBusiness], tostring(local!constructData) ) ) ) > 1, "Duplicate Line of business", null ) ),

Hi all, I’m using AI Document Center (AIDC) extraction models in a process to save extracted data to the database, and I’ve run into an inconsistent behavior between two models. Scenario A user uploads a document into my application. I save that document into an application folder. I send the document to an AIDC extraction model. After extraction, I delete the uploaded document from my application (using standard document deletion so it’s removed from Appian). Observed behavior For Extraction Model A, the Extraction Instance record has: sourceDocumentId = 46852 documentId = 46856 I delete the document my app knows about (46852). I can still open the Extraction Instance and reconcile without errors, which suggests AIDC is using documentId (46856), not sourceDocumentId. For Extraction Model B, the Extraction Instance record has: sourceDocumentId = 46908 documentId = 46908 (same value) When I delete the document fro

Hi all, I am using the AI Doc center version 2.9. I am trying to extract invoices with single and multiple line items. There is a field called service code, which needs to be a list of string. In the extraction details, I have given an options rule, which returns a list of string values, based on the type of invoice.  The prompt for this field is: " This should be selected from the values in the options. This value should be null if it is a dental receipt.  Please ensure you return a text value. When it is a single value, please ensure you return a single text value." The extraction is working fine when there are multiple line items in the receipt. If it is a single line item, the value is extracted as {"[value:Chiro-Init", "spanId:99492f14]"}. I need the value to be "Chiro-Init". Due to this, the extraction summary page is displaying the error: "A rich text item or rich text list item in a rich text display component [l

Hello everyone, Is anyone else having a problem with extremely slow file uploading process using the a!fileUploadField component in a form? It literally takes 30+ seconds to upload a 4kb text file. During the uploading, it completely freezes my browser instance. I can't access any other tabs.  Is there a solution?

Hi Everyone, I was trying to explore Appian integration with Gemini to summarize document, email and chatbot interface. If anyone did this either with or without plugin,  let me know the details in brief how you achieved it. Also, did you faced any limitations? (PS: Specifically needed to integrate with Gemini)

Getting this error using a!documentsChatField when a basic user is accessing it on the interface. Users have access to relevant groups but not able to access the document chatbot. Is there any AI specific group that the user should have access to?

Earn the Integrations Skill Badge to demonstrate your ability to build and configure integrations, including web APIs, connected systems, authentication, and security. This badge is intended for developers with an Associate Developer certification and at least 6 months of hands-on Appian project experience. The exam is based on the Integrations (Senior Developer) learning path and Appian Documentation resources.Skill Badges allow you to showcase your expertise to the Appian Community through short, topic-focused exams on Academy Online. These exams are free, non-proctored, and a great way to highlight your skills. More information about skill badges here.Enroll here!Questions? Please reach out to academyonline@appian.com.

If I run extraction again and again for same document, still confidence score is same for that field. If confidence score is greater than threshold, want to skip reconciliation and map the details. How will confidence score improve for a field in document extraction in docCenter? 

Hi Team, Below is my code snippet, i hope i have handled the null but still am getting. can you please guide where it went wrong. local!salesReps:index(rule!GSE_SCL_QRY_getViewIntakeDetails( region:local!region, sipYear:local!year, pagingInfo:a!pagingInfo(1,-1) ).data,"Name",null), local!repChoice:{union(local!salesReps,local!salesReps)}, local!salesRepName: if(a!isNullOrEmpty(local!repChoice),"None","All reps"), a!multipleDropdownField( label:"Sales rep name", choiceLabels: if(a!isNullOrEmpty(local!repChoice), {"No reps"}, {"All reps",local!repChoice}, ), choiceValues: if(a!isNullOrEmpty(local!repChoice), {"None"}, {"All reps",local!repChoice}, ), value:local!salesRepName, saveInto: local!salesRepName )

Hi all, I’m trying to handle failures from the Send E-Mail smart service (e.g. network) in a more user-friendly way. My goal is to display an interface showing the error and its corresponding resolution whenever the email fails, instead of having the process instance suspended. Currently: When the Send E-Mail smart service fails, the process model is suspended. I attempted to: Use a Timer Exception on the Send E-Mail node Place the Send E-Mail node inside a subprocess and handle the exception from the parent model However, both approaches do not work as expected because the subprocess itself becomes suspended when the Send E-Mail smart service fails. Is there any supported way to: Catch or handle Send E-Mail failures (e.g. network issues) without suspending the process, or Route the flow to a failure interface after retries are exhausted? Any guidance or recommended patterns would be greatly appreciated. Thanks in advance!

Hi, We are experiencing slowness in processes calling other processes using start process smart service asynchronously. Its taking 1-4 seconds in some cases just to invoke the process using start process smart service. Has anyone experienced this kind of a behavior while using start process. Regards, Vikrant Bhardwaj.

Hi there, i want to use the a!pickerFieldRecords interface component but I want to control which record fields the user is querying against when typing into this, and I also want the suggestions/selected value to displayed using a custom record field I created which is a concatenation of the two fields I want the user to be able to query against. Is there a way I can do this?

Can the text "This message has been sent by Appian" in an email be removed? What steps are needed to remove the text? Thanks

Hi everyone, To avoid ambiguity: my input is an excel document. The relevant sheet is the first sheet (index 0). In that sheet, the first row is completely empty, and the header starts on row 2 (e.g., A2, B2, …). When I try to read the data with readExcelSheetPaging(), Appian seems to interpret the sheet as empty and I get: List of Variant - 0 items Example Code: a!localVariables( local!excelData: readexcelsheetpaging( excelDocument: ri!excelInputFile, sheetNumber: 0, pagingInfo: a!pagingInfo( startIndex: 2, batchSize: 10 ), stopReadingAtFirstBlankRow: 0 ), local!excelData.data) What I have tried so far: Using the remove() function to remove the first row does not help. The empty row is removed but Appian still returns 0 row, interpretating the sheet as empty. If I modify the respective excel Input file sheet and put any dummy value in "A1", then the exact expression works as expected and returns data from row 2 onwards. In that case, removing/skipping the

Hi Appian folks, I am getting this error on Export SQL to Excel smart service - "The following error was raised by the Export SQL to Excel function:  Name is insufficiently unique". I have configured "Document_name_to_create" on this node by appending now() after the document name i.e. "Document Name " & now(). I understand that this error comes up when document name is not unique, although I have appended now() in the end, the error doesn't seem to resolve. How do I fix this issue?