New to Appian

Greetings All, I am new to Appian.  First I would like to thank Appian for creating the Community Edition.  Fabulous!! I have been through various courses relating to records and database concepts. I have experience with database design and I used the database tools to create three tables in the Appian schema with the necessary columns, primary keys and foreign key relationships.  I also manually populated some rows of data into these tables. I created a new application.  I think I now have to create Records that refer or point to these physical tables?  Or do I need to create Datastores and then Records that refer to the Datastores? I am happy to take a course that discusses these concepts, but I am having trouble finding information that ties the physical tables to objects that I would use in process models or with interfaces. Thanks very much for any pointers!! Paul

Hi everyone. I want to use external grid in Appian.I'm trying to create Appian's component using an external js file.I'm new to Appian. Please provide detailed documentation or examples for reference.And is it possible to create a component using Eclipse?If possible, please let me know the relevant documentation on how to adjust Eclipse's settings. Yours sincerely.

hello im new to appian, is there a way to assign a task to a group base on the value of groups in the dropdown ? i try using groupsByName function on the process model in the scriptask to get the specific group that i selected on the dropdown field but im unable to set the task assignment on that group Thank you very much 

Hello All, I am pretty new to Appian and started with interface designer. Now that i have reached a stage where i need to create Process model. Un fortunately i dont get the option to create a new process model from the drop down of New button. I can only create folder for Process model Tried on Internet Explorer as well as Mozilla firefox browsers. Same issue. I am in the Designer/developer security user groups. This problem doesnt show up for the Administrator role. Even though i was put in administrator role. I still have same issue. We are using the Appian Version 20.4.215.0 and on prem solution. Please let me know if you have any solutions to this problem. Regards Shiva

I have one interace in which name of a person is taken in a textfield , i want to delete the record from the cdt related to the name of the person .how can i delete the record from cdt?

HI  I am new to Appian and undergoing the online training Appian Foundations course . In the section  of  Users and Groups, we have Step by Step guide #1 for practicing.  Then in the Interfaces course section i am getting the step by step guide#4.  I need to know where can i find the guides 2, 3, and so on. Is there a place where all the step by step guides for practices are maintained Thanks in advance

Hi, I have a editable grid where in one field has single select dropdown (i.e Status), a!localVariables( local!data: rule!Data_Rule( serialNumber: null, pageBatchSize: -1 ), local!statusToUpdate, { a!gridLayout( label: "Editable Grid", labelPosition: "COLLAPSED", headerCells: { a!gridLayoutHeaderCell(label: "Serial Number"), a!gridLayoutHeaderCell(label: "Status") }, columnConfigs: {}, rows: { a!forEach( items: local!data, expression: { a!gridRowLayout( contents: { a!textField( label: "Serial Number", value: fv!item.serialNumber ), a!dropdownField( label: "Status", labelPosition: "ABOVE", choiceLabels: rule!RWM_Status_Matrix_Rule(currentStatus:fv!item.currentStatus), choiceValues: rule!RWM_Status_Matri

Questions related to deployment? 1. When deploying, is it right to deliver all source (interface, rule) files publicly?    If all source files are publicly delivered, won't the operation side also be able to access and make development changes? 2. In the case of JAVA, the source is converted to a JAR file through the compilation process and the inside cannot be seen.     What should I do if I want this result? 3. If all sources are opened after deployment, how do I set up security for it?     

Is it possible to fold options in checkboxField inside Hamburger like button (to have the behavior of dropdown) in Appian?

Hi Folks, I am building the below logic i.e comparing the two local variables values if that is true then it has to perform the logic (i.e) 1*50 or else should return the null values. And it has to save the value when I click the button continue. As we cannot save multiple values as a same target in a!save(), Now I am facing issue in saving the values. If I define any one logic in a!save()  that is working, whereas for multiple logic it is not working. Below I have attached my code, you can refer from line 101 to 147. Please suggest If there is any alternative approach for the below logic. a!localVariables( local!type, local!quanity, local!button, { a!cardLayout( style:"SUCCESS", contents:{ a!columnsLayout( columns:{ a!columnLayout( width:"MEDIUM", contents: { a!textField( label:"MENU", readOnly:true(), ), /*a!textField(readOnly:true() ),*/ a!dr

Hi Team, I came across a use case where I have a Document Repository where Excel files were dumped by an external system and wanted an Appian BPM process to automatically picked the file, convert it into CDT, parse it/massage it (based on business requirement) and then do further processing with the data. Please note that these excel are dynamic in nature (templates are yet to be standardize) and have macros in it. As I am new to Appian world, was wondering what may be the best approach to handle this by using Appian capabilities. Would request if someone can put some light and thoughts on how to handle this. Thanks and Regards, UM

Hi, so when i was testing the summary view interface using a query rule to get customer info by iD. I got this kind of message. How to solve this? Thank you Expression evaluation error at function a!eval_inputMapWithTypes_ruleInputCast [line 42]: Could not cast from List of Variant to SJ Customer. Details: CastInvalidCould not cast from List of Variant to SJ Customer. Details: CastInvalid

Hi All I have the following selectable grid layout. Here my requirement is  I have a status field with two types status's 1) Completed and 2) Not Completed In a rule input I'm maintaining the status Field Initially the status for all the grid rows will be Not Completed. What ever the rows I have selected those status value should be updated as Completed, if i uncheck some rows. those should revert back to original status Not Completed Please help me in this. Note : Grid rows are dynamic Thanks in advance

it is required that outcome produce by the app can be extracted with a specific reporting format for regulators?, Excel and PDF for extracted data is expected. The idea is to avoid any manual manipulation of the output/final report

Why does the count() function return a 1 if I pass in a null? so when I run count({null}) this returns a 1 but to me I would logically think 0. Was hoping for someone to explain this to me, Thank you.

Hi All, I'm having a button "COMPLETE" i want to put a shown condition on it in the following basis I'm having an array {"Completed","Not Completed"}, If both the values in that array are in completed status then only i want to show that button. Could you please help me with the logic. Thanks

Hi All I have a requirement to export data into excel with headerin the first column and value in the next . How to achieve this in appian?

when i created record type object from data store entity the data is not shown in the record eventhough the data is present inside the database but when create record from using process model data shown in record.so, pls tell how can i solve this that data will shown in my record?

Hi Team, I'm having a requirement to make the below milestone object to Dynamic.  Here  Not Assigned, InProgress, Completed are fetching from one table and Review, Rejected are fetching from another table. The milestone object should be like below. Please help me  Thanks in advance

Hello, I have a requirement to retrieve a value (CustomerCode) for a signed in user based on a group attribute. When a user logs in, we will be using this value for row level security. The problem is that users can belong to multiple groups, and not all the groups have the attribute value CustomerCode.  The only way I have been able to do this is using the unsupported try function which I know is not acceptable. getgroupattribute returns an exception if the attribute does not exists. a!localVariables( local!a: "mpierson", local!b: getgroupsformemberuser(local!a), local!d: a!forEach( items: local!b, expression: if( try( fn!getgroupattribute(fv!item, "CustomerCode"), "" ) "", fn!getgroupattribute(fv!item, "CustomerCode"), {} ) ), local!d ) Is there a supported way to handle exceptions?  Is there a better way to store attributes for groups of users? We are trying to not have to maintain at the user level.

HOliday landing page

1. How to change record user filter placeholder text from default "any" to text what I want? 2. How to set multiple default options when using record user filter? Thank you

- trying to add a query-filter to the read-only-grid - error message: - the field "PJ_ID" is type TEXT, - the value of the local!selectedRows: - it works fine when working like below:  -field "id" is type INTEGER

Hello, I have a read-only grid that is displaying results from an integration that is stored in a variable.  I also have a folder that contains documents that are related to the grid rows.  I would like to dynamically display the related document in a new interface/window. I am able to configure the documentDownloadLink, but would like to display using the documentViewerField instead. Here is the current interface. Please be kind, it's my first attempt and have been playing around a lot. I've hard coded the document value for now but will be using finddocumentsbyname to retrieve the document id. = a!localVariables( /* Set up the initial paging and sorting values */ local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1000, sort: a!sortInfo(field: "submitTimeUTC", ascending: false) ), CardCode: "C25000", local!id: finddocumentsbyname( searchAllContent: true, documentNameToSearchFor: "A_R Invoice*- 7649" ), /* Call the extern