General

The input should come from the date field and the output should include the year and the months in decimal. for example: Input 03/05/2016  the output: 6,5. .value: if( a!isNullOrEmpty(ri!dealerBusiness.dateOrganized), null, /*calculate the age of the person*/ int(right(today(), 4)) - ( right(ri!dealerBusiness.dateOrganized, 4) ) ), This what I have so far.

I have a use  case in wich i need to  convert a pdf  to text and extract some  data from it when  i  use a pdf with no hiperlink this takes les than 2 minutes but when i  upload a  document with hiperlink this process could take   more than 12 minutes even if this file contains less pages.

this is the save into code what might be the issue here

Hi, We have an Appian RPA process in place where we are downloading documents in PDF format from a website. However, we have observed an issue where the documents get downloaded in html format instead of PDF having size less than 1kb. As a result of which, further processing of that file gets disrupted and the process fails. Please note that this issue is happening intermittently and only in Production region. For development and test regions, the documents are getting downloaded properly in PDF format.  We have tried few approaches as well of downloading the document by clicking on the download option in the screen, right click on the screen and saving it as PDF, and using keyboard shortcut: Ctrl + P. None of these approaches are fixing the intermittent issue. Kindly suggest a solution or workaround for the same. Regards, Akansha Kumari

Hi all, I am struggling to send zip file over sftp. normal files are sending without any issue, but when i send zip file its give me error like  "The system cannot find the path specified. " can you please suggest how can i send zip file through sftp

Hi Team, How to make current assignee to empty in the user input task. PFA

I want to get the current screen type in which my interface opened.Here screen type I mean : "PHONE" , "DESKTOP", "DESKTOP_WIDE" etc I tried using a!isPageWidth() but that is not working for my requirement.Please help me with this.Thank you in advance!! 

While entering a leave request in a read-only grid I am entering the same date two times with different leave type (which is allowed).  I need to get the leave hours entered for the same date as I need to give a validation message if the sum of leave hours exceed 8 hrs for the same day.  How can I achieve this?   In the sample data given below, I want to extract the requested hours where the leave dates are same: [LAST_UPD_USR:ehelen,LAST_UPD_TS:10/14/2022 5:55 AM GMT,CREATE_USR:ehelen,CREATE_TS:10/14/2022 5:53 AM GMT,IS_ACTIVE:true,APPROVED_HRS:,REQUESTED_HRS:5,LEAVE_TYPE:Sick Leave,LEAVE_DATE:10/26/2022,FK_STAFF_ID:113,FK_EMPLOYEE_LEAVE_REQUEST_ID:19,EMPLOYEE_LEAVE_REQUEST_DETAILS_ID:1]; [LAST_UPD_USR:ehelen,LAST_UPD_TS:10/14/2022 5:55 AM GMT,CREATE_USR:ehelen,CREATE_TS:10/14/2022 5:53 AM GMT,IS_ACTIVE:true,APPROVED_HRS:,REQUESTED_HRS:8,LEAVE_TYPE:Vacation Leave,LEAVE_DATE:10/20/2022,FK_STAFF_ID:113,FK_EMPLOYEE_LEAVE_REQUEST_ID:19,EMPLOYEE_LEAVE_REQUEST_DETAILS_I

I created successfully a web api (image bellow) then i copy the URL in the browser and its works (check image bellow) But when I copy the URL in an incognito browse, shoe this error:  {"resource":"\/suite\/webapi\/CWAOECClients","error":"APNX-1-4187-000","message":"Authentication failed. Please check your credentials and try again.","title":"An Error Has Occurred"}Help please ///////////////////////////////////////////////////

What is the difference between quick apps and application builders to create an application?

I have data stored in db as row wise. that data i have to show in column wise is that possible if so please let me know  data stored in database like below  Contact ID  Contact Limit   AED (000)  Contact Outstanding  (AED’000)  Value of Extension Sought   AED (000)  Capital Amount  AED (000)  Interest Payment Due  (AED’000)  Current Due Date  Days to be Extended  New Maturity Date   From CrP  =Contract Limit  = Value of Full Contract - Outstanding    =Value of Extension Sought  = capital amount  = Interest Payment   =Current Maturity Date of Payment being extended  =Number of days extension sought (B)  =New Extended Maturity Date                    Total    100,000  5,555    1,192&nb

Query API fails with 500 Error because of Memory threshold reached during output conversion "An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [YMXXDT4282], threshold: [1,048,576 bytes], objects successfully converted: [2,431])" Is there any pagination option which we can use? Any insight would help a lot. Thanks

I am unable to get a milestone for a particular id . Can anyone help me with it please

Hi Everyone, I have the requirement of impelmenting SSO login for users while they are approving the items present in interface. Can anyone please help me out? Thanks, Shubham

Has anyone done any integration with an Appian program and a PLC?

Hi,Is there a video/tutorial on how it is possible to import a plugin into "FitNesse for Appian"? I would like to test using the plugins indicated on the official fitnesse website, but I'm not getting it. Thank you.

 HiI All, I have created a pricing change request poral and it has 3 users 1. vendors, 2. buyers 3. internal teams ,I want to design a login page for main portal . The login page will be same for all users but based on credentials we need to direct the users ,   for example login page is visible for all the category users whenever , the vender category user trying to login with his credentials it has to redirect the vender to the vendor action page , like wise for the buyers and internal team category , please let me know how to design  in my application vendor has to request , buyer and , internal teams will approve or reject the vendor request . and let me kow how to setup users credentials and passwords Thank you all

Hi, how can we fetch only 24 hour Data in expression without using DB in Appian.

Hello, In a process I'm sending an email with an attachment. The problem comes when the document attached looks like its corrupt or in a strange situation. What could cause this? Here i'm triying to insert pictures of the configuration and the error. Image of the document recived: Image of the configurations on the process in the email sender. Thank you!

Hello Team , I am new in Appian and now planning to give Associate level certification.  Anyone who recently appear for the certification can please help me with the question (If you remember so.) or type of question . I have already gone through Sample paper given in training .  Any help highly appreciated . Thank You,

Hello, can anyone suggest me how to add a new line in appian? Code: user(loggedInUser(),"firstName")& " " &user(loggedInUser(),"lastName")& " " & user(loggedInUser(),"email") The output should be: Beast Hulk green.hulk@avengers.com

Hello, Do we have any templates to gather the business requirements for Appian solution ?

In Process Modelling: Part 1 of Appian Developer learning can't find the process model name as AX New Vehicle. Please suggest. I am sharing the link of the document: academy.appian.com/

Hi all, I just want to ask if I could create a website with appian? or appian just for creating moblie applications?

here i have add A and B and show it in A+B row....[A+B row is read only] these rows am storing in value_txt field  shown in below so i have add the value_txt data where extensionRefId=4 and 12 and show the value in that integer field which refid=14 i had tried to write like index(fv!item.value_txt, wherecontains(4,fv!item.extensionRedId),{}) but this did not work can anyone help me with this