Discussion Categories

a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDate: {}, local!holidays: { if( a!isNullOrEmpty(local!holidayslist), {}, text(local!holidayslist, "DD") ) }, local!currentMonth: { a!forEach( items: local!selectedDate, expression: if( tointeger(text(fv!item, "MM")) = local!month, t

Hi Team I want to show case the percentage of data in the Y axis of the column chart field. Eg: If the X axis is have 4 values: A,B,C,D and Y axis is having values for each 1 for A, 2 for B, 3 for C, 4 for D. But other than showing these values is it also possible to showcase the percentage of these values as well? Thanks Harikrishnan

Hi all,As i have intalled RPA bot in my host machine.. I cant find the appain icon in my task barSo that my bot shows offline. I have tried executing the agent manually but it didn't workedPls suggest how to configure

I have installed RPA agent in my host machine. But I cant find icon in my taskbarI have tried to launch the agent manually but didn't worked

Can anyone help me to find default mariadb connection details in system logs?  I am not able to find in data server logs. Please let me know the exact path of that.

Our team is interested in developing applications using the appian platform and exploring options to publish them on the Appian App Market. Could anyone provide with more information on the partner plan available that align with our requirements? Specifically, we are looking for option that allows us to: 1) Build applications on the Appian platform using its low-code/no-code capabilities.2) To publish applications on the Appian App Market. Any information or guidance will be great help. Thank you in advance!

Hi All, Through Integration I am fetching the data from external system and storing it into my system. But it also stores duplicate records which already exists into my system. How should I prevent this, if I compare each row with existing data it would be time consuming. Please suggest.

Hi , How to remove unwanted characters from text ?  I get data from excel where its having char(9), char(160) sometimes different char(x) which none can expect example: \tHello ( In Appian value : fn!char(9)Hello ) I want only Hello from the value. To use stripwith, char(160), char(10) etc.. would come in value which I can't expect How can I achieve only wanted text or How can I remove those unwanted characters ?

hey, I am trying to sent email to a process model which gets triggered if it receives email as receive message event. I am using an on premise appian application. I tried to sent the emial using prcoessmodeluuid@domain but the mail is not getting sent. Also how to cofigure the domain for email. I already read the document but it wasnt of much help.

PGP Encryption Utilities Plugin is unable to encrypt file as .pdf extension but it is working fine for .txt file type.It is working fine for .txt file format as an encrypted file but is unable to create encrypted file with .pdf extension.when we try to open the encrypted file with .pdf extension gives above error.is there any solution we can use for PGP Encryption Utilities?

Hello Community, I need help with setting up an interface. I have an "ElectivesProfile" interface that has two columns: Elective and Students. If there are students for an elective, the Students column should show "Show More"; if not, it should show "-". When someone clicks "Show More," a list of student names should appear, and each name should link to that student's ID. Clicking on a student’s name should take the user to the "StudentDetails" interface, using the Student ID to show their details. I want to create a CDT with the keys studentFullName and studentID. When the user clicks a name, I need to update these values in the CDT (I can do this part). Then, I want to send these values to the "StudentDetails" interface as rule inputs: fullName and studentID. I'm having trouble using the CDT values as parameters in the "StudentDetails" interface.

I am getting an error in Maven Setting.With AppianRPA-configurator.exe, I am trying to do Maven Setting.However, the error log shows up. --------------- [INFO] Scanning for projects...[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[WARNING] Could not transfer metadata org.codehaus.mojo/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins:maven-archetype-plugin/maven-metadata.xml from/to SERVER_ID (mn

I am trying to create an RPA using APPIAN RPA Configurator, in the Maven settings, I get the error: This step checks if the Maven settings.xml configuration file exists and has the required configuration. Appian RPA Configurator can create or edit this file for you. Note: If you continue with this step, Appian RPA Configurator will create or add the required configuration to your settings.xml file When I go ahead and add the user, URL to the repository and the Maven key, another error pops up and returns me to the same screen with the previous error in red.

Hello everyone, Im new to Appian, Is it able to custom a box layout like this. I found that field style:"STANDARD" could be the same but I want it have to be white one. Can anyone help me?

Hi everyone, Please help check whether I'm doing anything wrong in below code. I'm having an editable grid with data source is a data subset local variable. In gridRowLayout I already provided the id for identifying, and save the selected ID into a blank local variable. But when I select each row, it's value is not stored into my local variable. I also tried with fv!index but that did not work either.  Below is the data subset local variable. I indexed into it's data.fileId field. 

Hi Team, Iam Learning New by picking up Random Task for Devlopment. and while devloping Calendar Iam Facing Issue With the Month Dec and Year 2024.  Could you please help me in understand me and updated the code if i make any mistake. even after 31 Dec i was able to select the card   a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!se

a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDate: {}, local!holidays: { if( a!isNullOrEmpty(local!holidayslist), {}, text(local!holidayslist, "DD") ) }, local!currentMonth: { a!forEach( items: local!selectedDate, expression: if( tointeger(text(fv!item, "MM")) = local!month, t

Hi All, I am trying to display a HTML document in interface. How can I do this any suggestions. Thanks in advance

Hi Community, I have a requirement involving a multi-select dropdown in an Appian interface. Here's the scenario: First Screen: I have a multi-select dropdown that is a mandatory field. Users must select at least one option. The selected options are saved in the database table, with each option stored in a separate row. Next Screen: The same multi-select dropdown is presented, but it is not a mandatory field. When the page loads, it should pre-select the options that the user selected in the previous screen (fetched from the database). The current user should be able to select more options or deselect previously selected options. Upon submission, the form should save the updated selections. I am looking for guidance on how to: Pre-select the options in the multi-select dropdown based on the user's previous selections. Allow users to dynamically update their selections (add or remove options) and save these changes. Any help or examples on how to implement this would

While testing a connected system point to a Postgre DB we are getting Test Failed. Where is the log file to find the details of what is causing this

Hi, we have been with an error for a while and we need some help to solve it. We are trying to generate the senders token for a Docusign Integration, but it gives us an success response (code 200), but in the response, we dont get the token. We are using the data used in the attached image In the emailAddresss Rule input we are using the same email of the developer account of docusign, and in the accessToken rule input, we pass an admin access token that we obtain in another integration.  If there is an easier way to implement this integration with docugin i would apreciate it if you can tell it.  Thank you!

Hi Team, currently working  to display a calendar to select some dates. so all months dates years are working fine but DEC Month is showing extra cards to select. I am providing my Devlopment need Support in understanding and Fixed code. a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDate: {}, local!holidays: { if( a!isNull

Hi team,  New here to Appian and i am trying to develop a calendar to select Multiple dates and it is working fine my problem is the calendar shows the extra cards in DEC 2024 month. the cards are selectable. i want to know the reason where my code fails and need support in fixing this. a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDat

Hello! I have an API which is returning an array of documents through an integration call with the response looking something like this:  { documents: [ { documentName: "document1.pdf", documentContent: "[BASE64ENCODEDCONTENT]" }, { documentName: "document2.pdf", documentContent: "[BASE64ENCODEDCONTENT]" } ] } The issue I'm having is that here in the integration where you can make appian to automatically convert the binary data to Document type, appian will recognise multiple files (content of them) through the fv! domain, but there is no way to set the document name for each document through the fv! domain.  What I want to be able to do is to set the document names similarly like I do here in the screenshot for the documentContent, which then correctly goes through the response and converts the data to document type.. What is the expected way to do this in appian? 

Hello,  I have a problem creating a query in Appian, which was previously created in SQL. Basically, we have 2 tables, the main one with the CASE numbers and the status, and another one where we record the historical movements of those cases: Main Table : CASE IDCase Status 1 Active 2 Active 3 Active 4 Close 5 Active Secondary Table: HistoryCase IDHISTORY IDCASE LogText CreatedDT 1 1 Created 11/23/2024 10:34 2 1 Updated 11/23/2024 10:34 3 1 Assigned 11/23/2024 10:34 4 1 Updated 11/23/2024 10:34 5 1 Closed 11/23/2024 10:34 6 2 Created 11/23/2024 10:34 7 2 Updated 11/23/2024 10:34 8 2 Assigned 11/23/2024 10:34 9 2 Updated 11/23/2024 10:34 10 2 Updated 11/23/2024 10:34 11 2 Updated 11/23/2024 10:34 12 2 Closed 11/23/2024 10:34 13 3 Created 11/23/2024 10:34 14 3 Updated 11/23/2024 10:34 15 3 Closed 11/23/2024 10:34 Our SQL query has subqueries, where we look for the last "Update" of each "CASE", so one we h