New to Appian

HI team, To learn adding External data sources as Connected System. i installed PostgreSQL locally in my system and host as localhost but when i try to conenct with localhost through connected system . I couldn't able to connect.

hi team. I have a requirement as: I have to create data using some dropdown values and after creation of that data user can delete that data from where that drop data is coming and once data is deleted from frontend then when user tries to edit that created data then error throws as: since value of that dropdown is deleted by the user then while editing how to handle this error please suggest any answer  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  [mention:57fc948ec4c44d7fbda6e5509555d197:e9ed411860ed4f2ba0265705b8793d05] 

Hi all, I have a requirement as: I have table in readonly grid where there are different site we can name it as A1, A2,A3,A4 , B1,B2, B3, B4 and each one has status as pending approval . and there are action button as approve and reject if user click on approve button on A1 status then its status is changing to preliminary approved and button color remains as green and user again click on approve button of A1 then status changes to approved and button changes from green to grey and link gets disbaled when user click on approve button of A2 then status changes from pending approval to preliminary but here button color changes to grey and link gets disabled since A1 is in approved status , it means if any of the sttaus of A is in aproved then any of A status is  preliminary approved then button will turn to grey and link also gets disbaled. now for B1 same cycle goes and if A1 status is approved  and B1 , B2, B3, B4 status is eather pending approval or

Hi,  I am running a process model and I want it to write/update record information after an input task. If they hit accept, the write records data service works perfectly but if they hit the reject button the write record service throws the following error: "Some referenced Items could not be found". What am I doing wrong? I'll share the buttons' interface code:  buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Aprobar", saveInto: { a!save( ri!record['recordType!{cef91250-961d-44c5-a3d4-47f5dd11ce8e}W1181S Solicitud.fields.{8765b93b-701f-4834-a1fa-466d22579f09}clausuraFecha'], today() ), a!save(ri!record['recordType!{cef91250-961d-44c5-a3d4-47f5dd11ce8e}W1181S Solicitud.fields.{52961fd0-4d58-4b78-a648-5fe0de023217}personaDecision'], loggedInUser() ), a!save( ri!record['recordType!{cef91250-961d-44c5-a3d4-47f5dd11ce8e}W1181S Solicitud.fields.{c9e90275-1a59-4f5c-a413-b7ed27eed6b1}idEstadodeSolicitud'], 3 ), a!save( ri!decisionDeAp

Cannot find AA Registrar site.

Hi all, I have a requirement as: I have table in read-only grid where there are different site we can name it as A1, A2,A3,A4 , B1,B2, B3, B4 and each one has status as pending approval . and there are action button as approve and reject if user click on approve button on A1 status then its status is changing to preliminary approved and button color remains as green and user again click on approve button of A1 then status changes to approved and button changes from green to grey and link gets disabled when user click on approve button of A2 then status changes from pending approval to preliminary but here button color changes to grey and link gets disabled since A1 is in approved status , it means if any of the status of A is in approved then any of A status is  preliminary approved then button will turn to grey and link also gets disabled. now for B1 same cycle goes and if A1 status is approved  and B1 , B2, B3, B4 status is either pending approval o

Hi all, I have a requirement as: I have table in readonly grid where there are different site we can name it as A1, A2,A3,A4 , B1,B2, B3, B4 and each one has status as pending approval . and there are action button as approve and reject if user click on approve button on A1 status then its status is changing to preliminary approved and button color remains as green and user again click on approve button of A1 then status changes to approved and button changes from green to grey and link gets disbaled when user click on approve button of A2 then status changes from pending approval to preliminary but here button color changes to grey and link gets disabled since A1 is in approved status , it means if any of the sttaus of A is in aproved then any of A status is  preliminary approved then button will turn to grey and link also gets disbaled. now for B1 same cycle goes and if A1 status is approved  and B1 , B2, B3, B4 status is eather pending approval or

Can I preview the excel documents in the document viewer field

Hello, I am trying to add a document link to an interface. I found the a!documentDownloadLink function and it tells me to create a constant to point to my documents but I am a bit lost. This is an interface where a supervisor will approve or deny a request so the document link in the form should be attached to the specific request. What do I need to do in the cosntant to point specifically to that value? The value is store in my recordType as an integer and it is added to the record through an attachment component in a record action.  any help is appreciated

I have two tables with a one to many relationship, an owners table and a pets table which are connected via the Owner ID. The owner can have many pets. I am trying to add an action under the owner summary view for the user to be able to add a new pet that belongs to the owner but I am struggling with how to connect the two records. I have created a related action under owner that points to the add / update pet but I am struggling to connect the owner ID to the pet being added, any help would be greatly appreciated! 

I created generated some sample data through ai but I have a problem with one of the fields. The createdBy field shows full names but when I add data through a record action it shows a user. I wanted to show only users. Is there a way to delete that data or change so it displays consistent information? I tried to edit those rows but the system does not let me.I can only edit the rows I did through record actions. Here is the column to show the issue: thank you

Hi All, I am calling the data from db through expression rules and gave batch size as 100. I need to use this data in interface inside grid, is this only 100 records will be displayed in interface or I can display whole data from table.

Trying to walk through the tutorial for the Acme Auto (SA) Application. When I click any vehicle I get the error below. When I add a vehicle, it does not get added. Obviously I'm new to Appian. Any help appreciated. Error Evaluating UI Expression Expression evaluation error [evaluation ID = I0L6P] in rule 'w1847aa_cmpt_vehiclerecordevents' (called by rule 'w1847aa_dash_vehiclesummaryview') at function a!eventHistoryListField [line 3]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!queryRecordTypeFunction [line 58]: An error occurred while retrieving the data for "W1847AA Vehicle Event History". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000)

hi,  I wanted to set a user filter for my record, which will pull the records based on quarter/month and year. I am trying to avoid the custom record field. example - Q4 Oct 2024 The field that has date time stamp in my record is "CREATED ON". Any help is appreciated.

Hello, I am working on the Portal Course. I am not listed as administrator on the WPO Wyndhamm Power Outage App so I am not able to create objects. Is there a way to request access to the group? Thanks

Hi all, I have a requirement as: I have 2 pickerfieldusers as A and B where A can select max 1 user and B can select max 5 user, requirement is when we select user in A then B cannot select that user which is already selected in A and should throw validation error as "A user cannot be selected in B". I tried putting validation as : validations: { if( contains( local!taskAdditionalAssignee, ri!record['recordType!{a6f5f29e-a89e-495a-afae-702df167aa19}RECT Record Tasks Sync.fields.{d0fec037-4f71-4d05-a7ef-766635d0ff13}taskAssignedTo'] ), "Assignee cannot be added as additional assignee", null ), } but when I open this form then as A and B both contains null value so same validation error throws comparing both A and b having null value which becomes similar please help me how to achieve this

I have a case study for Employee Onboarding Applications , where I have different roles Like who will be acting on the Task based on the previous user's input . I want to make this as Record Centric Application and Tasks should also come from Database . Also for Individual records , it will show the status of the record in a Grid . How can I achieve this using Appian's Best Practices ? TIA .

can someone provide the best answer for  this Appian ACD exam question it has many answers 

Hello, I have followed the instructions described in the documentation and my log is not writing in the correct place, just in the tomcat log and just the error messages, this is my configuration in the log4j file ( <APPIAN_HOME>/deployment/web.war/WEB-INF/resources/appian_log4j.properties):  #### custom connector log entrylog4j.logger.com.appian.us=DEBUG,INTEGRATION_LOG ###### INTEGRATION_LOG file appenderlog4j.appender.INTEGRATION_LOG=org.apache.log4j.RollingFileAppenderlog4j.appender.INTEGRATION_LOG.layout=org.apache.log4j.PatternLayoutlog4j.appender.INTEGRATION_LOG.layout.ConversionPattern=%d [%t] %-5p %c - %m%nlog4j.appender.INTEGRATION_LOG.File=${AE_LOGS}/integration.loglog4j.appender.INTEGRATION_LOG.MaxFileSize=10MBlog4j.appender.INTEGRATION_LOG.MaxBackupIndex=1000log4j.appender.INTEGRATION_LOG.encoding=UTF-8 in my gradle.build:implementation 'log4j:log4j:1.2.17' But I always got the warn: No appenders could be found for logger  Into my project there are

Hello, In Build An Application Step-by-Step #5. I am stuck on the Edit Record List Columns - Format the Image Column. The error says, "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 51]: User Does Not Have Rights to Perform this Operation". I completed all the steps specified in the previous exercises. Appreciate all the help I can get. Thank you!

Since any BPM tool like Appian follows BPMN Standards, I wonder why we don't have the error event in Appian process models. If I want to handle errors or exceptions in process models, how can I do it..?? for example : I have a write to data store entity smart service in my process model and for some reason like data length exceeds, the activity got failed, now in this situation, I want to add a exception flow which will create a user task to correct the entered data or lets say in my process model, I have an activity which is not so important, but if it fails to execute I don't want my process model to be paused, I want it to continue further ( we can do this in Appian by making the acitivity as subprocess, but is there any other way to avoid the subprocess)

HI EVERYONE  I AM NEW WITH APPIAN , I AM LOOKING TO UPLOAD MULTIPLE DOCUMENTS BUT I AM STRUGGLING TO FIND A SOLUTION. I HAVE A LIST OF DOCUMENTS  ITEMS THAT I RECEIVE FROM A QUERY ( BECAUSE  I NEED TO DISPLAY ON THE INTERFACE THOSE DOCUMENTS FOR THE USER TO UPLOAD , SOME TIMES THE AMOUNT OF DOCUMENTS TO DISPLAY CAN BE DIFFERENTS  BASED ON WHAT THE USER CLICK IN THE INTERFACE). NOW I LOOP THROUGH THE LIST THAT I HAVE AND CREATE A UPLOAD COMPONENT IN THE DYNAMIC WAY AND DISPLAY ON EACH LABEL OF THE COMPONENTS 'S DATA. BUT HOW CAN I SAVE EVERY DOCUMENTS IN LOCALVARIABLE  ??  tHE THING IS THAT I NEED AFTER THAT TO SAVE THOSE FILES DB , SO I CREATE  A  RULE INPUT DOCUMENT WITH CDT. THERE IS A BETTER  TO DOING THIS ?? 

Hi All,   I have an requirement where i need to read Google sheet data from the google sheet. In my case i have  functionalty where i am exporting grid data and uploading it to user's google drive which is working fine. But now i have another  requirement where a user can manualy provide his/her own uploaded google sheet Url in text field in the interface then perform some validations and then submit that google sheet data into db. so there is any way from which i can achive this.

hi,  I have a record list with values  {name:"Test1",id:1},{name:"Test1",id:2},{name:"Test2",id:3},{name:"Test1",id:4} my output should show - pid should be concat of the name and the sequence based on count 1. id:1,pid:"Test1001" 2. id:2,pid:"Test1002" 3.id:3,pid:"Test2001" 4.id:4,pid:"Test1003" any code suggestion will help 

Hi, I have a requirement to send about 1000 mails based on number of records updated. I am trying to send using MNI. I tested for 600 records at once and most of the process breaks and got error alters. I reduced the batch size to 150 then it works fine. But if the data is about 200 then the process starts to break.  The error is Failed to send email. Is there any limit to send mail. Is there any other way to send mail efficiently. Please let me know. Thanks