Foundation

Hello  how to convert this text string: "2022-11-12 00:00:00"(Text) to text string in format "dd/MM/yyyy" ? Thank you!. 

Hi All, I required to generate JSON in the below format for the data that needs to be sent to another system thru integration: Req format:  "[{\"ods_service_affected\":\"testetset\",\"ods_outage_start_datetime\":\"2021-11-30 13:00:00\",\"ods_outage_end_datetime\":\"2021-12-01 22:18:45\",\"ods_utage_duration_requested\":\"02 01:00:00\",\"ods_effect_on_site\":\"off\"},{\"ods_service_affected\":\"1213546\",\"ods_outage_start_datetime\":\"2021-12-01 13:00:00\",\"ods_outage_end_datetime\":\"2021-12-02 22:19:09\",\"ods_utage_duration_requested\":\"01 05:00:00\",\"ods_effect_on_site\":\"lor\"}]" As you can see there are escape characters that were added to the JSON. I tried adding those escape characters however I noticed an additional double quote is getting added to the string. It looks like by default double quotes are added to the values by JSON Below is my code: """ods_service_affected""": """" & fv!item.serviceAffected

Hi, I have uploaded an image using "Document" object under the folder "AT_Images" Now, I have created an HTML template which I am using to send an email using Send Email smart service. When I use below code in the .html template document, there were no image in the actual email which I have received. <img src="AT_Images\companylogo.jpg"></img> Can some throw some idea on this.

Hi All , I am showing a pattern like bar chart in an interface i.e Total , Approved , Rejected etc . Now what I am doing is showing total count in the respective field but now as per requirement I want to show the count based on user filter . For example Approved total request is 10 , now user filter the approved , and  the data displayed in the grid(1-5) has only 3 Approved . Then I have to change the 3 instead of 10. How to achieve this . Thanks in Advance

Hi, I have a CDT and it is linked to a form and fileds are linked to CDT columns. Now, when user submit the form, data should save in the main table as well as another Audit table. Any idea how can I achieve this requirement.

I am using user filter in recordtype . Type of filter is daterange. Filter is done by expression rule not by selecting field of record data. I want  start date and end date from daterange picker . How will i get both date? or how can i find data whose date is between this date range.

What is the best UI/UX Design for updating existing value in a particular field or creating new value for that field against unique ID in DB from an Interface?

Dear all, I am facing an issue while I try to run the appian status.sh script  as root user despite the ownership is root. I am getting the following error: ERROR: JAVA_HOME is not set and no 'java' command could be found in your PATH. Please set the JAVA_HOME variable in your environment to match thelocation of your Java installation. Any idea of how I can run it as root? Thanks beforehand. Kind regards,

I created a word template to be used in process model, in this template I had a chart, I'm able to replace the labels of the chart. But I'm not able to pass the data of the chart, can someone help how to export the data of the chart in the word template? Thanks 

Hi, We have a use case where an employee from a warehouse needs to scan multiple barcodes. We were asked if this is possible without pressing, for example, a "Submit" button for each and every barcode scanned, since it would delay the process. The main goal is to allow the user to pick multiple barcodes, save them into a variable for example, and whenever the task is finished, it would trigger a process. Do you know if this is possible to do without forcing the user to press hundreds of times a submit button, for each barcode scanned? Or it's only possible via JavaScript embedded on the webpage? Kind regards

Hi All,  I have a condition where I want to show a user profile photo if it is there otherwise show initials.  For Image , I am using a!Image and for Initials I am using a!stampField.  Can i use these two together so that if user profile is not present than I can show Initials. Thanks In Advance, Saurabh

Hi, I have an interface which I am using for Employee details capture. I am using the same form for the creation of a new record in the database and for the updation. I have created a RecordType and created "Update Employee" related action. Now when I click on the "Update Employee" button I am getting an error like  "Error Evaluating UI Expression Expression evaluation error [evaluation ID = 335d6:04711] in rule 'at_captureemployee' at function a!multipleDropdownField [line 68]: A multiple dropdown component [label="Languages Known"] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was [languageid:25,languagenumber:1]; [languageid:26,languagenumber:4]; [languageid:27,languagenumber:2] and choiceValues was 1; 4; 2; 5; 3." Can someone help on this.

Hi All, I am trying to design a Comment Page , where I am displaying an  Image just before comment textbox , but in that image field I want to display user profile if is available other Initials for the same.  Please help me out in this condition. Thanks In Advance

How to export local data to Excel?

Hi,  I have a table where username and password is stored , now in an interface i want to access password based on the username, can it be possible to access data from dB using a constant in the interface?

I Create a Process Model that will get all the user email address has exceed in the expiration date on the database and it will send an Email to the user that the Email they registered is already expired. I have 2 sample data of the user , my loop is working but the it will back in the 1st data. Please anyone help me how to get the second data in the loop inside the process model  

Good Day Everyone! I'm having a problem on how to use the foreign key on my CDT so that I use another Record type as Rule Input, but when I used the Interface in a process model, I'm having a problem on the variables because I used a record type as a rule input. also I can't use the can't call the rule input in the context under Related action on my record type because of the same problem that I used a record Type as a Rule Input. what should I do? Thank you!! 

Hi, I am working on Appian version 20.2 I have created a Record Type with a Data Store and Entity. The moment when I open the Records and selected my Record Type, I am getting a list with only few random fields and got a link for the first filed. I would like to get the data fields which I want instead of random fields. Can someone advise on this. Thanks.

Hi ,       Is there an Appian function to retrieve Severs' primary locale ? I am looking for something like userlocale() , but specific to server not user. I know this can be be achieved in plugin/java. But I am looking Appian function. Ideally , I am looking for a function which can return highlighted settings in admin console as shown in the screenshot The usecase is a process model scheduled to run as batch which is developed by a single country but runs in different countries with its own servers. I am looking to dynamically disable or enable this PM , by setting up an expression or condition in the start timer.

After a user loging in i want do open a diferent interface based on theyr permission levels, but it goes to end node without opening any of the interfaces from the process models

Hello community, I am exploring the loop functionality of a scrip task but can't figure out how to do the following. I have a list of  6 map entries (same structure) with e.g. 4 fields and want to pass the values of the field of each map entry to a subprocess for earch entry fetching the values. I use pv!listOfMap[tp!instanceindex] to get the values. But what happens is that the script task iterates  6 times first and passing the last value of index 6, to 6 instances of the sub process. So ending with 6 instances with only the last value, instead of 1 to 6. I know I can pass the list of maps to the sub process and also pass the [tp!instanceindex] as a variable, and use the index in the sub process. But what am I doing wrong here? Kind Regards, Erik

This feature request involves navigation controls upon Site Action completion.  Currently, as with all Appian Actions, when one is completed the user is returned to the area they initiated the action from. This makes sense in a number of situations, however, not always with Site Actions in my experience.  In most situations I've encountered, a user is expected to submit 1 action at a time.  Typically we will have a few Site Pages, maybe a Home Page interface with general process details/contacts, a Record with some reporting capabilities, and a Action to submit a request.  Currently when the action is completed, the default behavior is to return the user to the same action's start form, essentially now a blank interface for the same process they have already submitted.  This causes end user confusion and creates extra development when we want to show a user a confirmation screen and allow custom navigation.  Best case, an extra click and an orphane

HI, I am getting an error when I try to send emails using "Send E-Mail" service in the process model. Basically, I am an administrator at the application level and when I try to run I am not encountering the issue. Whenever any user is trying to run, they are encountering the below specified issue. I have used a constant to refer 2 different groups. The user which is running the process is part of those 2 groups. Any idea why I am getting this error.

Hi. I currently have a requirement to allow the canceling of a UI task while keeping tp!id the same. Basically the equivalent to exiting out of the window and coming back to it later. Is there a way to do this with a button labeled cancel within my PM or interface?

In the process model I used "Bar Chart To Image", can I change the color of the chart?  I had this result but I need to change the colors, there is any way?