Community

Hi All, Need your help in the following issue: Please how can I get the difference  between two dates should not more than 24 hrs?  For example 1 : Start Date = 7/1/2024 12:00 AM EST End Date = 7/1/2024 11:59 PM PST if user enter the above dates and time than Don’t allow to select since the difference is > 24 hours Thank you in advance for your help!

I am trying to complete the Query Your Data lesson and I followed the instructions in creating the Query Your Data (W000QYD) app, but when I go to search AA_GetVehicles in the expression rule, I keep getting a message saying I do not have permission to see all the objects in the app. I also cannot make a new expression rule with the name because the expression rule already exists. Does this have something to do with my security settings?  I created the app so im confused as to why I wouldn't be able to see all objects. Please let me know, thanks.

Hi All, I am using dateandtime field to send an invitation on mail, here i am facing issue with time, when i am selecting a date and time, the ttime which i am selecting which is showing different in grid field Like i am selecting 06/28/2024 05:00 am it's showing in grid as 06/28/2024 09:00 am which causing issue for time difference in invitation. So any one please suggest attach below code. a!sideBySideItem( item: a!dateTimeField( label: "Event Start Date & Time", labelPosition: "ABOVE", value:local!eventStartDateToSave, saveInto: local!eventStartDateToSave, required: true, requiredMessage: "Input required!", validations: {} ) ),

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

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

My goal is to produce an excel file from a set of Clergy Pension records.  My plan to do this is: 1.  Create an CDT to hold the data for the excel spreadsheet 2. Create an Expression Rule to create the data for the CDT 3. Use the Expression Rule in a Process Model to populate the CDT 4. Use the Export Data Store Entity to Excel smart service in the Process Model My problem is with the Expression Rule,  In the Expression Rule, I create two local variables; data and report.  The local variable holds the results of the query and the local variable report is formatted data for storage into the CDT. To create the local!data, I use a!queryRecordType() to pull the records I need.  The data comes from several tables and I use the Relationships from the main table of the query, CPMA Clergy Pension.  I filter and sort the data. Here is the code for local!data. local!data: a!queryRecordType( recordType: 'recordType!CPMA Clergy Pension', fields: { 'recor

Discover how Appian’s largest department, Engineering, is powered by our own Appian apps! Join us to see "dogfooding" in action as we leverage our platform to gain user insights and enhance our capabilities. In this exclusive livestream, our lead product evangelist, @April Schuppel, will be joined by @Suvajit Gupta, Executive Vice President of Engineering at Appian, for an insightful discussion. What’s on the agenda: Explore our internal apps and gain tips to improve your own operations. Uncover the possibilities with data fabric, AI, total experience, and case management. Engage with us and get your questions answered in real-time via live chat. Turn on notifications to make sure you don't miss it!

Why I cant see the database and admin in top grid. I am trying to create a database for my application

Hello, Could you please confirm is there any way to test appian application using fitnesse and cucumber (Selenium BDD) both tools. Also, how to integrate fixture files in fitnesse for appian application. Thanks in Advance.

I am facing issue in identifying the objects using Selenium/Java on sample Appian application available at Community edition site as below: Similar issue I am facing in working project screens for one of the clients. 1. Multiple - Dropdown: The dropdown values are not defined as Static. The <div> id has changed whenever page is getting reloaded. 2. Date Selector: The <div> id has changed whenever page is getting reloaded. sendKeys () method is also not working since the field was changing dynamically.

In exercise 8, when I want to do "Start Process for Debugging", I get the following error whenever I try to enter values into the fields "Expression evaluation error [evaluation ID = FI5GM] in rule 'wsaa_addvehicleform' at function a!fileUploadField [line 107]: WSAA Vehicle can only be indexed into using square brackets or the index function" Could someone help me to fix this?

a!startProcess( processModel: cons!CE_GERAR_PIX, processParameters: { token: local!token, idSolicitacao: ri!idSolicitacao, valorPrevisto: local!value_for_payment, fileHistoricoContrib: local!uploaded_contrib_history_file[1], result: null }, onSuccess: a!save( local!test, fv!processInfo.pv ) ) The result is not being updated from process model As it's a portal, I can't use a form inside the process model. At the Output, as you can see, the result is being stored. The process instance stores the variable, but it doesn't load the `Result` for the interface The instance: So what should I do to accomplish it? Any documentation into that? the interface onSuccess calling doesn't fully load the values I am expecting

Hi  Please tell me how to use sync record smart service. here is my configure result. I got a error. I do not know what is causing issue

Hi, I am unable to login to my community edition site from my personal laptop but can do so from Company laptop. On giving creds, it says " Unable to sign in". Can anybody give me the reason for this ?

Hi Team, We are facing issue to select value in drop downs - Drop down 1 and Drop down 2. We are working on FitNesse /Appian 24.1 using Wiki Keywords as below: |populate field |Drop Down 1|with|Cover1| |populate field |Drop Down 2|with|Cover2| Error in Test - Timeout period reached: Wait for Field - Drop Down 1 Please suggest to resolve this issue and how to select respective values in both drop downs using Wiki Keywords. Thank you. Shivi Khan

Join the Appian Community Hackathon! Work in teams of 1-3 developers to build a new, scalable AppMarket Utility that will help Appian developers create beautiful UIs efficiently. Submit your project by May 24, 2024, for a chance to win cash prizes and more.  All submissions must meet the following minimum requirements: Built on Appian 24.2 EA in the official Hackathon Appian cloud environment A reusable UI similar to the Inspiration examples found on design.appian.com Uses translation sets for easy i18n Easily replaceable sample data for general use At least one new Interface Component released with Appian 23.4+ Head over to Community Challenges to see all rules and details. 

Hi, We installed and configured the FitNesse for purpose of working with Appian sites to perform some AUT. Hence we configured with given Two Example by adding the appian url with version and username but getting following errors, cannot launch the appian site. 1. At first setup and launch of FitNesse worked but had issue in invoking the Appian site and throws following error 2. Unable run the Test itself also and throws following slim error message;  This was done after closing browser and than restarted the batch job of FitNesse & ran the test. Testing was interrupted and results are incomplete. Test Pages: 0 right, 0 wrong, 0 ignored, 0 exceptions     Assertions: 0 right, 0 wrong, 0 ignored, 0 exceptions (0.625 seconds) Could not complete testing: fitnesse.slim.SlimError: Error SLiM server died before Header Message could be read. Unable to start test system 'slim': fitnesse.slim.SlimError: Error SLiM server died before Header Messa

New to Appian, Hello, I'm doing step 10: Process Modeling 101, part 2. When creating a Related Action, step 7 of the exercise, when i click REQUEST MAINTENANCE to test the action, this error message appears (An error occurred while applying the context for the W0112AX Vehicle related action [identifier=41,530]. Details: No process parameter found corresponding to override [name=pv!vehicleId]. Non-parameter process variables cannot be overridden.)

In the documentation for the Send E-mail smart service, it says to put a semicolon between email recipients. This is the expression I am using. = toemailaddress( pv!spkrRecord['recordType!PMSO Speaker.fields.speakerEmail'] ); toemailaddress( pv!parishProfileRecord['recordType!PMSO Parish Profile.fields.parishContactEmail'] )  However, the first recipient receives the email, but the second one does not.  What am I doing wrong here?

Hi All, Is there a way to find user logged location in appian?

Hi! Has anyone else experienced difficulty uploading documents while creating a document in appian recently? When attempting to upload a particular document, there's a significant delay followed by an error stating, "File could not be uploaded. Please try uploading it again." 

hi I would like to ask a question I want to know how to use Query database, so I tried it, but it doesn't work. Here is my query database

Hello Experts, Currently, I'm working as an Associate Appian Developer for a company while also preparing for the Senior Developer certification. I believe practical knowledge is essential for this certification. Could you please suggest a use case for a proof of concept (POC) that covers topics relevant to the Senior Developer certification? This will help me learn with practical experience.[mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] 

There is a user who is already present in the Appian environment. If I change the last name of the user will the user cab still access the application or the user's account will get reset and the user will automatically get logged out from the respective applications and groups. Example: In the current situation: User's First Name (dummy) : Vivian User's Last Name (dummy) : Richards The current name of the user is 'Vivian Richards' and the user is currently active in the system. I want to change the username as: User's First Name (dummy) : Vivian User's Last Name (dummy) : Williamson Richards Is it possible to change without affecting the user's credential or any actions related to application's specific group. Any inputs/solutions will be greatly appreciated. Thank you

I ran into this problem when creating an expression rule for pulling the current pastor for a given parish Id (organization Id).  The Id is passed in a Rule Input as parishId. I have three tables that are needed for this query, all are related. Clergy Member, Clergy Assignment, and the reference table for the Position name.  I need to pull the assignments that are current, i.e. where the Position Term Date is greater than today or null (for permanent assignments).  This is a very similar problem to the one I posted here:  [mention:aa603d0cc3424d8185dbd2f2ce5acf40:46448885d0e64133bbfbf0cd7b0fd6f7:label=queryRecordType%20with%20an%20%26quot%3Bor%26quot%3B%20condition]  Now that a!queryLogicalExpression is my new best friend (a big thank you to Stefan Helzle for the intro) is used a very similar logic.  Since I wanted the results to be a Clergy Member record type, I used that as the record in the a!queryRecord function. a!queryRecordType( recordType: '