General

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. 

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 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

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

I would like to be able to select entities on case creation that can be associated with my case, but it appears that I do not have access to the interface that facilitates associating entities that is outlined in the CMS Guidance document: see attachment/cfs-file/__key/communityserver-discussions-components-files/11/Case-Management-Studio-_2D00_-Common-Customization-and-Configuration-Guidance-24.3.pdf (Page 17, Step 2 of the section "Associate entities on case creation".) Is there anything users can do to gain access to this document, or is it possible to perhaps implement this interface yourself? Does this interface support selection of multiple entities for association with a case, and if not, could I potentially extend it to allow this functionality?

Once a case type data field has been created in the Studio, what is the right way to go about deleting these fields? It seems like the option to delete these fields is not available in Studio, and ideally I would like both developers and end users to be able to delete case type data fields that have been created. Is the only way to do this to delete fields in the record type itself, and if so, would doing this break the functionality of Case Management Studio in some way?

a!localVariables( local!actualData: {a!map(standardFieldId: 277, categoryId: 350, ticketTypeId: 439, providerTypeLookupRefId: 42, assignee: fn!touser("egbeyong@test.com"), slaId: 379, priorityLookupRefId: 30, statusLookupRefId: 39, subStatusLookupRefId: 49, description: "Description Auto fill", submitterLookupRefId: 8, dueDate: fn!date(2024, 9, 25), isActive: true, createdBy: fn!touser("test.test@test.com"), createdDt: fn!datetime(2024, 9, 25, 10, 26, 55, 0), updatedBy: fn!touser("test.test@test.com"), updatedDt: fn!datetime(2024, 9, 25, 10, 27, 2, 0), ticketTypeName: "Provider Data Edit", derivedTicketId: "PRVDATAEDIT-277", dueDateSpecial: fn!date(2024, 9, 25), daysLeft: -5)}, local!data: {a!map(escalationFieldId: 14069, escalationPathwayId: 387, isRequired: true, visibilityStatusLookupRefId: fn!tointeger(null), autofillSourceFieldName: "description", autofillDestFieldName: "code", bigQueryRule: fn!tointeger(null), automationTypeLookupId: 40, isVisible: true, isActive:

I have the following: rule!ADC_DicionarioBanners { { id: 5, urlImagemMobile: "https://asset.gecdesigns.com/img/wallpapers/beautiful-fantasy-wallpaper-ultra-hd-wallpaper-4k-sr10012418-1706506236698-cover.webp", urlImagemTablet: "https://asset.gecdesigns.com/img/wallpapers/beautiful-fantasy-wallpaper-ultra-hd-wallpaper-4k-sr10012418-1706506236698-cover.webp", urlImagemDesktop: "https://asset.gecdesigns.com/img/wallpapers/beautiful-fantasy-wallpaper-ultra-hd-wallpaper-4k-sr10012418-1706506236698-cover.webp", }, { id: 6, urlImagemMobile: "https://wallpapercrafter.com/sizes/1366x768/108198-purple-nature-colorful-trees-forest-smoke-mist-artwork.jpg", urlImagemTablet: "https://wallpapercrafter.com/sizes/1366x768/108198-purple-nature-colorful-trees-forest-smoke-mist-artwork.jpg", urlImagemDesktop: "https://wallpapercrafter.com/sizes/1366x768/108198-purple-nature-colorful-trees-forest-smoke-mist-artwork.jpg", }, } interface rule: a!localVariables(

is there any way to cast from record type to map for me it  didn't worked cast( type!Map,{'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field'('recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{f5fe89e3-be39-448f-b18d-61ab47caa97b}escalationFieldId': 14069, 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{cbe43a10-86dc-41f2-a4f9-4beea7e8fc4a}escalationPathwayId': 387, 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{3437a64f-dac3-407a-a089-7e9d64dca973}isRequired': true, 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{571d49da-e656-4d6e-b6d3-bcfe8392f1b1}visibilityStatusLookupRefId': fn!tointeger(null), 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{166243bd-ab58-4b6c-a50f-613b8c6e48c9}autofillSourceFieldName': "description", 'recordT

Hello all, want to compare all constants from one environment to other environment, we have more than 15K constants and want to add in one package, is there any way to add all constants in one package?  Thanks, Bhushan J

Hello, I am an APPIAN newbie and during my day to day activities get to query the backend data. Sometimes the app's request table in the SQL database shows a task assigned to a group and is displayed as follows: [Group:442658].Question is: how can I track the actual Group by this number, and lookup its name and members? What is this number, is it a UID? What permissions I need to have to query this information in the APPIAN designer? Thanks in advance.

Hi All, Currently I have an interface where we allow the user to upload documents, we wanted to see if it was possible after the user clicks upload they can see the actual document before the submit the form, that way they "make sure" it is the correct document. Is this possible in appian at all? thanks in advance

Hi Team , I am getting this error in the grid field Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 173]: A grid component [label="Search results"] has an invalid value for "columns". A grid column [label="Relationship Manager"] has encountered an error. Expression evaluation error at function 'like' [line 229]: A null parameter has been passed as parameter 1.

I have an interface with a link(Open URL ex. https://) that opens a new tab/window. The new tab/window initiates a process, and I would like this window to close automatically once the process is completed. Is there a way to achieve this in Appian? Any guidance or code examples would be appreciated.

I’m using a webContentField in Appian to embed a webpage, but it doesn’t allow me to access the device camera. Is there a workaround or a different component I should be using to enable camera access within the Appian interface?

Hi all, I am Importing an excel file to database. It has two tables Deals and Loans. Deals to Loans have one to many relationship and deal id should be stored in loans table for the related loans. When I am uploading the file I am first storing the excel data in Datastore. And from data store I am saving the related data in the tables. while saving the loans the related deal Id is not storing properly. Loans data is being saved from datastore itself. We are applying index for deals table and then storing the related deal ID in loans. For example I have 10 deals of data in excel the first deal has one loan and the second deal has 3 loans and the third deal has one loan. For the first loan the dealId storing is 1 and for the next 3 loans the deal id is storing as 2 but for the 5th loan which belongs to 3rd deal the deal Id is storing as 5 instead of 3 in loans table.

Hi All , Two days ago, one of our DEV environment went down. Upon checking the server status, we found that all services were stopped. We restarted the server, and it's been working fine since then. However, I'm keen to understand the root cause of the issue. I checked the Tomcat logs but couldn't find any relevant information. Could you please suggest how I can identify the cause of this? which log should i see ? Thanks in Advance

How Can I fetch the List of value as a text string from the given List

Hi all, I have a requirement of importing the excel file to database. When the user upload an excel file in import it should create new data in 3 different tables. For example, in the excel file the data present is based on deals and each deal can have one or more number of loans and the deal will be having some amount values. So when the user upload a file it should update deals table, loans table an other table which contains of amount data of the deal. Thank you.

When we deploy a document from a lower environment to a higher environment, its ID is getting changed. Due to this, constant points to invalid/wrong a document.  We are using direct deployment (Compare & Deploy) Is it expected behavior?

We are using AppDynamics for monitoring, post upgrade to 24.2 version from 23.2  we see below error in tomcat logs and we see 404 error when we try opening the processmodel. 2024-09-24 14:11:47 SEVERE [main] org.apache.catalina.core.StandardContext.loadOnStartup Servlet [action] in web application [/suite] threw load() exception java.lang.VerifyError: Inconsistent stackmap frames at branch target 56Exception Details: Location: com/appiancorp/common/struts/DelegateActionServlet.<init>()V @56: putfield Reason: Type 'com/appiancorp/common/struts/AppianWebMvcActionServlet' (current frame, stack[1]) is not assignable to 'javax/servlet/http/HttpServlet' (stack map, stack[1]) Current Frame: bci: @46 flags: { } locals: { 'com/appiancorp/common/struts/DelegateActionServlet' } stack: { 'com/appiancorp/common/struts/DelegateActionServlet', 'com/appiancorp/common/struts/AppianWebMvcActionServlet' } Stackmap Frame: bci: @56 flags: { } locals: { &#