Foundation

Hi, I have text field in an interface and I need to trim the Leading and trailing spaces for the value if there any. So I have used trim() as in below code. I tested by giving some sample text with leading and trailing spaces, trim() has removed all the trailing and leading spaces in the interface. But when I checked the CDT to see how it stored, the spaces are still there and it is carrying forward the same value to next screens also. Can anyone please help me in resolving this.    a!textField( label: "Bundled Submission Description", labelPosition: "ADJACENT", value: trim(ri!bundle.submissionDesc_txt), saveInto: ri!bundle.submissionDesc_txt, required: true, validations: rule!RGRACSLBL_FN_getTextLengthValidationMessage( input_txt: index( ri!bundle, "submissionDesc_txt", {

Hello: I am trying to learn interfaces to create a single-page application.  I am using the Navigation (subsection) as the starting component (first image).  However, I would like to customize the interface so that when the cursor is hovering over an option, the text and background color changes.  As per the current configuration, the option (when a cursor is hovering) has a border but the text color is blue (option: Expenses in image one).  I would like to make it seem like the user-interface used in the Appian documentation page (second image).  Cursor is hovering on MODEL RECORD DATA.  I assume the collapsible feature is implemented using a!section.  Two questions: 1.  Is there an attribute or function that controls the color of the text/background when a cursor hovers?  2.  Is a!cardLayout (other than header/billboardlayout) the only component that provides ability to control the background - noticed that a!

How to set date-time format into : "jul 8 , 2021 9:35 AM" from using Date-time 

i have few doubts can someone clear me the doubts? i want to write the exam for L1 so which exam i have to take? here i found these, but not sure which is exam is for which level if i want to write L1 and L2 exams at a time then, which exams i have to register for and take?

We are searching with a text (example: "xyz pqr") and this input is passed to the integration to call API but API call fails because of the space in the input text/string.Expected outcome: want to encode the input like "xyz%20pqr".Note: Input may have any special characters including or other than spaces.

We are using a cardLayouts as a stack of buttons for actions the user must take before submitting the form.  The cardLayout has a label informing the user the type of action to perform and a status indicator to show the user visually whether the task is complete.  When you click the cardLayout, it displays a subpanel of information is displayed for the user to perform the needed task. Ultimately, we may have 7 – 10 of these cardLayouts stacked on the page.  This design allows users to see only what they want to see when they want to see it.  It also, helps them know when all steps are completed.  We feel that this is a very appealing UI design.   We are facing a challenge meeting WCAG requirements for this design.  Specifically, Criterion 4.1.2 which requires the following: 4.1.2 Name, Role, Value: For all user interface components (including but not limited to: form elements, links and components generated by scripts), the

I need to convert an excel document to the PDF, does anyone know how to do that ? Thanks in advance. 

Hi, We are having a editable grid where the columns are relation, soeid, geid, firstname, lastname. Relation is a dropdown field with the values {employee, contractor, client}. Soeid is a user picker field and the remaining columns are text fields. If user select employee or contractor in the dropdown and he should select soeid then the remaining columns will autopopulate related to the soeid. If user select client then the soeid and geid get disabled(grayed out) and he needs to fill all the other columns. My task is here 1. when the user first select employee and enter a soeid then the other columns will populate. 2. if the user select client again in the dropdown the soeid, geid, firstname, lastname which was already populated  should become blank. How to achieve the above functionality Thanks in advance.

First Create Function To Calculate Sum called : Calculate_Sum a!localVariables( if( ri!monthName null, sum( todecimal(index(ri!months, { ri!monthName }, 0)) ), sum( todecimal(ri!months.jan, 0), todecimal(ri!months.feb, 0), todecimal(ri!months.mar, 0), todecimal(ri!months.apr, 0), todecimal(ri!months.may, 0), todecimal(ri!months.june, 0), todecimal(ri!months.july, 0), todecimal(ri!months.aug, 0), todecimal(ri!months.sep, 0), todecimal(ri!months.oct, 0), todecimal(ri!months.nov, 0), todecimal(ri!months.dec, 0) ) ) ) Now Create Form in Grid to calculate and call the sum function: a!localVariables( local!invalidIncome: ("Please insert valid income value."), local!DuplicateIncome: ( "Duplicate value. Please check and delete if duplicated" ), local!CurrentRow: 0, local!TotalRow: 0, local!monthDetail: a!map( jan: null, feb: null, ma

Hello, I have a problem in process model when trying to send email. I needed to implement functionality as follows:  User needs to be on interface and enter email in textbox on which he wants to send email. After he clicks on the button email with document should be sent. User should then get information if email was sent or not on interface. For this I am using a!startProcess function on interface to start process model to send email. I have configured output message with all nodes having activity chaining at the end of the process model.  Message is returned when email is successfully sent, but when email that user enters does not exist I have a problem. In many cases, process will break on send e-mail node if user enters email that does not exist.  For instance I enter email ttestttttteee@gmail.com and process will break. But, if I enter email ttestttttteee@gmail.comm process model will continue and email will be sent. The problem is in email text after @ sign.

Any suggestions around it: I have requirement where user want to edit a column in editable grid and that column should be pickerfield. I have a table to store existing data and pulling from it on grid. For picker data, i have a reference table that pulls all the populating data as needed. I am getting an error while i try to remove the existing column data and fetch new data. I tried different ways to define this but somehow ended up facing different issue for each attempt. ONE ATTEMP: Below code is one way of my attempts!! TWO ATTEMPT: This is working fine if I do something like below but is not appropriate for business use case:  local!existingdata:  Record type uuid: 5bf7f7cb-2b7c-430f-93b1-102a13b4f3af from error is the Record that pulls existing data.

Hi All, Multiplying the below values by product function and expecting to return output as 16956.0843 but it is returning the output as 16956.08.  product(16746.75 * 1.0125) Regards,Sandeep

I was making a query today in which I wanted to find entries based on a particular field and if that field happens to be null, I want all the entries that have that field null. I ended up with 2 filters, one that looks for entries when the value is not null, and one that looks for entries when the value is null. It works and all, but the thing is there's a parameter called ignoreFiltersWithEmptyValues that is usually true by default. But you can make it false and now instead of ignoring those filters with empty values, it gives an error for each filter with empty values. My question is why does this parameter even exist if all turning it off does is cause an error on null values? Wouldn't it make more sense to search for null values instead? 

Hi All, Input code: a!toJson( value: {test: { assuranceText: "Jag försäkrar att uppgifterna jag har lämnat är riktiga och bekräftar att jag har tagit del av informationen och villkoren ovan.\n\nDin ansökan grundas på automatiserad behandling av dina personuppgifter. På vår hemsida och under inställningar kan du läsa mera om hur vi behandlar dina personuppgifter och om dina rättigheter.\n\nNär du skickar in din ansökan kommer en kreditupplysning om dig att hämtas in ifrån UC" } }, removenulloremptyfields: true()) I am geeting the out put as below: in the output you can observer that one extra backword is added for the newline character

Hi, I am handling documents in Appian using "a!fileUploadField". When we upload the files/documents using this component it is allowing to upload the files/documents to a specific Folder which we have created inside Appian. I would like to check if there is a way I can upload the documents to the network folder which is mounted. Any advises please.

Hi, I am using a smart service called "Export Data Store Entity to Excel" and generating a document and storing in a pv! variable. Now, when I try to attach the same document in the "Send E-Mail" service, I am getting an error. I passed the variable to the "Attachments" like pv!reportName and tointeger(pv!reportName), but still no luck. By looking into an error message I was unable to find the root cause. Can someone advise please. ERROR: Problem:  An error occurred in executing an Activity Class. Details:  Failed to process attachments Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority

Hi all,  when i want to save data in UI and then page jump out。 but i check the whole pm, chain every node and no error and the whole workflow in pm is fine .but just jump out . Below is my design.(just a mock) after i click save button in  UI and run the yellow part ,then the page will jump out. BUt if click save but dont run yellow part ,the page will keep. the yellow part is a sub process model to save data into db. all sub process model node chain. any idea for this? looks like yellow part is root cause.

What all cases are covered while using validateemailaddress() ?

I have a use case to check if a group already exists. And if not, we should create the group. Is there any way to check a group exists in an environment already.

Hi, I have observed many a times that in a script task with multiple inputs or outputs, that have some complex operations like queries, each input/output of the script task is stored in certain pv!. During execution only few pv! hold values and rest remain null, but if I use two script tasks instead of one and split the work among both the script tasks it works as expected. What could be the issue, is there any limit on processing a script task?

Hello!Context:  i have One page with 2 StartProcessLink: Link 1: List of sell Processes Link 2: Sell Procees Creation When i select the second link(Creation), it shows an Start Process Form, in wich i have a sumbit button. When the process starts, i want to have an interface showing a link to the Link 2 Form(Sell Processes List), so ive configured an user input task inside Link 2 Process, as shown in the image below: The thing is, it does not show, instead, when pressing submit, the main page its shown. Thank you for your help.

Do you have any idea on how to check if all values in array matched in appian? example arrayValue = {true,true,true} returns "All Elements are Same" else returns "Not the same"

Hello Everyone, In recent days, We are seeing this error in the tomcat-stdOut.log. In the front end, we are getting, An error encountered while processing the request. ERROR com.appiancorp.rest.shared.FallbackExceptionMapper - Internal Server Error on REST API invocation. com.appian.komodo.api.exceptions.SignalException: At least one referenced Activity Class Schema is invalid: ,304 Can you help us on solving this issue? Thanks in Advance

Hello Everyone, I am getting a multiple instance of the task name,how to fix this issue? Thanks in advance,

How to configure a key in CDT?