Process Automation

Hi, I have a question, I need to evaluate two dates, one I have already solved, the one I have solved is like this: I have a date, and I have to validate with a boolean that must receive a data from 3 months to here, if it is more than 3 months, it is already an invalid date, but the part that I have not solved is, that I mark an invalid date from tomorrow. I have compared it with an or, but it gives me true, I have this code, and it returns a true if( local!tipoComprobante = "INVOICE", a!localVariables( local!extraeFecha: substitute(right(local!fechaRecibida, 9), " ", "-"), local!mes: rule!months(month:extract(local!extraeFecha, "-")), local!fechaValida: concat(local!mes, "/", left(local!extraeFecha, 2), "/", "20", right(local!extraeFecha, 2)), or( today() <= edate(local!fechaValida,3), today()+1>local!fechaValida) ), false ) this code block is inside an if, could I get some suggestions? my local variable

Hi all, Is there a way or a plug-in that allow us to expose some appian functions? Let me explain the scenario: We have an application that is highly configurable, at some point we need to give a group of more experienced users the ability to be able to assign certain values to certain fields, besides being able to assign static values "1", "2", "3", "TEST", "EXAMPLE","OK" ,etc (for say something), we want to give them the ability to use functions to calculate differently the values using functios like Sum(), AVG(), etc. or for calculations with dates AddDays(X), today(), etc. Is there any way to expose those functions that we use in SAIL in some way to the end user? Thanks in advance for your help

a!gridColumn( label: "Conformance", sortField: "adherence", value: a!richTextDisplayField( label: "Adherence", value: { a!richTextItem( text: if( rule!INO_isBlank(fv!row.adherence), "-", fixed(fv!row.adherence, 2) & "%"/*text(fv!row.adherence /100, "##.##%")*/ ), link: a!dynamicLink( value: fv!row.employee, saveInto: { ri!selectedEmployee, a!save(ri!selectedEmployeeRow, fv!identifier) }, showWhen: and( and( not(isnull(ri!showDynamicLinks)), ri!showDynamicLinks ), fv!row.adherence 0, not(or(fv!row.employee.isTeamLead)) ) ),

"I've been providing the correct file path to the 'Open Excel File' action in Appian for a robotic task, yet I keep receiving an error indicating an incorrect filepath. Has anyone else run into this problem? I'd be grateful for any advice on how to troubleshoot and resolve this error."

Hi All, We have a scenario to extract data from PDF. In interface we have a screen to upload file and on submit starting a process using a!start process to extract data from that file. It is working fine from developer mode. when we add that screen to site document is not passing to that process, we are getting error like invalid content ID. Thank you. Priyanka

Hi everyone, i wanted to learn rpa so working on some poc, i have taken a simple example where i am logging into some website doing search and try to fetch the search result into process variable. i got the following error. what is the solution for this error?

Hi all, I have on-Premise environment and cloud environment where RWM ( Robotic Workforce Manager ) Application is installed in Cloud environment. I want to trigger/start RPA Task which is there in RWM Application from On-Premise. Can anyone help me on the steps. Thanks in advance.

In paragraph text , I want email validationtest1@gmail.comtest2@gmail.comtest3@gmail.comtest@test,com---(error)I would like to have email validation in such a way that it should accept only email like test@gmail.com ,only gmail.com mails it should validate and if it doesn't have gmail.com at the end then throw error at the line( @test.com in our case )

100 people standing in a circle in an order 1 to 100. No. 1 has a sword. He kills the next person (i.e. No. 2) and gives the sword to the next (i.e. No. 3). All people do the same until only 1 survives. Which number survives at the last? There are 100 people starting from 1 to 100.  can anyone please tell me how can i do it?

Hi all, I am trying to extract a data from PDF using the new AI SKILL feature. Attaching the screenshot of my PDF and Process Model. The Output is a stored in a CDT with the same field and name. This service does not give any data after execution and it takes 5 minutes of time for a simple process with 1 node. Kindly advice how to proceed.

Hello team, I would like to ask you for an advice. In my tool there is one User Input Task which is assigned to a group "Processors". The users of this group accept the task and complete it. I set up an "Escalation" to reassign the task back to queue if some of the processors forget to complete it.   My problem is that in some cases, I cant really explain why, the task is not released and its owner remains still the user who accept it. So I created a flow for business administrators who can reassign a task to somebody else from the pool using the "Reassign Task" smart service in Process model. But even if we select the "ICH Processors" as a group to assign the task back, the owner of the task will not change and the task will be not available to accept it. Any advice please on how to resolve this? How to change the owner correctly? Thanks

Hello, I've been training a document extraction AI Skill in one region and then deployed the AI Skill to a different region. Interestingly, I'm finding that the document extraction in the first region performs better than the document extraction in the newer region. Do AI skills have to be retrained in each region, like when you deploy from TEST to PROD? Thanks!

How to get the duplicates from an array: i/p:{1,2,2,3,3}o/p:{2,3}

I am testing the new version of appian and the AI ​​elements, specifically when I create an extraction model for an invoice, the document appears like this and I cannot map the data correctly. Does anyone know why?

Hello All, Is there a way to know which IDP version installed on my environment? I can see that the application was imported on the  7/8/2020. But other than that, I don't have anything else. Thanks for all the help! Akshar

Hi!I'm trying to filter out record where field 'value' is null, but it only gives the record of the first item, here's the code local!validValues:ri!properties[where(a!isNotNullOrEmpty(ri!properties['recordType!{5ebb976a-556f-4033-b1d7-9e5976ab963d}MM Property.fields.{041a7f43-dfd1-4b07-aaed-48e305712f4e}value']))], Any inputs? Thank you

Hello team, in my application for reporting i use a!exportDataStoreEntityToExcel smart service to download Excel report based on the filters selected. This part is working great. As a new requirement i need to limit the access, the users will be able to download report only for contracts which they created / they approved from sender side / they approved from receiver side. The way i tried to achieve this is to create an expression rule to query the entity, make queries with 3 different filters (when user is created, approver on sender side, approver on receiver side), save the results into 3 separate local variables, combine them into the final local variable which will be then used as the entity parameter in the excel smart service. But i am not able to cast it to proper format, all the time i receive an error message: Could not cast from ICH_V_ContractLineItemsReportCSV to Data Store Entity. Details: CastInvalid. Example: local!variable1: cast( 'type!{urn:com:appian:typ

Hi  I have created a constant for storing all the valid file extensions  constant : OPP_TXT_VALID_FILE_EXTENSION  -> {"PDF", "JPEG", "JPG", "PNG", "DOCX", "DOC", "XLSX", "XLS", "CSV", "TXT"}  Now I wanted to implement a validation in fileUploadField wherein I want to check for valid file extensions. For this I am using the contains function  contains ( cons!OPP_TXT_VALID_FILE_EXTENSIONS, upper(fv!files.extension) ) Now even for a valid file extension (say PNG) this validation fails But if I use normal array of hardcoded values instead of constant then I am getting the desired result contains( {"PDF", "JPEG", "JPG", "PNG", "DOCX", "DOC", "XLSX", "XLS", "CSV", "TXT"}, upper(fv!files.extension) )    Is there something that I am missing ?

Hello there, We need to update an Appian Portal based report (old technology previous to SAIL based reports) that displays multiple process instances. Many of them (around 3000) have incorrect security settings and need to be updated. What is the simplest way to do it? Is it possible to use Appian RPA for it? The solution requires to select each individual entry in the report and change the security settings. It is just a couple of clicks to resolve it but it needs to be done thousands of times. Is it possible to do it through a process model? Any idea would be appreciated. Thank you in advance!

For the automated expression rule testing, currently test results expire after 7 days (as mentioned in the documentation for function a!testRunResultForId). Is this a configuration that can be changed? We can to decrease the retention period to perform an aggressive clean up for this data. 

Hi there, There is a section in the PDF file, like below: Is there a way to capture these "checkbox" by using AI skill extraction objects? If the PDF file is protected by password due to the security, would it affect the performance of AI skill extraction? Any suggestion would be really appreciated. 

Hi All, We are facing below issue when we run the browser template bot in the virtual mechine. But, it is working fine on local mechine. not able to find the solution. Please help  us to fix the issue.  Please find the error details below [DEBUG] 2021-09-23 21:28:45 01s (0h) - Using default module Chrome options[WARN] 2021-09-23 21:29:05 21s (0h) - Driver could not be initialized: Timed out waiting for driver server to start.Build info: version: 'unknown', revision: 'unknown', time: 'unknown'System info: host: '#####', ip: '##.##.##.##', os.name: 'Windows 10', os.arch: 'amd64', os.version: '10.0', java.version: '1.8.0_271'Driver info: driver.version: ChromeDriver

As soon as I type the first character in Appian's Chat-GPT box, the red "Invalid Search String" error displays below, and nothing I type in makes it go away

Hi All, I am having two times saves in 2 variables  Eg: 1)  2/5/2023 9:00 AM GMT+05:30.  2)   2/5/2023 8:00 PM GMT+05:30 now my ask is what function we should use in order to get the output like output : 11 hrs or in minuts and also same for dates  Thank you 

Hi! I´m creating a rule expression to return a value based on the logged in user, and use this value in an interface. In this case, I want to return the value "Proveedor 2" and show it in the interface. But the problem is that, when I try to reference the rule as a local variable, the following is shown. My local variable configuration is: I think the problem is in the test output of my expression rule. When I put it in raw format, the same text which appears in the interface is show (I just want "Proveedor 2"): 1)Image of expression Rule 2) Expression rule output in various formats In this case, I would like to extract just the "Proveedor 2" output. How can I do this?