New to Appian

There is a user who is already present in the Appian environment. If I change the last name of the user will the user cab still access the application or the user's account will get reset and the user will automatically get logged out from the respective applications and groups. Example: In the current situation: User's First Name (dummy) : Vivian User's Last Name (dummy) : Richards The current name of the user is 'Vivian Richards' and the user is currently active in the system. I want to change the username as: User's First Name (dummy) : Vivian User's Last Name (dummy) : Williamson Richards Is it possible to change without affecting the user's credential or any actions related to application's specific group. Any inputs/solutions will be greatly appreciated. Thank you

I ran into this problem when creating an expression rule for pulling the current pastor for a given parish Id (organization Id).  The Id is passed in a Rule Input as parishId. I have three tables that are needed for this query, all are related. Clergy Member, Clergy Assignment, and the reference table for the Position name.  I need to pull the assignments that are current, i.e. where the Position Term Date is greater than today or null (for permanent assignments).  This is a very similar problem to the one I posted here:  [mention:aa603d0cc3424d8185dbd2f2ce5acf40:46448885d0e64133bbfbf0cd7b0fd6f7:label=queryRecordType%20with%20an%20%26quot%3Bor%26quot%3B%20condition]  Now that a!queryLogicalExpression is my new best friend (a big thank you to Stefan Helzle for the intro) is used a very similar logic.  Since I wanted the results to be a Clergy Member record type, I used that as the record in the a!queryRecord function. a!queryRecordType( recordType: '

I have taken appian associate developer exam yesterday, i got only 28 out of 60,but am confident to get more marks,any suggestions pls

Hi Everyone, I need to display multiple radio buttons in a single column of a grid. I am not sure if this is possible. If anyone can suggest would be helpful.

Hi Everyone, I am opening an interface 2 from interface 1 through record summary on click of link in interface 1. I need to have a cross icon in interface 2 upon clicking it, will open the first interface again. Can anyone please help me.

Hi Everyone, I am querying the db table through query record type. This query gives the list of db records. When I am using this in interface and using index to get the particular field, it gives this list of particular field. In case of null or single it also gives list. Can anyone please help me when it is null or single value should not give list.

I need an Expression Rule that has an or condition for a filed. I have a list of clergy assignments and I need to pull all current assignments and those that terminated over the last year.  The record type, CPMA Clergy Position has a termination date for the assignment, clergyPositionTermEnd which is a date formatted field.  If the assignment is for a fixed term, then there is a future date in the field.  If the assignment is a permanent assignment, then the field date is null.   The or function would look like this. or( RecordType!CPMA Clergy Position.field.clergypositiontermend >= today()-365, isNullOrEmpty(RecordType!CPMA Clergy Position.field.clergypositiontermend) ) However, I do not understand how to use this inside an Expression Rule.  My Expression Rule using the queryRecordType function looks like this. if( a!isNotNullOrEmpty(ri!clergyId), a!queryRecordType( recordType: 'recordType!CPMA Clergy Position', pagingInfo: a!pagin

HI team, i want to find the type of extension and Size of list of documents and i have used document function and build an expression rule it is working fine in expression rule as expected when i call that expression in an interfcae  it is shoowing error as document function is deleted.  a!localVariables( local!size: a!forEach(ri!documents, document(fv!item, "size")), local!extension: a!forEach( ri!documents, document(fv!item, "extension") ), toboolean( and(and(reject( fn!isnull, { a!forEach( local!extension, if(fv!item "pdf", false, null) ) } )), and(reject( fn!isnull, { a!forEach( local!size, if(fv!item > 5000000, false, null) ) } ) ))) ) when i use in interface getting error as shown below

Objective is to display the firstName of all active users. a!queryRecordType( recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User', fields: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{firstName}firstName', filters: a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{active}active', operator: "=", value: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)).data ref {user() Function - Appian 23.2} throwing below error  Expression evaluation error at function a!queryRecordType: The record type [identifier=SYSTEM_RECORD_TYPE_USER] cannot be queried because it is a service-backed record type.

Pls answer the below question 1.What is the difference between Entity Backed records and Process Backed records?

The page I am testing has a line chart with a download icon on it with the tooltip Download PNG Image, but I am unsure how to have my FitNesse script perform the download. I see support for downloading charts was added to FitNesse for Appian November 2023 - Release 23.4, but I don't see in the Cheat Sheet or documentation how to download charts.

Hi Team, Beginner here. I need to send a message to a Kafka topic that's used by another team. To do this, we're using a plugin that accepts messages(parameter) as text. The message I need to send is a dictionary in Appian, and I'm converting it into a JSON string using a!toJson(). so that the other team can parse it. However, the other team expects the dictionary to be enclosed in single quotes, like this: '{"a": "hello", "b": 1}'. I have few questions: Is it possible to create such string enclosed in single quotes in Appian? In the Expression Editor's output tab, there are three formats: "formatted," "raw," and "expression." Which one should I consider as a output. I mean the output format we see will be different while passing into pv! right. for example {"a","b","c"} will be shown in the output as below(image), but in the instance if we look at th

Hello I need advice .As my requirement after registered data to database and redirect register form. below is my process model flow. which flow is better and good for redirect interface. Is there any other method other than the Flow I implemented? Thanks

Hi Expert I have an interface where I have read only grid . Now, when the user clicks on completed Status , I want a way to open the interface as a dialog.  if there is a way please let me know. I tried with record action but not able to achieve this . a!gridColumn( label: "Status", sortField: 'recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status', value: a!richTextDisplayField( value: a!richTextItem( text: if( a!isNullOrEmpty( fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] ), "", fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] ), link: if( and(fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] = con

I have an interface where I have read only grid. Now, when the user clicks on Completed Status . I want a way to open the interface as a dialog, if there is a way please let me know. I tried with a!recordactionfield but not able to achieve this . a!gridColumn( label: "Status", sortField: 'recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status', value: a!richTextDisplayField( value: a!richTextItem( text: if( a!isNullOrEmpty( fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] ), "", fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] ), link: if( and(fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] = cons!CDM2_VAL_TARGET_ST

Hi, Can anyone help me with converting multiple map into single map, example input: {a!map(),a!Map(),a!map()} output{a!map()} Help is appreciated

How to click a button to copy data to clipboard in Appian

Hi I am new on Appian and I'm trying to make a PDF from a Word file using a dynamic DOCX template, but I'm having trouble generating the Word file, and I'm not sure where I've gone wrong. I've attached the XML data and Word file that I'm attempting to override [View:/cfs-file/__key/communityserver-discussions-components-files/62/PDFSample.docx:320:240] 1 General ticket New changes Verification 2 1 7125 2 General ticket ghgh 2 2 7141 3 Hardware Issue jhj hjhjk 2 2 7142 4 Software Installation Installation of MSSQL 1 1 5 Software Installation Test Software installation 1 Pending 7191 6 NA Pending 7 Hardware Issue Battery issue 1 2 Pending 8 Others Log Analysis 2 2 Pending Unable to check the logs 0 9 Others Server Upgrade 3 1 Pending Server Needs to upgrade 0 10 General ticket SQL Installation 1 1 Pending Required Sql server to work on Database relat

Hi Everyone, I have two process models p1 and p2. In p1 there is a user input tasks which opens the interface. In this interface there is a save button which runs the p2, but when p2 completes it is not refreshing the interface variables. I am using the refreshAfter param in refreshvariable function. Can anyone please help me out.

In list of variantsI want to create a list of text strings.(As shown in the attached image) I want to understand clearlyAfter trying it out, I couldn't get the expected results.

Hi Team, There was a timeout error, what this signifies? Here, we pull the data from snowflake as a batches. In the integration, we have setup to 1500 seconds. Will increasing query timeout help here?

Hi Everyone, I have ha grid having four columns that have a button at the last column. The button is record field action and the grid is selectable. I would like to display the button in that row only which is selected. Can anyone please help me how to achieve this.

Hi All, I'm not having the desired result when using proper() with words including special characters.  We receive the error when the user's name has special characters.  EXP)  O'Neal is being saved as O'neal, Aube-Kubel as Aube-kubel, etc. I need to implement a rule for capitalizing letters after special characters, but not sure how to proceed.  Any assistance is appreciated, thanks!

Hi Experts, Need your help in the following issue: I have created one view that is getting data from a table in a DB. Then I created the CDT for the same from that DB and then the DS is also verified and published with no error. But on retrieving the data from a DB rom a query entity I am getting the following error:   Using the Record Type also I am getting the following error while viewing the Record list, We have only 194 records in that view:  Please help me to identify the cause of the error. 

Hello, im new to appian and we have a requirement that after submitting the Form it should go to the Record List interface next and i have checked and "Confirmation URL" should do the job done. but im having trouble configuring it. i have used : "site and tempo links" dev.appian.com/suite/sites/sandbox/page/record-list dev.appian.com/suite/tempo/reports/view/KQPHyA please help. thank you very much!