Discussion Categories

How to update a single field for a record? Any idea! Reference Link :: Update existing data

If we use match instead of If, will it improve the performance

Hi all, I'm trying to finalize the integration approach for Appian cloud with AWS RDS Sql server. It seems there are two options available. 1. Private Link 2. Ip Sec Site to site VPN connection (VPN Tunnel). (Also I understand Appian cloud does not support VPC peering, however I could not find the reason behind this. ) Private link cons: https://docs.appian.com/suite/help/21.2/Access_Customer_VPC_using_AWS_PrivateLink.html "RDS is not officially supported behind a Network Load Balancer; therefore, if you would like to connect to RDS environments over AWS PrivateLink, you will have to employ one of many workarounds to create a VPC endpoint service in their VPC." It seems Ip Sec VPN not required to update the DNS of the RDS instance. Still bit confused if there any other advantages of using Privatelink than VPN tunnel? Could you please enlighten me on this? Thanks. 

Hi, I am using a Execute Stored Procedure smart service and it is returning 2 result set and each result set is returning with multiple values. Now, when I try to grab the store procedure output  result into a variable like below, I am getting an error. An error occurred while evaluating expression: keys:AC!ResultSets[0] (Invalid index (0) for list: valid range is 1..2) (Data Outputs)

Hi Experts, Which one of the above mentioned datatype would be advisable while storing a datetime value in DB and what will be the advantage of one over other while using it in APPIAN. Thanks, Gaurav Singh

We are trying to validate the Sorting on Grid Columns For this we are fetching the data of the column from DOM using web scraping   Example:   Column1: "Apple", "Apple1", "Apple0", "Apple_"   on sorting the Grid (say in Descending Order) We get: Column1: "Apple1", "Apple0", "Apple_", "Apple"   Which tells us that the order of preference when sorting is: '1' > '0' > '_' > ''   But the ASCII values are: Character        -        ASCII Value 1                -         49 0                -         48 _     

Hi, Requirement: Operations would like to be prompted when any robot resource is offline, so that recovery action can take place to put the robot back online. Possible solutions: 1. In the first instance this may be a Operations  interface within appian which looks like the RPA resource page. Future would be to prompt Operations that action is required by raising a task or send an email.  Is there a way to capture the information shown on the RPA Resources page specifically the resource name and status? 2. have a robot process regularly scheduled as a "ping" to check a resource is online and report the results of the robot process and assume if robot process failed then prompt Operations. Thoughts? Thanks

how can I prepopulate the fields of current task with previous completed task details?

Hi Experts, Currently I'm working on an Enhancement Project where in the legacy Application we were using CLOB field to store comments. Since CLOB is not available in MariaDb as a dataType what would be the recommended datatype to use in New System.The max number of chars that we have for one of the such comment is 21499 chars. What all will be the pros n cons of using VARCHAR(21499) vs BLOB datatype, and also if makes any impact on the performance of the record and UI using the comment table. Thanks, Gaurav Singh

Hello, we are experiencing some very radical spikes and increases in the session count of a report that we have in Appian. In the graph you can see how the level of logged in users automatically increased in a matter of a few minutes to illogical levels and we believe that this may be slowing down the general environment. We have not detected a process, an Appian object that jumps us that could be the cause of said increase.

Hi Champ, I am using docx from template smart service to create my docx from a template and converting to same to pdf later on to generate my pdf in the required format. I have a use case where I need to show checkbox to the user which they can fill it later on. Is it feasible ? Regards, Ghanashyam

Hi All, how can we see the tasks that completed by user it was not captured in the monitor and in the DB? Many thanks

Hi Team, I have a requirement of calling different integrations in one PM node depending on few conditions. The response of all integrations are saved as a JSON file and usage of integration is "Modifies Data". Call integration smart service does not work as it does not have the privilege of setting up integration depending on conditions. Also calling integrations in script task/ER using rule! does not work as usage of integration is "Modifies Data".  Do we have any other plugin or smart service to fulfill my requirement?

Hi all, How can I cast True or false into yes or no?is there any function to convert like this? Thanks in advance

Is there any way to still keep the legend in a graph but remove the click on legend filter functionality? In this case I am referring to the Points legend; this is a sample graph I am playing around with in but I do not want the user to filter on legend in this case.

Yesterday afternoon, the Add New record action on 3 different interfaces stopped working and the process models show the same following error: The only change that was made to those 3 interfaces was the following highlighted section was added into the expression mode: *Note - after this change was made to the example above I was able to create a new record in that table with no issue, then proceeded to make the change to the other 2 now having issue. Also, we tried putting it back the way it was and it still gave the error so we are stumped as to what is causing this issue now.

I tried adding a YouTube video to an interface but it ends up blank. a!videoField( videos: { a!webVideo( source: document(21953,"url") ) } ) I tried using this code and for source I tried replacing it with the YouTube video url which didn't work also. Do I need the mp4 of the video in documents or are YouTube videos not compatible?

Hi, community. I want to use "Appian IDP" with position specification. for example. I want to get the value of each colored part in the figure below.(This format is fixed and does not change.) This color "Area ■" is "Name Area". I want to get it like {name:"Nihon Taro"} I want to associate like "Area ■"="Name",  "Area ■"="Post Code" and  "Area ■"="Address".  if "Appian IDP" can use with position specification, it is as good as solved. Can't you do something like that with an IDP? Please tell me how if you know. Regards!

When i re-assign task to particular user then the status is still remains to assigned not the accpeted untill that person open the task, is this a functionality or task or a bug?

Dear All, Based on process instance ID I have unarchived the main process model but in the main process it has some sub process model also, I need to unarchive the sub process model. Kindly guide me How to unarchive the sub process.  Thanks in advance. 

Hi, I am trying to use "Sync Records" smart service after using "Execute Stored Procedure" I found in the documentation that in order to use "Sync Records" smart service with a service-backed record type, you must first configure a Sync Expression on your record type. As per the documentation, in order to generate a new Sync Expression, I have to follow the below steps  docs.appian.com/.../records-data-sync.html In the record type, go to Sync Options. Under Sync Changed Records, locate Configure Sync Expression and click + GENERATE EXPRESSION RULE. But, unfortunately I am not able to find the "GENERATE EXPRESSION RULE" under Sync Changed Records.  Any advise here.

Hi       I have created a robotic task, in that I want to configure an action for sending mail. I didn't find any action for sending mail. Do we have any action for that in Appian RPA robotic task. If their is no particular action for this then how can i achieve my requirement. Thanks in advance

Hi, I did set up from and other options as per the below specified screen shot, but still I am NOT getting email from IT Service Desk. I am getting an email from "appian-alerts@nsroot.net; on behalf of; XXX, XXX.com". Do I need to change any other setting any where to reflect this.

Hi, I have an URL of the format : https://www.google.com/<unique_id>_<fileName>_<remaining url> Now my requirement is I want to fetch the filename out of the URL ... the first part will always remain the same  i.e. first is https ... till .com/ then comes an unique identifier  then followed by '_' then followed by filename then followed by '_' and the remaining URL  Can anyone help me fetch the filename ? 

Hi, a!safeLink( label: "RPA", uri: cast( 'type!{www.appian.com/.../2009}SafeURI', "">XXXXX.appiancloud.com/.../nodes.xhtml", ), Regards