Discussion Categories

We have a series of Records configured in one large relationship structure (50 + record types).  A third party process retrieves data from a SOAP webservice, extracts pertinent data and using a series of stored procedures inserts that into the database. Is there a way to capture those new entries and sync them into my records without having to examine 50 tables and perform 50 Sync Record operations?

when user is working on any other tab and some task present in another tab (home page), then the user should get a blink message showing that a particular task has been updated. Any suggestion to achieve it?

I have a form that is used to upload documents.  The form works as intended except when removing a document the user just uploads.  Typically, a user can hover over the document icon and it will turn into a "X".  The user can click on that and remove the document so that another document can be uploaded in its place.  When the user does this, the following error is thrown. Expression evaluation error at function a!fileUploadField: An error occurred while executing a save: java.lang.ArrayIndexOutOfBoundsException: Invalid index (1) for list: valid range is empty. The code for the fileuploadfield is: a!fileUploadField( label: "File Upload", labelPosition: "ABOVE", instructions: "Use this to upload speaker documents.", target: tofolder(ri!speakerRecord['recordType!PMSO Speaker.fields.speakerFolderId']), maxSelections: 1, value: local!file, saveInto: {

I want to display the list of members in grid in row and wants to perform the user interaction like select the  multiple row to delete.

Hi, I have a very strange issue with a RecordType and a Process. So I would have 2 questions : 1/ My recordType is based on a simple table Category(#categoryId, name, isActive, fkIconId, orderNo) and the corresponding ProstgreSQL table contains a Primary Key with SERIAL on the "categoryId" field. I've created a new RecordAction to call a process, and the RecordAction passes the rv!record to the process.{ myRecord: rv!record} I've created an Interface with a RecordType based Grid, to try my recordAction :but when I click on the button on a grid row, the process is launched with the bad parameters : Example1 : Click on row(categoryId=4, name="CAR", isActive=true, orderNo=2) => but in the process instance I see this log : changed to {categoryId=2, name=BICYCLE} Example2 : Click on row(categoryId=2, name="BICYCLE", isActive=true, orderNo=4)=> but in the process instance I see this log : changed to {categoryId=4, name=CAR} It is exaclty like

I want to add a custom record field to a record, this field should calculate a count with related record A when isActive=true and calculate a count with related record B when isActive=false. How should I do? And how do I reference to other field(eg. isActive) in current record when writing expression for custom record field?

Hello, Having followed the Appian guide on how to use both doc extraction and doc reconciliation nodes, I am now running into a problem whereby the process does not seem to be learning from the multiple reconciliations that I have done. The documents that are being read are all structured the same way, with the desired information always being in the same place, yet, every time I process a new document, the same information is being recognised/unrecognised. Furthermore, when I run the process without a reconciliation step, some of the information which was previously automatically identified during the reconciliation is no longer identified. Does anyone know what I can do to solve this issue? Thank you

Hello We need to work with files larger than 1 GB, and in particular we have two scenarios: 1- A portal made in Angular, where users external to the organisation will attach a document larger than 1 GB. We need this file to reach Appian and then be sent to a sharepoint of the organisation. We have a limitation when receiving the file from the external portal as the appian api only allows 75 MB. 2- The other scenario is that a user in appian wants to attach files larger than 1GB in an appian interface with the uploadfile component, then appian through a web service must send it to sharepoint. We have the problem that the uploadfile component only allows 1GB. For these two scenarios, what would be the optimal solution?

I have two fields like this, only when "Yes" is selected for "Limited" field can user input value for "Limit" field. But I found when "Limit" is disabled, the value is still there. How can I clear value after "Limit" is disabled?

Hi All, We're interested in creating an Appian service using a Web API to return documents to an external client who will be processing these documents as part of a routine backend batch process.  While it's well documented how to convert a document to base64 in the request body for an outbound API call using an Integration object, I haven't found documentation on how Appian documents can be converted to a base64 string to return as part of the response body in an Appian Web API.  Curious if anyone else has had a similar use case and how they got around this. Thanks!

I want to update milestones with a new list of dictionary. Is there any way to do that? 

Hi all, I have a requirement of dividing 12 months in current year into 4 quarters. Can anyone help me with it?

is there a way to retrieve more than 4000 characters from database using either records type or data store entity 

Hi team, I have a requirement where I need to add multiple assignees to a request. To do that I have created a child record for Assignees and with "id", "Assignee" and "isActive" fields. To do this I have created a rule input and added this child record as an array. I have added a user picker field "Assignee" where I was not able to save multiple values to Rule input. Can anyone please help me. Thanks!!

I have number greater than 10 digit and that stored as a text and  I want sort them. I have tried with sortextarray() that is sorting based on ascii values so it is not giving me correct output. and I tried to convert into int but that is giving me infinity Please help me here to sort the array. Thanks in advance.

Hi everybody,I want to put some multiple default values into a Record Filter, but I don't know how.I see that with only one default option works correctly, but in the case in the screen didn't work.

Hello everyone, Here is the code for a field. When the user gives an input, there are some controls that should be verified. I want to add some code so that if the user gives an input that doesn't satisfy the condition, the field should be initialized as empty. How can I do this, please? a!integerField( label: "Montant Apport", labelPosition: "ABOVE", placeholder: "Donner le montant exact de l'apport", value: ri!record['recordType!{3e104763-60d6-49a4-8cdb-405e073de678}PBY prêt.fields.{0f648b9f-079f-483f-87ad-d8a64c53802e}montantApport'], saveInto: ri!record['recordType!{3e104763-60d6-49a4-8cdb-405e073de678}PBY prêt.fields.{0f648b9f-079f-483f-87ad-d8a64c53802e}montantApport'], required: true(), validations: { if( and( not(isnull(ri!record['recordType!{3e104763-60d6-49a4-8cdb-405e073de678}PBY prêt.fields.{0f648b9f-079f-483

There is a requirement that we have a means for non-appian users to create new accounts in the application I am working on. Since Appian does not appear to have any built in means of allowing this, the current workaround is to make a web API that connects to an external site and kicks off a process model which can make new users. This kind of makes us nervous (particularly since there is no way to delete unnecessary users in Appian), so we added an admin approval step before the actual user creation stage, but we're still a little nervous about potential DDoS attacks and the like. Is there an in-Appian method to limit how often an API gets accessed? And if not, is there some other best practice to prevent attacks on Appian APIs? 

Hi, I have Selectable Read-only grid and when I select few rows and click on select button a review grid will appear on the next page with the selected rows. Now I have an EDIT button which takes me to the previous page to select/de-select the rows, then here comes the issue that all the previous selection of the rows are getting removed. The EDIT button doesn't have anything to remove the selection. I'm not able to figure out what the issue is.. Can someone please help. This is my code for the selectable grid and review grid.  a!localVariables( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: cons!RGRACSLBL_BATCHSIZE_5 ), local!selectedBDLMAgreementActivities: if( not( or( rule!APN_isBlank(ri!BWELSelectedIds), rule!APN_isEmpty(ri!BWELSelectedIds) ) ), index( ri!veevaResults.data, wherecontains( touniformstring(ri!BWELSelectedIds), touniformstring(index(ri!veevaResults.data

Hi,  Am currently taking Appian Developer course and following the steps to build Acme Auto Site. While adding a new page to the site, its not able to look up for the record types in the content filed. Am trying to add Vehicles page of Record List type. It shows some error in the developer console, after some time it says gateway error.

I have a question about system groups.This is an issue within the environment managed by the organization.I want to add the interface I created to the design library, but I don't have permission. When I looked into the documentation, I found out that it needs to be added to the "Design Library Editor Group". When I selected a group object from the list of objects for the entire environment, the corresponding group did not exist. I tried adding a group object within the application I want to use, but no permissions are attached. Which steps should I review? Thank you. システムグループについて質問があります。組織で管理している環境内の問題です。作成したインターフェースをデザインライブラリに追加したい、しかし権限がありません。ドキュメントを調べていくと「デザインライブラリエディターグループ」に追加されている必要があるとわかりました。環境全体のオブジェクト一覧からグループオブジェクトを選択したところ、該当するグループは存在しませんでした。使いたいアプリケーション内でグループオブジェクトを追加してみましたが権限が付くことはありません。私はどこの手順を見直すべきでしょうか？よろしくお願いいたします。

Hi All, My requirement is to read the excel sheet data and to write it into Database table from Appian. The excel sheet contains some dateTime columns. But when we read the excel sheet in Appian, it considers all the columns as text, so I am getting the dateTime as below format when I read the excel, example 1: "2024-01-31 09:14:36" example 1: "2024-05-28 15:14:36" But I have created  columns with dateTime datatype in CDT/table, so please help me to convert the above dateTime text to dateTime as below formats, output 1: 1/31/2024 9:14 AM output 2: 5/28/2024 3:14 PM Thanks in Advance!

Hello All, My use case is using ai-knowledge-assistant(community.appian.com/.../ai-knowledge-assistant), chatbot will ask question sequentially like ai-knowledge-assistant: Hello! I am your assistance. How can I help you? Human :I want to register one student in the school. ai-knowledge-assistant:sure! what is the name of the student? Human : Arka ai-knowledge-assistant:what is his previous school name? Human: Abc ai-knowledge-assistant: Please upload the school results <Upload button> Human:<human uploads the document> ai-knowledge-assistant: Please review the below information  Student Name : Arka Previous school: Abc School result Please confirm  Human: I confirmed <system creates an entry in the student record > Now my question are  1. Is it possible to show the question sequentially ? 2. Is it possible to have a button to upload a document and save it  document folder? 3. Is it possible to trigger the process model after user says li

Good day, I would like to know if there is a plugin that allows extracting data marked as "tags" in .doc/.docx documents I would need the same functionality that the PDF Tools plugin allows with .pdf files (getPDFFormField, getPDFText, etc.) but for MS Word files Thank you very much in advance and farewell. PS: In the image: example of a MS Word tag from which I want to extract its information