Discussion Categories

Hi, I'm using expression in "Source & Default Filters" in RecordType. I can only save expression with 4 criteria but I cannot save it with more than 4. do you have any suggestion. my code is below: a!queryLogicalExpression( operator: "OR", filters: {a!queryFilter(field: "year1", operator: "<", value:2021), a!queryFilter(field: "year2", operator: "<", value:2021), a!queryFilter(field: "year3", operator: "<", value:2021), a!queryFilter(field: "year4", operator: "<", value:2021), a!queryFilter(field: "year5", operator: "<", value:2021), a!queryFilter(field: "year6", operator: "<", value:2021), a!queryFilter(field: "year7", operator: "<", value:2021), } )

Hi Everyone, I have an interface where the data is populated from record type and in the interface there is one link field where I am passing the record type field and identifiers. I the record type I have added the summary interface which will get open on click of hyperlink. My issue is how can I pass rule inputs from interface to the record summary interface? Any suggestions are welcome!

After upgrading to the latest version PDF Tools 2.4.1, the generated PDF is having format font issues. I created a new word template from scratch which it uses the word template to convert to PDF and still no luck. I have attached screenshots of the pdf and snippet of the process model. Anyone faced this issue? Please give me your suggestions on how to solve this issue.

Hi, I have record data as shown in the table below :  Id NumbersInText 1 One 2 One 3 One; Two 4 Two; One 5 One; Three; Two 6 Three 7 Three 8 Two 9 One; Three I am trying to aggregate this data is such a way that I can how the report below : NumberInText Count One 6 Two 4 Three 4 Please help me with it.

I am working on bulk file (docx and PDF) handling Application. My plan to use SharePoint for that. I want to know,       1)Is there any other optimal way to handle bulk file other than SharePoint integration that can connect to Appian.       2) While trying to connect to SharePoint, Integration give error, even though Connected system is correctly authorized. Thank you

Hi All, I have a requirement where I have to export the request to PDF. So to achieve this I am using "DOCX from dynamic template" smart service. Here I am facing 1 challenge, I have a Database table where I have data in below format(like grid), Section Name Clause Text Amendment Number date Sec1 Text1 1 18-01-2023 Sec2 Text2 2 18-01-2023   But in word, I want the above data as separate sections, like below format Sec1 Clause Text Text1 Amendment Number 1 Date 18-01-2023 Sec2 Clause Text Text2 Amendment Number 2 Date 18-01-2023 So please help me how to create dynamic sections based on the number of rows of data in word, I tried below one, but it is not working, throwing the error

Hello, I have a process model that is using execute Process Report to retrieve data on task metrics and store in the database. We are seeing an intermittent error where data is not being retrieved into process variables. I thought this may be a timing issue, but no data is being retrieved when the model is rerun and the underlying process report displays the required data. Are there any system logs that can be queried to help me identify the root cause of the issue?

How to transfer the data of excel file into mysql Database?

Hi While using Import CSV to database, i am facing this issue, Error message : Error executing SQL.Can any one help me with the solutionThanks in Advance

Getting "error has occured " while trying to download "Appian selenium api",Can someone help me with this issue

Getting "RecordFormatException" while updating the record in excel file. Used apache poi with the version 4.0.0 for reading and writing to the excel file. Can any one help on this issue?

I have one array like {1,2,3,4,12,12}, I want a new sub array from 3rd index till end like {3,4,12,12}is there any rule or function?

hello community, I would like to try the first level exam (associate) and I wanted to ask if it was possible to take the exam in Italian/Spanish or if alternatively it was possible to use google translate Best regards

When i'm creating cdt from database i'm facing this issue:- ->After selecting Data source no table or view is there for selection  -> data source (oracle DB)

Hello, I have an interface that needs to show default value in dropdown for my users when some options are specified (see example below)  { a!DropdownField( label: "Toto dropdown", choiceLabels: {"1", "2", "3"}, choiceValues: {1, 2, 3}, value: ri!toto ), a!DropdownField( label: "Tutu dropdown", choiceLabels: {"4", "5", "6"}, choiceValues: {1, 2, 3}, value: ri!tutu ), a!DropdownField( label: "Foo dropdown", choiceLabels: {"Test", "Test2"}, choiceValues: {140, 150}, value: if( and( isnull(ri!foo), a!isNotNullOrEmpty(ri!toto), a!isNotNullOrEmpty(ri!tutu) ), if( and(ri!toto = 1, ri!tutu = 2), 140, 150 ), ri!foo ), saveInto: ri!foo ) } This interface is embedded in a form component, when i submit this form and the default value of the "Foo dropdown" hasn&#3

Getting this below mentioned query: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error in rule 'isbn_mapbookdetails': Invalid index: Cannot index property 'body' of type Text into type Text Since, I am new to Appian, is there anyone who can help me  out?

Hi, I am having issues in my application with values being passed on.  While I am checking my record relationship, I am not able to get the field entries while checking the preview. itemid field is the common field. But no entries are found.  Where am I going wrong? There are two records Asset and Request. Trying to relate both these records.  My Asset Record Fields.  My Request Record Fields Because of this issue, I am not able to reference any asset fields in my request related interfaces. If I use two separate rule inputs to access the fields, my process models are working fine. But I want to use relationships to access my related records. I know this is a basic problem but somehow I am not able to fix it.  My table looks like this Appreciate if someone helps me with fixing and letting me know where I am doing an error? Thanks

Hi, Dropdown field is getting error, can anyone provide inputs to resolve. a!localVariables( local!refData: rule!EC_getReferenceData( appName: "EC", category: cons!EC_REFERENCE_CATEGORY[{ 2, 3, 4, 5 }] ), local!departmentList: rule!EC_filterRefData( refData: local!refData, category: cons!EC_REFERENCE_CATEGORY[2] ), local!Existing_Emp_ID: if( rule!APN_IsBlank( ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{5dd14089-6372-498b-bdd4-49221479de4c}id'] ), false(), true() ), local!Emp_Data: length( rule!EC_getEmployeeDetails( empRefId: ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{5dd14089-6372-498b-bdd4-49221479de4c}id'] ) ), local!EMP_Code: if( rule!APN_IsBlank( ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{5dd14089-6372-498b-bdd4-49221479de4c}id'] ), concat("EC" & local!Emp_Data + 1), ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{190fbb44-7340-

Has anyone successfully installed Appian on a Mac that uses the M1 Chip (Apple Silicon)? Currently I am having an issue as the Dockerfiile is using centos7 which is created for Intel chips, and its resulting an error because of the M1.  Getting this error when doing a docker-compose build: failed to solve: rpc error: code = Unknown desc = failed to solve with frontend dockerfile.v0: failed to create LLB definition: no match for platform in manifest sha256:691c55aabb3c4e3b89b953dd2f022f7ea845e5443954767d321d5f5fa394e28c: not found Another example of the error: https://stackoverflow.com/questions/67911250/cant-build-docker-compose-on-m1-chipset  I know this is not an Appian issue but anyone that has been through the same thing and managed to find a solution would help a lot!

Hi, How to prevent running of truncate and delete query accidentally on database table. Is there any role and access setup can be done to prevent this considering having "System Admin" access in APPIAN. Regards Bihitak

Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18} Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance

So I would like the user to click a link or a button in a UX and that launches a process model. The process model will determine a url that needs to be opened in a new tab. I only want the process model to run when the user clicks the button or link.I have tried a!startprocess with success: but im not sure how to get the url opened in a new tab. It successfully runs the process but nothing else seems to happen.Trying various things on the OnSuccess. Httpreponse etc

Hi there, I have one CDT array { {a: 1, b: "R" }, {a: 2, b: "E" }, {a: 3, b: "R" }, } what's the good way to update field b from "R" to "T". tried this, it does not work. a!update(CDT.b, {1, 3}, "T") anyone has the experience dong this? Regards, Lin

Hi I want to test an integration which should create a new record in an external system. This is the code that creates a 'job', with its name, the department, an array for the offices ids and a template_job ida!tojson({ "job_name": "AppianFlow3"& " "&"Related data"&ri!record['recordType!NJW NewJoiner.relationships.njwGhOfficePicklist.fields.officegh']&ri!record['recordType!{1fc618ce-6255-402a-81f8-007ca9ca5de4}NJW NewJoiner.relationships.{925eac6a-be91-4fe5-b4a3-1009d480994a}njwGhOfficePicklist.fields.id']& "NJWRecordType"&ri!record['recordType!NJW NewJoiner.fields.division']&" "& ri!record['recordType!NJW NewJoiner.fields.businessmanagerapprover']&ri!record['recordType!NJW NewJoiner.fields.id'], "department_id":"4076573002", "office_ids":{"4036737002"} , "template_job_id":"5468426002" } ) I want to test the integration by getting one record by id of the record type NJWNewJoiner and parse in the json request some fields from the NJWNewJoiner Record type as well as

Hi all, I have a problem converting bolded words from docx to pdf using PDF from DOCX Smart Service. Bolded words have special characters(need to use UTF-8). Is there a way to do this using this smart service(pdf options)? Thanks in advance.