Discussion Categories

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

Can somebody tell me if both are the same, if ACD101 is the newest or they are for different levels?  Thanks

Hi all, I am trying to capture Mail sent by user and save the attachment in a folder. I am using Receive Message Event for the same and sending mail from my Gmail account to the Process Model UUID as mentioned in the forum "processmodeluuid<UUID>@subdomain.appiancloud.com". Mail is not getting sent in Gmail and used another Smart service, 'SEND EMAIL' for sending mail for the above ID. Then also the process is not working and error "No Valid recipient" is displayed. I have done everything as per documentation. Can anyone please let me know the flow on how to Send the mail and start the process to receive the mail with attachment? Thanks in Advance. Please find screenshots below for reference and let me know the changes to be done.    Receive Message Event properties:      Process model properties.

I have a variable that contain list of items, items are ;- year , category , value 2024, cap internal , 20 2024, cap external, 60 2024, cap material, 50 2025, exp internal , 20 2025, exp external , 30 2025, exp material , 40 I want to sort this like :-  year , category , value 2024, cap external, 60 2024, cap material, 50 2024, cap internal , 20 2025, exp external , 30 2025, exp material , 40 2025, exp internal , 20

Hello, Record Type Excel Download is giving unusual value as 'TypedValue[it=3,v=Completed]', in place of 'Completed'. But, in the DB View, value is present as  How to fix this, as Export to Excel is a OOB feature and can't be coded. Can someone help with this.

If i enter the value ,the value should be like 56.00 ,i tried , unable to achieve it  it is in  floatingPointField function 

Hi, I am preparing Certified Associate Developer(ACD101) Exam from last month, The materials which is available on the community learning path is sufficient to pass (73%) the exam or I need a hands-on experience which I learned? Also is 1 month of preparation is sufficient to take the test? As I am confused, please suggest your valuable comment on this,   Thanks in advance. Regards, G Udhayan 

Hi , I am trying to upgrade a process from older version which is active in prod, we have included New Nodes, Added new pv's after a user input task in the updated version. I looked into the documentation and tried using these plugins, when I used upgrade Processes from version 2, it ran successfully, but no changes to the existing processes  then tried Upgrade processes plugin, it returned the result code as Invalid state, although the state of existing process is active. could anyone guide me on this issue?