New to Appian

Hi Experts I want to know about is there any impacts on performance if  we use default filter and limit search to selected field in record type ? Thanks

A user has a direct URL to access a record view.Which configuration(s) would allow the user this access? A. A combination of user filters, source security, and record type security are required. B. Source security is all that is required. C. A combination of data source security, record type security, and default filler configuration (if it is set) are required. D. Record Type security is all that is required.

Howdy All, I'm new to Appian and struggling with how to configure the Editable Grid for a form response. Particularly trying to troubleshoot the "Add New Row" feature within the Editable Grid. Any advice or guidance on how to adjust this would be appreciated! /* Editable Grid */ a!sectionLayout( label: "", contents: { a!gridLayout( label: "Please Complete below if there is no quote attached.", labelPosition: "ABOVE", headerCells: { /* 1 */ a!gridLayoutHeaderCell(label: "Action"), /* 2 */ a!gridLayoutHeaderCell(label: "Item Number"), /* 3 */ a!gridLayoutHeaderCell(label: "Item Description", align: "LEFT"), /* 4 */ a!gridLayoutHeaderCell(label: "Part Numbe

Hi, I have a requirement to create a graph with the following. Active in Oracle  - 1(ID) - count 2 Active in mainframes - 2(ID) - count 3 Pending - 3(ID) - count 4 Cancelled - 4(ID) - count 7 Now I need to create a graph with Active, Pending, Cancelled in X axis and in 5 ,4, and 7 in graph. Basically need to group 2 status in one and show the sum of count. And then on drilldown we need to show the records associated with them in grid. How can I achieve this. Thanks

hii all, i have a interface to request for Range Reset in retail organization , once the required details filled user going to submit the form here , for each RANGE RESET i have set of tasks to complete , whenever user clicks submit button 12 tasks should assign to 4 owners along with the task completion time lines , task owners are  1.reset manger 2.assistant buyer 3.buye 4.merchandiser , how to achieve this , each should assign 3 tasks per head

Hi Everyone, I am facing an issue with News Feed, My requirement is whenever I am posting a comment I should not receive any email, I tried disabling the Email notifications for News but it's not working. My scenario is, I have 2 users (Initiator and Approver), when initiator submits a case to the approver there will be post added to New feed Now Approver gets a task to approve the Case, at this point whoever(Initiator or Approver) comments the post, that user is not receiving any email But after the Approver Approves or Rejects the Case(the case will go back to Initiator if rejected), then in both scenarios Initiator is receiving an email if Initiator is posting comment in News feed Entry and Approver is not getting the email if anything is commented to the post. Please help me resolve this, I should not receive email notification for Initiator in any case. Thanks

Hello Appian, I'm having trouble with setting SMTP for on-premise appian server. https://docs.appian.com/suite/help/22.2/Mail_Server_Setup.html#sending-emails  I followed the instrtuctions from above link. And getting error like below from the log - tomcatstdout log - mail-listener.log - custom.properties How can I make this work? Thank you

Hi, I am trying to configure the Microsoft SQL local database from my machine into Appian application. While doing this I am seeing timeout exception (as shown below). We looked in to the logs and we are seeing the SQLTimeOutexception in the logs (As shown in below image). Are there any limitations with academy version of Appian to connect to the existing MS-SQL database? OR Am I missing anything here? I have reffered the below topics to resolve the issue… Without much help! docs.appian.com/.../Configuring_Relational_Databases.html https://community.appian.com/discussions/f/data/10274/connection-to-sql-server-2016

I was reading this article, creating records and related records using a process model, and I wondered if the code for the form interface, Case, referred to in the article is available on the Appian Community for reference. I'm working on a form (proof-of-concept) which has a similar structure as the Case form, i.e. a base record type and an editable grid of related record type on the form.

Hi Appian, I found that there is a cleanup.sh script that helps data maintenance. ( https://docs.appian.com/suite/help/22.1/Data_Maintenance.html#cleanup-script ) From the documentation, is says that [actions] for [data] cleans up old data files (*.kdb) in the live `gw*` directories. What are the content of the data files (*.kdb) that will be cleaned up from 'gw' directories? And what does the 'gw' directories stand for? Thank you

Is it possible to get the robotic task, which is custom developed in IDE (intellij) executed in Appian RPA?I am following the documentation on Custom code dev in Appian RPA. Using Guided configurator initial steps are completed with respect to JDK, Maven and IDE setup. After this I was reading Calculator tutorial and downloaded source code file to try and execute the custom developed bot in RPA console.Due to being novice in Java and Maven I am not able to understand fully how the IDE connects with Appian RPA console, - how do I get this calculator bot imported/deployed and then executed in Appian RPA.- Do I need to create a bot in RPA first and then export it, copy it in my IDE project folder, copy calculator code and then run some deployment command or how?Can someone simplify it for me and explain how to achieve this? If possible, please distil it down in steps.Thanks in Advance.

Hi, Is there any straightforward method to compare below two arrays in such a way that, SelectedAnswersArray[1]=correctAnswersArray[1] , SelectedAnswersArray[2]=correctAnswersArray[2] and SelectedAnswersArray[3]=correctAnswersArray[3] . SelectedAnswersArray: {"a","c","b"} correctAnswersArray: {"a","b","c"}

While creating a case , i will click on validate button and  data will be sent to  Api to verify the GRU is correct or not ,if it is incorrect in the form i need to go back to same form to update the correct GRUIn my process model ,it is going back to user input task but the form is again asking for details to be entered but the want is i need to update the Gru and resubmit the form .can someone please suggest how to achieve this

I am trying to update a specific list item from SharePoint list using SharePoint Connected System and Integration. Inserting a new Item to that list is working but not updating an existing item. Below is the integration: Getting the following error:  Can someone please help with this. Thank you

Is it possible to hide a related record action link based on certain conditions?  In the example below, a record summary view, when the status is In-Progress, the START MAINTENANCE action link should be hidden. Is this possible?  If so then where could I find the option to configure this? Thanks.

= a!localVariables( local!emails: ri!test.emailAddresses, local!individualMail: if( a!isNullOrEmpty(local!emails), {}, reject(fn!isnull(_), split(local!emails, char(10))) ), local!invalidEmails: substitute( tostring( reject( fn!isnull(_), a!forEach( items: local!individualMail, expression: if( regexmatch( pattern:"^[A-Z0-9\_-]+(\.{0,1}[A-Z0-9\+_-]+)*[@]{1}[A-Z0-9.-]*[A-Z0-9-]+[.]{1}[A-Z]{2,6}$", searchString: fv!item, regexFlags: "si" ), null, fv!index ) ) ) ), ";", "," ), local!validation: if( isnull(local!invalidEmails), {}, "Emails must be in a valid format, and each email must be on a new line. " ), a!formLayout( label: "Test", contents: { a!sectionLayout( contents: { a!columnsLayout( columns: { a!columnLayout(

As I am new to appian env, I tried to access the workspace for hands-on practice. For the same I request an instance to communityedition@appian.com and I got credentials to logged in this environment. After logged in it is rendering "403 Access Denied"  and You don't have permission to view this page.

I have to send email addresses as input from Appian to external system  and the external system validates those email address and send back the ids of those email address. How i can implement the design ,what all are needed ,can someone help?

Hi, I have two dropdowns on a form.  Is it possible to populate the choices for the second dropdown based on the selection from the first? In the first dropdown, I populated its choices from a record type using this example, Dropdown Component - Appian 23.4.  Based on the selection from this dropdown, I'd like to query another record type (filtering on this selection) and use the result as choices for the second dropdown. What is the best way to achieve this?  Any examples for reference would be much appreciated. Thanks.

I need to validate if the list is line delimited and in a valid email format using regex in paragraph field .  If not , throw a validation message.test@test.com test2@test.com test3@test.com

Hi, I have a code like below where I am getting a list of text strings into a local!leadIDs. When I try to use contains() function to check whether a specified string exists, then I am getting an error like  Expression evaluation error at function 'contains' [line 11]: Invalid types, can only act on data of the same type (Any Type, Text) Can someone advise, how to fix this. a!localVariables( local!leadIDs: index( rule!getLeads(key: null()), "id", null()), contains(local!leadIDs, "AB12345")) Expression evaluation error at function 'contains' [line 11]: Invalid types, can only act on data of the same type (Any Type, Text)

a!localVariables( local!emails, local!invalidEmails: if( isnull(local!emails), {}, joinarray( reject( isnull(_), a!forEach( items: split(local!emails, " "), expression: if( validateemailaddress(fv!item), null, fv!index ) ) ), "," ) ), local!validation: if( isnull(local!invalidEmails), {}, "Invalid email at " & local!invalidEmails & " position(s)" ), a!textField( label: "Enter emails", value: local!emails, saveInto: local!emails, validations: local!validation ) ) I want my email addresses validation each mail should be in one line otherwise throw an error and email format should be correct other wise throw an error. ( test@test.com test2@test.com test3@test.com )  can someone help me with the code and how to store this email address in line by line in db

I am unable to request to restart my community edition site. After clicking on the Restart the site, if check for the status i am getting the same page with restart, get new site, upgrade to paid version. After requesting for a restart i am getting this And if i click the check status i am again getting this instead an any mail.Can anyone help me out..?

Hello All, I have a requirement to display record types in an interface. We have around 20 record types and I should display in an interface in tiles. When we click on each tile respective record type should be open in same tab/Dialog box and perform the record actions. When cancel its should comeback to the home page. Please find the below screenshot for reference. Thanks in Advance

My process has Start form setting 3 fields, Script task adding few more fields. but after the data is written to DB, Properties is limited to id only, other data is removed from Process variables. No error in process model and data is written to DB as well. Anything missed from my side ?