Discussion Categories

Hi All,I ma using documentpreview to view the uploaded pdf file but the component is always showing the uploaded file in <100%.I am attaching the screenshot here as well.How can I make it 100% by default. Thanks in Advance,SSP

Hi Team,we are moving away from legacy (Base64 Auth) and move to SAML authentication and once the migration is completed we have to ensure MFA is working through our IdP (Azure) and ensure that anyone authenticating to the system has MFA enabled.Can you please guide me through the exact steps to implement this process. Please let me know if any further information is required

How to read data from sharepoint list to appian?Could you please suggest is there any functions or plugins or smart services?

Hi Team, Does SAML protect cross site request forgery token attack? A CSRF token is a unique, secret, and unpredictable value that is generated by the server-side application and shared with the client. When issuing a request to perform a sensitive action, such as submitting a form, the client must include the correct CSRF token. Otherwise, the server will refuse to perform the requested action. Please let me know if any further information is required

Hi everyone, i've got a problem with email sent to a process model with multiple nested .msg attachment. I want to extract the last nested email attached to the incoming email, but the received message node doesn't process the .msg file. it simply download all the other files (pdf, .xml...) without reading any information of this series of the nested .msg attached emails. I've used the striphtml(msg!properties.Attachments) function in the received message node configured to receive incoming email, as shown in the pitcure below. I don't use the read msg plug-in because i have to download the .msg file as attachment from the incoming email, so it's useless for my process.  Thank you all

Hi, When I try to add date using Today() ,value is saving into the database properly (Refer to the below attached screen shot) Whereas when I try to load into the grid using RecordType, it was showing like below. Any advises on this please.

Hi, I am trying to substitute few characters from input string and store/display in the rule input variable (i.e. target). SAIL:  a!localVariables( { a!buttonArrayLayout( buttons: a!buttonWidget( label: "Add", value: "Add", saveInto: a!save(ri!target,"2323432345,2343234543,4433443323") ) ), a!forEach( items: ri!target, expression: a!paragraphField( label: "Target", labelPosition: "COLLAPSED", value: substitute(fv!item, ",", char(10)), saveInto: a!save(fv!item,substitute(fv!item, ",", char(10))), required: true, refreshAfter: "UNFOCUS", ) ) }) In the image above I have used substitute( ) function to replace all comma ( , ) character with char(10) but as you can see the display value is converted to desired format where as the data stored in rule input remains the same (comma separated). Please help me convert the data :  From :  2323432345,2343234543,4433443323 To :  23

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!