Foundation

Hi,        I have a cdt in which a column is SNO as          SNO   name            1       abc            2       def            3       ghi            4       jkl  I want to update only SNO as 2,3,4,5  and it should be 3,4,5,6 . I don't want to update 1 . Which logic i should write?

I need to convert seconds to hh:mm:ss.  For example, 5565 seconds would be displayed as 01:32:45.  Does anyone have a good way to do this?

Hi All ,  I am using a a!gridField , in that one column is there having multiple values . I just want to make taht particular field based on show more and show less . so that it shoould not be conjusted to see .  a!gridColumn( label: "Decom Site(s)", sortField: "siteids", value: substitute(fv!row.sites, "|", char(10)),align: "START", width: "MEDIUM" ), fv!row.mob contains  AA000000 AAAAAAA AAAAAA AAAAAA AAAAAA AAAAAA AAAAAA and many more  Thanks in Advance 

Hi All, I have a Interface in which I have created approx 10 filters . What I am facing a problem is that I am having a  drop-down say "Select filter"  field in which I have 10 names , what I am achieving is that based on selection from "select filter" I am showing the filters . All the filers I have kept in For each loop , the main problem is there is that I am having 4 filers as date field and rest as drop-down . When I am selecting the filters from drop-down list all is that if am selecting All drop-down filters that they all are in same line that is looks perfect but when I am selecting one drop down and 2 date filters they look like messy means the arrangement is not looking good .. How can I achieve this .. Thanks in Advance

Example of Brush with Area chart observablehq.com/.../focus-context Example of Treemap https://observablehq.com/@d3/treemap Its our requirement can this integrated with Appian ... Thanks

Hi, We are using the Hemberger icon with large menu. We should be able view menu on-mouse over, How we can achieve this in appian ?

Hello, I have a record type, where I can open a dialog box with the interface A to modify a form.I want to know if it is possible to open another interface, by clicking a button I made in the interface A?In the process model, I have a User Input Task, but that does not open the new form interface. Thanks, Best Rewards, David

Hi there, I have a list of applications (n) which have to be equally distributed amongst users (n). Say there are 10 applications and 3 users where application is a CDT and I am using updatedictnary () for setting application.user : user1. Distribution should be like -->  application 1 : user 1 application 2 : user 2 application 3 : user 3 application 4 : user 1 application 5 : user 2 application 6 : user 3 application 7 : user 1 application 8 : user 2 application 9 : user 3 application 1 : user 1 How can this be achieved using only foreach? or is there any better way to do it?  Something I tried  local!i:1, local!UserList : {touser("ABC"),touser("PQR"),touser("GHJ")}, local!UserCount : count(local!UserList), a!forEach( items: local!LoanApplicationList, expression : updatedictionary( dictionary: fv!item, fieldsAndValues: { ApplicationUser : if(local!i=local!ListTotalUserCount, { local!i:sum(local!i,1),

Here in line no 350 for choice labels I need name and for choice values I need ID but in choice values when I am giving here its throwing me the above error. Can anyone let me know hw to solve it.

Hi All,  I have a column  name created date in db as datetime . When I am creating filter in expression rule as createddatefrom and createddateto . I am not able to filter it .  Expression Rule: a!queryFilter(field: "createddate",operator: "between",value: {todate(ri!createddatefrom),todate(ri!createddatefrom)+ day()},applywhen: not(rule!APN_isEmpty(ri!createddatefrom))),a!queryFilter(field: "createddate",operator: "between",value: {todate(ri!createddateto),todate(ri!createddateto) + day()},applywhen: not(rule!APN_isEmpty(ri!createddateto))), Please help and thanks in Advance

Hi all, I'm working on poc, i have an appian process which needs to be triggered only when new items are added in the database.

I have a situation where we are assigning individual named users to a task from a database by role but the task isn't visible.  When I look at the process instance, there is no error showing with the task itself except there are no assigned users showing in the assignment tab.  Is there a limit to the number of individual users that can be assigned a task? The users are part of groups in Appian but the task is assigned to individual users instead of the group. 

Hello, I want to insert a list of a CDT to the database. In an Interface, I create that list, and after, I want to insert multiple rows to the database (one for each item of list).How can I accomplish that?That interface is connected with a Process Model.With a forEach in the Interface, I can only insert 1 value, I think.It is possible to do a cycle to iterate the list in the Process Model?Thanks, David

Hi Everyone,  In Process model write to multiple data store Entity is breaking with this format error :---> error converting typed value TypedValue... to XML in order to convert it to java type " while saving .Please can anyone help me out in this and suggest .

Hi,       I have the following table as        sno     product    --------     -----------        1           product1        2           product2        3           product3        4           product4        I want to interchange the first two rows product sno as    2 for product1 and 1 for product2 and store the updated values in cdt again How can i do that?

So we want to invest in creating a print button that just calls javascript window.print().  Putting this in a customer interface component won't work, right?  The interface component cannot access outside it's context. What are other options?  Deploying a servlet with print that takes in the url for the form?  But then the form url has to be known each time and won't work for printing tasks, right?

I have a reference CDT for organization details. Here my requirements are when I select an organization name the tax id and address should be prepopulated.  Is there any way to get this requirement done!

Hello Guys, I am having a code which will generate a rating icon based on the input integer. So far its working fine, When I try to make the input as a array by click on the checkbox and gave 2 more input rating there shows an error. The first picture is the error one and the second one is the rating output when it is given a single input value, Thanks in Advance.

Hi!So, I have an interface that displays multiple items with some data about them, can i do something so that when i click it (for instance de name or picture of the item) it goes to another interface with more detailed information? Thank you

My use case is as follows: I have a CDT of dates and number of days.  I have the first date, but the others are not populated yet.  My goal is to populate each subsequent date with the previous indexes date + the number of days of the current iteration. For example I start with the following: {9/27/2021, 0}, {null,3}, {null,5} I want the output to be as follows: {9/27/2021, 0}, {9/30/2021,3}, {10/5/2021,5} Each iteration will reference the previous iteration's date to generate its own date. I appreciate your time and help!

Hello community, I wonder if this a bug or I am doing something wrong.we use Appian 20.4. If I try to get the data of a map using index or property it always returns default value when present.This behavior only occurs in the process model and not in a expression object.e.g.pv!testMap: a!map(errormessage: "something went wrong"), then this code property(pv!testMap, "errormessage",  "default") or the same using Index function.Will return "default". dot notation works: pv!testMap.errormessage wil return: "something went wrong".property or index without a default works: property(pv!testMap, "errormessage") wil return: something went wrong". Maybe I overlook something, got it working by the way by casting the map to a map but that makes no sense off course. Kind Regards, Erik    

Need to restrict the document type while uploading a file in Portal forms. Please help how to do this in portal forms? I am aware of the SAIL form file restrictions. Please help with portal forms how to achieve this.

HI Im getting this error one the process model of Export Data Store Entity to CSV An error occurred while attempting to setup the export for ADDRESSUPDATE. Please contact your system administrator for additional details. (APNX-1-4505-054) Any ideas? Thanks Neil

Could someone please share any Appian Artificial Intelligence (AI) use cases within the the U.S. Government space? 

Hi All, I am facing one issue in dropdown field. I have 4 interface and dependency is mentioned below: 1 is calling 2 and 3 inside 2 i have a ruleinput called ClickedTileNo Inside 3 is calling 4 inside 4 i have Filter and Grid (I am passing this ClickedTileNo inside this interface) Now in 4th Interface i am using dropdown as filter { a!localvariables( local!id: null, local!name:null, local!data: rule!getdata(id:local!id, name:local!name, approver: if(contains({1,2,3},ri!ClickedTileNo),1,0)), local!filter: rule!getdata(id:local!id, name:local!name, approver: if(contains({1,2,3},ri!ClickedTileNo),1,0)).data, local!filterId:{Union(local!filter.idt,local!filter.id)}, { a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "ID", labelPosition: "ADJACENT", placeholderLabel: "--- Select ID---", choiceLabels: local!filterID, choiceValues: local!filterID, value: local!Id, saveInto: local!id ) }, width: "MEDIUM" ), ) /*****