Foundation

I am aware of the custom picker feature that functions as a predictive text input. However I want it to have the capability to select a value if it already exists, and if it doesn't exist, allow the user to input a new value.(Similar to Excel). This is necessary to prevent the creation of duplicate entries in a field. Can you provide suggestions on implementing this functionality while avoiding performance issues in the interface

Hi All, I have an Map operator which contains key value pairs as  {eventId:6,actualsId:1,planId:2} i saved it in a process variable in a script task and then when i tried doing the value as  pv!map.eventId it is saving the value as 6, if i do index(pv!map,"eventId",999) it is saving as 999 instead of 6. Not sure what is the issue. Any one faced such kind of issue in process model. Please Note : I tried this in Process model not in rule. In rule it is working fine.

I still got this error "The number of tasks per node  (Node name) would exceed the limit of 1000" after setting MNI as below:  Could some one help clarify the use of the highlighted tick box please? I thought it is to replace the looping if there are more than 1000 instances for the process node?

After querying a record, I am trying to access a value from a related record, but the value is not showing up. It just returns null. I checked my Record Lists to confirm the expected values are there. Ex. Record one called Activity Status has a many to one relationship with record two called Activity. Record Activity Status has the status of the activity for each user with a foreign key called ActivityID that references the Activity record. Record Activity has the name of the activity. Ex row for Activity Status: id 1, activityID 2. Ex row for Activity: id 2, name: "running" My record query returns the ActivityStatus with id 1 and activityID 2, which is stored in local!data. I am trying to get the activity name with local!data[recordType!ActivityStatus.relationships.Activity.fields.name] Does anyone know why this does not work?

Hi!  I have created an editable grid so the user can add new rows and fields manually (invoice lines). My next step is to make a validation to assure the fields match with fields in another previous interface (invoice header). The validation runs OK if I put an static condition (f.e. = "Prueba 1") but I have trouble when linking to a previous record field (the relationship between records is created and runs OK). Even though the first input of the previous record and the second input (actual interface) are the same, Appian recognize it as they are different values. The code I´m using for the validation is the following: validations: { if(fv!item['recordType!{b83ae990-aa66-4847-b974-1e1e40019294}CPF Maestro LÃ%ADneas Factura.fields.{14eaacbb-19fc-41e2-aea2-3ec9b3322722}idFactura'] = ri!recordLineasFact['recordType!{b83ae990-aa66-4847-b974-1e1e40019294}CPF Maestro LÃ%ADneas Factura.relationships.{fca16b27-3afd-4932-a545-53d4160413d1}maestroFactura

Hi everyone,  I have an interface that contain a submit button to submit a request, that when the submit button is clicked, it will start a process model by a!startProcess() in a!save(). After clicking the submit button, I want that process model to not run until 21:00 that day. How do I set the timer event to achieve that result? The button will be clicked every day, and I want to delay that day's process instances until 21:00 each day, not just 1 single day. I'm not sure how to define the date and time yet. Could any one help? Thank you!

Hi All, I have to apply character limit on text field like it will only show 5 digits after decimal and before decimal "n " number  ex. if we enter 1234.123456789 , it will show and store only 1234.1234567 thanks in advance

I have a use case where I should navigate from my interface to another application and should  create an object and after saving the changes, once it is saved it should again redirect back to interface

Can we increase maximum no of schema in maria DB allowed from 50 to 60 or any another number?

Hi Suppose  I'm Working in a application  i.e  X and i have to redirect to another application(using safe link) name i.e Y, if i create a object in second application i.e Y then i have to redirect back to previous application i.e X is there any way to do this ?

I am trying to save data in the submit button from CDT from interface into another array CDT where i use a!save(ri!big_cdt.subset1, a!foreach( items:ri!samll_cdt, expression: {fv!item.subset1}))... this way i am filling multiple values so that i can write array CDT into a datastore as multiple rows in an single attempt using write to data store in the process model. but, i get this error in the interface "Interface Definition: Expression evaluation error [evaluation ID = 2ce92:fe3b0] : An error occurred while executing a save: java.lang.IllegalArgumentException: Cannot derive list type from List of Text String in which to store data of type List of Variant" not sure what i am missing ?

Hi All - Anyone have any way to handle the validation message "The value provided is not an integer." in the Integer field?I would like to have the custom message for users when they are entering some Alphabets in the integer field. Instead of the above message.  Note: I don't wanted to use the text field with the regex validation rule to check if any alphabets were entered

Hi! I created an interface with an editable grid so that the user can add invoice line information and new rows. When clicking the button of confirmation, the rows must be saved into a record ([]). The interface runs in a perfect way when I test it (all the values I write are stored in local!data) , but when I try to add it to the process model an error appears :  Image of the error related with local variables (local!data): To create the interface I followed the steps of an Appian tutorial ("Write or Delete Records using an Editable Grid | Editable Grids, Part 2"): https://www.youtube.com/watch?v=z0FF9aCZRBE In the tutorial, we store the inserted values in a local variable (local!data), to end passing the information to the record. I leave here the code: a!formLayout( label: "Crear Nueva Factura (2/2)", contents: { a!localVariables( local!data, { a!sectionLayout( label: "Información de LÃ%ADnea de Factura", contents: { a!gridLayout(

Hi everyone, I ran into the following problem: I have a job model that downloads files from an S3 bucket and stores the downloaded documents on a constant in document format. I would like to know if by clicking on the image given by the a!documentimage function from an interface, it is possible to start the process that downloads the file to me and then actually see the download of the file. What I do now is use 2 buttons, one to start the process model to store the document in the constant and another one to download the file from the updated constant into the a!documentimage, but I would like to combine the two and use just one click. Thanks in advance.

Hi All, We have a requirement of uploading 500 rows at a time. Out of 500 instances i see few instances are failing with the below error. a!queryRecordType [line 2]: APNX-3-4300-001: Connection pool drained - too many concurrent requests: org.apache.http.conn.ConnectionPoolTimeoutException: Timeout waiting for connection from pool) (Data Outputs). What could be the reason of failure though the data is being fetched from the cached data of a record type? Thanks in Advance !!

Pdf load in component plugin html fails to load but gets loaded with the following iframe gets refresh. Please let us know what is blocking in SAIL to get this refreshed or loaded?

I am trying to export to the word doc, the spell check of the exported doc as we open is disabled. It isnt showing red underline under the misspelled words. Does anyone know how we can solve this as we open the doc?

a!localVariables() can be evaluated as empty a!localVariables() can increase the number of queries that are executed

can we make changes to the database in the development environment and can we changes directly in database

Hi Everyone,  We have a requirement where  Application is writing 500 rows parallely via startprocess smart service(Loop).   Now for every Write opertion sync will run that means sync will run 500 times in backend. It seems to be creating connection pool issue  though connection pool is 200.   can some one suggest the best soultion in this case? Thanks in Advance!!

Hi , Is there any possible way to extract table structure from single line string , like I am using the getpdftext to get the text in single like string , but it has table structure inside it, is there any way to extract the table from it? Thanks Bihitak

Hi, I need to put validation for two fields in below formats. 1. P (upper case).7 digits the user provided input should have first letter as capital P dot with 7 digits 2.  P (upper case).7 digits.2 digits the user provided input should have first letter as capital P dot with 7 digits and dot with 2 digits Kindly suggest on this

Hi ! I am facing a pagination issue with Grid Field.  I need to fetch data from a csv using previewcsvimport  and display it in a grid, batch size 10, but an error pops up when I try to move directly to the last page , only for the files which have (10n +1) number of rows.

Hi. I would like to implement a system that includes the following features: Regarding No. 3, please tell us whether it can be realized or not. 1. Create a list from a data entity containing video URLs. 2. Set up a link that will take you to some interface when you click on the list. 3. Dynamically change the video displayed in that interface based on the URL of the video registered in the list. Thank you.

We are sending 3 Documents for Customer for DocuSign using connected System. Requirement is hold the process After DocuSign Mail has sent to Customer and resume after the DocuSign completed by customer.(Real time implementation) once the user completes the Signature ,  we want to get response from DocuSign to Appian mentioning event completed until this response get from DocuSign to Appian the Flow will be paused. whenever the response hits the Appian then the Process has to be Resumed and  flow will be continued.