Foundation

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, I have a requirement of dividing 12 months in current year into 4 quarters. Can anyone help me with it?

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.

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

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

When DB Write to DS is giving locking issue saying it is Locked by some other process. Below is the error message. com.appiancorp.rdbms.common.LockException: Could not write to the entities [XXXXXX] of data store "XXXXXXXXXXX", because the data is locked. (APNX-1-4180-00A): javax.persistence.OptimisticLockException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : XXXXXXX

Hi In our environment we are following GMT time zone as default. We have a scheduler we needs to run at 15:00 London time which is as expected during daylight saving is off but during the daylight saving is active then also it should run at the same time i.e, 15:00 London time but it is running at 16:00 London time.we tried to use the isDayLightSaving function in the timer (start node) but it seems not working.Please suggest how to make the timing consistent.

hello, im develloping an application that contains 2 groupes i have created a sign in page this page allows me to  create a new user and then add it to a specifique group , now i want that after the user receive a mail that contains the login and the password to his appian account an interface that contains information will be played ( i want to display this interface directly after the user loged to appian )  any help how can i do this please !

I have PDF pages that are being created as part of an HTML template. Basically an indefinite amount of these attachment pages can be created depending how many filing numbers the user inputs for their filing. HTML from template node -> HTML to PDF node. This is all working fine.  The last page of filing numbers, if it's only a partial page, which usually is the case - the last page being just partial, is printing landscape. The print preview looks like all the other pages, but when the pages are printed, it prints out landscape. Anyone have any reason why this might be? Thanks

I have been trying to run automated testing through Jenkin. I have followed appian documentation Running Automated Tests on Expression Rules with Jenkins - Appian 23.4 . I was getting several errors and managed to solve some of them and got stuck at one particular issue.  Highlighted all the errors faced so far -  I was getting below error but managed to resolve it by modify the “build.gradle” file. I have removed the less-than symbol (<<) in build.gradle file. After resolving above issue, now I was getting message “Could not parse content-type header”. I have resolved it by adding header (content-type: text/plain) in “ciStartRuleTestsApplications” webapi. After resolving above issue, I am getting error related to “java.io.Writer” For better understanding of error, I have added parameter “--stacktrace” to task in Jenkin build step, it shows “noSuchMethodError” Error type.   Can so

I just want to know how much score i have to get for passing the ACD 101 Certification Exam

Hi Team, Recently, I had used the "getdocumentsfromfolder" appian function. For few days it worked well but suddenly it started throwing error saying that - The function getdocumentsfromfolder is unavailable. Could you please help me out what could be the possible reason for this error. I have attached the reference screenshot below.

I am calculating time difference between 2 time stamps in   hours: min :sec   format  . Now my problem is I have to eliminate weekends between 2 time stamps and calculate difference in   hours: min :sec   format  

I have a requirement where before submitting the form (without clicking submit ), it should call the integration and validate the entered text , if incorrect data is present then throw validation on UI . Is it possible to call the integration with in interface?

Hi All, I want to create an interface with French language. Excluding "LOAD Resource Bundle" plug in and new features of 24.1 release. There is any other way to implement this? If yes please suggest me. If no then please guide me how to use LOAD Resource Bundle plugin steps for the same.

Hello everyone, I have a question. I'm developing an application. The home page contains two buttons related to record action. The first one is the "Create Account" button, where the user can create an account and input different fields. This button works as expected. In the process model related to this page, I have added a "Create User" node so that after the creation, the process sends an email containing the name and password for the user. Now, I want to create a "Sign In" button. Is that possible, and how can I verify if this account really exists?

Appian month to text conversion  issue I am using this command month(today()) ---> it print current month  after this i am plan to convert this as a text format  like  text(month(today()),"MMM")  my output is something different  let me know the cause of this 

I just want to know Can a basic user get the access of the appian designer if account is related to community account only. how is it possible to give the designer access to a basic user. i have check it but did not find the system designer group if we set basic user authentication to a user. Please help

Hi Team, I am Self Learning appian and now creating  interfaces, i want  a requirement to create Repetitive Section Layout based on input integer value Scenario is let a integer input vale named Number of clients count.  now i have collect the first Name, last Name and some other fields of clients, i created a CDT for those client data and created a Rule input as the interface is as shown below, when the number of client value is empty , we are displaying only one section layout as default. When i entered 2 as number of client, i got 2 section layouts how since i use for loop to display the recursive section layout, when i enter the details of first client , its is copied into second layout also i tried using indexing , but i faced problem when i am inserting data into fields. How do store Values into list type rule input in this situation. please help me, Thanks in advance I am attaching code for review. let me know if I made any mistakes { a!cardLayout(

Due to the Appian upgrade there is a significant impact in DOM element of the webpages, most of the web elements and structure of the elements (of webpages) got changed. Due to which our selenium script is unable to locate the elements in a page anymore.Hence Automation Scripts are not working. Earlier we tried using Unique ID as a Identifier to locate elements  but due to restrictions from appian product we have to use xpath to identify element on UI.  After Appian upgrade,  plugins related to Appian also got updated and due to which Xpaths we have used in older versions are not working in new appian version. As Selenium is dependent on DOM elements for automation , hence its creating a huge impact. In order to make our script work, a significant amount of efforts are required. So How to minimize the effort and ensure that for Future appian upgrades our automation scripts doesnt fails?

Hi there, I'm trying to get details about a typical error that I constantly seeing on a process.  A little background: This process is suppose to read rows from the uploaded spreadsheet, based on row validation it has to complete two sets of DB updates. In current configuration these uploads are done when the valid rows are passed through a start process smart service. Since we have to update two different tables we have created a parallel flow after AND gate to complete the same. But the problem arises when one of the node completes and hits the end node and the other node waiting of the sub-process to complete. Please check the screenshot attached. Consider to share the reason for this error and suggest the possible methods to avoid this. Thanks, Vishnu Devalla 

Hi, Is there a way to restrict APPIAN basic users to access tempo site? Thanks/Mp

Hello Everyone, I am using rich text display field to capture ranting from user. I want that field to be required and i am not able to figure it out how to do that. Your help will be appreciated. Below is the code i am using. a!richTextDisplayField( label: "Rating", value: { a!forEach( items: enumerate(ri!totalStars), expression: { a!richTextIcon( icon: if( fv!index <= ri!rating, "star", "star-o" ), link: a!dynamicLink( value: if(ri!rating=fv!index, 0, fv!index), saveInto: ri!rating ), linkstyle: cons!MMS_DG_LINK_STYLE[2], color: cons!MMS_DG_BOX_STYLE[2], size: cons!MMS_DG_LINK_SIZE[1] ) } ) } )

Good day, I am new to Appian, I am trying to use the specific values in a return from a record query in a portal interface. I am using the interface for a customer data card using an expression, I now want to expand the information on the card to include bank branch information (name, address, etc) I have an expression that gets the branch information from a record type based on the branch Id and I am calling that into a local variable in the interface. My problem is that I do not know how to access specific parts of that local variable in order to display the data. I have tried a read only grid but get an error Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 105]: A grid component [label="Read-only Grid"] has an invalid value for "columns". A grid column [label="Branch Id"] has encountered an error. Expression evaluation error: BNK Branch can only be indexed into using squar