Discussion Categories

I'm trying to simulate a double-click-like behavior in a read-only grid using a!gridField_24r3. The goal is to return a selected row's value when a user clicks on a field grid value twice. I am able to save the value of the grid after selecting it for the very first time by using fv!deselectedRows. Refer below code:a!save( local!previousSelectedRow, if( length(local!currentSelectedRow) = 0, index(fv!deselectedRows, 1, null), local!previousSelectedRow ) ) Now within the parameter "selectionvalue" of a!gridField_24r3, I am trying to manipulate the value it holds with below logic where I put a condition if there is no selection made --> ri!selected will be empty but we have a value store within local!previousSelectedrow then we should get the id of that grid returned. if( a!isNotNullOrEmpty(ri!selected), ri!selected, if( a

Hello, I'm trying to generate a dynamic table in docx. But unfortunately, I'm getting an empty table. Attached below are the screenshots and the XML data that i'm passing. XML Text -  "<find><irish control='Control1' observation='Observ' risk='Risk' /><irish control='Control2' observation='Observ2' risk='Risk2' /><irish control='test control' observation='test observation' risk='test risk data 4365475' /></find>" Template -  Result -  Could you please let me know what am i doing wrong here?

Hi All, My requirement is if any error comesup then it has to redirect to the same interface to modify the form and then resubmit the form again . IN the 2nd interface (which is same as 1st) I'm getting the below error .can someone please help.An error occurred while evaluating expression: Error.message:AC!error.body (Invalid index: Cannot index property 'body' of type Text into type IntegrationError) (Data Outputs)

Hi everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8], I have a scenario to use ReadExcelByHeaders.  But it is throwing me an error:Expression evaluation error at function 'readexcelbyheaders' [line 3]: java.lang.NullPointerException: Cannot invoke "java.util.Map.entrySet()" because "expectedHeaders" is null

First Scenario: I have created a "GET" web API in Appian Community Edition and called it through a integration from another Appian environment, but I receive body in the "HTML" format instead of Json and receiving below error. Second Scenario:Whereas, When I create it other way around like creating web API in other Appian environment and calling it from Appian community Edition returns a proper Json value in the response body. Why I am receiving "HTML" value in response body in First Scenario, it is like Appian community Edition doesn't support web APIs?

Looking for an Appian tutor to get me over the hump for senior by next friday. Was close on first attempt. Please reply if interested. 

I have main data store entity that comes from CDT, in this CDT has 2 related CDT's. I am currently trying to delete from main data store entity to then have impacts on the related ones. When I made a process model that takes user input that then results in "delete from data store entities" node to delete, it was working for a few unique identifiers before not working anymore. It has ConstraintViolation as the error that it's giving. I am just trying to clear all of the data that are within my DSE's but keep the structure there.

I am sending an email attached with excel sheet to process model vai Receive Email at start node. I could able to extract the excel from email but the data is not written in the database.FYI: Using Plugin Import Excel to Database, Using CDT 

We have some Appian administrator users who, when they try to access process supervision, edit the process, and try to change a value in a node, do not see all the tabs and cannot change anything. For all other administrator users, it displays correctly. At first glance, it seems that both have the same groups, but we don't understand why the tabs don't appear. We are probably missing some groups, but we thought that an administrator could do everything.  Is that right? Thank you very much for your help.

"RUN EXTRACTION" button is not visible on AI Document Center, after creating an Extraction Model. Why?

"RUN EXTRACTION" button is not visible on AI Document Center, after creating an Extraction Model. Why?

Hi All, What would you all recommend for implementing a confirmation page after a form is submitted ? another user form ? The only concern I have is that once my user submits the form is a subprocess creating multiple instances (as we need). So basically for the confirmation page we need something along the lines this # of items were created in the system, even better if we can give the ids of the created items. Any suggestions for a good design implementation? Thanks in advance

Can someone please explain what are major pros and cons of process driven and  db driven task and in which use case we should consider db driven and process driven approach.

Hi, We have an excel file in shared network drive (x drive) which we need to update as per some business logic in Appian. We dont need the file to be stored in Appian. Is there any way (eg. plug-in function / smart service / connected system), through which we can update the remote excel file? Thanks, Sudip

a!localVariables( local!bookinfo: if( a!isNotNullOrEmpty( ri!Lms_issuebook['recordType!{01e3b0e9-0572-442f-afd0-5278d2e5255e}LMS_books_issue.fields.{550c5ea8-8a07-4a21-9693-209c159c6319}bookId'] ), a!queryRecordType( recordType: 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK', fields: { 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.fields.{92b7d831-6d1e-4319-941c-66d2c1b49a9f}author', 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.fields.{39d871be-ff6b-43bc-8200-4f5764212db4}availableCopies', 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.relationships.{23c62a5c-04db-4f30-89f0-4ccc4bb61a47}lmsGenre.fields.{d2da18ac-f795-482a-99d8-914552162ac1}value' }, filters: a!queryFilter( field: 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.fields.{8a72e153-4658-455c-a313-dc3d895c5ed3}bookId', operator: "=", value: ri!Lms_issuebook['recordType!{01e3b0e9-0572-442f-afd0-5278d2e5255e}LMS

We have some fields with extra long text type in our records. Seems only 3 fields are allowed with extra long text data type and we had 4 fields. We assume this warning is coming because of the recent upgrade. Its showing warning that only 3 fields can have extra long text and its not allowing us to add any column. And we are unable to change datatype from extra long to text from record side. I changed the column from text to varchar in db side but still getting this error. Please let us know how to resolve this issue.

We are trying to enter a decimal number into a!floatingPointField and storing it in Number(Decimal) field. Since it is a decimal we are trying to save it using rounddown(value, 2) so as to allow only 2 decimals according to our requirement. Note: This functionality is being used in editable grids. While doing so, for certain fields we are getting random numbers keep appearing after the decimal for the numbers. (47.3 shows as 47.3000000004, etc.). This is happening only for that particular row for only a specific value i.e in the example 47.30 only will show 47.3000000004, if we enter 47.322445 it will round down to 47.32. We tried using, round(), roundup(), rounddown() and floor(). SInce we have mutliple grids in the same fashion, this issue seems to appear in atleast 1 grid row.

I need to Show Error Message for the user in the User interface when process on create record action fails. Currently it just says 'Action completed' whether the process is success or failure. User is unable to know if the record is successfully created or not.

Hi Everyone, I 'm getting above error for the below code. a!dropdownField( label: "Is Under Header", placeholder: "Select", /*required: ri!questions[ri!index].questionType<>cons!RIDCO_QUESTION_TYPES[11],*/ disabled: index( ri!questions[ri!index], "questionType", {} ) = cons!RIDCO_QUESTION_TYPES[11], choiceLabels: touniformstring(local!headerQuestions), choiceValues: touniformstring(local!headerQuestions), value : touniformstring(index(index(ri!tempQuestions,ri!index,""),"parentQuestionText",{})), local!headerQuestions : returns list of text string

Hi everyone, good day. I’m working with an AI Skill for document extraction in Appian, specifically targeting a structured and standardized document used in Mexico: the Constancia de Situación Fiscal (a tax ID certificate). My goal is to extract the following fields: RFC (tax ID) Business or legal name (Razón Social) Start date of activities List of economic activities (shown as a table in the document) The issue I’m facing is that the AI Skill successfully extracts all the individual fields (RFC, name, start date), but it completely skips the table that contains the economic activities. I’ve already configured the document type, field mappings, and extraction zones where possible — I’ll share screenshots of my current setup below. Has anyone encountered a similar issue with table extraction in structured documents? Any suggestions would be greatly appreciated. Best regards, Víctor Valenzuela

Hi All, What is the difference between calling a synchrous process via Subprocess and Start Process smart service nodes? Is it just that the first runs in the same thread / Appian engine and the latter runs in a separate thread / process to balance the workload? I know that Subprocesses are traditionally used in synchronous settings and are especially helpful when the child process is activity chained, but would it ever make sense to use the Start Process node in a synchronous setting? I've only primarily used Start Process nodes for asynchronous processes. 

Hi All, Please help in understanding or explaining the working of the following code. displayvalue( 5, { 1, 2, 3, 4, 5 }, { "A", "B", "C", "D" }, "Z") In the above sample code, based on it's behavior, ideally, the result should be the default value ("Z" in this case as there is no item in 5th index of 2nd array). But the result I'm getting is "A", the 1st index from the array. Version I'm using is Appian 24.4 Please refer the screenshot attached.

Appian's a!isNotNullOrEmpty funciton does not work for values {null}, {null,null} please find below testcase. code given on community works as expected but not a!isNotNullOrEmpty https://docs.appian.com/suite/help/25.2/fnc_informational_isnotnullorempty.html#replace-if()-and-isnull()-expressions-with-a!isnotnullorempty

Hi Com, I have tried to install RPA Agent in my laptop. However it shows greyed out in the taskbar. I followed the steps mentioned in the documentation-Intalled java 17 Changed system environment variable.My doubt is, if i wish to not opt for enable automatic sign in, i will not select the checkbox. I have directly installed the agent and run on laptop. But it is greyed out.Any other prerequisite that i am missing? is there any other framework or software needed to start the agent?

Hi All,Currently we are having a workflow which consists of a task which will be worked by a user. When any updates to the workflow occur from external system, we cannot show the updates to the user in the UI when user has the UI already open since the data cannot be refreshed. We are thinking of either cancelling and creating a new workflow with the latest updates or completing the task using smart service and recreating the task within the same workflow. Any insights on which will be better approach will be useful.