General

I'm trying to use the file upload functionality in Appian Interface and is there any way I can restrict from uploading the file with the same name which already exists in the db or even if it allows the upload is there a way to over write the existing file with the latest file?

Hi Everyone, I am getting a variable of type Map from Appian RPA Integration in Execute Robotic Process smart service, the values are coming like below as a single Map variable: { varABCIndex=26, varSiteNameIndex=16, varCurrentMonthTotal=64, varProjectIdIndex=24, varExcelModifySourceFilePath=, varOutputDocId=164646} Suppose I want to fetch value of varOutputDocId from this map variable, so how I can fetch this value. Please suggest.

Updated to "Arial" font and size "small", but when inspect the content in mail it is showing me Arial, Helvetica, sans-serif. If Arial then it should be only Arial, why all these right?

HI am getting like this error  what might be the reason?

Hi   Is there any option in appian to  sync user role information from UI to DB and viceversa. Thanks in Advance

I would like to know if there is any limitations in terms of number of rows or the memory limit to export the data to excel by using export DSE to excel smart service. As I am aware there is a limitation of 50 in terms of columns. I am curious to know if there is such limitations in terms of rows or the data limit.

i have 3 columnslayout i will show 2nd columnlayout when i click a link on first columnlayout, using showwhen:not(isnull(local!selectedcards)).---->it is working fine Same way, if i click a link on 2nd columnlayout i want to show 3rd columnlayout(using same showwhen()).------->it is working , but it is not hiding 2nd columnlayout. it is displaying both 2nd and 3rd layout. How to give condition for this in showwhen?

Hii Guys!! where we can find the saved draft forms in process model can anybody help me to share about this please

Hi Appian Community, Currently, our process automatically deactivates users (change status to inactive) that did not login to Appian for more than 30 days. The issue, however, is that the users that were deactivated manually have the same inactive status as the automatically deactivated ones. I would like to source ideas on how I can get this list of dormant users. Advance thank you for the people who will respond to this.

On the FAQ --  What is the cost of the certification exams? Each exam attempt costs $200 (US). Appian Partners receive a 50% discount. We do not currently offer regional discounts. (Note: There is no longer first free attempts for partner practitioners but recertification will be free) As an employee working for Appian partner. Could you suggest how the 50% discount can be availed. I see no option during payment at the time of scheduling exam.

I am trying to understand the working behaviour of foreach . i have tried this below code from appian doc. a!forEach( items: {"January", "February", "March"}, expression: a!localVariables( local!month: fv!item, a!forEach( items: {1, 15}, expression: local!month & " " & fv!item ) )) the code throws the below error.Kindly help.

When using the sftp smart service, is there any way to search for a file in a folder, ideally with some kind of wildcard option? I've got a folder with a list of files named something like <FILENAME><SOME_RANDOM_NUMBERS><DATE>.csv and while the filename part stays the same, I don't necessarily know the number or date attached to it ahead of time. Is there some way I can pull the latest file called <filename>*.csv or something? Or do I HAVE to know the exact file name to download it?

i configured all the node inputs of a!docExtractionResult() smart service properly. i used this smart service in process model. i assigned that task to application administrators group. when i run this process model, i got this error message "The document extraction instance [docExtractionId=8,545] does not exist, has been deleted, or you do not have sufficient privileges to access its data. Please submit this task to complete. You will be prompted with an error message upon submission." But, the document is there with the specified id(8545) and also i am having the required previleges as iam  in application adminstrators group. Please provide me some info regarding this. Thanks in Advance.

Hi, We're using on-premise Appian with MSSQL(Sql Server) Db that includes both Appian Primary DB and Business DB. We're on the steps to move to Appian Cloud. Could anyone tried and share your suggestions how to migrate Appian Primary DB to Appian Cloud pls? We understand Appian Cloud uses Maria DB, trying to find if there any better approach OR schema backup tool available for this use case pls? Thanks.

Hello all, We have set up new environments and write to data store in to a table having PK and 4 columns it self takes 1.34 second which seems to be too high . Issue we are facing with the other nodes which is inserting more data and time is at higher end which is impacting the perfomance and response time of the process. Is there any possibilty to update some configuration or setting at server side so that write to data store takes lesser time ? Usually write to data store should not take time in seconds to just insert 4 columns . Any pointer will be helpful . We have on-premises env whihc is newly setup . Thanks in advance, Pooja

I have a question while using the a!pickerFieldCustom Component example in Document. a!localVariables( local!pickedState, local!stateLabels: { "Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Hampshire", "New Jersey", "New Mexico", "New York", "North Carolina", "North Dakota", "Ohio", "Oklahoma", "Oregon", "Pennsylvania", "Rhode Island", "South Carolina", "South Dakota", "Tennessee", "Texas", "Utah", "Vermont", "Virginia", "Washington", "West Virginia", "Wisconsin", "Wyoming" }, local!stateAbbreviations: { "AL", "AK", "AZ", "AR", "CA", "CO", "CT", "DE", "FL", "GA", "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NE", "NV", "NH", "NJ", "NM", "NY", "NC", "

The time i use for setting meeting using "Send Meeting Request" is 10AM, but the meeting is generated for 3.30PM.(GMT+5.30 hours)(I live in India). Is there any setting to correct this? Like the process model time zone or something else? Currently i am working around this using =(pv!InterviewInviteDetails.startDateTime - time(5, 30, 0, 0)) in the Start parameter of the Send Meeting Request.

Hi All,  Hope you're doing well.  I'm trying to setup automated CI/CD on Azure.  VCS = GIT sits on Azure Below are the steps we're trying to achieve: Comit/Push the exported zip from local to GIT repo(using IntelliJ IDE) once the objects are committed into the repo, Trigger pipeline to add/merge the updated objects into existing application objects Build the Application - Generate the package .zip Import into the target environment Issue:  When executing the addContents action getting the below error message, please help me to understand the error if I missed anything. Error Message: 2022-07-07 00:25:03,353 - Missing git repository. Cloning automatically. 2022-07-07 00:25:03,353 - Cloning from <Repo URL> to <local_repor_path> 2022-07-07 00:25:04,954 - Local repo updated successfully 2022-07-07 00:25:05,162 - close() called when useCnt is already zero 2022-07-07 00:25:05,163 - There was an error completing the select

 I am getting this error whenever i m trying to generate the document { "error" : "APNX -1000-000" , "message" : "Invalid Content ID", "title" : "AN error has occured. Any suggestions?

Hi Everyone, if(     rimod1 = 2, {cons!member1,cons!member2),{} ) In the above code I try to get the value from 2 constant which contain group member, but I am getting value from member1 not from member2. can anyone help me on this.

"

I am not sure if I'm just doing/understanding something wrong or if this is a bug or what. When configuring a site, there's an option that says, "Show Tempo Link in Navigation Menu". I could have sworn that if I select never on that, that I wouldn't ever see the site listing when I click on that 9 square icon listing all the tempo sites. However, I am able to see the site listed. What am I doing wrong here? 

Hi, We have a grid layout, user needs to enter the necessary the data in the field by clicking on +Add row, every row has a dedicated Save and Discard button. the UI have Back (LINK) to go previous page. when a user click on + Add row in the table and enters data and don't click on save. click on back (LINK), and comes to the same screen again, ACTUAL RESULT: row value entered is displayed even row is not saved. EXPECTED RESULT: Row value entered should not be displayed. After clicking on Back (LINK) in UI and coming to the grid screen.  

Hi all, We've got a requirement to provide some documentation/information on two things: 1. Resiliency for our Appian instances 2. The Capacity and Performance of our Appian instances Our environments are cloud-hosted, does anyone know where would be the best place to find any info on this, either generic or specific to our instances? Can I find this myself or would I need to get in contact with someone from Appian? I've tried having a look but I haven't come across anything yet.  Thanks

I have a requirement where the files in our directory have the naming convention as: filename_{yyyymmdd}.{hh23miss}.txt abc_20220131.121314.txt The interface can and SFTP smart service combination can read the user input for file and date combination, but how can I retrieve a file which has timestamp associated? Newbie to Appian, please assist.