Foundation

HI Team, I see sometimes my form is not submitting and moving back to home screen but backend the process is moving furthure?, Is this an environmental issue ? This issue is causing only for few open tasks but not all of them ? Below is the submit button code  a!buttonWidget( label: "Submit", submit: true(), validate: true(), value: true(), saveInto: { a!save(ri!submit,save!value), a!forEach( items: local!data, expression: a!save(ri!II_DT_DocumentClassification, append(ri!II_DT_DocumentClassification,fv!item)) ) }, style: "PRIMARY" )

a!columnsLayout( columns: { a!columnLayout( width: "EXTRA_NARROW", contents: { a!imageField( images: a!documentImage( document: rule!EILM_Datafeed_fetchSystemIcon(systemCode: local!selectedSystemType['recordType!{fcce7d6a-d964-4fb7-bc9c-610a5333f0ee}EILM Inventory Data Feed.fields.{785adc35-6266-4c30-abbe-eca44c05c93d}systemTypeCode']) ), size: "TINY", align: "CENTER" ) } ), a!columnLayout( contents: { a!richTextDisplayField( value: { a!richTextItem( text: { displayvalue( local!selectedSystemType, local!refSystemsData['recordType!{6bfcaf5e-7f37-4e20-a544-b4915d162997}RD Data Feed Systems.fields.{037fb842-a09e-4e3f-836e-85f83c476be1}systemCode'], local!refSystemsData['recordType!{6bfcaf5e-7f37-4e20-a544-b4915d162997}RD Data Feed Systems.fields.{abcb5cb3-86d6-4255-9ce3-f435dc50cb36}systemName'], local!selectedSystemType ) }, color: "STANDARD", size: "LARGE", style: { "STRONG" } ), char(10), a!richTextItem( text: { local!dataFeed

Hi  I have a parent process which is deciding startDateTime and  delayMinutes and then passing this parameter to start process smart node which is delaying the subprocess with this set up: pv!startDateTime + intervalds(0,pv!delayMinutes,0) . However, this should delay the process by calculated time. But it is not delaying it at all.  I want to ask,  How to implement Dynamic delay in timer? Does intervalds does not work with process variables as parameters?

I am executing a process model from an interface on button click using a!startProcess, and saving some of the process variables (lists) on the OnSuccess parameter of a!startProcess into UI variables. The process model has chaining enabled on all connections, both in the parent process and two sub-processes.  Both sub processes run synchronously, and execute at the same time.  In both sub processes, I loop over an integration using a counter variable (not MNI). The issue that I am seeing is that the saves on the OnSuccess parameter of a!startProcess execute before the process is complete, so I either get no results from the process at all, or partial lists.  When I monitor the process, it executes successfully and all the expected values are there. How can I ensure that the entire process executes before the OnSuccess saves execute?   The process typically takes between 1-3 minutes to finish.   Note: The goal of this process is

In my use case, A Customer is linked to multiple Units in a one-to-many relationship. On one interface, I have a customer selection, and based on the selected customer, the corresponding units are displayed in a dropdown labeled "Unit." This is achieved using an expression rule within a refresh variable. Additionally, there's an option for the user to add a unit on the same page for the selected customer. For this, I'm using a Record action, where a pop-up window opens for data entry. Once the user submits the data, the unit list in the dropdown is refreshed to include the newly added unit. This is done using the "refresh after record action" feature. While this functionality works as expected in the browser, it does not work on the Appian mobile application. Any suggestions?Here is the Code Snippet local!units: a!refreshVariable( value: rule!FAA_QR_get_Unit( customerTpi: ri!assetRecord['recordType!{20d559ec-3d4b-4870-9672-f594295b09f7}FFA Asset.fields.

Dear community, Modal popup windows are a very frequently asked UI element Appian does not provide OOTB. The purpose of a popup is to make any UI element fade into the background and provide an isolated area to require a specific input from the user. In Appian, we cannot implement this visual style directly, but we can achieve a very similar behavior. Instead, we hide all UI elements and display a single centered card layout. This card contains all the necessary elements. When a user clicks a button, the popup is closed, and the rest of the UI becomes visible again. Read my blog post for more details. https://appian.rocks/2023/06/20/popup-windows-in-appian/ Cheers, Stefan.

why there is no user context in an expression in a node output

I would like to force logout a user without user interaction. I know that Appian has Session timeout, but I would like to logout a user on a specific workflow (after 30 sec) without disturbing Appian default session timeout settings.

I have a form where user can upload document, I can see the documentId and the document name in localvariable in the form, but when I try to resolve the document content, like using excelreadcellsbynumber. But it feels like the document content is not available, does it mean the document is actually not uploaded at the moment. Since this form is a startform of process A, I try to use startProcess in this form to initiate another process B, but it seems the document is not available in process B as well. Can anyone explain if there is a rule that document content will only be available after submit this form

i have this {a!map(memberId: "test ui "), a!map(holdReason: "test ui "), a!map(description: "test ui "), a!map(summary: "test ui ")} wants an out put like a!map( memberId: "test ui ", holdReason: "test ui ", description: "test ui ", summary: "test ui " )is this possible ??

We deal with sensitive documents and for the sake of security, we are looking for a way to upload docs directly from Appian UI to S3 instead of temporarily saving it in Appian folder and deleting it later. 

I have this statement as the SQL statement on a Query Database node:UPDATE `ThisTable` SET `Status`= ac!closedStatus WHERE `TableId` in (ac!ListOfTableIds) ac!closedStatus is an Int, ac!ListOfTableIds is a list of ints. When I run the process, the Query Database node errors with this error: There was a problem executing the SQL query. SQL Message : class [Ljava.lang.Long; cannot be cast to class java.lang.Long ([Ljava.lang.Long; and java.lang.Long are in module java.base of loader 'bootstrap') I know I've gotten "IN" working on query database before, I just always forget the trick. Does anyone know it?

Hi , I have a scenario , where if a request is rejected by a user , the same request cannot be delete by the same user who rejected it . a!buttonWidget( label: "Delete", icon: "times", value: cons!Deleted[2] saveInto: {ri!buttonAction} style: "DESTRUCTIVE" showwhen: and( ri!readonly = false, loggedinuser() = ri!maker ---- this is just a rule input with type text a!isNotnullorempty(ri!rejectedby) ), disabled: if( ri!rejectedby = loggedinuser(), true, false ), validate:false Can anyone please help me with it . Thank you in advance.

Hello everyone, I’m working with an interface grid that is prepopulated with different documents. There's also an "Add New" button that allows users to upload additional documents to the grid. Requirement: Users should be able to upload new documents. They should also have the ability to replace the prepopulated documents with new ones if they find an issue. When a document is re-uploaded (i.e., replaced), the old document should be replaced with new one, and not saved. Essentially, we want to fully replace the old document with the new one. I’ve read in previous posts that the target attribute on the a!fileUploadField component, when set to a folder, creates a new document in that folder. If set to a document, it’s supposed to replace the existing document by creating a new version. However, I’m encountering issues with this approach. Here’s the code I’m using: a!fileUploadField( target: if(

The excel sheet contains some blank rows to divide the sections which I can't change, how can I skip these blank rows when reading from excel sheet. I see this readexcelsheet() function in other post seems it can decide which row to start, is it deprecated?

we are using chartcolumn in our application. Can we increase the X axis and Y axis labels. currently appian provide XAxis Style, YAxis style options are "NONE" and "STANDARD". please let me know if we can make these labels bold and italic/underlined. Thanks

Hi, I am trying to call a process from parent process model but the start form in child process does not open and flow just pass through it. I tried with activity chaining or used subprocess but nothing worked. One way i know to change the process start form to task based form but wanted to check if there is any other way without it? Parent PM: Child PM:

I keep getting this issue, at first I was able to resolve it by going on the missing precedents page and granting all missing precedents but now there isnt anything missing. 

Hi all, We're running out of disk space on our cloud environment. Appian Support has identified that the main culprits are our Knowledge Centers. They can't however identify which specific Knowledge Centers are the largest. We have over a hundred though so it may just be an accumulation of them all. But anyway, I need to find all their individual sizes and am hoping someone knows how to do this without manually checking each Knowledge Center's properties? An option I'm trying is:  a!localVariables( local!knowledgeCenter: cons!ABC_KNOWLEDGE_CENTER_PROPERTIES, a!forEach( items: local!knowledgeCenter, expression: { creator: knowledgecenter(fv!item, "creator"), dateCreated: knowledgecenter(fv!item, "dateCreated"), description: knowledgecenter(fv!item, "description"), id: knowledgecenter(fv!item, "id"), name: knowledgecenter(fv!item, "name"), numberOfDocuments: knowledgecenter(fv!item, "numberOfDocuments"), size

we have column wise grid users wants it in row wise grid how can we implement 

when I click on the red triangle error, it reads the following: Syntax error Details: Expression evaluation error at functiona!isNullOrEmpty parameter 1 [line3]: Invalid index operator 'hash' (expecting comma).

Hello, I need to add text to a PDF file and save it to a rule input or local variable. Is this possible in Appian? Any suggestions would be appreciated. The a!documentViewer() function allows adding text, but it doesn't save to a local variable or rule input. There's also a pdfAnnotations() plugin that lets you add text, but it requires creating an Adobe project and specifying a domain, which doesn't accept HTTPS. Assistance on this matter would be helpful. I am attaching a screenshot of the Adobe domain issue. Thank you in Advance. Hari Lakkam.

Hello All, I need to create a Scheduler which marks all the existing records under in table against column Is_observed = 1 at the end of each year starting December 31, 2024. Is this good to go?

I'm looking for some best ideas to support read only access to prod. I'm leaning towards create dev/qa as basic user and add to designers group and view only application specific groups then remove designers from DB Editors which allows dev to access both DB and designer in read only mode. Any drawbacks or any articles/ ideas to do it in different way? Appreciate your time! Thanks

Hi All,  I have a grid(using record data) that its making my interface take about 10-15 seconds to load- it has 32 columns and the data is very big. Any suggestions to improve performance ? thanks in advance