General

Hello All, We have 21.4 version running on our server and  have two languages locales enabled en_UK and en_US We have a requirement to set the Locale settings especially primary locale to en_GB for all the users on Appian one time ...Currently its not consistent across the users. how to do this one time for all users ? Regards Shiva

Hi,  Suppose, I am adding some users to a group using an interface and when downloading that user names as Excel format I want the user names to be separated by comma in my excel sheet. Can anybody help me how to do it?

Hi team, I have scenario where I need to upload the excel documents, By using the excel data, I should get the data into my interface. example in the below format, 1.I should get the drop down to the Field type component (if i give the drop down field in the excel)  Can you please guide me for this scenario.

In my Application I can't load files to appian regardless of formatting (ie. Excel, pdf or word files). When I upload a file. The file will start to load but right before it completes I get the error as "The file null could not be uploaded. Please try uploading it again". I didn't changed any code recently in my application but I don't know why it's occurring. Please help me to solve this.

I'm aware that given a starting and ending date/time and a calendar, it will calculate the business hours between those two days, not including weekends/off hours if indicated in your calendar. In our calendar, our business days are 12:03 AM to 11:59 PM (as per business requirement), which means there is 23.95 working hours per day. Are these working hours rounded when calworkhours() generates a value? Are they rounded up? Rounded down? Is each working day rounded first or rounding happens after all the working hours are added. Any help is greatly appreciated!

load( local!counter: 20, a!cardLayout( contents: { a!forEach( items: enumerate(local!counter)+1, expression: { a!cardLayout( contents: { a!richTextDisplayField( value: a!richTextHeader(text: "Counter" & fv!item) ) }, shape: "ROUNDED", padding: "STANDARD", marginBelow: "STANDARD" ) } ), a!cardLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextIcon(icon: "repeat", size: "MEDIUM"), a!richTextItem(text: " Load More", style:"STRONG" ) }, align: "CENTER" ) }, link: a!dynamicLink( saveInto: {a!save(local!counter, local!counter+20)} ), height: "AUTO", style: "ACCENT", marginBelow: "NONE" ) }, showBorder: false(

Hi, I am a newbie to Appian and i have been exploring the various functionalities. I have an Interface (lets' call it Interface A) that uses "Dynamic Link" to add/remove rows in a editable grid. The interface works fine when i test it out in Design/Expression mode. I also have a record type with several views. I added the above Interface A as a view to this record type. I then opened the view by going to the site but for some reason i could not add any new rows. Not sure if i am missing anything. Thank you for the help.

Does Appian application support branching, labeling, merging features using Appian versioning Manager? For ex. we want to go to previous release and meanwhile we have added new artifacts into application, will it be possible to move to actual previous application while working with Application versioning manager with Git.

I've a requirement to make available a number of PDF documents within our UI, that the users can download as and when they wish.Initially I sorted this by saving those docs in Appian KC, along with an associated DB table that stores amongst other things the docID. At run time I simply make a call to the db table, get the doc id's and then generate the list using a!documentlnk. a!richTextDisplayField( value:{ a!richTextIcon(icon:"newspaper-o", color:if(fv!item.priority="1","NEGATIVE",{}) ), a!richTextItem( text:" "&todate(fv!item.updatedon)&" "&fv!item.message, link:if(toboolean(fv!item.islink)=true(), {a!documentDownloadLink( label:"download",document:fv!item.doc) }Works great.However I want to expand this to capture which of the docs are being downloaded and are true FAQ's vs ones that simple dont need to be taking space. Ideally I thought to use an a!saveinto and write the pertinent into to another d

I have an app for site surveying equipment that produces a task which is going to be completed primarily on mobile, often offline. Since the task could take multiple days to complete I added the 'Save Draft' button to the interface from the process model. On desktop it works as expected, I can hit the save draft button, exit the task, then go back in and pick up where I left off with all the previous data still there. However, on the mobile Appian app, when I hit this button the data is saved properly, but the task then closes. Since I experience the occasional app crash with the Appian mobile app, I would like to be able to save my work periodically without having to exit the task each time. Is there a way to prevent the 'Save Draft' button from closing the task in the mobile app? Thanks in advance!

how to give action to the Icon, such that onclick it should add the card layout above the icons column layout?

dependent and precedent errors in exporting application

Hi Team, I am getting special character i.e ";" in empty field, how to remove the special character and save the value? Already tried stripwith() and it is not working as expected.

Hi Team, I have an excel template in which i need to map values to the particular cell positions like {B2,B3,B4,E2,E3}; that are being retreived from a table. I am getting all the data in single row currently even after giving the cell keys. Any suggestion? Thanks Anandita

Is there a way to query up who is assigned to a particular task? I've got a process report, but I'd like to somehow pull the assignee for a particular task out of that for use elsewhere. What is the best way to do that? 

Good afternoon, We used the node Send File Over SFTP (com.appiancorp.a2.process.runtime.activities.sftp.SendFileOverSFTPwithSCSUsernameAndPasswordV2) Later we updated to version 2.2.1(Send File Over SFTP (com.appiancorp.a2.process.runtime.activities.sftp.SendFileOverSFTPwithSCSUsernameAndPasswordV3) and since then, passing the same values ​​in the input inputs, the shipment no longer occurs and gives us the following error: Does anyone know if anything has changed? A greeting and thanks in advance

Hello, I am trying to achieve below 2 things and need your help please. My form consists of 5 fields (ClientName, SubmittedBy, SubmittedDate, isSaved, isSubmit) which will be save into to DB table. 1. Form is having 2 buttons save and submit. On click of Save, it should save all the 5 fields with isSubmit=false in the database and the form should not be closed. On click of Submit, the isSubmit=true and the form is closed. 2. How to create a reusable function which is called from both Save and Submit button. That function should have the a!save code which will save the fields accordingly. The below 3 lines are called in both the buttons and based on from which button is called, it should save fields.                              fn (isSubmitClick) {                                              

in my database i have time in 24 hours format for example "8:00". when i create a query for this datetime what i receive is   a result with four hours difference how can i achieve to get it in the same time zone  as the database

My scenario is to check the date past 45 days.  todate(now())-local!creat_dt return intervals(days to Seconds). How to retrieve Days from it. Or is there an other solution to find?

Hello, I am getting the below error when querying a particular table from the application. The entity I am querying is a nested CDT.  Expression evaluation error in rule 'dcm_getproductbycaseid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0] Server Log file Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0]) (APNX-1-4164-025) at com.appiancorp.type.external.teneoimpl.QueryRuleExceptionHandler.handle(QueryRuleExceptionHandler.java:50) at com.appiancorp.type.external.teneoimpl.TimedWorkRunner.run(TimedWorkRunner.java:62) at com.appiancorp.type.external.teneoimpl.TeneoQueryExecutor.execute(Te

Hello Everyone, I am getting the following error when querying one of the table from application. The entity I am querying is a nested CDT.  Expression evaluation error in rule 'dcm_getproductbycaseid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0] It is an existing CDT which used to work just fine. The only recent change I have made is increased the column length for some of the fields in the table and removed the length parameter from the xsd annotation. Could it be the issue? I am able to get data by sql select statement. Please help if anyone knows or have experience on how to fix this issue. Thank you.

When searching for objects in appian, is there a way to exclude something? Like if I was going to Google something, for example, I could search for "fruit" but not "apples" by typing "fruit -apples" is there some equivalent in Appian? Most of the objects in my application have a specific prefix and I'd like to search for the ones that don't have that prefix so I can eliminate them. 

Hello There, How to upgrade to Appian 22.1? I am using the free plan 

Hello Team, I am trying to create a new view with expression rule or sql script that will include the sum(PaymentAmt) for cases where directDepositTF is 1. For example in the attached image, caseId 138465, I would like a view that sums the amount in paymentAmt column into a new view. Thanks

The project I am working on has a specific use case where they export a excel sheet and then convert that into a PDF from there. The excel sheet doesn't necessarily hold data. It holds data in the sense that fields are highlighted. My question is for the example attached is it possible to recreate this using the document generation/management tools or any other tools within Appian? If so what would I be looking for and how would I accomplish this? Attached is an example about states vs what foods they like, don't like, or indifferent as example data. What could I do to recreate an appian export of this data and it changing if I have a field that says if fries are good and burgers are bad etc.