Foundation

I'm not sure if this is possible, but I'm trying to run a HTML script that creates a chart and then exports it as an image in a process model. I'd like to then use that image (and other data) to create a PDF report using the Fill PDF smart service. However, currently for the image to export the HTML file has to be downloaded and opened. Is there a way to have it run automatically in the process model? I also tried the PDF from HTML smart service but that doesn't seem to support charts. Here is the HTML code I'm using to test this process. I'm pretty new to working with HTML so if anyone has suggestions on that front, I'm open to that too. window.onload = function () { var chart = new CanvasJS.Chart("chartContainer", { theme: "light2", title:{ text: "Export Chart using exportChart method" }, data: [ { type: "column", dataPoints: [ { label: "apple", y: 10 }, { label: "orange", y: 15 }, { label:

What is the best way to take in and map AD groups to Appian groups and then add or remove Appian users from an Appian group based on if a users are in an AD group? Basically syncing AD groups to Appian groups. I was looking over the LDAP plugin for a few hours, but to me it looks like it just adds, activates and deactivates users based on ad groups. I may be mistaken

Hi, I've read that input ou output expressions inside a script tasks are not consecutives, and the fact that Developer must not count on this. If I have to create and use a custom counter, and then get a CDT value from this array at the index counter, is there a way to do it from the same Script Task or I'm obligated to use 2 consecutive script tasks ? Ex :  - pv!counter  = myCounter +1 - pv!data = index(pv!myData, pv!counter, null)

When adding a new custom data type as a rule input to interface, Appian does not recognize its entries: Where my yellow circle is, I expect a "plus" symbol, and instead of the last "null" I should see something like [processStepId=,processStepName=,...] but I don't. What do I overlook? Here the configuration of the first and last rule inputs, respectively:

Hi All I have a requirement to create dynamic tabs based on certain conditions. I tried below code but is not working. The foreach in choose section is not returning the list. { a!localVariables( local!selectedTab: 1, local!names: {"1", "2", "3"}, { a!buttonArrayLayout( buttons: { a!forEach( items: local!names, expression: a!localVariables( local!modified, a!buttonWidget( label: "Tab1 "&fv!item, saveInto: {a!save(local!selectedTab, fv!item)}, size: "SMALL", style: if(local!selectedTab = fv!item, "PRIMARY", "LINK") ), ) ) } ), { choose( local!selectedTab, a!forEach( items:local!names, expression: a!localVariables(a!forEach( items: {1}, expression:{ a!textField( label:"Enter data", ), }, ) ) ), ) } } )}

I have a process model that presents a user with a confirmation page.  This page contains three links for the user to select from.  Currently, we have a timer that will skip this link after a number of minutes.  I was wondering if there is a way that I can set it up that when as user clicks one of the links it will continue on without the use of the timer.

Hi all, I've managed to configure AWS RDS SqlServer Data source in our Appian dev env application. Current dev environment is running on vmware private cloud with Sql Server data source. Could someone please suggest the procedure/steps how to replace current data source with RDS Sql Server? Do we need to modify each DSE objects OR any recommended systematic approach to achieve this? What are the objects that we need to check other than DSE please? Can we update the application module by module basis? (i.e. Part of the application/functions will retain the current/existing data source, some of the specific modules will can use AWS RDS source? ) It would be helpful if someone can shed the light on any available whitepapers/ case studies resource and share the details of known challenges for this use case please. - Thanks.

I have an external excel file containing data. I need to import it in appian data base in one of the table. How can I achieve this functionality ? is there any smart service available to import the external file directly into database ?

Hi all, I am attempting to use the following expressions user(loggedInUser(), "username") to retrieve the username of the currently logged in user. The expression is being used in a script task within a process model. When I run the process the expression returns Administrator instead of the actual username. When I test this expression as an expression rule however it returns my actual username. Any insight into the discrepancy would be greatly appreciated.

I need to make a odata request with couple of filters. One is GUID. For all other data types like String/Text and Number/Integer is working good. But when I'm trying to use GUID as text/string, Im getting below error. Error: A binary operator with incompatible types was detected. Found operand types 'Edm.Guid' and 'Edm.String' for operator kind 'Equal'.Form Appian, through ExpressionRule I need to construct api format in such a way that GUID should not be in text format. http://XXXX/v2/Internal/editable/MarketSolutionRelLinks?$select=KeyMktplaceSolutionRelatedLink&$filter=((MktPlaceSolutionLinkTitle+eq+%27Title1%27)and(KeyPlatformService+eq+%27c64900aa-c912-4c52-bf3e-c1a0c77f8c4a%27))  --- Appian Constructed Format http://XXXX/v2/Internal/editable/MarketSolutionRelLinks?$select=KeyMktplaceSolutionRelatedLink&$filter=((MktPlaceSolutionLinkTitle+eq+%27Title1%27)and(KeyPlatformService+eq+c64900aa-c912-4c52-bf3e-c1a0c77f8c4a)) ---- Expect

Hi Everyone, Is there any way to capture logged in user details in site without taking nay action on ui.

I want to have a field that display user list when @ is typed and normal text in single user input field. Is there a component to accomplish this already?

Can anyone help me on how to use Script Task to capture process initiator,  set current date/time, and set a status for the process ? I will also like to know how I can make a process name dynamic. Thank you

We have upgraded Appian to version 21.1. Now some functions are not working fine after the upgrade so we want to downgrade the Appian version back to 20.4.  Is it possible to do it? If yes, How can it be done? 

Hi All I am trying to update one document with the details of another.  I have a interface that populates with a document (record A) and a dropdown with a list of documents filtered on the company of Record A. This stores the doucmentID of the document to update Record A with in a rule input. Ive tried building an sub-interface with the same fields and dropping that to the right to show the details of the record to update from but couldn't drop that into the form (not sure if you can use other interfaces within a form?) I was using the following within a column: rule!DMR_V2_documentTypeDetails_Sub( rule!DMR_V2_DocumentType_MasterByID(ri!documentID)) Got the following: So for now Ive just dropped some text fields and are populating these using a expression rule that grabs the field based on the documentId - however - although it displays the info, its not storing it into the CDT (the display value is using the expression rule, the save into is pointing to the CDT ne

Hi All, I've to create the create a new application that's going to include thousands of existing objects.(For example 90K objects.) It means, if each page is displaying 25 number of objects in a page list, I'll have to navigate around 3600 pages to select all objects in each page and click "Add to Application" for each page.  Is there any quick work around for achieving this? For example, we can think about writing automated script for this process in Selenium. Just wondering if we have any another smart approaches to meet this requirement, please?  Thanks.

Hi, I am trying to deploy the process model which has old portal forms.I am getting below error when i deploy. The processModel  was not exported because it contains an invalid precedent: content [uuid=1234 location=Node > "test" >  > Task Form > Element] cannot be found. (APNX-1-4070-001) (APNX-1-4071-003) Please suggest. Thanks in advance

I want my interface to show the currently logged in users for application in the text field. Can someone please help in getting the solution for this ?

Hi all  From an Interface, I need to extract Data from a given CSV file (present in APPIAN). The only solution I am seeing is to extract the data into a DB table on the cloud and then query it.  Does anyone have the same issue? Does anyone know a possible solution? 

Has anyone created a PDF Template where a field can flow to a second page if needed?  I have a need where the selected data may fit on one page but may also need to run to a second page.

Hello, If we want to keep alive a process in order to use reports to show information to the customer, is that a big memory usage for Appian?  Thanks

How to configure the execute stored procedure smart service?

I have to update 6rows in a table and need to create a new row with updated values in a table. I have used query entity to fetch the data and configured in script task at output and writing into the table.but am calling same rule for 6 times to update each fields,so it may not work efficiently.can you provide me alternative way. Thanks in advance

Hi, Basically, I need to upload a document into Appian BUT I only have the link for that document and I want to use it directly on my interface/process model. there is a way to do it or I really need to upload it manually? Thanks

Assume I have a form which saves many parameters into a rule input myDataDict of a custom data type with different entries, let's say myDataDict.name (required field) and myDataDict.common is directly visible on my interface. However, in addition to the visible things, I want to automatically populate myDataDict.timestamp with the date-time when the submit-button is pressed. How do I do that in the most standard way? Where do I have to place my a!save()-call? Inside my a!buttonWidget() ?