Discussion Categories

can we save xls file which we are getting from fileupload interface component to our local PC drive? can we do it without any process model ? if process model is required then how we can do it?

Hi, I have a "DELETE" button in an interface where I have a readonly grid and the grid is loading the data using a RecordType. Now, when the user selects multiple rows of data, I am calling "deleteFromDataStoreEntitites" and passing required parameters and in the background data is getting deleted. But, the issue, the deleted row data is still showing in the readonly grid. Is there any way, I can do page reload or grid load to call after "Delete" button click.

I have my own data or CDT called "Clients" and i have a relationship with other CDT called "Vendor" I have this editable grid created with the CDT called "Clients" (red square image bellow) this works great. Now i want add the related data or relationship of the CDT called "Vendor" (blue square image bellow) into the editable grid  Its possible? How do I call that data?, what expression should I use? Here is my relationships between my data 

Is there a way to sort a record dataset after it's been queried? I have a list of records I got from a queryRecordType stored in a local variable that I am using in multiple places on an interface. I only want the record dataset to be sorted in a particular way for only one instance on the interface, but I want to leave it alone in all other instances, so I don't want to sort the data set within the initial queryRecordType call in the local variable. The only solution I've thought of is query the record again but this time sort it the way I want and store it in a new local variable or write my own expression rule to be able to sort records. I am not allowed to install plug-ins on my environment by the way. Thanks!

Team, We have  HTML output and we want to convert that output to pdf for showing the same in UI via document viewer component. Any idea how to ? Please Note: i have html output not html document.

Hi, I am trying to populate the data in a read only grid using Record Type. I have enabled Search, Refresh and export to excel options. Not, I am try to implement DELETE record List Action where user will select multiple check boxes on the grid and click on "DELETE". Is there any option to move and align the "DELETE" beside to Filter or refresh icons.

Hii Experts, please tell me how to validate the IMSI number and IMEI number and INTERNATIONAL Number? Thanks

Hi,  I want to upload multiple files to each item in an editable grid. I am using a link to add documents outside of the grid. When I submit the form for adding documents, I want to associate the documents with relevant item. I am using rule inputs of request _tems and request_item_documents CDTs. Because the requestitemId is null, I am not able to fetch the documents for the relevant request item.  How do I resolve this? Thanks in advance.  a!localVariables( local!hardwareClassList: rule!AMF_QR_getHardwareClassifications(), local!currentUser: loggedInUser(), local!selectedId, { a!gridLayout( label: "", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "PDM Number", align: "CENTER"), a!gridLayoutHeaderCell(label: "Serial Number", align: "CENTER"), a!gridLayoutHeaderCell( label: "Part Description", align: "CENTER" ), a!gridLayoutHeaderCell(label: "Revision",

Hi All, Please see the below screenshot on PM user input task node I have enabled the option Execution Options --> When this node is chained:---> Allow users to step back to this node from the next chained activity. But on the last user input task form go back button not showing, Please suggest where I'm lacking

Hi When I use a text field, by default it occupies the entire width of the page horizontally. But it looks bad in the interface. Is there a way other than wrapping it in a column / sidebyside layout to reduce the size of the text field ??

Hi All,           I have a requirement that to display  gallery of  images that needs to be automatically scrolled  . Is there any possibilities for this requirement?          

Hi Team I need help Right now if you see in the image I want a selection disabled condition in editable grid like if the status of the particular grid is "Completed", then  the selectable checkbox should be disabled for the Particular row

Hi! Thank you for your help!Context:I have 1 site in appian, it has 3 pages. 1 Landing page : Interface 2 Page 1 : Process Model With Sail Form 3 Page 2 : Process Model With Sail Form Problem: I need to hide from the pages bar, the pages 1 and 2 when the user is in the landing, and the other way, hide landing page when the user is in page 1 or 2.I´ve managed to implement this using a field in a database called : is_home.And checking the status with executestoredprocedure() from the database.So, the thing is, the bar does not refresh until i reload the page, pressing F5, or pressing in the Home Page icon again.This leads to an error everytime i press the button in the interface that should not be visible. Once in a while, the site refreshes and the bar does work properly. Same occurs with Dynamic Site>Pages Names.

How can we make the File upload component as dynamic ? I have a rule input which has the type has a record type , so i cant select the multiple array option it it. The document id should be stored in the DB and the files should be saved in a Target folder.

Do we have any Html decode function other than stripHtml? or any regex function to use ? Example of My current String which I get from Portal and it will be saved in DB as "I’m Appian resource.  Any other existing–resource?" If I use striphtml("I’m Appian resource.  Any other existing–resource?") I am getting same output -> "I’m Appian resource.  Any other existing–resource?" If I use reduce( fn!substitute, striphtml(ri!displayName), merge({ "’", "–" }, { "'", "-" }) ) Then I will get proper result -> "I'm Appian resource.  Any other existing-resource?" But I can't predict only 2 html entity names. There are many, that I need to convert and display in a!paragraph field.

Hi, I need to store multiple records in a single table of the database. Is this possible using "Write to Data Store Entity" or do I need to use "Write to Multiple Data Store Entity". Thanks

i have a process i d which is getting stored in the Db and getting data using exprule and displaying the data in the readonly grid. now my question is  i have one grid column which is have icon on click on it should trigger the process instance of the particular record how can i achive it ?

I have a flow in process model where each and every subprocess of export to sql runs in sequence(synchronus also) following activity chaining . Once flow is done(when it is success and taking fv!processinfo as a reference) i will show a link to dowload  document which has data generated from sql .But, strangely i am seeing that without completiion of process model in backend that document link is enabled for users where some data is missing beacuse of that. What makes that document download option is enabling though process model is still running in backend? What makes onsuccess parameter of a!startprocess is not working though i am saving fv!processinfo to  know when to enable that dowload option? Can someone pls help on this? 

i developed a smart service in appian  iam facing a issue while adding external jars getting classNotFoundException while using the plugin in appian even i simply copy paste the required external jars in META-INF/lib folder after convert into jar and deploying the jar in onpremise server while running the plugin classNotFoundException we got for creating a WorkBook 2023-02-09 13:08:47,874 [ThreadPoolTaskExecutor-9383] ERROR com.appiancorp.process.workpoller.WorkItemListener - The following exception occurred while attempting to complete work item [[WorkId: 45, EngineId: execution00, Request: UnattendedJavaActivityRequest:1154462 as M0223 by M0223, ProcessId: 14617, ProcessModelId: 726, Response: null]] - Exception: javax.resource.spi.work.WorkCompletedException: java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTWorkbook at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:247) at java.util

Dear All, In my earlier project I was using Appian On-premise and Oracle RBDMS, and in current project am using Appian cloud and Maria DB. Am not understanding one scenario, which worked in earlier project and not working in current project. Can some one help me understand this ? Scenario: > There is DB table "Employee" created in DEV & QA. > There is an existing Datastore "DS_TA BLE" in both DEV & QA. > Created a CDT "employee_test" in DEV (From existing Table) and the Data store Entity is mapped and verified automatically. > When I deploy this CDT to QA, Why the Datastore Entity mapping is not happening automatically ?

I have following code in my expression rule, its giving the data correctly but when i apply sorting it is working fine for all the other fields but for the fields: "Headlines" and "ArticlePostDate" it shows empty data, doesn't return any data. These two are the fields that are not part of the main table and i am referencing it from another table that could be the cause that its not showing any data when I apply sorting in them. Can anyone please help what to do in this scenario. Thanks a!localVariables( local!sortField_txt: rule!EF_PlantDashboard_NewsPagingMapping( sortField_txt: ri!pagingInfo_pi.sort.field ), local!oDataQuery_txt: concat( "/Internal/Editable/ABC?editable=true&includeDeleted=true&$expand=Article($select=ArticlePostDate,Headline)&$filter=Key+eq+", ri!Key, "&$count=true&$top=", cons!EF_PLANTDASHBOARD_NEWS_PAGESIZE, "&$skip=", ri!pagingInfo_pi.startIndex - 1, "&$orderby=", local!sortField_txt, if(

Hi team, We are on Appian 22.4 cloud. We have two interfaces, both built using headerContentLayout. First UI has background color set as Dark Blue and is a landing page. It is also configured as a start form in a process model. Second interface has a background color set as a light blue. This interface loads when start form (interface 1) is submitted. And Interface 1 and Interface 2 are activity chained. Now when I submit the interface 1, the second interface carries the background color of interface 1. So, interface 2 shows Dark Blue as a background color instead of light blue. Is this an expected behavior? Thanks, Akshar

How to do mathematical calculations based on the received value. Example : «${d.cost.price}» * «${f.quantity}» how to product of these two values and what is format to use to get the final result of this product. even for addition. Please suggest .Thanks in advance.

Here is the Screenshot of warning which i'm facing in the Execution Log. Earlier, it was working fine, but after the update of Google Chrome, this happened.

Hi, My data resides in Neo4j graph database. I need to connect to Appian and build a relational DB based on this graph data model. Is there a direct connectivity possible to achieve this? I'm looking for a direct integration from neo4j to Appian in the form of connectors or ETL tool or API's. Please let me know. Any help appreciated. Thanks, Sonia