Foundation

I have a doubt that, If two CDT's are created for the same table(TCDT without new column and  previous cdt  with new column) and how can we  write to the db that CDT which is new cdt data and moved from existing table and taking primary key as a output  and writing it to db? I am doing this Bcoz having a issue with the new column added to the table which is required. Thanks in Advance.

Hi, I'm using the WebField element to display videos uploaded to Appian. This works, but there's a problem: it's impossible to move from one point of the video to the other. In other words, clicking on the progress bar of the video does absolutely nothing. Tried using the Advanced Video Player, and the same problem occurs. While testing the example of the documentation, this functionality works, so I don't know if there's something I'm not getting right. https://docs.appian.com/suite/help/22.2/Video_Component.html Maybe this functionality doesn't exist when the videos are from within Appian? My code is: a!videoField( label: "Vídeo", labelPosition: "ABOVE", videos: { a!webVideo( source: document(ri!document, "url") ) } )

Hi, I tried to log in to the Appian designer page but got below the attached page.

Hi all, need some help with the user's configuration. Is it possible enable by defaultthe user's accessibility option? I mean before to create it. Thanks for reading

HI , In my usecase, i have to open the interface form and upload a excel file to load data in editable grid. Then on pressing submit button the flow goes to Process model where doing some business logic inserting that data to db tbl. I am able to display data in form after uploading and reading it from excel the problem is updating rule input cdt which is having blank values as not able to set the values read from excel to ruleinput. . Flow as of now PM--> Interface form--> PM  --> Same Interface form (User to view and edit data if needed the submit)-

Hi everyone, apologise if this question has been asked before as I couldn't find the it anywhere :) I want to update date time value of 2 columns (createdDateTime and updatedDateTime)  in my data table by using Write To Data Store Entity.  I already have a CDT that has primary key matching with my data table. For configuring Write to Data Store smart service node, I want to config this node to update the 2 columns (createdDateTime = pv!createdDateTime  and updatedDateTime = pv!updatedDateTime) where Id (primary key column) = pv!id. How do I achieve that? Thank you! P/s:  I tried Execute Store Procedure smart service but not sure why it updated only 1 column with my input date time, but the other column was not updated, and I couldn't find the reason for that. That's why I tried to change to Write To Data Store Entity to see if this works

Is there anyway can we show all the currently logged in users in the interface

Hi, I have a read-only grid and loading the data using a recordType. I am trying to implement "delete" functionality to delete each row of data/db record by having "Delete" in each row. I am trying to implement by using a Related Actions. But, when I click on "DELETE" it is opening a popup (DIALOG BOX) and closing automatically. Is there a way I can avoid popup window which is not useful in this scenario.  Thanks

I researched and checked theres known issues for a!update so I was hoping that someone may have solutions for this particular scenario.The output for the following code just returns a 4 instead of 4 Current a!update( remove( {1,2,3,4,5,6,7}, remove( enumerate(0,1,2,3), 1 ) ), 1, ri!application.projectYears & " Current" )

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 

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.

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.

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? 

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