Foundation

Hello community, I have a problem with multipleDropdownField component that should show the list of options depending on the list of selected items in another multipleDropdownField. Then based on selection data should be displayed in Grid. Can someone help the code.

Hi, I have created a view to display it in read only grid.  There is huge amount of data that needs to be retrieved and displayed. But when am writing simple query to fetch data am getting error: a!queryEntity( entity: cons!AB_DE_V_DD, query: a!query( pagingInfo: if( rule!APN_isEmpty( ri!pagingInfo ), a!pagingInfo( startIndex: 1, batchSize: 50 ), ri!pagingInfo ) ) ) Error: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Can someone help to sort this issue. Note: When am using filter to retrieve data, am not getting any error

I tried to hide some components inside interface when the user logged in from a phone, and test it usnig appian mobile application, but it still show the components while the user is using the mobile applcation

We are in need to use mobile push notifications notifications on certain events, but the issue is that we are on on-premise environment and Mobile push notifications are only available on Appian Cloud. Is there any suggestions or other ways to achieve the mobile push notifications service in self-hosted or on-premise ?

I am using below logic to convert and display  Source  location ID to Source Location name in Read only grid but when am using same logic while downloading Excel sheet. Its providing me  Source location ID instead of Source Location name. Is there any way how i can get Source Location name in Excel Sheet. a!gridColumn( label: "Source Location", sortField: "SourceLocation", value: { rule!ABC_DE_getLocationNameBasedOnLocationId( locationId: fv!row.collectionfromlocationid ) },

Hi All, Objective: Get History details of selected Ticket Number from table row. Process Model: Step1: Get & Show latest Ticket Number details data step2: Store the Old ticket data and changed data into Single table(can be two tables),so that there will be two/more entries for same ticket. Need Process model and its related script/ steps guidance on above requirement. I have already built process model to achieve step1 above and able to update one  ticket, but addin one more updated  entry for history   seems difficult Please let me know if required input information is not clear. Thanks, Deepak

I have two sections in the same form as- Section 1. Shows Ticket details on form with on selecting table row from a table(achieved this) section 2. shows updates history for selected ticket.(Not sure how to do using process model design ?) I have a process model used in record type having table to show tickets list and update a single ticket details when selected, which is working fine, he I have single CDT mapped to DB. How to achieve section 2 is my challenge? Here, on loading form having data populated need to store copy of record before submitting and update entry in the same table(can use two table if needed) Can be multiple rows to show ticket history in table below- 

Hi Everyone, Can somebody please help me with the below query, In my project, we are currently working on Private Network and we are slowly planning to implement Appian Cloud instance in our project. We have decided to connect the Appian cloud using Saas service. However, we wanted the dedicated Appian cloud instance to be only accessed from our private network. i.e. the dedicated Appian Cloud URL should not be accessed from any other network. Also, we wanted to know how does Appian Saas validates the connection made from our network. i.e. in terms of Appian RPA, if the bot installed in the system (Private network) communicates with the Appian server, how does the Saas service validates the communication. Please let me know. Many thanks.

i want to use temasysField() in  premise, but it dose not show any thing in the interface.

Hi Guys , getting readexcelsheet function error at interface level , need your suggestion to resolve, Interface Definition: Expression evaluation error at function 'readexcelsheet' [line 41]: Thanks

Team, I have a date component in editable grid and on that i an using validation to check if same data exist in DB for a country when user changes the existing date in grid. After changing i am seeing that all date component in the entire grid is getting validation message rather the one updated . Any idea why ?

I'm using ADT and generating several templates and then converting multiple PDFs into a single PDF document using merge PDF plugins. During this process, pagination is not consistent across. Eg:- 1st ADT to PDF has 5 pages and they are named 1, 2, 3, 4 and 5 2nd ADT to PDF has 3 pages and they are named 1, 2 and 3 When merging the PDFs, a single PDF is generated as expected however the pagination is not continuous i.e., 1,2,3,4,5,6,7,8. Instead it shows as 1,2,3,4,5,1,23 Is there a way to fix this issue? Is there a plugin that can take a single PDF document and apply pagination to it. Appreciate your suggestions!!!

a!localVariables( local!Leave: 'type!{urn:com:appian:types}HN_AS_LeaveDetails'(), { a!gridLayout( label: "Leave Details", labelPosition: "ABOVE", instructions:"Please add the records", headerCells: { a!gridLayoutHeaderCell(label: "Employee Number"), a!gridLayoutHeaderCell( label: "Leave Type" ), a!gridLayoutHeaderCell( label: "From Date" ), a!gridLayoutHeaderCell( label: "To Date" ), a!gridLayoutHeaderCell( label: "No Of Hours" ), a!gridLayoutHeaderCell( label: "" ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "NARROW" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "NARROW" ), a!gridLayoutColumnConfig( width: "ICON" ) }, rows: { a!forEach( items: ri!AS_LeaveDetails, expression:a!gridRowLay

Case: I have record type that connected to an Employee data store entity which display all the records in the database under 'Record' tab. In addition, I have created a filter for the employees to filter all the records that are assigned to them. Now, how should I make this grid bulk editable? What I want to Achieve: Now, once employees filter all the records assigned to them through the given filter then they should be able click on Edit button and update the all the records simultaneously in the grid view. Any help would be much appreciated!

Case 2: Process Model with three "Write to Data Store Entity" Adding the Same data multiple times in the data store entity: Step 1: I have a Process model which takes input from the User through an interface and add record to the data store entity (X).  Step 2: Using the user input field, the process model assigns the task to the approver for updating certain fields. Now, Approver updates the required field for the same record (Using second Write to Data Store entity to store the data here to save Approver's updates). Issue: The second Write To Data store Entity is adding a new row in the data store entity instead of updating the same record. So, how to pass the ID variable among different "Write to Data Store Entities" in the same process model? 

I have one table say A, with location { delhi, patna, kanpur} and it's location id is {1,2,3} . I also have another table say locationjourney in which a person xyz travels from location id 1 to 3 and another person abc from 2 to 3. Now I need to display: person name(xyz)and location from ( delhi) to( kanpur)

Hi, I have created a view and then displayed the value in Read only grid. Every thing is working fine. But there is no ID field which will display 1,2,3,4...based on number of Rows. Is it possible to add it from Appian Side(because there is no ID field in Database)..

Hi All, I need to find the common values from one List of Text String to another list of string . I have tried to use foreach but still there is no luck  !

Can someone help: CASE                                WHEN ISNULL(pr.[isDefunct], 0) = 1 THEN 0                                WHEN ISNULL(pr.[isCancelled], 0) = 1 THEN 0                                WHEN ISNULL(ab.IsEscorted, 0) = 0 THEN 0                                WHEN bc.Movement <> 'CR Movement' THEN 0         &n

Good day, Im new to appian and Im currently doing the Appian Developer Skills Practice Application. In the part where Im suppose to create an Interface that has a column chart, the guide says to select a data source in the component configuration pane. But as seen in the screenshot below there isnt one. Can anyone help me or point me to where I can find this option. Thanks [emoticon:6d505171faa4497c85c5ca27290c555d] P.S. This is the data source option that I cannot find

Hi All,      i have written an interface code , which calls an query entity multiple time , because of which sometimes am facing Query timeout issue, Please help me in Optimizing the code with( a!localVariables( local!dcSelectedrole : ri!dcSelectedRole, /*super admin variables starts*/ local!superadminPOCdata: if (rule!APN_isBlank(ri!programId), {}, rule!CMP_getChartDataprogramLevel( roleType: "SuperAdmin", programId: ri!programId, type: "POC", typeValue: "1" ).data ), local!superadminNonPOCdata: if (rule!APN_isBlank(ri!programId), {}, rule!CMP_getChartDataprogramLevel( roleType: "SuperAdmin", programId: ri!programId, type: "POC", typeValue: "2", pagingInfo: ri!paginginfo ).data), local!superadminGenderFdata: if (rule!APN_isBlank(ri!programId), {}, rule!CMP_getChartDataprogramLevel( roleType: "SuperAdmin", programId: ri!programId, type: "GENDER", typeValue: "1", pagingInfo: ri!pag

the provided ur is not working how to hit the url to display the content in DB

Hi All, I have state and county drop downs when changed states loading respective county in 2nd dropdown i.e.county dropdown. When i selected county value and tried change state value, getting error as - intterface Definition: Expression evaluation error at function a!dropdownField [line 76]: A dropdown component [label=“County”] has an invalid value for “value”. All selected values must be present in the choiceValues array, but value was Beaver and choiceValues was Carson City; Churchill; Clark; Douglas; Elko; etc... saveInto:  {ri!PTS.state,a!save(ri!target:PTS.County,value:null)} Thanks, Deepak

Hi team, My use case requires me to select multiple options like: north, south, east ,west which am able to configure and it's working perfectly. But there should also be an option to select all(I.e North, south, east, west) and based on it data should be displayed. Can someone help with the code.

Hi. I am looking for a way where I can filter down the objects in designer using the created by attribute or filter them between a date range of creation and NOT modification.Similar filters are available for modified by and modified on date range but is there any way to filter the objects by created by, or creation date? Thank you in advance.