-
Recently active
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
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(
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:
Is there a way to get some output back to the interface after executing a!startProcessLink(), or a way to update some variable inside the interface to insure process has been executed
a!buttonWidget( label: "SUBMIT", submit: true, style: "PRIMARY", loadingIndicator: true(), showWhen: local!activeStep = length(local!steps), confirmMessage: "Do you want to continue and submit data?", confirmButtonLabel: "SUBMIT", cancelButtonLabel: "CANCEL" ), Hi All, I have a form for the user to add some required/ optional fields, right now my confirmation message in the submit button shows before it validates the required fields. So it shows confirmation message, and then shows the red field validations- instead I would like to see those validations immediately once I click the first submit, instead of after the confirmation message. Is there a way to show the confirmation message after the button itself has validated that all required fields are filled in the form? or show confirmation only when all required fields are filled in
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
