Discussion Categories

Hello, Having two environments (PAM and PRO, both on cloud), I want to copy the database schema from PRO to PAM under the name "Appian_pro". After that, on PAM environment, I want to delete the "Appian" schema and rename the copied schema as "Appian", all of this to operate with Pro data on PAM.Would be possible to perform these steps? Thank you in advance. Regards

Hello,  Does anyone know if it is possible to make a related action visible or not depending on the user?.Because I want only the user who performed the action to be able to edit it again, this is my table Thank you very much

Hello, I have been struggling with an issue for almost 2 days so far. I have an integration in a process that is triggered by a web API. I am repeating this integration up to 5 times the response was not successful. In the case where the response of the integration is successful in the first time, I am getting back the required response that is a json format that I am indexing from a process variable. In the case where the integration is repeated twice or more, the response I am getting back is empty as if the process variable was returned as a null value. The response i am indexing is the variable where I am saving the httpresponse from the integration. So again, if integration goes through from the first time, the response is filled, if it goes through on the second time or more, the response is empty as if the web API only considered the first value saved in the variable where i am saving the httpresponse and it's not updating it; and when i check the process variable

Hi, please archive? thank you!

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.

Does Appian SAML SSO work with http (not https) IDP requests. Is it mandatory to have all the systems running under https rather than http to be compatible with saml SSO? What is the rule?

Hello: I am trying to use a!writeRecords() to write a list of records (of the same recordType) to the DB and it is writing a column of one-field to each field in the DB (images below).  The debugging section shows the values before I click on 'Submit'.  The second image is the data in the DB (Data Preview screen). My understanding was that a!writeRecords smart service would insert two records - one for each row of information.  Obviously, I am not correct in my understanding of the service.   How do I get each row to be written as a record in the DB? As always, thanks for the help! a!localVariables( local!userSelection: null(), local!ListOfOptions: rule!FST_getGuidelines(), local!ListOfChoiceValues: enumerate(length(local!ListOfOptions)) + 1, local!ListOfCategories: {}, a!formLayout( label: "Category Management", contents: { rule!FST_UserSelection( ListOfOptions: local!ListOfOptions, ListOfChoiceValues: local

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

Hello team, I have a requirement where in the from there is a section where user need to fill order details (item, price, quantity). I need to provide an option to user to fill these details manually (this part is done) or by using an excel template. The tool should be able to read the content of the excel and fill it in the form before submitting the form itself. I know there is an excel plugin to read content but if I understand it correctly it can be read only after submitting the form. Is there a way how i can enable for the user to lead data form excel without levaing the form (staying on the same screen)? Thanks for nay answer

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  .

How to show Record Sync History on the interface as read only?

My needs is to check if other user is standing on page, so in this case i cannot edit data on it. Is there some functionality to check that the record summary page is in use right now? Thanks for help!

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!

I am trying to use a!writeToDataStoreEntity   to write to into a database , if one on the fields is a (foreign key) which is an auto-generated primary key of another table in the "same interface ", how can i pass it to the other table when it  hasn't been generated yet?   

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,  For the creation of Users in Appian, what the different validations for it. Please help me with it. E.g max char for the firstName and lastName Thanks

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]

Would it be possible to remove any option from the dropdown on the filter? Also, we have created a ‘Custodian’ dropdown and are passing that value into the record filter to filter the records dynamically. However, there seems to be an issue when we export, such as not showing that value in the filter because that value is not part of the filters. Would it be possible to set that value programmatically?

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?