Discussion Categories

Hi! I´m trying to import a CSV to Appian via Cloud Database When I finish to enter my data and try to import, the following error appears: It seems like the table has been created but I have no access for some reason/permissions (I´m the admin of my site so I don´t know what to do). I wanted to ask: 1) ¿How can I correct fix this error? 2) ¿Is this the correct way to create a database in appian from a CSV? Thanks a lot

Hi All, We have developed an application. We have designed UI with front-end technologies and back-end with java,  But UI front-end technologies are not acceptable in Client side, Can we use Appian to design front end interfaces and link with backend java code?

Hi all, I would like to know if one of the process node had configured Exception Flow and then that node fails will it paused by process Exception or will Exception Flow triggers.Can you please give me some technical details regarding this. Best Regards, Divya

I have a record with all text columns, even the integer/decimal data is being saved in text type fields. In appian I want to sort ascending/descending properly but it is taking the ASCII value of string & sorting them on that basis. Is there any work around in "gridField" with data as recordType?

Hi! I have created a process model in which a validation is needed depending on the group of the user In this case, if the user is from the group "CPF Proveedores", a validation Interface should appear as a task for the users of the group "CPF_Gestores". In order to fulfill my objective, I configured the User Input t In order to fulfill my objective, I configured the User Input task this way: But the fact is that, when I enter as the user from "CPF_Proveedores", the validation interface appears to me, instead of leaving it as a "pending status" until the user from "CPF Gestores" approves/rejects it. This means that the logic of detecting the user is correct, but the interface is shown to CPF Proveedores too. What am I configuring wrong?  Thanks a lot for your time

Hi Team, I would like to understand the refresh rate for a readonly grid. What all options are available to refrehs the data based on action completion or loading data etc

can we declare  local variables inside a!foreach() inside expression rule 

Hi Everyone, is it possible to stop this dialogue box, if yes , How can we stop this dialogue box when we click on save option?

I'm trying to do a required field but I only want the option to select or deselect the required field, I know I've seen that done somewhere, do any of you know how to do it? Thanks

Consider there are three steps in a process which run parallel and each of the task is assigned to three users, now you need to design the process in such way that if any of the user completes a particular task then other two tasks has to be cancelled, what is your design approach in Appian

a!sideBySideItem( item: a!pickerFieldCustom( labelPosition: "COLLAPSED", placeholder: "Department", suggestFunction: rule!INO_departmentSearchSuggestFunction( nameList: if( rule!INO_isBlank(ri!selectedDepartmentList), ri!departmentList.departmentDescription, index( remove( ri!departmentList, wherecontains( ri!selectedDepartmentList, ri!departmentList ) ), "departmentDescription", null ) ), departmentList: if( rule!INO_isBlank(ri!selectedDepartmentList), ri!departmentList, remove( ri!departmentList, wherecontains( ri!selectedDepartmentList, ri

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