Discussion Categories

Hi All, I have a scenario where I want to open a site with the record data context thought a mail sent to a user. The user will click on the site URL present in the mail and then he will be directly navigated to the exact context of the record data and the page where he want to go with the record data.Can we achieve this identifier scenario for a recordtype based site URL?

What should I write script for grid Thanks

I am a graduate student using the community edition as part of my Appian learning journey. I plan on doing a grad project on integrating Appian with AWS.  Is it possible to explore this connectivity in the community edition? Any help would be appreciated.

Hi All, Can anyone please help, on how we can disable the login.jsp page, so that, when users tries to access it, there will be an error throwed. Warm Regards Vineeth

Is it possible to download the data in Compare and Deploy grid into an Excel file. Or any way to implement a custom report around it to download the data in that grid?

Hello Techies, We are planning to roll out Appian to thousands of our customers and looking to onboard a digital adoption platform like "WalkMe" with Appian. They typically use either JavaScript or browser plug-ins to work with a web application. Appian does not support adding JavaScripts to sites or elsewhere.  Have you used DAPs in your projects? If not, have you configured JavaScript anyhow?

I am working on Connecting Twilio to Appian, I have Inserted everything correctly and connected system authenticate properly. But the Twilio field is not working. It says invalid parameter for Sid, how can i resolve this.

I have a grid layout consist of dropdown,  If I select a value on the first drop down then if I add new row it will show new drop down on the second drop down I need to hide the value that is selected on the first drop down. Here is my initial code. I just  created it but the problem is in choiceLabel it's showing id. The requirements is to show the column "name". I try indexing it but it show an error.  a!localVariables( local!service: rule!IBM_GetServiceByFilter( extractData: true, fetchAll: true, status: {cons!IBM_SERVICE_STATUS_PENDING_APPROVAL,cons!IBM_SERVICE_STATUS_ACTIVE} ), local!user: user(loggedInUser(), "firstName") & " " & user(loggedInUser(), "lastName"), local!now: now(), { a!gridLayout( labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "List of services"), a!gridLayoutHeaderCell(label: "" ) }, columnConfigs: { a!gridLayoutColumnConfig(width: "D

I have created a sample code, where the current date is being displayed in specific color, but I am facing an issue while selecting the date. Once the date is selected I am getting the issue mentioned below.  The calendar display The calendar after selection of date  : The calendar display after selecting month:

Hi, I have a date time field in DB stored with max value 9999-12-31 00:00:00.000000 i have a record type synced with this DB column field as date time type. when i am querying the record from Appian I am getting 4/10/2292 11:47 PM as result. when i verified the field in the record list this expression is used if( isnull(fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs']), fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs'], datetext(fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs'], "default") )

Hello , In the current client we have the need to create a document (specifications for tenders). The functionality is that in the bpm there is a form with several sections that the user must fill with information. This information must be formatted (tables, bold, list of items). We need to be able to add this formatted text in specific points of the document that is used as a template. We have tried with the smart service dynamic template but it does not preserve the text formatting. What would be the right solution for this?

Hi, In DB we have one date set to 12/31/9999 (MM/DD/YYYY) which is a data source for a recordtype. When this record type is used in one of the site page the recordlist date and time column is display the wrong date as below  Is it somewhere setting max date? Not able to find. Expected Date to display in recordlist: 12/31/9999

Hi ,All My question is that  in the view summary page of Record type, I have add an interface to show the data  in summary view page . So I am fetching data with the rule expression ,and call it in the interface. My problem is that ,all data is showing in the interface but  some data is not showing in the summary view page . Please help me how can I resolve this issue of inconsistency of Data in summary page.

Greetings everyone, I had found a previous post from 7 years ago, however the solution found is not one that works for our use case.  We have a usage monitor application that pulls data from the csv files of login-audit.csv from the shared-logs. Currently, files of login-audit.csv are stored in a folder inside the application's Knowledge Center. I was wondering if there is a method to getting files from shared-logs into Knowledge Center folder. The plugins such as login reader and login information parser would not work in this case as the data is pulling from the folder in knowledge center already. I was wondering if this can be kept intact, and if there is a way to automate moving files from shared-logs to knowledge center. 

Hi,  Has anyone ever had to send an encrypted password from Appian to an external system? In my case, I need to send an encrypted password to RPA (Blue Prism) and I have tried the encryptvalue() function of this Encryption Functions plugin  that uses the AES-256 method to encrypt, but the RPA team is not able to decrypt it from Blue Prism... I had also thought about using the native encryptedTextField() component but I don't know what method it uses to encrypt or how to obtain the key needed to decrypt from an external system. Thanks

a!localVariables( local!array: cast( 97, { { item: "stapler", name: "Mike", countryId: 1 }, { item: "printer", name: "Larry", countryId: 2 }, { item: "laptop", name: "Mike", countryId: 1 }, { item: "glass", name: "Mike", countryId: 3 } } ), local!updatedArray: a!forEach( items: local!array, expression: remove(fv!item,"item") ), local!finalArray: a!forEach( items: local!updatedArray, expression: remove(fv!item,"name") ), local!finalArray )

I need to read and save data from XLS document. I tried using "Export excel to Database" smart service, but it is giving error "???The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)???". I also tried to convert the XLS document to CSV document using the "Convert excel to CSV" smart service and also tried to read XLS file in expression rule using fn!readexcelsheetpaging but still getting same error. Is there any way we can read XLS document? 

Hi All, I was wondering if there is a way to limit the number of characters shown per column in a grid. For example, I have a grid that has one column that shows a field called description and its data max character limit is 2000, but in the grid visually I only want to show 500 and then .... if they put their cursor over can see the rest. Is this possible or even something similar, this way the grid looks more harmonic since some data has up to 2000 characters but other ones are only 100-200  and things like that. thanks in advance

What am I missing? Why is it taking weeks to set up Community Environments for new users? Could Appian not create some sort of RPA process to generate them? It's REALLY difficult going through the Developer training activities without an environment.

Any idea why the input value is not recognizing the array? I've tried with/without the comma, but Appian is still saying there is only 1 item in the list.

An Award Record has 3 sections: Section 1, Section 2, and Section 3. Section 1 and 2 combine to serve as a unique identifier. When you edit Section 3 of an Award Record, all of the Awards with the same values for Section 1 and 2 should be updated as well. This process model updates the value for Section 3, but it does not check to see if there are other awards with the same combination of Section 1&2 before writing to the DB. I was told to "build a dictionary in building the CDT before the DB write and write the array". Any help would be greatly appreciated! Thank you

Hi, what is the Appian's Policy for data collection in regard to a company data?  and we have a use case to enable the SSO authentication via Microsoft to login into the site or portal that we made in an application. what is the process for the same?  

I have been unable to find a starting point to the COMPLETE documentation of the Appian expression language (I don't know the correct name as I have not been able to find one). As an example, I found this by searching Google: https://docs.appian.com/suite/help/23.3/expression-advanced-evaluation.html But, this seems to be a random orphan page. I am unable to find a series of pages to which this belongs, and if I start from the menu on the upper left, I don't see how one would encounter this page by navigating that menu. I have found the page with documentation to all the functions, but not a complete FULL documentation to the syntax of the expression language. I would absolutely love to read it in its entirety instead of having vague ideas of what can be done and how it works from random examples. Where can I find this documentation that I seek? Am I overlooking something obvious? Thank you

I have a one to one relationship between WorkItem and Lead where workitemId is a foreign key in Lead. I first create workitem and then pass its id to lead while creating lead. Conditions in table, workitemId is unique and not null. This has been working fine in previous version of Write Record Smart service but in new version it is not working and giving error for workItemId not being there. Lead: {leadId=505, workItemId=2843, qualityScore=4} This gives error: Unable to write to the source due to system error. Error Details: Field 'work_item_id' doesn't have a default value. Note: Same input still works with old version of write record smart service. In logs I see it creates prepared statement without workitemId field:  Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO `PRO_Lead` (`quality_score`, `lead_id`) VALUES (?, ?)]; Field 'work_item_id' doesn't have a default value; nested excep

Hello Community! I have next error after running tomcat: aused by: java.lang.ClassNotFoundException: Unable to load class: org.postgresql.Driver from ClassLoader:java.net.URLClassLoader@326de728;ClassLoader:AppianWebappClassLoader  context: suite  delegate: false----------> Parent Classloader:java.net.URLClassLoader@326de728                at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:56)                at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:304)                ... 29 more        Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver                at