Foundation

i want to highlight these two duplicate values when a user enter a duplicate value. Please suggest me validation code.

Hi Team,I have a few doubts in start node triggers. My requirement is to trigger a process model when certain conditions are met. So, what we are doing is we created a interface for users to schedule the process when to occur. we storing the date & time in separate constants. Try 1: then in the process model start node trigger we added a time recurrence to daily and it's time to value from the time constant = pm!timezone and checking whether the date constant is today or not in timer conditions (advanced options) and delay to 0 mins. each time after the trigger the process model will update the date constant to future date. Issue: working for the first time only(while publishing) after the constant update its not working.Try 2: process model will trigger daily at 00:00 , a xor to check whether its today or not, and a script task with scheduler (delay until the datetime mentioned in the constant). Issue: if the user sets the schedule to 06:00 but trigger star

In my "Request " CDT  , i have a field named "branch" of type number.  I am trying to display the branch ID  on the interface , from the query "GetRequestData".  value: rule!GetRequestData(ri!documentID).branch, ri!documentID holds the ID of the request.  when I test the query it returns the data correctly, but on the interface it doesn't show. when i debug the process model it shows ((Cannot index property 'branch' of type String into type List of Variant))  i don't quite understand the error message. how can i display it correctly ?    

a!localVariables( local!selectedPermission, local!selectedArea, local!selectedComponent, local!selectedDepartment, local!departments: a!refreshVariable( value: rule!MECMS_getDepartmentList(activeFilter: true), refreshOnVarChange: { ri!refreshInt } ), local!area: a!refreshVariable( value: if( rule!APN_isBlank(local!selectedPermission), null, rule!MECMS_getRefArea( selections: {"id", "value"}, permissionId: local!selectedPermission, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ).data ), refreshOnVarChange: { ri!refreshInt } ), local!component: a!refreshVariable( value: rule!MECMS_getRefComponent( selections: {"id", "value", "areaId"}, areaId: if( a!isNotNullOrEmpty(local!selectedArea), local!selectedArea, if( rule!APN_isEmpty(local!area), -1, local!area.id ) ), pagingInfo: a!pagingInfo( startIn

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

I have "requestID" as a foreign key in 2 tables "attachment" and "Document"  i passed it as process variable through a task script. When i debug the process it works but it saves the foreign key "Null".  what might be the reason? 

Hello  How to pass the Values of the local variables to the Docx????   a!localVariables( local!data:ri!DocData, local!name:rule!SKJ_GetCustomerByAcc(AccountNum:ri!Number), local!resonDes:ri!resDes, /*to collect the data*/ concat( /*Parent */ "", /*Name*/ "", local!name['recordType!{a0871cca-bd3d-4d03-b9ce-d1652bfa9dc0}SKJ Customer.fields.{b06eb39c-bf2f-4bb4-b283-cdbb894e406d}name'], "", /*Reson Des*/ "", local!resonDes, "", "", datetext(now(),"yyyy/MM/dd"), "", /*for each*/ a!forEach( items: local!data, expression: "" ), "", ), )

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 when the process hits the Post comment to feed entry smart service it was errored out saying like below: An error occurred while trying to post a command or hazard to feed(entry id(1.840,280) Details: The supply feed entry (1,840,280) is not accessible (APNX-1-4181-100)  Kindly just on this

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 )

I am trying to determine the shift based on datetime. Here is the use case: Shift 1: 07:00 - 14:59:59 Shift 2: 15:00 - 22:59:59 Shift 3: 23:00 - 06:59:59 However, it’s not working as expected according to the current code that I have ( Please see the attached screenshot) . The date in Appian writes with GMT adjustment  .

I am getting an Invalid Process Parameter error in my interface, and i made sure that the parameters have the same name and type in both process model and Interface. what might be the reason of this error ?  a!startProcess( processModel: cons!GeneratePDF, processParameters: { customerNum:ri!customerNum, descriptionReason:ri!reqDetails.reasonDesc, data:ri!DocDetails, }, onSuccess: {a!save( local!pdfId, fv!processInfo.pv.CreatedPDF )} ), 

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 Guys, What is the most effective way to do error handling for multiple parallel API calls while loading the interface. Currently My code look something like this. a!localVariables( local!users:rule!APN_GetUsers().result.body, local!items:rule!APN_GetItems(id).result.body, local!info:rule!APN_GetBasicInfo(id).result.body, local!summary:rule!APN_GetSummary().result.body, {} ) If one of the API fails I will show some error in card. But how to effectively do this ? I need to this in multiple interfaces. [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]

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

Im getting Cannot index type Number (Integer) into type (DOCUMENT_DETAILS) - which is a cdt.  local!indexNum is  just a local a!radioButtonField( label: "Radio Buttons", labelPosition: "ABOVE", choiceLabels:rule!SKJ_GetForm( {} )['recordType!{228c141f-e2f8-4a93-bf0d-0dfed8c9c6b4}SKJ Form.fields.{af4b3fdd-a9a3-4ea7-82d9-8f16e323e35f}descEn'], choiceValues:rule!SKJ_GetForm( {} )['recordType!{228c141f-e2f8-4a93-bf0d-0dfed8c9c6b4}SKJ Form.fields.{d69bf265-893b-4707-965c-3512e6e1c9bd}itemCode'], value: ri!DocDetails[local!indexNum].docForm, saveInto: { ri!DocDetails[local!indexNum].docForm }, required: true, choiceLayout: "COMPAC

i want to cover the black space below the comment with column. And when we expend the comment then column size get auto reduce. 

I have a grid column which should be displayed based on a condition. When the condition is true it will show a grid as below. and when the condition is false it should not show anything but instead it is displaying as below. I haven't configured anything to display something like this in the interface.  Can someone please help.