Discussion Categories

I have a read only grid with a record type as source, I have three columns that has dynamic values. Meaning, I am using 4 or 5 record fields and get average these are custom fields. value: recordType!field1+recordType!field3+recordType!field3 / 3          --Its a numeric field lets say field name is "Avg value" then I have one drop down that suppose to filter the values in readonly grid based on slection. If I select the value ">1" from drop down readonly grid should filtered and show only records have "Avg value" column >=1 I am not able to use queryFilter as I don't have appropriate value for "Field"

Dear anyone, I am currently trying to execute Box API that uses JWT, But the following issue occurred when executing the Box API to obtain an access token. If someone else has sent about the same issue and it has been resolved, or alternative solutions you may suggest would be highly appreciated.   [Error details]　*This is written in the body of the HTTP response. "{"error":"invalid_grant","error_description":"Please check the 'box_sub_type' claim. The value for 'box_sub_type' is invalid"}"   [Procedure] 1.Obtain a JWT using the createtoken() function of the “Box” Plug-ins. 2.Execute the Box API to obtain Box's Access Token.   *An error occurs here.   [Already Confirmed] 1.Applications created in Box have been approved by the Box administrator. 2.'box_sub_type' and 'sub' classifications must match.   Thank you very much in advance for your assistance. Best reg

Hello All ,  we have a database view , using that we created a record ( disable data sync) as Appian record is not allowing view with enable sync option.  facing performance issues with this Appian record picker, please can someone help with the following questions :  Question 1 : how can we implement a minimum character requirement for the search input in the record picker (pickerFieldRecords) to reduce the number of database queries ? Question 2 : how can we limit the initial load to a smaller subset (i.e. only load 20 result based on user filter) of records to prevent performance bottlenecks ? Question 3 : is there a way to implement Appian caches record data in memory with disabled data sync record  type ? Thanks!

Difference in Write to Multiple Data Store entity and Write to Data Store entity?  When we need to use the multiple data store entity?

Dear Anyone, I am currently trying to execute Box API that uses JWT, But the following issue occurred when executing the Box API to obtain an access token. I get an error stating that the JWT is an invalid value, but when I check with jwt.io I can see that it is a valid value. If someone else has sent a support request asking about the same issue and it has been resolved, or alternative solutions you may suggest would be highly appreciated. [Error details]　*This is written in the body of the HTTP response. body: "{"error":"invalid_grant","error_description":"Signature verification failed"}" ・Confirmed JWT in jwt.io Thank you very much in advance for your assistance.

I have update and delete options in my related actions tab , but i want to remove the related actions tab and add the update and delete options in the summary view (Job Details) tab itself. Can anyone guide me how its done.

Dear anyone, I am currently trying to execute Box API that uses JWT, I saw an article that said that you need to set "Third-Party Credentials" when executing the Box API. However, the connection is not working properly, so if you know which field to set in the Credentials, please let me know.   Thank you very much in advance for your assistance. Best regards,

How to click on the above Menu Layout Button? using the Appian Selenium 

Is it possible to generate a unique URL to open a process in Appian? I would like to be able to start an Appian process instance using an API from another system, and open that process from a screen like "Appian process list" on the other system.A process has multiple User Input Tasks and also enters sub-processes, but I would like to be able to open the process from the "Appian Process List" no matter what state it is in.Is it possible to generate and return a unique URL for opening a process, regardless of the task, when a process instance is launched? How should I implement this?I've recently started learning Appian.Please forgive me for asking a beginner's question. Thanks in Advance.

Hi all... i have a database-table (postgresql) with 3 columns: id (integer), year (integer) and cost_pre_hour (numeric(10,2)). I would like to use this table as a source for a dropdown.As choicelabels I want a contaminated string in the format: ‘Price for year ’ + [year] + ‘ (’ + [cost_per_hour] + ‘)’[cost_per_hour] preferably formatted with 2 decimal places. I just can't get it to work. what i tried:in the record-type another calculated field:a!customFieldConcat( { "Price for  ",recordType!<recordType>.fields.year," (",?????????" euro/hour)"})for ????????? i set:text(recordType!<recordType>.fields.cost_per_hour,"#.##0,00")orcast(typeof(1.0),recordType!<recordType>.fields.cost_per_hour)or other internal-cast-functions or/and combinations.I got the error Could not cast from Record Field to .... CastInvalid or something like thatWhen i try:tostring(recordType!<recordType>.fie

Hi everyone, I'm trying to load json to db using this Appian smart serivces. My sample json data i have given below. It has multiple dynamics parameter for example user have multiple types of phone number. if it flattens json file then its working without any issue but sub paramters are not working as expected. Added more details below Main Issue while accessing the json sub parameters which is dynamic In smart service Load JSON to a database, "JSON key/Column Name mapping" Field for json fields key i have tried like this Phone.number as well as Phone[].number but while executing Process model considered as "FirstName", "Phone" as column instead of each table column fields like FirstName, PhoneType PhoneNumber. I cant able to navigate inside of sub paramters while mapping json key to table columns name Plugin name: JSON Tools Smart service name: Load JSON to a database my sample appian rule { "FirstName": "First_

I'm using a Google Sheets connected system in Appian with OAuth 2.0 authentication. The integration works initially, but I'm encountering an issue where the connection requires reauthorization almost every hour. Has anyone faced a similar problem with token expiration or session persistence? Is there a recommended way to maintain or refresh the token without requiring manual reauthorization so frequently? Appreciate any suggestions or best practices to resolve this.

I am getting this error on html to pdf converter node - java.lang.Exception: java.lang.IllegalArgumentException: null incompatible with Global antialiasing enable key Following is the html body retrieved from email Best regards,Isac Hi Eunice/Team, All set: Hi team Pls set up both tranches Thanks, Eunice Trader Additional Comments Term Sheet;<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="">schemas.microsoft.com/.../omml" xmlns="">www.w3.org/.../REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--/* Font Definitions */@font-face {font-family:"Cambria Math"; pa

Hi Appian Community, Iam new to appian and iam still struggling at a lot of things due to my limited approach. I have recently started working on a POC which is a little bit complicated due to which iam facing a lot of blockers. It would be great if anyone is willing to guide me a little bit on how to resolve my blockers and help me complete my POC. You can just help me in your free time or how little you can. Thankyou.

Hello everyone, I believe I created a real issue by deleting documents I should have left alone. My goal was to make environment B identical to environment A.  There were existing files in environment B so my approach was to delete everything I could and then import everything from environment A.  To clear away everything in environment B I hard deleted all application files by going into the application in designer, check the box next to the file name, delete, and confirm delete.  Once all files were deleted I would then delete the application itself.  Once all applications and their corresponding files were deleted I then went after files that lived outside of the applications.  I'm fairly certain this is where I created my problem.  I deleted documents that I now believe were being used for the appian user profile pictures.  The documents I deleted had the format of <username>_180, <username>_90, <usernam

I have to open a web page as RPA Task and scroll down to click on an icon to extend the additional info. Upto scroll down to that particular section, it is working fine. But I am not able to click on the add icon to extend. Can someone guide me with the configuration.

Hi All, i want to know , how to configure the below logic BY default all the option should be selected. and also in dropdown i can have the option to deselect all /select all along with all the options. Please help me how i can go about this

Hello, We are running a query on Synced Record data using a!queryRecordType where we need to filter based on a list of Text. This is the query filter we are using: a!queryFilter( field: 'recordType!recordName.fields.email', operator: "in", value: ri!email ) The record field is type Text and contains users' emails, which vary in how they are capitalized. The rule input ri!email is a list of Text String. When we pass in only a few items to that rule input we are able to return the expected results and we do see the records being returned with the email field matched in a case-insensitive manner. However, in our implementation we need to search on a large number of emails where the capitalization is not consistent across data sources. When we pass in 173 items to the ri!email rule input, we do not see the results being returned as expected with the email field matched in a case-insensitive manner. Then, if we update that 173-item list to make t

Hi, I need to create JWT token, for this installed JWT Tools Plugin, createtoken() function is pasking for externalSystemKey as param, I don't know how and where to configure it, and if it dependent on other 3rd party integration, what to configure there and how it will handshake with apian to test? Kindly guide us on this. Thanks,

I want to have a custom record field, get data from related record field with out any aggregation it is a text field(like  we have group_concat and group by in SQL). I want to have this field as I want to apply sorting in read only grid on this column

Hello, I am trying to capture the attachments sent by email when starting a process by email is configured. I have tried to store in a variable (multiple) of type document the following data but the variable remains null: - fn!property(msg!properties,"attachment",null()) - fn!property(msg!properties,"Attachments",null()) And I also tried just msg!properties.Attachments but I get this error by email:

In a queryentity function, in an interface, I'm getting an error like "Unexpected error executing query (type: [CPVAccountsStatementTrackerDT8331], query:[queryentity expression], order by: [[Sort[FinancialInstitutionOther asc]]], filters:[(firmId = TypedValue[it=1,v=-1)])". How should I resolve this error. In one of filters, we are filtering based on -1 but this is working in some environment while failing at  some.

I created and RPA to upload a document(CSV File) from a Virtual Machine to Appian.  Everything works fine when I run the RPA manually, ie select execute from the robotic process.  However when  the RPA runs as part of my process model,  I get the following error. [ERROR] 2022-11-14 17:55:06 - - Error code APNX-1-4530-023 with message "The document cannot be uploaded because the storage limit exceeded, you do not have privilege or the document name is not unique." found for resource /api/v1/uploadDoc[WARN] 2022-11-14 17:55:06 - - Method manageException invoked I'm sure it must be some security setting in my Process model, but I can't figure it out.  Any ideas?

Hi, I have a RPA that takes files from my local machine and upload them into an Appian folder with the Upload Document module provided in Appian Services.. When I run the RPA within the Appian RPA console it works perfectly fine. I want to trigger this RPA from an Appian Process Model that uses the Robotic Process Smart Service but when I do so the RPA start fine but then I have an error that I can't solve so far... (looks like it's about the Target Folder).Error code APNX-1-4530-021 with message "docFolderUuid query paramter is not found." found for resource /api/v1/uploadDoc Can anyone help me? Thanks, Jeremy.

Hello Everyone, What is Appian Composer where can we  find that?If there documentation please do share