Discussion Categories

Hello Community, U want to use a array of CDT's as input to the text from template smartservice. It works fine for 1 Line. How to configure the next CDT's Will append to the document on the next Line? Tried joinarray char 13 and char 10, this only works for one mergefield. Kind regards, Erik

I have a dropdown component and I want certain values to be available for choice based on the security groups of the user. For example someone who is only in group A might be able to choose 1, 2 or 3 from a dropdown, someone in group B might be able to choose 4, 5 and 6 from the dropdown and someone who is in both groups would be able to choose all 6 options. Changing the dropdown labels/values based on group is not a big deal to do, however, since the dropdown only allows values to exist that are within the currently available list of labels/values, if group A chooses 1 and someone in group B looks at the form, the 1 will be invalid and break the interface. What would be a good way to get around this issue? 

Hello everybody, I am a bartender and YES I am changing careers. Currently I'm taking college classes in development to catch up on tech and I will be attending APPIAN WORLD 2023 in San Diego on may 1st. My concentration is development to start applying jobs in about 6 months. I wanted to go ahead and connect with people who recently did a career change, OR already done it (NICE WORK BTW) - and potentially become Appian buddies and learn from each other OR learn from YOU! If you are going to attend Appian world, we seriously should connect. I am looking to build Appian relationships, share and consume projects in the community too. Hit me up on LinkedIn, its sorta lonely over there but don't we gotta start somewhere? Thanks for this community and take care colleagues! LinkedIN

HelloI have a section that is collapsible but the label has to change based on the state of the section - any suggestions on how I can implement it using Appian's built-in features. I can do it using richTextField but then I can't seem to emulate the slow animation that Appian's default code does. So, two questions: Is there a way to change labels based on the state or Is there a way to emulate the slow animation of the arrow if I create the section label using richTextField.a!sectionLayout( if (sectionIsCollapsed, label:"Show Details", label: "Hide Details") is it possible to code the slow animation of the arrow as Appian does here?label:"Show Details", logic to change text to display based on the state of the section  Thank you for your assistance M a!localVariables( local!isExpanded: false(), a!sectionLayout( label: "Outer Section", isCollapsible: true, contents: { a!richTextDisplayField( value: {

Ok so, inside a forEach statement I define a local variable like so: a!localVariables( local!routingChoices: a!refreshVariable( value: if( a!isNotNullOrEmpty(ri!inputData[local!currentIndex].routingAction[fv!index]), a!match( value: ri!inputData[local!currentIndex].routingAction[fv!index], equals: 6, then: {1,2}, equals: 7, then: {1,3}, equals: 8, then: {2,4}, equals: 9, then: {2,3}, equals: 10, then: {3,4}, equals: 11, then: {1,2,3}, equals: 12, then: {2,3,4}, default: fv!value ), null() ), refreshOnReferencedVarChange: false(), refreshOnVarChange: local!sealCount ), local!sealCount stores an integer and the forEach is set up to run "enumerate(local!sealCount)" times (so if local!sealCount = 2 the forEach runs twice). Then, farther down in the interface, I have a dynamic link that acts as a "delete&q

Hello everybody we have got this message in tomcat logs: "A high-memory expression evaluation was logged, but the evaluation was not identified. The expressions aborted log will not contain all evaluation info" and this message is repeated several times and between every occurrence there are the lines that I have put in the log in attachment. I would ask if someone has ever met this error, or in alternative if you can give to me some hints,  after the reading of the log, that in my opinion in quite hard to understand. Thank you in advance for any help or suggestion, best regards Paolo [View:/cfs-file/__key/communityserver-discussions-components-files/11/log.txt:87:58]

Hi All I am working on version 22.3. My requirement is to get data from DB and provide it to user in excel format. This I have achieved using OOTB node "Export Data Store Entity to Excel". The excel sheet obtained looks something like below: However, I want to transpose the excel data as below: Can anyone please suggest how is the above achievable. Thanks in advance!!

Hi All,Can we check and enable/disable track changes to word documents using Appian. Thanks in advance,Surya 

Hi Appian Community, I want to implement a simple Try... Catch within my Web API sail expression to test the request body being a valid JSON message. I still notice that the Try() function is not publicized in the documentation but it has been an easier implementation. And in posts that mention Try() function it heavily cautions that it is not recommended and could become unavailable. I looked into using some regular expressions off Google that match for JSON as an alternative but found they aren't compliant with the regex plugin. Example Regex /(?{((?\"([^\0-\x1F\"\\]|\\[\"\\\/bfnrt]|\\u[0-9a-fA-F]{4})*\"):(?\g|(?-?(0|[1-9]\d*)(.\d+)?([eE][+-]?\d+)?)|\g|\g|true|false|null))?\s*((?,\s*)\g(?:\s*)\g)*})|(?\[\g?(\g\g)*\])/ What are some recommended HTTP Request Body validation expressions that can validate whether the message is JSON or XML? It would be great if WebAPI object can handle the content-type validation automatically for us. Below code is using try() function to test f

Hi, I have a very basic process model where I'm setting a new value for a users first name and last name, then setting a new value for the username and finally deactivating the user. The process has been working as expected for approx. 1 month but is now showing this error on the Rename Users Smart Service: The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete. It also sporadically shows the following error, again on the same Rename Users Smart Service node: An error occurred in executing an Activity Class. Error in the tomcat.stdOut log: 2022-03-23 09:46:44,983 [ajp-nio-0.0.0.0-8009-exec-836] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536877698, classname=com.appiancorp.process.runtime.activities.StartProcessSmartService2 com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.initiateProcess.userMsg=Failed to st

For the word "technology", Eg t-1 e-1 c-1 I need character count of unique elements of this string

Can anyone provide me road-map to study for L2 Certification?

I am trying to create an excel sheet with the data present in my PV variable, this data is not directly from the SQL database as i have to modify it before writing it to the excel. Can you please tell me which smart service i can use. Export Data Store Entity to Excel/CSV isn't giving me the desired result as the requirement is to use the data in PV variable not from the DB. Please help me here. Thanks, Preji

Do Appian has provided a course for Appian L2 Certification? I am unable to find it.

I have three CDTs that contain some fields with the same value. I want to create an expression rule that matches them and extracts only the fields that don't overlap. What function can I use to make it?

how to import old data for task report? We are migrating old data to db and  we have some process/task report which is not updating tha db data to UI grids.

How to ensure a process have a well-defined life cycle? (select multiple from bellow options) a. configure process data management settings b. use a terminate end node to complete workflow c. configure all processes as sub-process that are quick task d. configure exceptions on every node in process. 

how can we import the process instance from one env to another??

I have a date field that autopopulates a read-only field and also saves to the data. Right now in the read-only field the dates are displayed as 2/28/2023 and I would like to have it displayed as February 27 2023. any suggestions for the code? this is what I have atm text(local!birthDate, "mmmm") & " " & text(local!birthDate, "dd") & ", " & text(local!birthDate, "yyyy")

Hi Guys, Just wanted to know since a lot of work is done in expression mode which is in light theme so is there any way we can switch to dark theme as most of the editor of other languages have dark theme. And it's sometimes difficult to look in light theme for a long time. Thanks in advance

Hi, While clicking on few of the documents below to see the summary like INEE1 and INEE2 - I am getting an error as below.  1. This is not happening for all the documents. I am able to see the summary of other docs 2. Also this is not happening with the problematic document when the document state is in Auto Extracting or Pending Reconciliation State. At Auto Extracting or Pending Reconciliation State - I can see the summary of the docs. The moment it moves to Completed status I get the above error. any help will be appreciated thanks jaideep

How can i implement grid export toexcel to user system on single click Bot to aappian system

Hi Appian team, I am learning IDP and this is not a blocking issue though.  When I set up everything as in the given tutorial for IDP I have 1 doc type - let's say - 'Expense Reimbursement' I do the required configurations in the Configure tab and then upload 1 pdf and it asks for classification Why it should be asking users to classify if I have only 1 area of classification? Shouldn't it pick it be default ? thanks jaideep

Hi, I am trying to get the document name by passing the documentId. If I am fetching the documentid into a local variable and pass, then I am getting an error. Where as when I pass the documentId number manually, I am getting required output. Not sure what is wrong. Do I need to do any kind of conversion before assign to a local variable. a!localVariables( local!templateDetails: rule!LC_getTemp(Key: 4), local!documentId: index(local!templateDetails, "documentid",null()), local!documentId /*document(local!documentId,"name")*/) When I try to execute below code, I am getting below output. a!localVariables( local!templateDetails: rule!LC_getTemp(Key: 4), local!documentId: index(local!templateDetails, "documentid",null()), document(local!documentId,"name")) Whereas when I try to execute the above code, I am getting the below error. Can someone advice here.

I am attempting to display a CSV file stored in CDT in the UI using the documentViewerField. Here is the code.However, I just get a blank rectangle in the UI. Does the documentViewerField component not work for CSV files? a!documentViewerField( label: index(ri!variable, "documentName", {}), document: index(ri!variable, "document", {}), height: "TALL" ),