Discussion Categories

Good day, I downloaded the Database Load Generator on the App Market and tried to import it on the environment, but I've been having data store error? anyone have suggestion/insights on how to solve this problem? I've also already added the plugins that are needed for this.

What is the reason behind this error? Can anyone suggest on this please?I have mapped the correct rules only. Thanks in advance.

a!dropdownField( label: "POL", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!polDetails.pol, choiceValues: local!polDetails.id, value: local!pol, saveInto: { local!psl, a!save(local!selectedSubPol, null) }, searchDisplay: "AUTO", validations: {} ), a!multipleDropdownField( label: "Sub - POL", labelPosition: "ABOVE", placeholder: "--- Select Values ---", choiceLabels: local!subPol.subPol, choiceValues: local!subPol.id, value: if(a!isNotNullOrEmpty(local!pol),local!subPol.id,local!selectedsubPol), saveInto: { local!selectedsubPol, a!save(local!selectedsubPol, null) }) error is coming when i am un-selecting the default selected values . can somebody help me on this

I am trying to import the calendar template plugin to my application as I would like to use the calendar component in an interface. However when I try to import the zip file, it is only importing the CT application and a couple of the folders but nothing else. I ran an inspection and got the above result. In the import log I am getting the reason for the error as "User Does Not Have Rights to Perform this Operation (APNX-1-4071-007)". How would I go about fixing these issues and importing the entire package?

Hi Team, I have a requirement to extract/read bar code from the user uploaded pdf file as part of the IDP process. Can you please suggest the possible solution to achieve this?

Hello, me and a colleague are trying to make a database where we have a table called "students" and one called "subjects", meaning many students can take many subjects. We've been researching for a bit and the way explained in the Appian Documentation is the one explained here, it says create both the parents and child CDTs, then create a third table where you have: a primary key, a foreign key that corresponds to the first table, a foreign key that corresponds to the second table, and an index. The problem is that by doing so, you can add duplicates of each, meaning that the same student can be assigned to the same subject twice (this screenshot is the Intermediary record type): (I made 3 record types, Subjects, Students and Intermediary). That's why I wanted to ask all of you for any suggestions so that this table does not take duplicates, or if there's anything that we are doing wrong. Thank you!

Hello Community, Trying to sort a query field that is currently text but hold dates.  Was wondering if in the query it might be possible to cast as type date. Currently attempting to sort the C2 column, however due to it being text it's not correct. query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1000, sort: a!sortInfo(field: "c2", ascending: true) ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "c4", operator: "includes", value: local!activityFilter, applyWhen: not(isnull(local!activityFilter)) ), a!queryFilter( field: "c1", operator: "in", value: local!statusFilter, applyWhen: a!isNotNullOrEmpty(local!statusFilter) ), }, logicalExpressions: a!queryLogicalExpression( operator: "OR",

Hi All, So here, i using related action for Return form the manager, based on return status i make a visibility condition to display the Related action,  problem:when shopkeeper accidentally  click and submit the form , the manager will get two Tasks in Same Instance. related action form.

I have the above expression rule, and when I call it in my interface I am getting the value of [ID:7]. Is there a way to only return the integer value of 7? I'm sure this is probably an easy fix, I'm just very new to this

Hi,Could someone help me understand the concept and solve my below problem? I have a Two tables 1. VehicleTypesFieldId   category1    Cars2    Buses3   Trains 2nd table SubVehicleTypes SubID Id SubCategory1         1     Sedan2         1     Suv3         2     Luxury4         2     Semi luxury5         3     Ac Trains6         3     Non Ac Trains Requirements:1. Drop Down 1 will have data from Table 12. Drop Down 2 will have data from Table 2 I want to display the selected field in 2nd dropdown with the list like Actually i want this

I am getting two recordtypes with the same name. Pls suggest why and how to make it a single one. Each of the two 'Product Recordtype' is referenced in different locations. Pls suggest how to make them into one and all referencing objects should refer to a single one.

Hello, I am trying to use the Call Web Service smart service in a process, but I have the problem that the WSDL URL is too long and I am unable to insert it in the field completly. I am trying to use the dynamic WSDL URL but it retrieves an error. Any idea? Thank you

How to migrate dev Appian environment to staging appian

Expression evaluation error at function a!queryEntity_22r2: An invalid start index of 0 was passed in. Start indices must be greater or equal to 1. I am getting this error for the below code pagingInfo: a!pagingInfo( startIndex: ri!pagingInfo.startIndex, batchSize: ri!pagingInfo.batchSize, sort: { a!sortInfo(field: "createdOn", ascending: false) } )

Hi, I am tasked to do a timesheet POC, I am asking the user to select the date, and I will using the weeknum function to find out the week number, after that will add into the database and wait for supervisor approval.  How to verify the week number is exist in the database record before the user submits the form.  Please kindly assist me thank you 

Hi Team, We are using "googleHistogramChartField"  by "Appcino Technologies" the requirement is  Is it possible to color the boxes (of reach composition) based on the overall risk (green, yellow, red) I was unable to find any setting for the same  https://developers.google.com/chart/interactive/docs/gallery/histogram can anyone suggest that how we can implement histogram in Appian without 3rd party plugin Regards Bihitak

Hi, Recently I have deployed a new application to Production environment. But facing DB connectivity issue. But there is no problem regarding DB connection at lower environment. I have created the Data Source at Admin Console and here it shows Test Successful. The Screenshot: But when I am trying to verify the Data Store, it is not able to connect to DB. The Screenshot: Can anyone please help me regarding this DB connectivity issue? Pertinently I like to inform you the a few days ago the connection was successful and in-between nothing was changed related to configuration or not any further deployment was done in production. Thanks, Surajit Sen

Hello, can the usage of plugins (once installed) restricted with a security(role/permission model or something similar? Thank youThomas

Please share any example to write HTML code into the Expression rule 

Hi, I have a pie chart that displays the 'label' & 'data' outside the pie chart. I want to display the 'label' outside the pie chart and the 'data' inside the pie chart. Is there a way to do this?

Hi Team! Good morning! Need your help/suggestion on the below: I have got a requirement like the check box should appear on the UI with all possible values as selected(ticked) by default, then the user unselects the option that they does not require and submit it. I have tried the below snippet, where in UI its appearing with all the values checked, but upon unchecking the box, it gets selected again. Can you please help me or let me know if there is any possibility to achieve this functionality ? Code snippet: a!localVariables ( local!Checklist:{"A","B","C"}, a!checkboxField( label:"Checkbox testing", choiceLabels: local!Checklist, choiceValues: local!Checklist, value:local!Checklist, saveinto: a!save(local!checked, save!value) ) ) Expected result: 1. At first ,all the options get checked by default 2. The user can able to unselect one or more of the option and submit it  Actual result: But after unselection, the values gets chec

I'd like the employee ID to auto increment and populate automatically whenever a new employee is being added to the record.

Hello all. I am following the Appian online course and making a side project to practice. In the query data section for querying VehiclesAddedThisMonth it shows us how to query and filter a vehicle that was added this month. The problem I am having is that the field I am using is datetime and not date. Error: Expression evaluation error at function a!queryRecordType: Cannot apply operator [EQUALS] to field [createdOn] when comparing to value [TypedValue[it=1,v=10]]. Code: a!queryRecordType( recordType: 'recordType!{7dc09094-e6de-418e-855a-35ab22892fc7}BB Product', filters: a!queryFilter( field: 'recordType!{7dc09094-e6de-418e-855a-35ab22892fc7}BB Product.fields.{34fab307-ea54-4ea9-a01b-40a0706f32c7}createdOn', operator: "=", value: month(now()) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data Seems like the issue is that the operator cannot compare the month function to my datetime field however it is ok if the month compare to

Hello All, I need to display excel within appian UI (interface may be). I need to edit the excel and save it back to where it was (knowledge Centre). How can I implement it? any suggestion is appreciated.

Hi, Recently we deployed a new application to Production environment. It's working fine. The screenshot But facing DB connectivity issue every 37 minutes we are getting this error. Can anyone please help me regarding this DB connectivity issue?