Discussion Categories

Hey developers, I need some help. Can anyone tell me what the problem is with this interface? I cannot update two records using the same button. a!localVariables( local!livret: rule!PBY_getLivertByUser(), local!accounts: rule!PBY_getoccountByUser(), local!transactionAmount: if( not(isnull(ri!record['recordType!{4af9711d-c31c-43ce-b28b-448102fcb3db}PBY virementInterne.fields.{16a63de7-fa2e-4180-ae25-b255d12f5d9f}montant'])), ri!record['recordType!{4af9711d-c31c-43ce-b28b-448102fcb3db}PBY virementInterne.fields.{16a63de7-fa2e-4180-ae25-b255d12f5d9f}montant'], 0 ), local!selectedAccount: index(local!accounts, 1, {}), local!accountName: local!selectedAccount['recordType!{b37748b2-8103-41ea-8028-2b358e4f229c}PBY account.fields.{ed06f701-2605-4d77-bcbe-b3806b766f9d}Nom'] & " " & local!selectedAccount['recordType!{b37748b2-8103-41ea-8028-2b358e4f229c}PBY account.fields.{cdd08f61-8471-4cc4-960d-99bdc81ed235}prenom'], local!solde: local!selectedAccount['recordType!{b37

Hi folks, is there a way to limit the size of a file with fileUploadField function?

Good afternoon, I am trying to compare in a foreach loop a data with the previous iteration, but I am not able to access this iteration, is there any way? I need to sort a list, but if there are two equal values ​​they have the same order, with the array{ name:"aaaaa", valor:2 name:"bbbbb", valor:10 name:"ccccc", valor:10 name:"ddddd", valor:10 name:"eeeee", valor:45}get as a result{ name:"aaaaa", pos:1 name:"bbbbb", pos:2 name:"ccccc", pos:2 name:"ddddd", pos:2 name:"eeeee", pos:3}I am trying to save the pos outside of the foreach in a local variable, or recover the value saved in pos of the previous item Thank you very much

Hi all, We are using a read-only grid to display data from a record and have the Export to Excel option available. The problem we are facing is that the Excel also includes the Edit and Delete Row columns which we added to the grid to add these functionalities to the interface. Does anyone know if we can select the columns we want to be included in Excel or how to delete these two columns? Thanks in advance.

Hello is it possible to create a staked column chart like below: /resized-image/__size/996x878/__key/communityserver-discussions-components-files/13/Screenshot-2024_2D00_06_2D00_21-at-2.37.11_2F20_PM.pngThe data is like thisLous Total:50         Running: 30             D1: 5             D2: 10             D3: 10             D4: 5        Completed: 20             D1: 20How do I achieve this kind of chart. Thanks 

Hi All, When I try to click the link 'Click here to download Report', it is not at all moving. We are on Appin 24.2 version and following is the code written a!linkField( links: a!documentDownloadLink( label: Click here to Download Report (Label), document: local!generatedReport Please help.

Hello, I require your support, well, I have a problem, or rather a very big doubt, is it possible to do a foreach to get data from related records? For example:supposing I have the following records:Record PersonRecord AddressRecord AccountRecord idRelationship the record idRelationship record will help me to relate the other records by means of an id. so far so good, (I hope I understand) then, I need to make an expression rule that will bring me the ordered data for a cdt, or a map, 'this is for formatting purposes'. what i am doing is relating my records, and inserting data, I am first sorting them by local variables localVariables( local!relationship:rule....(relationship: Record idRelationship....) local!getOwner:{ Record Person Record Address Record Account } local!getBenef:{ Record Person Record Address Record Account } is something like this, so after I do my indexing, what I do is create another local variable that does my foreach, but for each 'beneficiary' that I h

Hi Everyone, I am new to apian and I am bit stuck on logic for validating grid records on save button. Heres my scenario I have been working with- I have grid with 5 columns, first 2 columns are read-only as the user entered data will be seeing on this form in my process model, 3rd column is where user has to enter the values if the 4th column is unchecked. 5th column is mandatory when  4th column check box is true.  I want to save records when either column 3 is filled or save when column 4 is checked and column 5 is filled. the below code isn't working  validations: if( and( count(local!items) = length(local!items.column1), count(local!items) = length(local!items.column2), or( count(local!items) = length(local!items.column3), and( count(local!items) = count(local!items.column4 = true), count(local!items) = length(local!items.column5), length(local!items.column3) = 0 ) ), ), "", "Please ensure you have entered Address Book Number or checked Excl

Can someone help in configuring DOCX From Dynamic Template What document should be sent for Docx Template and how to generate Xml data model, Can someone share sample screenshots

I've updated the application object securities to Inherit from parent  then 1 object of application and 1 connected system object is now following securities from root folder respective to "Application" & "###SYSTEM_CONNECTED_SYSTEMS_ROOT_FOLDER" . So , how can I remove this inheritance security. Also, for root folders what is the default security. I'm also facing issues to set those.

Problem Statement : by using Self Service Analytics can i build elastic Search and it will show case me the data according to it ? Is there any feature or option to build a global search for entire project. If i Search like  i want List of Employees part of Some XYZ Project. then it should show case the data accordingly. Just like a google Search and show the Results(Grid, Reports etc) in Appropriate manner from the database. I have tried documentation but could not able to find anything. Please let me know is there any way to do it ?  Thanks, Praneeth

Hi All, This is the setup I have for my start node timer - if I change the selection for daily or weekly it works fine and saves, but for monthly is not letting me save. I want it to run the last Sunday of every month. Has anyone faced this issue before? Thanks in advance

Does anyone know how to find out or know what the version is of the JDBC SQL Server driver deployed to an Appian cloud instance that is v23.4?

Hi Everyone, I have a requirement to send a reply email using Appian. Generally, I receive emails using the mail poller plugin in my system, and later I display them in the interface. Now, users need to send a reply email. Is it possible to send a reply email in Appian that is linked to the original email's thread? If not, are there any workarounds? Thanks. [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] 

Hi team, How to implement autosuggest feature for  a!paragraphField ,as we do not want to use the   a!pickerFieldCustom due to the small size of the text box. Please suggest.

I am trying to use the Selection Node Input to limit and rename the fields I want to export to Excel.  However, I can not figure out how to set this up.  The documentation is no help.  It states to use the a!querySelection() and then the a!queryColumn() functions when setting up the columns. However, the configuration input seems to have the ability to add columns, fields, alias and visible without using the functions. I have tried to key in the fields, alias and visible into each of these inputs, but for the life of me, I can figure out how to add in more columns and adding just one selection throws an error, "Query has failed: Could not parse expression [1]. Details: Unexpected count of record variables (APNX-1-4505-005)" I have tried to write the Jason using the a!querySelection(a!queryColumn(),a!queryColumn(),etc...) at the Selection and Columns level.  This just throws the same error as above. a!querySelection( { a!queryColumn( pv!pe

How can we remove/delete the current working draft version of the Process Model so that it reverts to the last published version and removes all changes done in the draft version? If we load the last published version, we need to save and publish it again. It will create an unnecessary new version. Hence, looking for any other option if available.  Please suggest if there is any other way to do this.

Can I create a process model or a plugin to listen to user logins? I would like to create the user based on another API.

How to calculate 15th business day of every month excluding holidays and weekends?

Hi all, I have a user account that was mysteriously deactivated. It may have been due to account inactivity but I would like to be sure. Are user account deactivations stored in the logs anywhere whether they are done manually or due to passing the inactivity threshold? Thanks, Christian W. Harris

I have 20 custom filters created for my read-only grid. I am unable to create more filters.Error posted above. Is there any way I can increase the saved filter limit?

Case Management Studio has several out of the box email notification like case creation, case assignment confirmation. I want to send email notifications as per my requirement with email template of my choice.Is it possible in Case Management Studio? If yes how to do it?

Hi! Does anyone know if there is a native or out of the box way to retry an integration when it fails? or the only option is to do a manual retry on the object that uses that integration?

I have a story where I need to create a PDF document. Within this PDF, I need to incorporate multiple fields and grids. While the fields are functioning properly, I encountered an error when attempting to dynamically add grids. Interestingly, there are no errors apparent in the XML structure. However, during the process of converting the XML to PDF, an error arises.Error:  freemarker.core.NonStringOrTemplateOutputException: For "${...}" content: Expected a string or something automatically convertible to string (number, date or boolean), or "template output" , but this has evaluated to a sequence+hash (wrapper: f.e.dom.NodeListModel):==> wo.@vendorName [in template "fr.opensagres.xdocreport.document.docx.DocxReport@322fce7b!word/document.xml" at line 4, column 28085] ----Tip: This XML query result can't be used as string because for that it had to contain exactly 1 XML node, but it contains 0 nodes. That is, the constructing XML query has found no matche

Hello, I know APPIAN has no OOB feature for phonetic pronunciation yet. Any suggestion for text to speech plugins or how to implement one? Reason -- User wants to pronounce the correct names when in-call with consumer. Thanks! Ajay