Discussion Categories

I have a requirement to connect to Drone from Appian. I have seen an application developed by Procensol in Appian Hackathon for the same. https://youtu.be/IN5MEyguKaM?si=kl-wATgZ00rDg53Q Please let me know if there is any Plugin/API to use the same? Thanks, Sarat Tumu

Hi Team, I have group - Group1 In the group 1, we have 3 users user1, user2, and user3. Now, I have loggedin with user1 account. In the pickerField now the user1 should not be listed out. Can you please help with the approach.  a!pickerFieldUsers( label: "Users", labelPosition: "JUSTIFIED", maxSelections: 5, groupFilter: cons!Group1, value: local!selectedApprovers, saveInto: local!selectedApprovers, required: true(), validations: {} )

Hello,  We are testing the waters for a DB migration.  ( MySQL to Amazon RDS ).  Within one of our environments, we plan to make a copy of our existing apps, and point the copies to the new DB for testing purposes.   We realized this would entail updated all object references for the copied objects, which is labor intensive.  Is there a tool tailored for this scenario, or a better approach we could try? Thanks.

Hi, I am trying to get the next day from today's date. For eg: today is 18/9/2023. I need to get 19/09/2023. I tried using some day function to get the day and add 1 to it. I was testing with different timezones. now() - 9/18/2023 10:50 PM PDT now() + 1 - 9/19/2023 10:50 PM PDTwhen I used day function on now() +1, its giving 20 instead of 19. I am not sure what is the issue or maybe I am missing some timezone offset. This is occuring when I tested for Pacific timezone. Its working fine for IST. Please help me on this. a!localVariables( local!date: now(), local!endDate: now()+1, local!day: day(local!endDate), local!day )

HI  i am getting an error  in PM while executing generate PDF FROM DOCX Element type "ceatable" must be followed by either attribute specifications, ">" or "/>". How can i reslove this Thanks

I have a group of sequential tasks (data record, interface, query, script task..) and i want to group them into a subprocess to simplify the process model. How should i do this?

I am using square brackets but this error shows .  what is wrong with my code? a!boxLayout( label: "Box", contents: { a!gridLayout( label: "Document", headerCells: { a!gridLayoutHeaderCell(label: "Document", align: "CENTER"), a!gridLayoutHeaderCell(label: "Name", align: "CENTER"), a!gridLayoutHeaderCell(label: "Classification", align: "CENTER"), a!gridLayoutHeaderCell(label: "Upload By", align: "CENTER"), a!gridLayoutHeaderCell(label: "Upload On", align: "CENTER") }, columnConfigs: { a!gridLayoutColumnConfig(), a!gridLayoutColumnConfig(), a!gridLayoutColumnConfig(), a!gridLayoutColumnConfig(), a!gridLayoutColumnConfig() }, rows: a!forEach( items: if( a!isNotNullOrEmpty( ri!record['recordType!{2206daff-ddbb-4759-a797-1588754c3925}SKJ Deposit Request.fields.{0cfaa083-3ffb-447a-b

Greetings to all the Appianites out there! I have a client organization who adopted Appian, over a decade ago, to build one application in its own data center. They didn't keep up with the product upgrade (like any undisciplined DIY jobs). The application is now wrought with all kinds of issues and the stakeholders is second guessing Appian and contemplating changing horses, though I believe a more sensable approach is just to rebuild the app on latest version of Appian on Managed Cloud.  To convince the client to stay with Appian, some facts on the revolutionary Appian product improvements could be super helpful. I started my Appian journey only about 5 years ago. Hence I have little knowledge of what it might feel like working with decade plus old Appian platform. Would be grateful if anyone care to share his/her perspectives, traveling down the memory lane of Appian product evolvement.

Hi  when i uplaod a doc to the grid , it returns this error shown in image below(Document must be indexed by its corresponding record type fields or relationships) .  ALSO the name field shows [Reaction Tree] what is that? where exactly am i supposed to fix the indexing? how to resolve this issue  ? local!document:rule!SKJ_GetDocumentByDocId(local!ac), a!sectionLayout( label: "Documentation Details ", labelIcon: "file-text", labelSize: "SMALL", labelColor: "STANDARD", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!gridLayout( totalCount: count(local!document), headerCells: { a!gridLayoutHeaderCell(label: "Document" ), a!gridLayoutHeaderCell(label: "Name" ),

When you and your colleague are working on the same expression rule, you need to have a common test case to be used for both of you, what will you do?? Select multiple actions required[Multiple Choice][a] Create Test case[b] Add it to a testing group[c] Use Ad-hoc Test Cases[d] Create a new testing Expression Rule

I have below record Data {'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':3, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11107, 'recordType!PRO Lead Documents.fields.pdmDocumentId':110604, ), 'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':4, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11108, 'recordType!PRO Lead Documents.fields.pdmDocumentId':110605, ), 'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':5, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11109, 'recordType!PRO Lead Documents.fields.

Hi all, I'm a bit unfamiliar on how can I search for a document based on its name to send it on an email? right now of course doing it manually works but I was wondering if there is a function that returns the document based on its name or anything similar. For example, I want to send the document named YI5688 (saved in my appian folder called documents) , my process variable contains the name , but I'm not sure how to "search" for the document. Any thoughts or suggestions? Thanks in advance!

I am getting the above error , what does it mean and how to fix it?  I am trying to add the document in the grid , and save to its record type.  The rule input Doc is defined as (array) could this be where the problem is?  a!sectionLayout( label: "Documentation Details ", labelIcon: "file-text", labelSize: "SMALL", labelColor: "STANDARD", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!gridLayout( totalCount: count(ri!Doc), headerCells: { a!gridLayoutHeaderCell(label: "Document" ), a!gridLayoutHeaderCell(label: "Name" ), a!gridLayoutHeaderCell(label: "Classification" ), a!gridLayoutHeaderCell(l

Hello All, We are having a requirement to split the document uploaded by the user into smaller documents if the size of the document uploaded by the user is more than 5MB. The file type can be any like Excel, txt, pdf etc. We need to create a solution that will pick the file and divide that in small size files and save in Appian document folder. Thanks in advance for your response. Regards

Hi, we need to make an integration with SharePoint Online, in form of single system login, with Appian 21.4 The customer after done the configuration on SharePont, gave us a PFX certificate and no client secret. But as I read on Appian documentation the "certificate authentication" is an alternative to Client Secret authentication which is needed by Sharepoint Connected System on Appian. So we need the customer to configure following "Granting access using SharePoint App-Only" (https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs) and not "Granting access via Azure AD App-Only". Is what I say correct? Is there a way to configure a SPO integration on Appian by using the certifcate authentication? Thanks

I have a parent Interface calling 2 child interfaces. Both the child interfaces are grids.  The first grid shows previously added data and has capability to select a row and add it to the bottom grid using Select button. The second grid has search fields to search for an item and add it to the grid. I'm passing these 2 different data as 2 different variables to the Grid 2. (Though I tried passing as single didn't work). Here is my scenario:   I select first item from Grid1 it gets added to the Grid 2 Then I search functionality and add data to Grid 2 Now I select another item from Grid1 and try to add. Problem: This time when I select my second item from Grid 1, I don't see the newly added item in Grid 2. I see the newly added item is seen in local!submissionSubstance_HTTP but not in the Gri 2 This is the local for my Grid 1 selection local!submissionSubstance_HTTP: a!refreshVariable( value:rule!DCC_castSubmissionSubstanceData( s

Hi, I have a web API, and inside that am calling few expression rules and storing it in Local variable. Is there a way that i can see what value is getting stored in that local Variable.(just like we have an option in interface, expression rules.) Eg: From local!getDelta am getting Delta value local!abc: rule!xyz( getDelta:local!getDelta, processid:index(http!request.querryParameters,"processId",{}) ) I need to check what is the value in local!abc in Web API object.

Does anyone tried to execute a robotic task using a robot installed in a remote linux terminal? Im trying to execute a simple robotic task that open chrome browser and returns me some data of a webpage, the robot is online on the dashboard but when i try to open the browser it pops the following error:  2023-04-18 11:05:07 02s (0h) - Driver could not be initialized: unknown error: Chrome failed to start: exited abnormally. 

Hello, I'm retrieving from DB base64 documents by record types from CDT queries and using it in the app, and I am having a problem when retrieving them. The application should be able to work with documents up to 2 MB, but the limit for queries is 1MB. Is there any way to increase this limit?

Hi! I have created two different Records (R1, R2). In my site, I have a summary view of R1, which shows some info + a Read-Only Grid of R2 (filtered by R1 primary key) Besides I have a related action (of R1) to delete the records of R1 My problem here is that, when I try to delete R1 I have faced different "errors" among the time: A) nothing happens B) an error appears (not able to delete) C) It deletes the summary view and the R1 field, but NOT the R2 fields Something similar occurs when I try to update records So, which recommendations would you give me in order to be able to delete/update two different records at the same time? I would like to hear the best practices. I was thinking about re-making each process model (delete-update) and add a delete/update records of R2 in each case. Would this be a good approach? Thanks a lot!

I have a record used in an interface and I want, as I press a dynamic link, in the save() part to add an empty vale to the array of the record, to do this I try a!save(recordtype,append(recordtype,save!vale) the save!value is the recordtype(), but it says it doesn't allow appends to records, how do I do it? I don't have much experience with records still. I need this because I have a foreach with that recordtype as the item so I need a new row when I press the dynamic link so I can fill the fields that should appear Thank you

I am trying to get a temporary table data by executing a stored procedure. This stored procedure is responsible to create a temporary table, insert some hard cored values (id and name as fields) and then dropping the temporary table. Before dropping Inam using select all statement so to get my data before dropping the table. But somehow I got the data which is similar to this, { { id = 1, name = Abc }, { id = 1, name = Pqr }, { id = 1, name = Uvw }, { id = 1, name = Xyz }, { id = 1, name = Ijk } } It looks like 2D list of map. can anyone help me in binding the data to excel using Export DataStoreEntity to Excel and Execute Stored Procedure smart services.

Hi All, I'm new to appian plugin development. I need some kind of road map where to start and how to develop my knowledge. I have basic understanding in java. What is the basic requirement that is needed for a plugin development.  Thanks!

We have freeform paragraph field, where user can enter any text string except the emojis. I have tried some of following regexreplaceall function which works fine to remove emojis but it also removes some of the special chars as well. Any suggestion on how to just eliminate emojis by completely removing it or just replace it with text string. input: "afs saf [emoticon:4191f5ee34e248a29fa0dbe8d975f74a][emoticon:5ced9b85a4a246058e4772ef2b9956f4][emoticon:33306c418930400bac28808410f8ac8b][emoticon:ac85b29e2ff049dd9278224b337cdf43][emoticon:ccfc0979d5bf49dc92a54d454ae8fe68] sdfa sdf___~!@#$%^&*()_+{}|:<>?" Function:  regexreplaceall("[^\u1F600-\u1F6FF\s]", ri!input, "" ) currentOutput: "afssafsdfasdf___~@^_{}|:<>?" desireOutput: "afs saf  sdfa sdf___~!@#$%^&*()_+{}|:<>?" Thanks! Ajay

We have 3 cloud based environments: DEV, QC & Production. When the Appian platform is being upgraded on the cloud, we can schedule the date/time it happens for each environment. General good practice is that you should upgrade your non-production environments first. After a period of regression testing on those environments, you upgrade your production environment. Now, if we upgrade our non-development environments first for a period of a week to give the developers and software testers time to do their regression testing, we cannot deploy any new features or bug fixes to production during this time as the Appian versions on DEV/QC are different to Production. This is a major problem if during that week of testing a critical bug is found in production that needs to be fixed and deployed to production ASAP. How do you all handle this?