General

Hi Guys. Im trying to make a function where the string contains half-width and full-width spaces, the first and last spaces will be removed. When i used the trim() function in appian it only trim(beginning and trail) half width spaces but if the spaces are full width it will not trim. so i tried to trim and use the substitute function like this: trim(substitute(ri!value,"　"," " )).  It does trim the value perfectly, but it will also substitute the spaces in between the value where it shouldnt be. Example process: "<full-wdith spaces>he<full-wdith spaces>ll<full-wdith spaces>" after executing the process: trim(substitute(ri!value,"　"," " )) result: "he<half wdith space>ll" expected output should be : "he<full-wdith spaces>ll" Do you have any other idea to perform the desired process? Thank You guys [emoticon:2e0881b394ea47039c4b7e5eed46a79e]

I have two interfaces and want to switch between them but my process variable doesn't interact. when I click the "Edit Mode" button in the interface, the process variable doesn't change and the process stays in view mode.

Zuuup, people ? So, I've created a releated action and added it to a interface. All following the usual, nothing exceptional. However (of course, otherwise this post wouldn't be necessary), the follwing message poped up when I tryied to click on it. I reviewed security settings for this action and releated items to it. All looks ok. Any suggestions ?

How can I add a row that calculates all the rows above: id number 1 20 2 30 sum 50 something like this. tnx

is it possible to change the cell background color when the value of the cell is null?

i have an requirement of optimising below  grid column , in the value of grid Column  i am fetching the required value from query rule.But i have to declare query rule in local variable first and then i have to use  how shud i fetch the relevant value after using in local variable . a!gridColumn( label: "Data Type", value: index( rule!WFM_qeGetLookupRefDataByInput( isActive: true(), lookupRefId: fv!row['recordType!FWM_record.id] ), "label", {} ) )

Hi, I am getting data into a Process Variable like below inside a process model Name                    Type          Multiple     Value --------------------    ----------        ----------     ------------ listOfSubmitters    Text           Yes           [addedby:AA1234]; [addedby:AA1235]; [addedby:AA1236] Now, when I try to access the index 1 value, nothing is coming out. Any guess what went wrong

Hi Guys, I have a query entity rule which is failing to retrieve data when I run for the first time in a day. If I run again, it's working as expected. This behavior has started happening recently(it was running fine from long). I looked into the logs and I am not finding the error.  We use on-prem servers and DB is oracle. Thanks in advance

I need to know our Appian Instance IP's. where can i find it or do i need to raise support case to get it?

Hello, I have a site with an interface page as content. My interface nested other interfaces and the navigation through all interfaces is based on the logic of local variables. However, in some interfaces I use "a!processTaskLink" to run tasks on already started processes. My problem is: I want to open these tasks in the same tab and when I finish my task, I want to go back to the interface where I was. But, the actual behaviour is that when I finish my task, I go back to the main interface because the values of local variables are lost. Does anyone know how to get around this problem? Thank you.

I'm getting this error in my tomcat stdOut log when I startup Appian. I'm able to go on the site but when I try to run/debug my process model it always stuck on the start node and won't continue the flow. Not sure what went wrong, It worked fine other times when I did a fresh install of Appian. 2021-12-29 20:31:45,319 [ForkJoinPool-1-worker-25] ERROR com.appiancorp.common.config.ConfigObject - An error occurred while trying to initialize the config LoadExceptionHandling [0ms] [resources 27ms] java.nio.file.InvalidPathException: Cannot store the note content, because the location is not valid.: C:/appian21.2/_admin/process_notes/exec/00/2/0 at com.appiancorp.process.notes.services.NotesContentServiceImpl.createNoteContent(NotesContentServiceImpl.java:164) at com.appiancorp.process.notes.services.NotesContentServiceImpl.createNoteContent(NotesContentServiceImpl.java:178) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImp

Is there any other way to check the performance of an interface other than the performance tab? I often see interfaces that say they take 100 ms to load (or whatever number) and yet spend 20-30 seconds opening the page. There seems to be some kind of disconnect there and I am trying to figure out where the issue stems. 

here will be selecting one row in grid and showing the below data  but same data in separate section we have multiple selection here how can i show the selection data because I'll be selecting multiple rows here can anyone suggest me the approach

Hello, I have a question, I have an interface which is a grid, this allows me to add a dropdown with information obtained from a constant, this constant has 3 groups, my question is, how can I do so that when I add a new grid, this information from my constant is independent of my dropdown that makes new, all this is written to another constant through a process. I have something like this, I already tried using save to to my new constant, but it is not updated with the process, does not elminate or anything. this is my code. thanks you! a!localVariables( /*rule to save groups */ local!groups: rule!GS1_getgroupnames(), /*rule to get all groups */ local!grupos: rule!GS1_getgroups(), a!formLayout( label: "Manage Additional Distribution List", instructions: "Please select and modify the groups that you wish to update in the grid below.", contents: { a!sectionLayout( label: "Additional Distribution List", contents: { a!gridLayout( label: "", labelPo

Hi, We've got a scenario where we want to provide hyperlinks for the user to access a site page which contains a record list. Is there a way to have filters prepopulated for a record list when the user clicks on the hyperlink, like maybe through passing values via the URL? Or any way to have filters prepopulated at all? I know users can save filters, is there something similar to preset them? I've been looking through the forums and documentation but I haven't found anything yet. Thanks for any help!

Hi, I am trying to pass the timestamp value which is of type text in CDT from upstream through webapi. The milliseconds part is getting rounded off automatically Value from Upstream: 2022-11-21T09:00:56.998992Z Roundoff Value: 2022-11-21T09:00:57Z Expected format : %Y-%m-%dT%H:%M:%S.%fZ" But I need to send the same value from my upstream to my downstream system Any solution for the above please?

Hello, is there any way I can remove this window from the SITE and directly start from the Login Page?   I also Removed the  My Learning Journey Contact Appian (Sign-in Page Links) from the Admin console but it is not reflecting on the SITE.

Zup, people ? So, I'm trying to tigger a action after some task is reassigned, due my business rules. I have to change a record in database, for example. Is it possible ? thanks for ur attetion in advance!

Hi everyone, I am trying to reassigning task from one group to other group by using Reassign smart service but it is not working. As a Appian designer I have administration permission if I initiate the process model that time reassignment work properly, but the same process model if I use as sub process than its not working.

Hi Guys! I have these Data Store mapped on the appian cloud. And as shown on the picture below it was successfully verified. However when i checked on my appian cloud there are missing database table which are not visible. Only the highlighted items shown on the picture are visible on the appian cloud.(see below) I already save and published it many times, refreshed the browser on the appian cloud but still not working. Is anyone has any idea on how to fix this? Thank You!

expected output : textShouldBeInCamelCase

Hi, I have written down a code to calculate this, please let me know if it can be more refined. a!localVariables( /*rule inputs local!StartDate, local!EndDate*/ local!StartDate:todate(ri!StartDate), local!EndDate:todate(ri!EndDate), local!WorkStartTime:time(2,0,0,0), local!WorkEndTime:time(10,0,0,0), local!StartTime1:totime(ri!StartDate), local!EndTime1:totime(ri!EndDate), local!StartTime2:if(local!StartTime1local!WorkEndTime, local!WorkEndTime, local!EndTime1), local!EndTime: if(local!EndTime2local!WorkEndTime,local!WorkEndTime,local!StartTime2), local!StartDateTime:datetime(year(local!StartDate), month(local!StartDate), day(local!StartDate), hour(local!StartTime), minute(local!StartTime),second(local!StartTime),milli(local!StartTime)), local!EndDateTime:datetime(year(local!EndDate), month(local!EndDate), day(local!EndDate), hour(local!EndTime), minute(local!EndTime),second(local!EndTime),milli(local!EndTime)), local!ElapsedDays:elapseddays( local!

There are two column layout when you zoom out in the browser they move apart one to left another two right I want them to stick together Any solution for this 

I have an application has a lot of objects I don't want to import. Most notably it has a data store which taking it will result in a massive amount of extra data types and baggage. All I care about is a process model I have copied.  All of its dependents have been brought in to a new application I am using to package up and import. I am getting some cascading and normal errors that seem to stem from me being unable to import the datastore.  What can I do to decouple this datastore from my application for importing? I already created a new datastore in my environment I am trying to move export it to and created any constants there that pointed to the data store entities inside it in the old application. In summary what do you do if you want to bring in portion of an app but don't want to bring in the data store entity it had?

If i delete tempo reports in lower environment same change should reflect in higher environment i.e auto deleted while deployment . Is this possible ? If not how to achieve this..Because I don't have production access to delete