-
Recently active
I watched RPA Tutorial: Parse Excel Files Please guide me what kind of code on Evaluate Expression Drag and drop an Evaluate Expression action below the previous one. a. In CONFIGURATION, click Edit. Facing issue in RPA Any one have solution
Hi Champs, I have a requirement where in portal, I have to fetch user details from IDP and show it in a dropdown or in a autocomplete list? I have two questions here? 1) How to fetch data from a IDP ? will it be a API call ? If Yes how to do that 2) Will portal support this use case? Regards, Ghanashyam
Hello, I am exporting a table on a button click and I want to give download link for the latest exported excel document. So when I click on "Generate Excel" button, It should export a table and then update the download link for the latest document. How can I achieve this on one interface. Thanks in advance!
Hi Experts, Can someone help me to understand why Appian sets the CHARACTER SET as utf8mb3 for the varchar column even though we have CHARACTER SET utf8mb4, Using Appian 22.4 cloud instance Thanks, Gaurav
Hi After doing changes in CDT for newly created requests it will work fine and process will fetch the updated details but for inflight ones it will be still old CDT is there any way to get the updated cdt to inflight instances
How can we call a link in buttonWidget?
Hi All We have a requirement to read the file clasification i.e. internal,public,confidential etc. We are usng readofficedoccustomprops function & tried with multiple functions & smart services. But did not find the function/smart service for it to get clasfucation for all file types ( docx,pdf,excel,csv,ppt).using readofficedoccustomprops function & MS Office Read Custom Metadata plugin , we could able to get the Classification for external type files but when trying with clasification as internal /confidential it is giving error with file metadata. Can any one faced similar issue to read metadata of all type of files .Please share with us.
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)
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.