General

Hi Community, I got an issue regarding "Export to Excel" button in the record type. The button is clickable but no action happens. However there are 16,000 rows there and the source is data type. Also, it happens to some users but it fails for me. We are all using chrome (although I checked Microsoft Edge and it is the same). Could anyone suggest a solution please ? Thanks in advance.

I have a custom VB script which I need to execute using Appian. Does Appian have resources to do so? What are the steps I need to take to execute the script?

i am creating record type (Source as web service )Also Created one expression rule as written in code snipet a!localVariables( local!result: rule!JTV_intCustomFieldsGET(), local!rows: if( condition: index(local!result, "success", false), valueIfTrue: local!result.result.body.values, valueIfFalse: {} ), a!forEach( local!rows, a!map( projectId: index(fv!item, "projectIds", {}), customFieldName: index(fv!item, "name", {}), customFieldId:index(fv!item, "numericId", {}) ) ) )But it returns output like this by doing like this project id will be blank in record type or i have to to join array to make it comma separated in record type ..... But out put required is like  MapprojectId 18800(Number (Integer))customFieldName"2nd Outreach"(Text)customFieldId28306(Number (Integer))MapprojectId 12405(Number (Integer))customFieldName"2nd Outreach"(Text)customFieldId28306(Number (Integer)) MapprojectId 11000(Number (Int

I have a process model that opens an interface to "update a request."  I called the process, passed the parameters and the rule expression to fill the form of the previously entered data which the user is going to update. when i click edit, the interface shows up , but when i click next or cancel or any other button, it says " Action completed "  and then closed the interface and returns to this page.  Next or cancel are not the end of the form , next is supposed to take me to the next slide,  and the button works perfectly on the page that i am calling using the process model.  "Next" is supposed to take me to the next slide to make the user update the data. 

Hi All , In the attached Screenshot, two values are shown for the project ID, and I want the custom field name to repeat itself twice and the custom field id to repeat itself twice as well.  I've added code snippet to what I've currently written for reference  and  Output should look like this  map project id  list of number(integer)-2 items   18800 (number(integer))    12405 (number(integer)) customFieldName  list of (Text)-2 items    "2nd Outreach" (Text)    "2nd Outreach" (Text) customFieldId. List of Number (Integer) -2 items    28306 (number(integer))    28306 (number(integer)) a!localVariables( local!result: rule!LGH_intCustomFieldsGET(), local!rows: if( condition: index(local!result, "success", false), valueIfTrue: local!result.result.body.values, valueIfFalse: {} ), a!forEach( local!rows, a!map(

Hi everyone, I would like to export my app from dev to prod environment. In the 2 different environments there is a folder with the same name but containing different files. I would like to delete the current app in prod and replace it with the updated version of dev, but keep that specific folder that already exists in prod, then replace the same folder of the app imported from dev to prod with the files I need, keeping the same UUIDs of the documents contained in it and also the other information. It can be done? Or can you download a folder from a specific development environment on the local PC and then upload it as a zip file to the desired environment without changing the uuids? What is very important for me is that the uuids do not change. Thanks in advance

I have created a PM to get Json data, next I have created a webApiPost Start Process, I have tested the request, status code:200, after filling the body {} with json data, is passed to a process variable. But the purpose is to store all the data with mutliple table, through one CDT.

How I know what are the new objects come in Appian 23.3 and 23.2 versions  Please share me docs.appian.com page link for new release of 23.3 and 23.2 versions

Hi, Please suggest some links or videos where i can learn how to create Suite page, test page and what is significant. how to maintain test scripts  for an applicaton. Thank you in Advance.

a!localVariables( local!maxData: a!queryEntity( entity: cons!ISP_DSE_CAPACITY_CONFIG, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "startDate", isGrouping: FALSE, aggregationFunction: "MAX" ), a!queryAggregationColumn(field: "distCenter", isGrouping: true), } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "distCenter", operator: "=", value: ri!dc, applyWhen: a!isNotNullOrEmpty(ri!dc) ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: false ).data, local!date: tostring(index(local!maxData, "startDate", null)), a!queryEntity( entity: cons!ISP_DSE_CAPACITY_CONFIG, query: a!query( filter: { a!queryFilter( field: "startDate", operator: "=", value: local!date, applyWhen: a!isNotNullOrEmpty(local!date) ), a!queryFilter( field: &q

Hi Team, i have a user task which has to complete by a set of Users in a group. i used MNI in other tab for the task and selected as shown below but when i debug the flow its working same as group. i mean once a user is accepted this task. its completing. could you please help me in implementing  a user task which has to complete by a set of Users in a group(Everyone in the group have to compete the task )

We have a use case where we want to try and show a pop up in an interface, and then based on the action performed in that pop up we want to save specific values. For the pop up we're calling a recordActionItem in a recordActionField. Is there a way to pass values back out of the record action once it's been completed and access them in the interface? And is it possible to somehow call a list of saves in the interface after the record action has been completed as well? Thanks for any help!

Hi, I noticed that in write records it only saves primary key, what if i want to use other fields in next set of forms do i have to query record or there is a way ? Regards  Chandra

Hi there, I have the following information in a paragraph, need to send this information in the email body. in the "send email" smart service, tried this: substitute(tostring(pv!newComments), "cha(10)", "<br>"), it does not work, all the informaiton are in one line in the email body. could anyone know how to do it? thanks. L

When I click on the link in row in read only gird, I want to open the summary interfacebut the code does not work, what is the problem?

When I click on the link in row in read only gird (the data from cdt not record Type), I want to open the summary interfacebut the code does not work, what is the problem?

Hello Everyone , I have one issue in process model it saying  "Document Does Not Exist or has been Deleted) (Data Inputs)" we have added a condition like documents exist or not if exit we are taking document name by using Document() function . when we validate the document by using  getcontentobjectdetailsbyid() we are getting below result. "Content Object [Name: Bill.jpg, UUID: _a-0000eae4-0751-8000-9d71-011c48011c48_24018957, Parent: Temporary Documents Knowledge Center, Parent Id: 7, Type: Document, Latest version: 1, State: Invactive Published, Internal file name: N/A]" but I'm not able to find any document in MY KC. and it is saying "State: Invactive Published," what it mean and how we can fix this issue ? Thanks  Saikumar

Hello Everyone, Does Appian allows the user to upload any password protected document into its cloud instance?  We have a requirement to upload the password protected file but when we try to do it through File Upload field or simply add it as a document within the application objects, it throws the following error: "File could not be uploaded. Please try uploading it again" Note: We do not have any restrictions applied in our Admin console in the "File Upload" section. Thanks in Advance, Nandini

Hi everyone, I have a column storing Date Time values but is now Varchar type in DB, eg. 2022-09-12 03:53:33 (varchar(19)). I want to format it to 9/12/2022 03:53 AM Any recommendation? Thanks a lot for your help :)

Deploying application first time from dev to test environment giving error in record type. Below is the screenshot. I have checked this record type is present in the deployment package but still showing missing precedents. Also, connected system is also part of the deployment. Do we need to deploy connected system individually first and then need to deploy rest of the package?

Hello All, i am trying to filter the record which has been created in the 1st half of that particular month. So basically,  I have a record with a column "Created on" (Data type). on this column, i have to apply the filter to get the records which have been created in the 1st half of the month. For eg. if record created on "11/10/2023, it is created in the 1st half (Before 16th October and so on.

Hi I need to implement a use case, where I implemented links to view document and download document links. So that, I can capture the user response and use it for audit purpose. Like how many times document is viewed and how many times document is downloaded.  When user clicks on view, I have used documentViewerField and users can able to view. For pdf documents, users can download the document from the pre-defined options on the component. Like (download, print) etc.  Is there any way to hide those options? Like disable download or disable print option.  Kind Regards Rahul Gundu

Hi my query is working fine for the last 9 months and now it is showing errors as below: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DetailViewDT3872], query: [queryentity expression], order by: [[Sort[AccNumber asc]]], filters:[null])  I built a new constant and it still did not work. Could you please assist why it is starting to show this error and how to fix it? this is my query: a!queryEntity( entity: cons!Detail_View, query: a!query( selection: a!querySelection( columns: {a!queryColumn(field: "AccNumber")} ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true ).totalCount

Hi Team, I am Looking forward to learn Advanced topics like data analysis and prediction Algorithms in appian by implementing the below Explained Proof of Concept (POC). 1.Data Analysis and Prediction of sales: The progressive stock control, quote to buy, and conveyance system designed for Organization XYZ utilizes data Analysis and predictive algorithms to upgrade stock levels in light of past sales and future forecasts. 2.Quote to procure: When goods become scarce, the system first investigates internally for spare parts, producing items if parts are available. If not, it autonomously puts in orders for spare parts with providers, assessing cost and delivery offers from numerous vendors to make an informed judgement. 3.Logistics: Once procurement is finalized, the system meticulously plans shipping, streamlining paths and techniques of transportation to guarantee on-time delivery of components. I need you inputs and suggestions to learn and implement this POC. Regards J

i have a use case, where i need to display two arrays - a before and after if you will. local!array1:{"Dog","Cat","Mouse"},local!array1:{"Dog","Cat","Mouse","Elk","Rat"} ideally i'd like to display them in a grid, so that the user see's a nicely formatted list - which I can then add some functionality too. Something like :----BEFORE---- AFTER-------------------------------------------Dog     ----- Dog -------------Cat     ------Cat ---------- ----Mouse ---- Mouse ----- ----NULL ------- Elk ------------Null ------- Rat ----------However / whatever i do, i keep tripping over that the gird only really wants to parse one data array. if i try using the two different arrays in the row then I soon trip over having different array lengths.Any ideas ?