Discussion Categories

I have requirement to export a view to excel such that one of the fields (request ID) should be having a hyperLink to Appian record. Data to be exported is stored in a view. How can I achieve this in Appian? Note: We need to send the exported excel via email every week. Thanks in Advance.

Upgrading to Appian version 24.4 and cannot get the Tomcat server to initialize completely. The following is a snippet from the tomcat-stdout.log:"host [http://localhost:9200], URI [/], status line [HTTP/1.1 401 Unauthorized]{"error":{"root_cause":[{"type":"security_exception","reason":"missing authentication credentials for REST request [/]","header":{"WWW-Authenticate":["Basic realm=\"security\", charset=\"UTF-8\"","ApiKey"]}}],"type":"security_exception","reason":"missing authentication credentials for REST request [/]","header":{"WWW-Authenticate":["Basic realm=\"security\", charset=\"UTF-8\"","ApiKey"]}},"status":401}" ..... [wait-for-component] INFO  com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Search Server to be healthy... I've ensured the apiKeys match in <APPIAN_H

I have a requirement to embed iframe into Appian user interface. Is there any way to do this?

TCN is a system used for auto-dialling customers in our use case.  Currently, TCN interfaces are used to auto-dial the customers and record the communications. However, with Appian coming into picture, we are now exploring the option to embed the TCN Screen into Appian interfaces. Your inputs here are highly appreciated here on achieving this. 

Hi All, I have a requirement tehre is column in a table story multiple values with text datatype  and when I'm trying to filter them on grid using filters then I'm using this code to show on filter dropdown: line 68-82   then getting dropdown as this:: But from first screenshot when I'm trying to search any one of the data from array example: 213396 then my grid is displaying empty data and for other data as well who are in array in gridhelp me achieve this,Thankyou!

Hi there. If I select the “Generate groups and folders to protect and organize objects” option when creating a new Application, what groups are created by default? I think they were “Administrators” and “Users” but I saw in a forum that someone was talking about the “Designers” group being created as well. Is this true?

I need to make a record-like query for a 1 to N relationship, in which it only returns the values ​​of the parent record if all the values ​​in the N relationship meet a condition. Example : I have a record called "Need" and it is related to another called "needchangestate" through a relationship 1 to N, I need it to return only the needs where all the needchangestate meet a condition, if all the elements of the relationship N do not meet the condition, the element Need should not appear Currently it returns me an investment where the condition is met in at least one of the records of the relationship N but this is not what I am looking for.

Hi All I am working on version 24.3! My scenario is, in the SITE provided to the users there is an Active Tasks page where user is shown the tasks as a link. On clicking the link; at the backend we have used a!startProcessLink() to start the appropriate Process Model with the required parameters.  We send a customised mail to user using Send E-mail smart service whenever a task gets assigned to them. The user wants the functionality that in that customised email, a link is provided for the task such that on clicking the link a task gets opened just like it gets opened from the SITE. I understand that a!startProcessLink() actually returns a Reaction Tree which Appian internally reads when we call the a!startProcessLink(). Wanted to check is there a way to handle the same scenario from the email such that on clicking the link in the email; the corresponding process gets started in Appian just like it happens from the SITE. Thanks in advance!!

So I want to be able for the user to add hyphens into their phone number(s) when entered into a form I have. Whenever I add hyphens to the phone number field it pushes the hyphens to the very front for some reason, like this but I want it to stay like this Here's my code a!textField( label: "Contractor's Phone Number", labelPosition: "ABOVE", value: ri!record['recordType!{d327a5dc-18d4-4ffd-8bdf-6a22b134677f}DS Contractor.fields.{f2502f28-185b-4cdb-87eb-56e09d28d249}conphoneNum'], saveInto: ri!record['recordType!{d327a5dc-18d4-4ffd-8bdf-6a22b134677f}DS Contractor.fields.{f2502f28-185b-4cdb-87eb-56e09d28d249}conphoneNum'], refreshAfter: "UNFOCUS", required: true, characterLimit: 12, validations: {} )

I need to deploy a series of datatypes to another environment. So I deployed the datatypes and then the datastore, and overwrote the original. Now the datatypes I needed are on the new datastore.But when I go on with the deployment sending the rest of the changes to my environment, the Data store entities constants related to the datatypes I recently sent to my other environment give me the following error: UnresolvedDataStoreEntityException: entity [...] in data store [id=... uuid=...] cannot be found.help, please!

Hi Everyone,  In my case i have 2 record types first one is  Case Summary and second record is case summary Items. I have one to many relationship. like- the primary key of case summary have foreign key constraint  from case summary items record. Now i have to make an editable grid in  which i will show all items from case summary items records but behalf of relations with case summary id . Now i am confused how can i achieve this because i have to write records at same time for summary records and case summary item records. Means have to use a!writeRecord() in interface which will update both summary and items records with relationship. can anyone help me on this. Thanks in advance

Hi, I need help understanding why record sync is not occurring when using the "Write to Datastore" smart service in one environment, while the latest data appears in the records in another environment. In the environment where sync is not happening, a manual sync is required to view the latest data. Can someone help me understand the cause of this issue?

Hi, I'm using Appian 24.2.270.0 and trying to insert an eventHistoryListField with comments in an interface , but when I click in the field for comments, the buttons appears like in the image here below.By clicking, the comment is inserted fine but why those buttons?Any solution?Thanks!

Is there any way to trigger a process from an Script Task within a process using a!startProcess() ? Thanks a lot.

Hi there. Related to the best practices, wich is the best way to call to an interface rules on my interface? Calling the interface rule on a rule input, Using keyword syntax or Always use consistent ordering of rule parameters? Thanks in advance.

I want to change the field name of a CDT to match the renamed field in the database. The old name was "FIRSTNAME" and the new one is "FIRST_NAME". Related to the best practices, the best way to do so is to download the CDT as XSD, change the field name in there, and re-upload the XSD, verify and publish the data store as a last step or is there any other best practice thing? Thanks in advance.

Hello Everyone, I am using another client’s SFTP server for demo purposes, which uses SSH key pair authentication with a private key that works in FileZilla. I have created Third-Party Credentials in Appian using the username only and uploaded the private key along with a constant associated with it. Here is my File Transfer Configurations CDT: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: "xyz.com", serverPort: 22, scsExternalSystemKey: "aws-cmd", usePerUserCredentials: false(), privateKeyFile: tointeger(cons!MS_SFTP_USER_PRIVATE_KEY_FILE) ) I am getting an error: invalid private key: [B@5bbde572. I know the private key works fine because I have used it in FileZilla.

Can I add hidden record fields if data sync is NOT enabled on a record type?

I have two records. I prepared the data attached. The records are: one is LTM GROUP and the other is LTM USER. Both are related records. I have heard that we can store data in the base and related child record in one shot. As GroupId is the primary key in LTM Group (autogenerated), plus LTM User has a foreign key named userGroupId, and obviously, this table also has a primary key userId which is autogenerated. Can you please help me with storing data in tables with the help of writing records in a single shot? /*Group*/ { recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 25, LTM Group.name : "Admin", LTM Group.updatedby : "rt343", LTM Group.addedby : "rt343", LTM Group.dateadded : fn!date(2025, 2, 25), LTM Group.disabled : false ), recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 26, LTM Group.name : "RTR User", LTM Group.updatedby : "rt567", LTM Group.addedby : "rt567", LTM Group.dateadded : fn!date

If the task is assigned in process model and it is still in pending and it arrives archiving time then the process will be archived or not 

Hi Team, I need to fetch data from a GraphQL API endpoint, but I'm unsure about the connected system required for the connection. The client has provided the ClientId and ClientSecret for AWS Cognito and mentioned that they are using SRP (Secure Remote Password) Authentication. However, I'm not sure what additional information is needed to establish the connection to the GraphQL service. Can you please provide more details?

I'm getting the error 'JAXB failure trying to convert value ProcessInfo{.....} to Appian type ProcessInfo (id=xxx)' when using the Start Process node in a process model. Does anyone know what may have caused this issue?

Hi, I have section of questions using 15 fields of a cdt (cdt has total 30+ fields).  Based on a dropdown value change, I want to make all 15 fields to null.  Is there any way I can make all 15 fields to null in one go, instead of writing 15 a!save.

Hi All, Hope you all are doing well, quick question, is it true that using a!queryEntity can skip the Record Type synchronization? I'm facing issues in my application cause I have an after insert trigger that is inserting a record based on some conditions, but the new record inserted is not being reflected in the application until I manually click Start Full Sync, wondering how can avoid this issue. By the way the version that I have is 23.4 Any help would be greatly appreciated. Thanks in advance, Jose Castellot

Hello, We had recently updated the SFTP Functions plugin to v3.0.2. After the update, the SFTP Send File smart service is failing with the error "Auth fail". Third-party credentials are setup and have not changed. The plugin has access to the third party credentials. The FT_Config CDT has got updated (due to the plugin update) and has the below structure: Smart Service Inputs: We are passing the values to the smart service as below:             File Transfer Configurations: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'(             serverHostName: cons!SFTP_HOST_NAME, (text)             serverPort: cons!SFTP_SERVER_PORT_NUMBER, (integer)             scsExternalSystemKey: cons!SFTP_EXTERNAL_SYSTEM_KEY, (text)             usePerUserCredentials: false(), (boolean)             pr