Discussion Categories

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?

Hello all! I am creating a portal for Appian Europe Live Build Challenge 2022. In this task among others I am showing on my interface a read-only grid with scheduled World Cup matches.  Since I need to use Appian Portal, I cannot use record type and my data source for the read-only grid component is a (local) variable that contains list of Dictionary data I got from previously created API and Integration. The question is: How to create user filters that allow to dynamically filter rows in a read-only grid component?  In my case, a user would enter my Portal website and filter matches by coutry or group. Thanks in advance! Marcin

Hello Everyone,  Can anyone help me in the below scenario. Scenario: Using multiple dropdown selection field End-User should search and select the no of items from the dropdown field.  Details for this scenario:Table = Courses (Record Type)In the multiple dropdown field i want to fetch all the existing course names from the courses record type for selection.

Hi Folks, So the scenario is to that we have a case dashboard where we are showing case count over time. In that  screen ,the use case is if we have a date range, from -to date and if we click on filter it should show us the graph along with the cases count between selected date range. How can we make a graph for this , including the X  AXIS data points? Like how do we make range displayed as batch for each filter, data wise we are good as we can have data for specific time range,but how to display in graph.

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", {} ) )

I have created dynamic interface , in  which if user have option to create number of text field , if want to 2 or 3 text field , i have created according for each , text field appearing fine, but storing data is a problem in CDT, here i have two field, i field is filled by manager and corresponding field will filled by employee as task. , 

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, is there any way to increase the expression rule timeout which is pulling data from a view .  As now its getting timeout because of the complex logic in view so i  just need to increase the timeout of a expression rule to check it  Thanks in advance

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?

How to auto refresh a page that is being called in a site. for example, when I click on Change Department and fill the form and submit. the changes must be reflected on the User screen without refreshing manually

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 want to ask about this function =task_avg_completion() as its output is not compatible by its description when I try to implement it in the process report. I am targeting to return from this function in my report the average completion time of a task per all process instances of a process model which is expected to be the same for all the process instances but the average completion time is different from a task to another inspite it is the same task name as shown in the following pic

Hi, i am looking how to achieve multi transaction using Appian. Is there any bottleneck  to achieve this? e.g parent and child transaction should commit at the same time. Thanks in advance Chetanshi

i have a requirement where i have a field for which im not storing data in the db. but i need to show that value on the landing page . how can i achive it?

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

Hi,After successful deployment, I am getting the above error at UAT in the parent process because of the subprocess.

I have not created any record for storing status values i.e. assigned, accepted and completed. How can I do it?

Hi, How to Handle Errors in interface level,I have a Scenario where we are passing list of document Id's to interface and if any documents is  deleted the the UI is throwing an error,We want to handle it like if the function document is throwing an error , we want to handle it in a way that particluar docid should be removed from the list of inputs or that execution should be skipped. How can we achieve this? Thanks is Advance,SSP

i want to create the interface like this but i don't know how to create the interface with this type of format can anyone help me for this, i want clickable links in the interface for that what i want component i want to use.

Hi All, When starting to run a health check, getting below expression error: Expression evaluation error [evaluation ID = 2f8ea:98060] in rule 'ahc_ui_requesthealthcheck' at function 'gethealthcheckcollectionstatus' [line 67]: The function 'gethealthcheckcollectionstatus' is unavailable. Could you please advise on what needs to be done and steps to be followed on how to run the health check from admin console?

I started the process with an interface (Create Exam) and then I want to store it in the database, but I guess there is some problem with the database or Record type, Can anyone please help me understand what I am doing wrong?  

Hi Everyone, I have a requirement like. Action dropdown with value Approve Reject Terminate Comment paragraph filed Use Case 1 – If user select Approve from action dropdown, Comment field should be optional.(non-required) Use Case 2 – If user select Reject or Terminate from action dropdown, Comment field should be become mandatory (*Required field) We have below code, a!localVariables( local!selectedaction, local!comment, local!submitClick, local!isActionChanged, local!previousSelection, a!formLayout( label: "Form", contents: { a!sectionLayout( label: "Section", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Action", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: { "Approve", "Reject", "Terminate" }, choiceValues: { 1, 2, 3 }, value: local!selectedaction, saveInto: { a!save(local!comment, null), a!save(local!submitClic

Hi, I have a below expression rule and it is working fine when I tested. But, when I try to use inside an interface, I am getting an error. Anyone is having any idea on this? Thanks.