Foundation

I have below grid of data but i want to sort the below data by Month. User have dropdown option to select sort field as month and sort by like ascending or descending. The challenges am facing here is , since we kept month as text field its sorting in an Alphabetical order. can anyone help how do i do the sorting to get the month in a calendar order (Jan to Dec). Month        Vehical Brand    Repair  NewApril           BMW                 Yes      yesJanuary     Tata                    No       yesDecember Toyato                yes      No March        Audi                   Yes      yesMay           Kia  &

HI guys I'm chasing my tail here. We are assessing software against 4 criteria per software title. For each criterion we have a different assessor group. The software titles are kept in a list of map since they are not yet approved for our Allow List and we don't want to keep the data if they are not approved. We have a custom comments record type which has a many-to-one relationship with the software table. Issue: For each software title we need to keep 4 comments, but I find I am only able to overwrite the comments value, not append.Here's the code for my approval details interface:a!localVariables( local!softwareCategoryList: rule!getSoftwareCategoryList( includeDisabled: false, includedSoftwareCategoryID: if( a!isNullOrEmpty( ri!mappedValue.software[Global Software.fields.id'] ), null, ri!mappedValue.software['recordType!Global Software.fields.softwareCategoryID'] ) ), a!gridLayout( label: "Approve Software", lab

I'm facing an issue related to timestamp precision in an Oracle table that’s used with Appian. The table has two timestamp columns: one with zero precision (Datatype - TIMESTAMP(0)) one with six precision (Datatype - TIMESTAMP(6)) When I insert data into these columns without any triggers enabled, everything works as expected: the zero precision column doesn’t include milliseconds, and the six precision column includes milliseconds. However, when I add a trigger to the zero-precision column, I get an error saying the actual timestamp precision is 7, but received 11 even though the column is defined with zero precision and the trigger only defaults it to SYSTIMESTAMP if null. Why would the trigger suddenly cause exception , wanted to understand the logic better 

if( rule!APN_isBlank(singlePV: ri!date), "", /*left(text(ri!date, "mmm",3), ri!format))*/ left(text(ri!date,"mmm",3), ri!format)) Following is the error  Expression evaluation error at function 'text' [line 7]: Signature length (2) does not match parameter length (3)

Hi i have a process variable called request_data which is cdt type and in that there was one column called casettnotes which is a cdt casenotes cdt has currently 4 rows of data in that there was a column casenote which i need to update which is 4th row case note column data for this i dont have primary value it was null so i tried using other column which is issuetype like if issuetype is failed then update casenot for that issue type like that, all i want the casenote column which is 4th row column in casettnotes cdt need to be updated how to acheive this tried using many alforeach with update function but nothing working kindly suggest on this

Hey everyone, I need to use the Fill PDF plugin in my Appian project. I have to create PDF documents where users of my application can add items, such as their name. I've built an interface that includes a 'paragraphField' containing the text of my PDF. I've used this interface as a form for my Fill PDF plugin. Can anyone help me better understand how the Fill PDF plugin works? I couldn't find any documentation.

Good day everyone, I am making use of a coulpe a!pickerFieldRecords(), but in one instance it displays the corrcet values and in the other it doesn't. Please see the screenshots I've uplaoded illustrating what's being returned for both instances. Also see the code for both instances. # Values are displaying incorrectly - a!pickerFieldRecords( label: "Property Type", labelPosition: local!labelPosition, placeholder: "Search for the property type", maxSelections: 1, recordType: 'recordType!{7068b0aa-dd81-434e-a6a2-049c4ebc1894}AH Property Type', value: ri!record['recordType!{b4e98f0d-2927-4efc-87fb-bc265c91339e}AH Risk Location.fields.{7b7cc88a-959d-4ca2-b6df-dd684e8df4cf}property_type_id'], saveInto: ri!record['recordType!{b4e98f0d-2927-4efc-87fb-bc265c91339e}AH Risk Location.fields.{7b7cc88a-959d-4ca2-b6df-dd684e8df4cf}property_type_id'], required: true, marginAbove: "LESS", showRecordLinks: false ), # Values are displaying cor

I want to create a custom UI where all my actions are displayed as styled buttons using a!buttonWidget, but still open the native record action dialog (start form, etc.) the way a!recordActionField does. Currently, a!recordActionField works fine for triggering the action and opening the dialog, but it doesn’t give me the same level of styling flexibility as a!buttonWidget. I tried using a!startProcess() inside the saveInto of a button, but that just runs the process silently without opening the dialog. Is there any way to call a record action directly from a button widget (and open its dialog), or is a!recordActionField the only supported method?

Hello Community, We are currently facing challenges with early detection of errors in Appian processes. In our implementation, many flows include killers and orchestrate multiple subprocesses. While Appian’s process monitor allows us to see execution paths and variable values, this visibility is very limited once the processes are archived. As a result, identifying failures in a timely manner is difficult, especially in complex orchestrator flows. What we are looking for is: Early Alerts Is there a way to configure alerts/notifications when: A process fails, A process takes longer than expected, A subprocess does not start or complete as designed? Observability / Logging Are there recommended best practices or design patterns to achieve better observability? For example: persisting process variables, execution history, and error details (including history errors and variable values) into logs or records so we can analyze issues even after processes are archive

Within the Appian interface, the date field typically accepts dates separated by a forward slash ("/"). However, in our use case, there are scenarios where we need to support dates separated by a hyphen ("-") or a pipe ("|"). To accommodate this requirement, I’ve written the following piece of code a!localVariables( local!onlyNumbers: cleanwith("1.22.1957", "1234567890"), local!length: len(local!onlyNumbers), if(local!length = 8, concat(left(local!onlyNumbers, 2), "/", mid(local!onlyNumbers, 3, 2), "/", right(local!onlyNumbers, 4)), if(local!length = 7, concat("0", left(local!onlyNumbers, 1), "/", mid(local!onlyNumbers, 2, 2), "/", right(local!onlyNumbers, 4)), null ) )) It seems that the Appian interface is not executing the logic as expected, and the error still persists.

In my application I need to configure the approval task for multiple approvers in parallel. I m thinking to configure MNI for the process to assign the task to approvers. Scenario is let's say I have 3 approvers and if two approvers approves and one reject it then the request need to be reassigned to the initiator. It should move forward only if all the approvers are approved.. How to achieve this in appian. And also for approving I need to use the esign which is integrated in another application. Should I just to call that interface object or do I need to integrate that application in my application?

Hello everyone, I would like to implement a notification bell on an interface, that would show me notifications, similar to the facebook one attached, where if I click on it I see notification messages.I found a link to the post docs.appian.com/.../ux_messages_comments.html but it doesn't suit for my case: I don't want to take up additional space in my interface, nor is it nice in terms of user experience. Thank you very much in advance

I suddenly find when I use Dependents to check the dependents. I can not see any process model in the dependents tree. I also check the other env, they can see it normally. I want to konw why it occurs, is it wrong setting or a bug of Appian. How to fix it. 

I am planning for ACD300 certification so anyone kindly share valid suggestion

I have a requirement where users upload a CSV file, and I need to validate whether the column headers match a predefined template before parsing it into a CDT. Is there a way in Appian to check headers during file upload, preferably before running readcsvlogtoCDT()?

a!localVariables( local!transaction: index( rule!NW_getTransactionDataFromKongAPI(transactionId: ri!transactionId), 1, {} ), { a!cardLayout( contents: { a!richTextDisplayField( value: { a!richTextItem( text: cons!NW_TXT_QUICK_ACTION_CASE_TYPE_UPDATE_SUITABILITY_STATUS, color: cons!NW_COLOR_WHITE, size: "MEDIUM_PLUS", style: "STRONG" ) } ) }, height: "EXTRA_SHORT", style: cons!NW_COLOR_PRIMARY, marginBelow: "STANDARD" ), a!cardLayout( contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Suitability Status", labelPosition: "ADJACENT", required: true(), placeholder: "------Select Suitability Status from the below List----",

I'm getting this error in my application  I call the interface with the upload field in the forms and at one of the primary buttons i call the function a!submitUploadedFiles().    "at function a!buttonWidget". I cant understand what can i do for this to work. Already checked the version of the buttons and forms. It's all up to date. Can some help me ? 

Hi all,  i'm encountering trouble with my Admin Profile in a Cloud enviroment. Whenever i try to open properties of a node in Process Modeling or in Modifying a Process, i do not see all the related tabs but only the languages tabs.  Here is a screen:  This problem is present only in production enviroment of a single cloud system. In test, dev and production of other client i dont have this problem.  I've checked my profile in Admin Console and try to find difference with other admin profile that works perfect, but i dont seem to find any.  Tryed even to change browser and cancel cookies and chronology but without any success?  Does anyone encountered and knows something about this problem?  tks for reading 'regards

I have a form where we are showing multiple sections which is collapsable. I made couple of sections as collapsed initially thinking that contents would not load until user expand the section. But its not the case, contents are still evaluating even if section is collapsed by default.  I need certain data to be collapsed to improve the initail loading screen and need to do validation on clicking submit even for collapsed one. Section layout is perfectly doing the validation but its loading the contents in the background. Any suggestions or thoughts?

I am creating this post so that if anyone else runs into the below Error on an Interface, when they try to search for it on Google, they will see this & be able to fix it easily. Interface Definition: Expression evaluation error in rule 'applylocalvartestexpression': local!dollarConversion uses a refresh configuration that is not supported in looping functions other than a!forEach(). All other looping functions do not support variables that use the default behavior or configurations other than "refreshAlways". Change the variables refresh configurations using a!refreshVariable(), pass the necessary variables via rule inputs, or use a!forEach() instead. Root Cause: It is generally recommended to replace load()/with() => a!localVariables(), but when this update is made in an Expression Rule and there is an interface (or interface-dependent Expression Rule) referencing it with an apply(), this will break the interface. This is because "a!localVariables does n

Hi together,I have a "map" value in a process. I realized that an IsNull/emptycheck rule I used in a gateway down the line, was failing of evaluating that there was (in my understanding) an empty valuecast( 'type!{http://www.appian.com/ae/types/2009}Boolean', length(a!flatten(ri!value)) = 0 )Even the new rules a!isNullOrEmpty ..... are not recognizing this properly. Does anybody experienced this as well? (not difficult to solve, but it was pretty unexpected) Kind regards, Richard

There are multiple objects in Appian that help us developers to design and build dynamic, fresh, and good-looking interfaces. Sometimes, however, we find the existing components restrictive, preventing us from fully customizing them and building around a specific interface look. This thread, in particular, is about the component BoxLayout, which, after some discussion with our team, has shown a lot of potential to upgrade both functionally and aesthetically. As shown in the screenshot, we have come up with the idea of adding new parameters to the existing component that we think will allow more detail-focused developers to have full access to the colors and style of the component. Also, we think it would be interesting to have full control over the margins that affect the component, in order to build around it more easily. Thanks in advance. Fran.

Hi,  I want to remove the null value keys from the list of the map below. Please let me know how to achieve that:{a!map(ABC: 6.7, EFG: 15.44, HIJ: 470.888, KLM: "9.8989984", OPQ: null), a!map(ABC: 8.4, EFG: 15.43, HIJ: 470.656, KLM: "9.2342", OPQ: null), a!map(ABC: 7.2, EFG: 15.42, HIJ: 470.554, KLM: "9.234234", OPQ: null), a!map(ABC: 5.6, EFG: 15.42, HIJ: 470.234, KLM: "9.63242", OPQ: null), a!map(ABC: "", EFG: 15.42, HIJ: 470.665, KLM: "9.54343", OPQ: null)} Regards, Sowvik

Expression Rule Body: a!localVariables(  local!formatDetails: {{format: "#.#", columnorder: 9, name: "ABC"}, {format: "#.##", columnorder: 11, name: "EFG"}, {format: "#.###", columnorder: 9, name: "HIJ"}, {format: "#.#", columnorder: 11, name: "KLM"}},  local!data: {a!map(ABC: "6.78998", EFG: "15.44443", HIJ: "470.8888", KLM: "9.8989984"), a!map(ABC: "8.44544", EFG: "15.4323", HIJ: "470.656565", KLM: "9.2342"), a!map(ABC: "7.232323", EFG: "15.4234234", HIJ: "470.55445", KLM: "9.234234"), a!map(ABC: "5.64545", EFG: "15.4234234", HIJ: "470.2342", KLM: "9.63242"), a!map(ABC: "453.345345", EFG: "15.4234234", HIJ: "470.665434", KLM: "9.54343")},  a!forEach(    items: local!formatDetails,&nbs

I’m building an interface where the user is asked: "Do you want to use your previous data?" If the user selects Yes and clicks the Continue button, I want the following flow: Show a loading GIF screen immediately). In the background, fetch the user's previous data using a rule and save it to a local variable. Once the data is available, automatically transition to a new screen that displays this data. Problem:If I try to show the GIF and fetch the data in the same saveInto (e.g. within the button click), the interface waits for the data fetch to complete before updating the UI. As a result, the loading GIF doesn't appear immediately — it only flashes briefly or doesn't show at all. I am sure we can easily manage it at process model end. but trying to see if anyone has done it at interface level which i can reuse.