Discussion Categories

Hello, Please let me know if we can generate the password protected excel using Appian? or make the generated document password protected? Thank You!!

Is there an way to list all expression rules in an application inside an expression rule itself. Or list all the Appian rules insider a rules folder. My purpose is to find expression rules in an application with and without test cases.

Hi All, We have a Postgre SQL DB connected to Appian system, and we are trying to fetching the data from respective table. i created CDT, entity mapping verified & Data store published successfully. In Rule Expression, when we tried the query entity for this DSE, we are getting below error.  Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [AAFAssetDT2555], query: [queryentity expression], order by: [[Sort[assetpreviousstatus asc]]], filters:[null]) could you please suggest me to resolve the issue.

Hi! I'm having trouble trying to modify this list of maps (which I get from a!queryRecordType with an aggregation). local!Grades: {a!map(Group: "A", Excellent: 0, Good: 0, Regular: 0),a!map(Group: "A", Excellent: 2, Good: 0, Regular: 0),a!map(Group: "B", Excellent: 0, Good: 0, Regular: 2),a!map(Group: "B", Excellent: 0, Good: 2, Regular: 0),a!map(Group: "C", Excellent: 0, Good: 2, Regular: 0),}, The aggregation does not allow me to get each Group in only 1 row, because I need to "count" the grades by category (Excellent, Good, Regular) I would like to display that result in a read-only grid and am trying to prepare the data before displaying it there (as I read in some other suggestions). The result I am trying to obtain is this: local!Grades: {a!map(Group: "A", Excellent: 2, Good: 0, Regular: 0),a!map(Group: "B", Excellent: 0, Good: 2, Regular: 2),a!map(Group: "C", Excellent: 0, Good: 2, Regu

Hi Team, I have requirement to get the groups names which has the input value which we pass. For example: If I pass input value as "United States" I should get the group with the name "<App prefix>_United States", India => "<App Prefix>_India"

I am working in a planning poker App, and I'm trying to refresh the values for all users at the same time automatically after some record action is executed. I just don't want to complete the action via dialog window, is there any way for doing that or am I doomed?

 [mention:89ec515a02ff4fa28317edeb40cf0a4d:e9ed411860ed4f2ba0265705b8793d05]  [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05]  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  and [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] will be there - come ask them your questions live!

Hi All, Its very urgent. I am facing an issue with removing <style>......</style> from the HTML text. I want to remove all the text/special character/all the property between style tag. <html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style> <!-- @font-face {font-family:"Cambria Math"} @font-face {font-family:Calibri} p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif} span.EmailStyle17 {font-family:"Calibri",sans-serif; color:windowtext} .MsoChpDefault {font-family:"Calibri",sans-serif} @page WordSection1 {margin:72.0pt 72.0pt 72.0pt 72.0pt} div.WordSection1 {} --> </style></head><body  style="word-wrap:break-word"><div class="WordSection1"><p class="

Hi team, I want to display a refresh button in a interface after upload action(record action item) takes place.It should not be displayed when the interface loads. I tried using  a!refreshVariable but it is not working as the variable is always true as in value field. can anyone tell any ways of achieving this?    Thanks in advance.

Hi Export Data Store entity to csv smart service cannot work expectedly. Export Data Store entity to csv smart service only 50 columns can be used. I have more than 50 columns ,so i want to select desire column . but got error and cannot fix error.pls help !! Thanks

Hi I am having 2,60,000 of data in MS SQL Server. How can I bring all the data from MS SQL Server and store it in Appian Cloud database.

Hi Everyone, Is there any way to include radio button instead of check box in read only grid for selection?

Is it possible to add new fields/columns to the database using an interface and automatically update record list columns and other dependent interfaces? 

Hi there, I have created a button to generate CSV file but after clicking on button- page redirects to home page. I want to create document link when clicking on button so that file get downloaded. How can I do this in interface? Thanks

Hi All, Is it possible at all to edit the reassign task screen? I want the user to be able to only select a certain number of groups not all the ones available in the application itself. thanks in advance

Hello Appian community,   There is a way to create an EML file other than using the plugin "Create & Read Email Files Utilities"?   In this moment y have 22.4.870.0 version  Thanks in advance  

I'm the Agile lead for my company and I'm trying to shorten the feedback loops for the Appian development teams I coach.  They are very resistant to splitting stories and complain that the Appian platform and its object model make splitting of large stories difficult if not impossible.  I keep pushing back against that narrative so they will try the experiment but continue to get resistance.  I've seen no evidence in my research that supports that claim.  Can anyone provide insight into whether story splitting is indeed not possible or practical for development teams employing Appian?

I am trying to pull the records from a reference table.  There are 4 records in the table. However, the expression rule is only pulling three records. There are no filters on the record type. The Expression Rule a!queryRecordType( recordType: 'recordType!PMSO REF VolunteerRequestStatus', fields: { 'recordType!PMSO REF VolunteerRequestStatus.fields.VolunteerStatus_id', 'recordType!PMSO REF VolunteerRequestStatus.fields.VolunteerStatus' }, filters: { a!queryFilter( field: 'recordType!PMSO REF VolunteerRequestStatus.fields.isActive', operator: "=", value: true ) }, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10, sort: a!sortInfo( field: 'recordType!PMSO REF VolunteerRequestStatus.fields.sortBy', ascending: true() ) )).data

Hi All, Currently we are able to configure custom DL email ID (eg: testmail.com) in tomcat server for Appian process alerts (Appian process alerts which we will receive when process got failed or error).But how to configure Subject (eg: PROD) in tomcat server, so that if any Appian process fails or error we will receive process alert with Subject displaying PROD. This will helpful to identify the Production environment process alerts. Please let us know if more details needed. Regards,Sandeep

Hi Team, I have designed an interface which has 1 Rule Input  Now on the UI I am calling an integration and getting data from the integration The requirement here is to save the data coming from the integration to rule input  but without clicking any buttons. i.e. there are no buttons in the interface (if there were buttons I could have used the saveInto parameter of it)  Is there any alternative way to save the data to my RI ?

I want to check specific developers' changed objects based on date range, is there any way can do that?

Hii, I am getting this error while clicking on record Action: An error occurred while applying the context for the GAI Grant related action [identifier=253]. Details: The record data does not exist, has been deleted, or you do not have sufficient privileges to access it. How can i resolve this ? ), a!gridColumn( value: a!recordActionField( actions: a!recordActionItem( action: 'recordType!{8b4ab8ba-4c5b-4a6e-bf36-23ee7bb475b3}GAI Grant.actions.{4e3745c4-618f-44fe-a3de-3c29fd228894}editProjectObjective', identifier: { appId: ri!appId, projectObjectivesId: fv!row['recordType!{0b254c54-d92c-4674-a733-f9a9e4e2b147}GAI Application Project Objective.fields.{bd9fc329-44b3-4179-bd65-a400aee6091c}projectObjectivesId'] }

Hi team, Am working on an app which aims to updated external database(Mongo DB) and for this we are using Mongo DB connected system. Now we have a use case where we must update an existing collection entry with new details, and we are facing problem to update it correctly. Below is my collection structure.   Col A      Col B Col C [ {NestColC1A,     NestCol C1B,      NestColC1C}, {NestColC2A,     NestCol C2B,      NestColC2C}, ] Col D [ {NestColD1A,     NestCol D1B,      NestColD1C1[ {NestNestColD1C1A1,                    NestNestColD1C1B1,                      NestNestColD1C1C1}, {NestNestColD1C1A2,          &nb

Hi All I am working on version 23.3. My use case is to extract data from a PDF file; the data can be both hand written or system written. In case the content is system written; after few runs; the system is able to extract certain amount of data from the PDF (which is the expected behaviour from AI Document Extraction). However, if my input PDF document is hand written; no data gets extracted after multiple cycle runs as well. Can any one please guide as to how I can achieve data extraction from hand written document as well or what am I missing to achieve my goal. I am referring to the following link to achieve my goal (Note: Currently trying to capture PDF data in CDT; not in record for my POC): Create a Document Extraction AI Skill - Appian 23.3 Thanks in advance!!

Hello Everyone, I am working on a!gridField and need to select the rows which are of same status and other rows should be disabled(Non selectable). For Example : If I select any row with status :"Inprogress" then only inprogress rows should be selectable where other rows should be in disbaled.Later similarly if I select a row with Draft status then only draft status records should be selectable and other should be disabled. Please help me if anyone have worked this kind of requirement. Thanks in advance.