Discussion Categories

I have tried to use the AI skill to extract info from pdf. But I notice that the speed of the AI skill is too slow. A doc like this. It takes 5 minutes to execute such a simple document. Is there anyway I can increase the execution speed? Is this because my model is not trained enough? Should I trained my model more?  

i have a store procedure where it has 13 different columns retrieved from 20 different tables i need to get user a link on single click to export data to Excel , and also if possible matched data should  be bold in the excel

Within the Appian interface, the date field typically accepts dates separated by a forward slash ("/"). However, in our use case, there are scenarios where we need to support dates separated by a hyphen ("-") or a pipe ("|"). To accommodate this requirement, I’ve written the following piece of code a!localVariables( local!onlyNumbers: cleanwith("1.22.1957", "1234567890"), local!length: len(local!onlyNumbers), if(local!length = 8, concat(left(local!onlyNumbers, 2), "/", mid(local!onlyNumbers, 3, 2), "/", right(local!onlyNumbers, 4)), if(local!length = 7, concat("0", left(local!onlyNumbers, 1), "/", mid(local!onlyNumbers, 2, 2), "/", right(local!onlyNumbers, 4)), null ) )) It seems that the Appian interface is not executing the logic as expected, and the error still persists.

I'm hearing that Appian does not accept passwords that are 22 characters long. What is the maximum length for the password of an Appian user account? Is this published officially anywhere?  (I did not see it on the Administration Console documentation page.) Thank you.

HI all  I have a record for sum insured values let's say he below: id: Primary Key (QuoteID) riskType1SumInsured: Aggregate field of all RiskType1 sum insureds riskType2SumInsured: Aggregate field of all RiskType2 sum insureds riskType3SumInsured: Aggregate field of all RiskType3 sum insureds totalSumInsured: a!customFieldSum(riskType1SumInsured, riskType2SumInsured,riskType3SumInsured )  When all the risk type 1,2 and 3 sum insured values have a value (Not Null) the totalSumInsured works correctly, however as soon as one or many of the risk type 1,2 and 3 sum insured values are null, the totalSumInsured simply returns a null. I have tried wrapping the risk type 1,2 and 3 sum insured values in the a!customFieldSum(), with a!defaultValue() as well is a!isnullOrEmpty(), but no change in behaviour. Is there something i am missing?

In my application I need to configure the approval task for multiple approvers in parallel. I m thinking to configure MNI for the process to assign the task to approvers. Scenario is let's say I have 3 approvers and if two approvers approves and one reject it then the request need to be reassigned to the initiator. It should move forward only if all the approvers are approved.. How to achieve this in appian. And also for approving I need to use the esign which is integrated in another application. Should I just to call that interface object or do I need to integrate that application in my application?

Hello, I am trying to implement a custompickerField, but I still don't understand very well how the suggestFunction and selectedLabels work since I have my DP_addressSugestion rule that receives the address and through the Google Maps API it already returns the filtering. Here is my suggestFunction. a!localVariables( local!addressSugestion: rule!DP_AddressGoogleMaps( address: ri!address, latitud: -9.5, longitud: -75 ), if( local!addressSugestion.success, a!localVariables( local!labels: a!forEach( items: local!addressSugestion.result.places, expression: index(fv!item, "description", null) ), local!values: a!forEach( items: local!addressSugestion.result.places, expression: index(fv!item, "description", null) ), a!dataSubset( data: local!labels, identifiers: local!values, ) ), a!dataSubset( data: {}, identifiers: {}, totalCount: 0 ) ) ) Pleas

a!documentViewerField This function specifically, I have gotten it to work, by displaying a PDF file through creation of constants and inserting documents etc. However, my issue with this is that, though it works well on Desktop/Laptop, the additional features such as scrolling, printing, saving the document, editing, annotation, fit to window, rotate, search, functions are not available on Mobile/Tablet devices. Minimally, I want to allow my users to scroll up and down, why am I unable to do so?

Hi, Our client has an Appian process (triggered by a daily batch job) that exports all the data from around fifty tables.The plugin used for this is: "MySQL Dump To Document".Since we've upgraded to Appian 25.3, the plugin is now deprecated, and the latter process is failing in error.*** Error: "Error creating MySQL Dump to Appian Document"What new plugin alternative could you advise me to use and install ?Otherwise, which native Appian solution could you propose ?Our client needs to deploy a solution in Production in few days, so I have to find a solution. Regards

Hi All, I am trying to quey the view which has 20000 rows. when i apply filter to one of the calculated column which has 0 rows present, queryentity still throws below error.  Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [ELMRISKREDUCTIONLANDINGPAGEVWDT16641], query: [queryentity expression], order by: [[Sort[eucInventoryId asc]]], filters:[(currentReductionStage in TypedValue[it=103,v={Process Re-engineering/Non GFT/ITeSS,}])]) We tried optimizing the view as well, but no luck. Any suggestion would be appreciated.

Hello everyone, I would like to implement a notification bell on an interface, that would show me notifications, similar to the facebook one attached, where if I click on it I see notification messages.I found a link to the post docs.appian.com/.../ux_messages_comments.html but it doesn't suit for my case: I don't want to take up additional space in my interface, nor is it nice in terms of user experience. Thank you very much in advance

I suddenly find when I use Dependents to check the dependents. I can not see any process model in the dependents tree. I also check the other env, they can see it normally. I want to konw why it occurs, is it wrong setting or a bug of Appian. How to fix it. 

I am able to connect to the External API with Postman using the API keys and API secrets and am successful. But when I use the Integration object I get a this error. This request requires authentication but does not specify the type of authentication expected HTTP/1.1 401 Unauthorized We are trying to connect to World Check-One API and wondering if anyone else has ever connected to their API.

Dear all, in the Online course I have the following quesiton: Which of the following use cases likely requires third party integrations? and one of the answer is "You want to automate a business process, such as sending out emails to subscribers." Taking into account online course and also this link (https://docs.appian.com/suite/help/25.3/email-in-appian.html), I understood that an integration is needed to send email in Appian. Instead in the Appian analyst practice exam the answer "You want to automate a business process, such as sending out emails to subscribers." is not correct. Can you please tell me if sending out emails required or not third party integration? Thanks a lot.

I am planning for ACD300 certification so anyone kindly share valid suggestion

Can someone tell me what all options are correct for this question? Which two use-cases would require a third party integration? A customer needs to be able to share document with other Appian users A customer needs to be able to retain and store an extensive number of large, historical documents over a 7 year period A customer needs to collaborate on documents with non-Appian users in real time A customer needs to email copies of documents to non-appian users

I am getting above error, I have a doubt for now I am using record data function to get the data and using it as a source for grid component.  i tried changing source to result to queryrecordtype  instead of recorddata also . so as this message suggest  Do I need to directly reference the recordtype in the data field of grid component?

In the interface user has privilege to upload the excel document, we are using the function readexcelsheetpaging to get the information from the 4th sheet of the uploaded excel. when the user uploads the excel with sheets < 4 expression error is shown. Is there a way to check the number of sheets in the excel uploaded  before passing it to readexcelsheetpaging function?

When I want to use a plugin like pdftools. Is there anyway I can read the document of the plugin. I want to know the behavior and function of each nodes' Inputs and outputs, and the available value of the inputs and outputs.

Hi  Can I have some plugins for the following requirement, We need to offer the user to import a CSV file and once the user uploads the file, we need to parse the data in the file and show it on a grid below. CSV file is going to follow a template with defined set of columns, the number of rows alone would vary. 

Hi I want to export an excel sheet from a process model where its cells will be coloured according to its value. How will i do it?

Dear all, I'm studying for Appian Certified Analyst and I'm having some difficulties to understand different responsabilities between Product Owner and Business analyst. I'm studying on Online course ("Initiate and Buil for Appian analyst") and Appian Community documentation and I understood that Product Owner is responsible for creating the product blacklog and prioritaziong user stories in the product backlog. Also the Product Owner represent the needs of the business. Instead the Business Analyst has the responsbailities to create user stories, create personas, "HELP product owner to convert the needs of the business into actionable blacklog items". But If I try to answer to some Test Question in Online Appian Courses I found that "Prioritizing the backlog" is one of responsibilities of the business analyst in the Initiate phase. Can you please help me to understand this? thanks a lot.

I have a requirement where users upload a CSV file, and I need to validate whether the column headers match a predefined template before parsing it into a CDT. Is there a way in Appian to check headers during file upload, preferably before running readcsvlogtoCDT()?

I've been having headaches with dates in Appian and I think it has to do with the way appian handles timezones.  Unless I'm mistaken, appian is supposed to record dates in GMT then then later read them in whatever local time zone is appropriate. What I'm finding is that it records in the local time zone, then later reads it as though it were GMT and adjusts to the local time zone, resulting in incorrect dates.  The more frustrating thing about this is how I access/display the date affects what gets shown.  For example if I use a date picker, appian records the date as 4 hours earlier. Thus 8/8/2025 will be recorded in the db as 8/7/2025 8:00 pm EDT If I display the date in a text field, I'll get 8/7/2025 8:00 pm EDT, but if I put it through any kind of function such as text() to format what it looks like it'll come out as 8/8/2025.  What's worse is I imported a csv of a bunch of legacy data and the dates were all converted to date/time a

a!localVariables( local!transaction: index( rule!NW_getTransactionDataFromKongAPI(transactionId: ri!transactionId), 1, {} ), { a!cardLayout( contents: { a!richTextDisplayField( value: { a!richTextItem( text: cons!NW_TXT_QUICK_ACTION_CASE_TYPE_UPDATE_SUITABILITY_STATUS, color: cons!NW_COLOR_WHITE, size: "MEDIUM_PLUS", style: "STRONG" ) } ) }, height: "EXTRA_SHORT", style: cons!NW_COLOR_PRIMARY, marginBelow: "STANDARD" ), a!cardLayout( contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Suitability Status", labelPosition: "ADJACENT", required: true(), placeholder: "------Select Suitability Status from the below List----",