Discussion Categories

I have a recordtype "User" and it has column named : 'IsInternal' that decides if user is internal or external and its a Boolean field. On the basis of this column i want to find out if the loggedinuser is external or internal how can I achieve that? after knowing that if the user is internal or external i will enable and disable the filter list options which i am achieving through logic below: a!recordFilterList( name: "User Email Domain", options: { a!recordFilterListOption( id: 1, name: "Internal", filter: a!queryFilter( field: User.isInternal, operator: "=", value: true() ) ), a!recordFilterListOption( id: 2, name: "External", filter: a!queryFilter( field: User.isInternal, operator: "=", value: false() ), ) }, defaultOption: "External", isVisible: true, allowMultipleSelections: true )

I am trying to insert data in dictionary in if condition and it shows reaction tree in output. I am new to appian please help me with this.

I have an array of maps that I iterate over and generate cards with links like so:local!selectedCard, local!example: {a!map( icon: "first-aid", name: "name1", link: a!dynamicLink(saveInto: a!save(local!selectedCard, 1)) ), a!map( icon: "home", name: "name2", link: a!startProcessLink( processModel: some process, processParameters: { /* some params */ } ) ), /* some more options */ }, { a!columnsLayout( columns: { a!columnLayout(), a!forEach( items: local!options, expression: a!columnLayout( contents: { a!cardLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { char(10), c

Hello, I know there are older posts for this but since links are not working am posting again.I am looking for information regarding the APPIAN update since version 17.Is there a way to access old information (pdfs, or working links). If anyone kept records for that I would appreciate it if he/she could share it. The company I work hadn't update it and now that it needs update no information is found. They spoke with the APPIAN support for over a month and no result [emoticon:ca08b2c27c2f40e993e89508acf29e0b] Thanks in advance.

Hello , Is there a possibility to select a specific Cell in a grid and not the whole line ?

Hi Experts, I'm extracting some data by doing some comparisons via process model and when whole data is extracted(just before the process going to end node), I finally dump the data in excel using Export CDT to excel. But the problem is, in this process a variable of type CDT contains whole data for long (till dumping it to excel) which increase its chances of failure if a large amount of data will extract. I want ---> If in total there are 6000 rows which need to be extract, So I want to extract first 1000 rows and dump them in excel and repeat this process for all the 6000 rows which extract in 6 times. Main problem ---> I want all the data in same excel, same sheet, next 1000 rows append after the first 1000 rows Don't want different excel , different sheet. Suggest some possible solutions thoroughly  Thanks in advance

Hi everyone,  I'm facing a strange behavior when using a!queryRecordType() to query to related record types.  I'm having 3 record types with relationships as below: I'm doing the below query to get all the teams that Shaun is a member of (team A and B).  a!localVariables( local!dataset: a!refreshVariable( value: a!queryRecordType( recordType: 'recordType!Team', filters: a!queryLogicalExpression( operator: a!defaultValue(ri!filterOperator,"AND"), logicalExpressions: ri!logicalExpression, filters: { if( a!isNullOrEmpty(ri!id), null, a!queryFilter( field: 'recordType!Team.fields.id', operator: "IN", value: ri!id ), if( a!isNullOrEmpty(ri!name), null, a!queryFilter( field: 'recordType!Team.fields.name', operator: "IN", value: ri!na

Hello Appian Community so from last 2-3 days I don't know  why I am not able to access my cloud database , whenever I am trying to open it so new tab is opened but there is blank page I don't know what's wrong so someone can help me out regarding this. ?

We have a process model that inserts records into a table and then we call a stored procedure that will execute and perform an update action on the newly inserted records while running it the process model is executing successfully and records are getting inserted but it seems the execute stored procedure node is not executing. also, the node is not giving any errors, yet it is taking some time to process but the update is not done. Can anyone help on what might be the probable reason? Is it going out of scope? Screenshot of the PM where the node has been added:

Hi all, I have a scenario where i am using google chat integration to send the message  also i am receiving this message perfectly but i need to make the message body more dynamic where i can send some respective link,issue is that appian links are not supporting in the message body

Node Input and Output Limits Appian node inputs and node outputs that handle multiple values from a form are restricted to a limit of up to 1250 indices. What does this indices actually mean and any use cases to understand it better? docs.appian.com/.../Configuring_Relational_Databases.html

"I am working with dependent tables, and it's already functioning in the interface. However, when starting debugging in the process model, it throws the following error: I believe this might be due to the variable in the 'Group' field, which comes from the interface as an integer variable but is presented as text in the user form. Could you guide me on how to handle the configuration of the node or the properties of the Process Model M to fix this error?" This is what I have in my node configuration These are the variables on my Process Model´s properties and this is my rule inputs on the interface Appreciate your comments. Regards,

Hello Everyone, We have a database view with 45 columns and it taken 4sec of time(40k records) to execute from database view. Also DT created for this view in appian,  now we mapped this DB view to Record and it was thrown below error:  Expression evaluation error [evaluation ID = fead6:13bce] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit. (APNX-1-4198-000) It's looks like a wired behavior of Record because as per the community it will support 40L records. Could someone help me out to fix the issue.  DS also verified and published without error. FYI, We can't see the data in record after we mapped to DB view and it shown the error message as mentioned above. stdout log here: Caused by: com.appiancorp.core.expr.exceptions.IssuedException: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evalu

Following all the steps in 23.3 Exercise 5_ Records Part 1, Accessing Your Data.pdfPage 12, In the Expression Editor, delete all text, and enter the following expression:if(a!isNullOrEmpty(fv!row[recordType!AXVehicle.fields.image]), a!EXAMPLE_DOCUMENT_IMAGE(),fv!row[recordType!AX Vehicle.fields.image])I enter that, make sure it's formatted well, but the "OK" button does not get enabled.  The red triangle says Invalid index operator ''vehicle'' (expecting comma).

Hi, I am trying to show data on piechart, the field make has different data.  I want to segregate the data into let's Ford and non Ford. How can I do that?{ a!pieChartField( data: 'recordType!{aa4ce38f-1a9d-4827-af51-e2ccb80a2c8b}AS Vehicle', config: a!pieChartConfig( primaryGrouping: a!grouping( field: 'recordType!{aa4ce38f-1a9d-4827-af51-e2ccb80a2c8b}AS Vehicle.fields.{7aa3dcda-863a-4271-9034-85821a2bd453}make', alias: "vehicleMake_primaryGrouping" ), measures: { a!measure( function: "COUNT", field: 'recordType!{aa4ce38f-1a9d-4827-af51-e2ccb80a2c8b}AS Vehicle.fields.{595da20e-a849-4c36-a57e-d569453c622f}vehicleID', alias: "vehicleId_count_measure1" ) }, sort: { a!sortInfo( field: "vehicleId_count_measure1", ascending: false ) }, dataLimit: 100 ), label: "Vehicles by Make", labelPosition: "ABOVE", showDataLabels

There is a requirement where I have to show Editable grid in a read only mode and I can edit by keeping icon when selected. But Is it possible to filter one of the dropdown field to filter it out. in editable grid.

Hello every one Is it possible to set a process model on a record type summary? I know it can be done with an interface, but I would like to verify if it is possible with a process model. Like in the photo below (i tried it and failed) Thanks

In a PM, getting the below error, how can I resolve this?

Hi Everyone, In our environment we are using 'Chart creator' to create charts. Is this plugin still functioning in appian? i know that we have chart generator plugin to generate charts.

Hi, I have an interface from which I am passing documents from an attachment field from an interface to a process model. That process model simply writes the doc id to the database. I am getting a problem thet the rule inputs are holding the values but it is not passed to my process model. Can anyone please help on this.

Hi Everyone !!!,I know this is very common question i know it but for clerification can anyone let me know that  We can directly save the data into the database througth interface but which is better from process model or interface??

 Requirement During the new record creation if user fill Details  and doesn't click on save draft button and didn't submit the form and no actions are performed on it within 24 hours, the task should be automatically deleted. If user Clicks on save Draft  button then task shouldn't be deleted for 30 days Thanks in advance!

Hi When user is clicking default  appian profile it's throwing an error An Error Has Occurred  record data does not exist, has been deleted, or you do not have sufficient privileges to access it. (APNX-1-4205-006) but user is part of all groups. Only one person is getting this error. Could you please provide suggestions. How can i achieve this.

Hi All, I have to display the data shown in below screenshot. Is there any grid pattern available to display like that?

Hello, We have a CDT in our application to match an Excel file that is being uploaded. If the Excel template changes (ie. column headers are renamed and rearranged), what is the best practice for getting the CDT to match the new Excel file being imported? If I edit the XSD of the CDT to match the new Excel template, will all dependencies automatically update under the CDT?