New to Appian

Hello All, I am currently working through the developer training for Appian and am experiencing an issue trying to add record events to a record type. It worked fine last week for the Vehicle record type, however when I logged back in this week to continue my training, i'm receiving the below error: I felt like that was odd, so I checked security on the application and I'm in as an admin, so the error isn't making sense to me: I had added record events to the vehicle record type last week, and it had worked fine. I just went back to check and it is now showing the same error as well: Finally, checked to see if somehow there were missing precedents and nothing shows: Is there anywhere else I should be looking to resolve this issue, or did something change with the data source over the weekend? I'd like to move on with the training, but need to complete the exercise first!

hi,  I have implemented pagination for an editable grid, but when i select a first row and move to next page the selection remain same , though the row data is different Page1 , i choose the first row Page 2 - first row is automatically selected how do I control the selection in pagination , local!listPagingInfo: a!pagingInfo(startIndex: 1, batchSize: 20), local!pagedList: rule!getData(Id: local!search,pagingInfo: local!listPagingInfo) a!gridLayout( labelPosition: "ABOVE", totalCount: null, headerCells: {}, columnConfigs: {}, rows: {}, selectionValue: local!selectedIndex, selectionSaveInto: { a!save( local!selectedIndex, a!flatten(save!value) ), a!save( ri!selecteditems, if( a!isNullOrEmpty(local!selectedIndex), {}, index( local!pagedList, local!selectedIndex ) ) ) }, /*selectionRequired: true,*/ selectable: true, selectionStyle: "CHECKBOX", validations: {}, shadeAlternateRows: true, borderStyle: "STANDARD", rowHeader: 1 ),

I have three tables, SpeakerEvent, ParishEvent and a junction table that joins SpeakerEvent to ParishEvent, JNC_Speaker_Event_Parish_Event I need an Appian query that can tell me which SpeakerEvents have not been assigned to a Parish as well as another query that will tell me a Parish has not be assigned to a SpeakerEvent. If I were creating a view in SQL, this would be done easily with a left join and checking to see if the ParishEventId is null. SELECT SE.* FROM `PMSO_SPEAKER_EVENT` AS SE LEFT JOIN `PMSO_JNC_SPEAKER_EVENT_PARISH_EVENT` AS JSP ON SE.SPEAKER_EVENT_ID = JSP.SPEAKER_EVENT_ID WHERE JSP.PARISH_EVENT_ID IS NULL In Appian, I am trying to create an Expression Rule to do the same thing.  I tried several version of using a a!queryFilters as well as a!queryLogicalExpression.  I'm guessing that it has to do with the fact that there are no records on the other end of the relationship (JNC_Speaker_Event_Parish_Event). if( a!isnotNullOrEmpty(ri!speakerId), a!queryR

Hi all, I am a beginner of Appian, and I would like to know access right to "Task". I can see the task tab below,...but my colleague cannot see the task bar.... Why? In this case, how the colleague check his task ?? Best regards,

I’m a bit confused about the concept of Input-Only Users in Appian. Are they users who do not have an account in the Appian application, or am I misunderstanding the term? Specifically, if a user submits information through an Appian application portal without having a user account, would they be considered an Input-Only User? Can someone clarify this for me?

I have a Parent Summary interface that I want to add a record action button to that creates an entry in a child table. Adding the button is easy enough, however adding that button alone doesn't connect the Parent to the child when using the button. So what steps am I missing to make that connection?

Hi all, I am a new to Appian, and I am required to create a workflow in Appian. According to an article, I need to install case management studio to make it easily. My understanding is correct? Without case management studio, I guess it takes a long time to create workflow... I am trying to install a sql file..., but errors occur at step3. Appian Case Management Studio Overview - Appian 23.4 Step 3: Creating database objects Copy link to clipboard To create the structure for the database tables, views, and other objects that are a part of the Appian Case Management base application, you need to run a DDL script in your database. To create the database objects: In your MariaDB business database, import and run the 01.CaseManagementStudioBasev1.2.0.sql file downloaded in Step 1. May I know how to resolve the error? Hope your advice! Best regards,

I have gone through several times, however I'm unable to understand why this error is getting.

a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDate: {}, local!holidays: { if( a!isNullOrEmpty(local!holidayslist), {}, text(local!holidayslist, "DD") ) }, local!currentMonth: { a!forEach( items: local!selectedDate, expression: if( tointeger(text(fv!item, "MM")) = local!month, t

Can anyone help me to find default mariadb connection details in system logs?  I am not able to find in data server logs. Please let me know the exact path of that.

My Child Interface has Submit and Cancel Button. It has File Upload functionality. Below are the 2 Rule Inputs it has: Cancel Rule Input (Type Boolean) excelData Rule Input (Type Document) I have a Parent Interface which uses Navigation, in one of the Navigation link I need to have this Child Interface appear. I was using rule!Child Interface, but its asking me to pass 2 parameters. Can you please help me on how I can pass those 2 parameters from Parent Interface? Regards, Mahesh

Hi, I have a Child Interface with a Submit button and a File Upload functionality. It has two Rule Inputs: cancelInput (Type: Boolean) uploadedFile (Type: Document) Now, I’m using a Parent Interface that has a Tab-based Navigation layout, and I want one of the tabs to display this Child Interface. However, the system prompts me to pass the two parameters (cancelInput and uploadedFile) when I call the Child Interface using rule!ChildInterface(). How can I effectively pass these parameters from the Parent Interface to the Child Interface while keeping the setup simple? I’d appreciate any tips or examples! Thanks in advance for your help! Naveen k Rajakumar

In step 9 they have asked to check 3 boxes as below but i cannot find 2 records

Hi all, I'm a beginner of Appian. I am required to get a user activity log such as "approved", "reassigned" , "reject" and so on... Do you know how to get these log? Am I need to create a new record type to get the information? My client requires to get them and download as csv... Hope somebody give me advice... Best regards,

I am working on an interview application and one of the features is to edit previous questions. I was tasked with having the header display the current question and answer given when you click on the question's ID. My problem is I'm not sure how to create this type of header. Any help with the code would be great! I know it needs to be done in the views and header section of the record type but I'm not sure exactly what to put. Any help is appreciated!

I completed the Step-by-Step Guide and wanted to run through it again, but when I was deleting the objects, it doesn't allow me to delete some remaining objects from that application.  Note that I missed the note that tells you that deleting applications doesn't delete objects. hence the W2735SA...........1.  The object W2735SA Administrators is actually W2735SA Administrators 2, but I deleted the other admin groups previously.Anyone know a work around to delete those objects?

when i am trying to follow the step i found the below error given expression i used - rule!W0866aa_FormatDisplayName(user:fv!row[recordType!W0866aa Vehicle.fields.addedBy])

I signed up for communitiy edition and am going through the developer learning path.   I designer, I do not have the link to the admin console.  I can view users, and when viewing my user, it shows that i'm a basic user.  How can I get my security changed to system administrator? Thanks

I am working on the following step in the Interfaces 101: Build Forms and Other Interfaces shown below.  I have run into an issue with configuring the rule inputs. The directions are unclear to me and I am receiving the following error:  I have named the rule input "vehicle" and made it a W777SA Vehicle data record type. I'm uncertain what the value for the "Value" field should be. 

Hi All,Is there any way to create the fields dynamically in cdt and then assign values. I have a use case,User will be uploading a excel and i need to show the excel data in grid format (excel can be different),So for that i am using readexceldata function and and I am trying to create a cdt with the column names and their respective row values (here column names are dynamic) to use that in the data field for grid field. Ex:excel file has 2 columns A,B now the cdt will be an array of row data like {{A:first row A value,B:first row B value},{A:seconf row A value,B:second row B value}} and if the excel has 3 columsn as A,B,C then the expected cdt should be {{A:first row A value,B:first row B value,C:first row C value},{A:seconf row A value,B:second row B value,C:second row C value}} and use this cdt in gridfield data parameter. Thanks in Advance,SSP

Hi everyone, I'm using the latest Appian Community Enviroment, but I can't finish the Step 5.  In the Edit List part I use this Expression: if(a!isNullOrEmpty( fv!row[recordType!W#SA Vehicle.fields.image] ), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row[recordType!W#SA Vehicle.fields.image] ) And I get the following error:  Expression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 52]: User Does Not Have Rights to Perform this Operation I don't have access to the database or any vehicle data to manage the user permissions.Thanks!

Cookie cleared Using robotId and hash as authentication system. Hash used to be sent to console is yeZIqzlGOd... Cookie cleared Using robotId and hash as authentication system. Hash used to be sent to console is yeZIqzlGOd... Sent REQ_JK_RESOURCE (478) Setting a new cookie 'Jidoka=1700659462066-73' received from the server Received REQ_JK_RESOURCE_KO Planet 65513b3e8c549364669f5c5d cannot be registered now

Hi, We have one engineer for him "New" and "Add Existing" dropdowns are not showing when he connect to the Appian designer even though he was part of "process model creator" and "designer". But, he was able to edit the existing objects. Can someone help here.

Hello, I am trying to add pv! data to a task report but it always comes out empty.  My data definition is: pv!record[W1182 Solicitud.idCategoria] formatting: number  It does not display any information. All information I request using tp! works fine.  Am I doing it wrong? or is it not possible to display rv! info in the report? Thank you

I am new to appian  I need read excel data along with header which is dynamic it will change for excel to excel some fileds are static and insert them into a staging table both header and data for that column . my staging table contains fileds like attribute1, reason1, score1 till 20 . I want to insert headers to attriubute field from 1st row and reason and score to data from second row I am trying with readexcelsheet/readexcelwithfiter/readexcelwithpaging functions but since its dynamic i am having confusion how to do the mapping  Imp : Number of header column and name of the header column will be dynamic Can anyone help me how to do or is there any other approaches there ?