Discussion Categories

Hi  I am not able to connect with google sheet using google sheet plug in, when ever i test connection from connected system i am getting permission denied issue.

A form has 5 rule inputs ,as follows: > 1cdt variable > 3 text variables > 1 integer variable According to best practices,how many process variables are required in the process model's user input task Options 1) 1 2) 3 3) 5 4) 6

Hi, We have a requirement to implement the stripe hosted checkout for our application. To get a callback from the stripe once the checkout session has completed, We have created a webapi in appian and provided the endpoint in the stripe's webhook dashboard so that once the checkout session is completed Appian webapi is called. It seems like we cannot pass the API key for the appian webapi as a header when the stripe invokes the appian webapi so the authentication doesnot happen. The webapi works fine when triggered with Postman.  Is there any way we can resolve this issue?

Hi, I want to add a Safelink in buttonWidget, is there anyway to do this?

Hi All, I want to save some local variable after the button "submit" is pressed.But Submit button located in other interface (details are there in one interface and we are using details  interface in other interfcae which has SUBMIT button.So where can I use this a!save(target,value) to store local variable?

Hi Everyone, Is there a way for the end-users of the Appian application to adjust the frequency as well as the capability to turn on/off email notifications from the front-end in the long run?  Thanks 

Hi, I have a requirement to change the alert for all pm. I find a plugin and it can modify the alert recipient by the smart service PMAlertsRecipientsSetter. But it need the pm uuids as the input. Is there any plugin has the function to get all process model uuids / ids / details in an application? Or any other way to get this input? https://community.appian.com/discussions/f/plug-ins/18173/process-utilities-plugin-to-bulk-update-alerts This question mentioned getapplicationprocessmodelsuuids() but I don't know which plugin has this function

Hi All, Requirement:                     I have a use case where I have to get documents from target environment to source environment. Information:                     I have list of appian documents id in my source environment database. Approach: ->  I have developed a web api in target environment , it will return document based on appian document id. -> I have designed a process model , In which I am getting appian documents id from table and calling target webapi using integration object. It was working fine and getting documents as i expected. Inputs required : Which way is better among below two approaches. 1) Getting appian documents id's as a batches ,using MNI  and pass it to sub process having integration call logic  2) Looping approach . I don't have enough information about number of appian documents id's to process , Please share your

Hi All , Hope you doing  well.  "My scenario is that I worked on a Card layout. Within the Card layout, I have some text fields. Initially, the Card layout has a predefined color. My task is to change the color of the Card layout when any value is entered into the text field. Can anyone help me out?"

Hi All, What is the use of using a!save in save into of interface.Is there any clarification on this? Thanks

Trying to map entries that full under the same month together and return count for total entries in that month  with( local!metrics: rule!OCSC_getNumOfTierTwoRequestsSubmitted( startDate: ri!startDate, endDate: ri!endDate, ), local!asmts: a!forEach( items: local!metrics, expression: { svc_request_id: fv!item.svc_request_id, totalServicesPerformed: fv!itemCount, date: fv!item.created_datetime, month: month(fv!item.created_datetime), year: year(fv!item.created_datetime) } ), local!mergedRows: local!asmts, /* create list of maps with sum of collective asmts done by year-month */ local!dates: a!forEach( items: local!mergedRows, expression: { month: fv!item.month, year: fv!item.year } ), local!datesDist: union(local!dates, local!dates), local!prepared: a!forEach( items: local!datesDist, expression: with( local!dateIndex: fv!item, a!map( month: fv!item.month, year: fv

Hello i am trying to make validation for editable grid in appian so i am not able to enter same value into multiple rows but even when value is entered only in one row validation is triggered. Here is the code for validation: validations: if(fv!item.value = local!arrayOfStrings,"Id already exist",""), fv!item.value is always there at least once as it is automatically stored in local!arrayOfString so even if it is not in local variable once i entered the value into grid it is saved into  array so i need to check if it is there more than once thanks for any advice in advance

HI I'm getting an error while creating a form  Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!imageField [line 60]: The image at index 1 in an image gallery component [label=""] has an invalid value for "document". "document" must not be null. Please help me

What is the recommended best practice for Search Record List Limits from a table? Are 500,000 records or less acceptable?

Hello! This question arose from working through the course "Tutorial: Automate Windows Applications (RPA)", which involves copying and pasting text between Calculator and Notepad.  Unfortunately the instructions assume an older version of Calculator, since mine doesn't have an Edit menu. My workaround is to have the robotic task right-click into the display screen in order to be able to grab the text. Since RPA is new to me, I am currently having to brute-force the coordinates of where the mouse should go to click. I downloaded Mouse Point Viewer and got the following values: Relative (Calculator) Coords: X=130, Y=132 Screen Coords: X=324, Y=179 However, in the Move Mouse function in the task, after much trial and error, it finally worked after I configured the location to (800, 800). Can anyone explain where (800, 800) comes from?

Hi there, Anyone here know how to connect to GitLab? I see there is connected system for GitHub, anyone know there is one for GitLab? Thanks, Lin

I want to the same result as this SQL query "SELECT WorkType, COUNT(DISTINCT Site) AS DistinctSites FROM your_table_name GROUP BY WorkType;" in using query on data entity. I am able to get the count of sites and Group by WorkType but count of sites is not distinct.a!queryEntity( entity: cons!SD_TEST_DATA, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "worktype", isGrouping: true ), a!queryAggregationColumn( field: "site", alias: "site_count", aggregationFunction: "COUNT" ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: false )

Hi Team, I need a plugin having capability to convert DOCX to PDF format. I tried below available plugins for my requirement but I am unable to get any OPEN-SOURCE available for this.  advanced-document-templating-1.0.12.jar (It is not converting complete data. It only shows only picture format data to convert DOCX to PDF not shape format) dynamic-document-generator-2.0.4.jar (It is not converting complete data. It only shows picture format data to convert DOCX to PDF not shape format) convert-docx-to-pdf-(aspose)-2.0.10.jar (It is a paid License) Out of these plugins, convert-docx-to-pdf-(aspose)-2.0.10.jar this plugin  have the capability to convert DOCX to PDF but paid license required. So if you can suggest any other plugin which is available on Appian AppMarket to use for converting DOCX into PDF. (That should be Open Source)

Hi there, I've got a business needs where I have 2 records types (let's call them RT1 and RT2). RT1 has a one-to-many relationship with RT2 and I need to display a grid where my row would be RT1, in which the first 5 columns would be property of RT1 while the following columns would be dynamically added based on possible values of RT2, this mean the number of columns would be equal to the number of properties of RT1 + the number of possible values for RT2. This could give something like :  Name Color Brand Model Places Feat1 Feat2 Feat3 Feat4 Feat5 XYZ Blue Ford GT 2 1000 200 500 1500 600 ABC Red Mazda CX-9 7 2500 3000 What would be the best architecture to build that?

Hi All , I have a very strange scenario . I have created an Interface which shows Data in Editable Grid, I want to Export this Data into an Excel File. In order to Export the Excel File , I have created a Process Model which stores the required document into One Document Folder.Now, I want to have a link to download that particular file.I am able to do everything , While testing Interface , I am getting output of process variable ( i.e. the Exported Document) but when I am using that Interface in Site I am not getting output from Process Model.Here is the image of Process Model: a!startProcess( processModel: cons!MBUA_PM_EXPORTEXCEL, processParameters: { gridData: ri!excelData, }, onSuccess: a!save( ri!document, fv!processInfo.pv.exportedExcel ) )Here is the code which I have used for Starting this Process Model.

I want to generate a Column Chart from Expression rule which contains query aggregation on two columns , How can I generate a Column Chart for this. Below is the code of my Expression Rule index( a!queryEntity( entity: cons!MBUA_DSE_TESTSITEDATA, query: a!query( aggregation: a!queryAggregation( { a!queryAggregationColumn(field: "site", isGrouping: true()), a!queryAggregationColumn(field: "worktype", isGrouping: true()), } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: false ), "data", null() ) Below is the code on Interface having Column Chart: a!localVariables( local!myData: rule!MBUA_readChartView(), { a!columnChartField( label: "Column Chart", categories: { "Category 1", "Category 2" }, series: a!forEach( items: local!myData, expression: a!chartSeries(label: "Chart", data: fv!item.worktype) ), stacking: "NONE", show

Has anyone successfully used JWT (JSON Web Token) to integrate with another system? Is Appian able to decode a JWT? It is necessary to use a plugin? I found this plugin https://community.appian.com/b/appmarket/posts/jwt-web-token-tools in the app market and I think that with the decodeJWT function I can achieve this. Can someone confirm this please?

Hi, I am getting an error when I click on any dynamic link or button in my task (with no submit). I only have this error when I access the task from the mobile application, from the browser everything works correctly. The error is "An error was encountered while processing your request", and I don't know how to get more information about it, maybe in the STDOUT log? I have deleted any operation in saveInto for testing, and I still have the problem, It seems that it is simply by clicking Could someone explain to me what could be happening? Thanks and regards

Hi, I am getting following exception error while running fittnesse test: _EXCEPTION__:org.openqa.selenium.remote.http.ConnectionFailedException: Unable to establish websocket connection to localhost:57708/.../98ab4b7f-1fff-48c0-88eb-853c24056bed Build info: version: '4.1.2', revision: '9a5a329c5a' System info: host: 'DESKTOP-88E80PB', ip: '10.0.0.252', os.name: 'Windows 10', os.arch: 'amd64', os.version: '10.0', java.version: '1.8.0_251' Driver info: driver.version: ChromeDriver at org.openqa.selenium.remote.http.netty.NettyWebSocket.<init>(NettyWebSocket.java:104) [selenium-remote-driver-4.1.2.jar] at org.openqa.selenium.remote.http.netty.NettyWebSocket.lambda$create$3(NettyWebSocket.java:137) [selenium-remote-driver-4.1.2.jar] at org.openqa.selenium.remote.http.netty.NettyClient.openSocket(NettyClient.java:118) [selenium-remote-driver-4.1.2.jar] at org.openqa.selenium.devtools.Connection.<init>(Connection.ja

Is there a way to identify the number of logins from past 6 months? I know we can access the login -audit files manually but that would take a lot of time. Is there another easier way to fetch it via rule? Please advise.