Foundation

getting this error while loading data to DB table using import excel to DB smart service (conn=246144) Incorrect date value: '4/24/24' for column `Appian`.`bwauserdobcdt`.`dob` at row 1

Hi Everyone, Can anyone please help me, Is it possible to display image in radio button as shown in screenshot below:

Hello, everyone, I need to create a PDF from a template that requires a dynamic hyperlink. When I tried using a DOC template, the link wasn't generated. When I attempted to use an HTML template, the link was generated, but after converting it to PDF, the link didn't work in the converted PDF. Could you please suggest a way to create a dynamic hyperlink in a PDF?

Hello, We are building a site which will be used to gather request and I'm trying to find if there is a possibility to make bulk upload of these request using excel. The form which need to be submitted contain single rows and also arrays of data. We want all of these bulk uploaded request to stay in "draft" mode and not being push to the backend databases, because that can lead to incorrect information to the database since we have some validations which need to pass. We need to give the client the agility to edit these information when they are loaded as bulk. What are the capabilities of Appian to load bulk data, what are the limitations?  Thank you!

Hi everyone,I have a process with a PDF from HTML task. The problem is that the pdf that is generated only has one page, so only the content that fits on one page is displayed. How can I modify this process to generate multpiple pages? This is the process:

Hello, we have a locally hosted production environment and a cloud development environment. We want to deploy the application from the cloud to the local machine. When we export in dev and import the app to prod environment the database tables are understandably not linked to the record types. However when I connect them and tell Appian where they are (I am running a local MariaDb and connected it to Appian via admin console) they are connected up until I import another version of the application. So on each import I have to go through each record type and add the data source which is the database table. How to solve this? There has to be a better way to do this.

How do we go about inserting a TIFF file into a Word document using ADT? Currently, we're able to insert a TIFF file with a single image into Word without any issues. However, when attempting to insert a TIFF file with two images, we encounter a problem - only one image is inserted successfully while the other is not. What could be causing this issue?"

Hello everyone, I have a field for created date of type varchar(255) and it has the value in string, for example: "20220505101000345600", what I did before was converting it to date before saving it to database with this expression:  concat( mid( index( ri!pulsarMessageValue, "CREATION_TIMESTAMP", null ), 5, 2 ), "/", mid( index( ri!pulsarMessageValue, "CREATION_TIMESTAMP", null ), 7, 2 ), "/", left( index( ri!pulsarMessageValue, "CREATION_TIMESTAMP", null ), 4 ) ), but now I am required to do store it as timestamp so then I can show it in the interface. My question is if is there any way to store it as datetime and then in the interface part I can use the formatted column or I need to convert it in the interface like this:

Hello,  Is there any way to add a dynamically generated dropdown inside of the Appian navigation bar?  For example, I have a database table filled with a value that I would like to 1. Create a dropdown record for each value 2. When selected, open up an interface with that value passed into it as a rule input Thank you,  Nicholas

I have a few dropdowns in my interface, however when selecting the dropdown, choices are being constrained by the UI component they are housed in. This is leading to dropdown options being unable to be selected. How can I have the dropdown choices overflow the UI elements?  (Prod) The strangest thing about this issue is that the dropdowns overflow as expected in my prod org, but doesn't work in either my Dev or QA org. My Prod org is 23.4 vs my Dev and QA orgs being 24.1. Any help would be greatly appreciated! 

Hi All, We have the requirement to retrieve & show the Emails send to the Users in the read only format. In the Email content it contains URL links, tables so i archived the table content with the richTextFieldWithTables function but we need to show the URL link as Link but it is taking it has text. Please find below screenshot In the Preview mode we could see the Table & the associate URL Links but the URL displayed as text instead of Link. So please suggest is there any way to show the URL in link

Hi everyone,  I'm seeing this behaviour which I cannot explain. Could anyone recommend me a solution or reason for this behaviour? I'm having an interface with gridField(), one of the grid column's value is richTextIcon() containing a submitLink() to kick off a process model. Please see below the code to build up my grid column:  a!gridColumn( align: "CENTER", label: "", value: a!localVariables( local!showLink: false, a!richTextDisplayField( value: a!richTextIcon( caption: "Re-open Case", icon: "folder-open", link: a!submitLink( showWhen: local!showLink = false(), saveInto: { a!startProcess( processModel: cons!PRO_PM_REACTIVATE_CASE processParameters: { noteContent: "This case was re-activated", caseId: f

Hi All, Can anyone please help me how to change the color of button using recordaction in interface.

Hi,I am not able to see properties of any node in process models of all applications. I verified all the permissions everything is fine.Here I am attaching snippet for reference.

I'm using record field action as edit supervisor questionary button in the interface. I have a requirement that as soon as someone clicks the record action field, it should update a field in the database as edited by and when submits it, again the same field should be modified to submitted by. How can I achieve this?

Hi.   I am getting an error trying to parse a list of docIds and convert  it to a list of cdts I made.  The cdt are of the form projectMouDocument{mouId(int), docId(int)) I pass in a static mouId and a list of docIds.Heres my script for the output into a process variable that is a list of projectMouDocuments.  I expect to get a list of projectMou documents from this. a!forEach(    pv!documentIds,    cast(  'type!{urn:com:appian:types}DSC01_projectMouDocuments'(), a!map(  docId: pv!mouId,   mouId: tointeger(fv!item)  )   ))Error in script task : An error occurred while evaluating expression: projectMouDocuments:a!forEach(pv!documentIds, cast('type!{urn:com:appian:types}DSC01_projectMouDocuments'(), a!map(docId:pv!mouId, mouId:tointeger(fv!item)))) (Expression evaluation error at function a!forEach: Error in a!forEach() expression during iteration 1: Expression evaluation error at functio

I have a PM with a non start form interface in it that can acquire a list of documents from the user before going on to the next node of the pm. All the inputs are set up correctly (saveinto and the form has its inputs set up),  I have confirmed that the value is saving into ri!documents when testing the interface.   However when it gets to the PM after submitting the user input task, documents is nowhere to be seen.

I have created a read only grid using queried data. Now I want to export it to the excel sheet. Besodes, I am also able to export it to the excel sheet using export data store entity to excel smart service. The issue is I have a column active date in the database table as "date timestamp" but I want it as only "date value" in the sheet. And this should be done automatically when someone clicks export to excel. How can i achieve this formatting?

Hi All,  I have a form like this with multiple steps. For some action, I don't want to display some of the steps. ( For action A, I want to display only the form 2 and for the remaining actions, I want to display all 3)  Now I am storing the label values in a local variable. Can someone help here please on how to have the  conditioning  local!formSteps: { "Upload Document", "Add data", "Add other details ", },  

Use Case Screen-A Have text field and button to send value to Screen-B Screen-B Obtain value from Screen-A and display form based on obtain value. Solution that I tired 1. Record Action: Does not work because can't send value to Process Model 2. Related Action: Does not work because It can send only static value. not a value from Screen-B I search for some forums and there is solution of using starProcessLink but, It is limited to hyperlink. Not work as a button. Maybe I have to create cardLayout to simulate it as a button and use startProcessLink inside? Thanks!

Hi! I need help!!! I want to use  a!aggregationFields  and filter together how can i get it

Hi, Over time, Appian users have been deactivated.  When process models created by these deactivated users are modified by a change to a sub process model, then warnings are sent to deactivated users.  Would like to stop this happening by reassigning the process model to a active user. Regards

Code ------------------------- a!localVariables( local!currencyValue: a!currency( isoCode:"USD", value:-152552.774, format:"SYMBOL", decimalPlaces:2, indicatorAlignment: "START" ), stripwith( local!currencyValue, "$" ) ) Output -------------------------- "(152,552.77)" I need the output as "152,552.77".Can some one help to rectify the code

I got error when deploying a  package, there seems some missing objects, but all uuid, how can I find the objects by uuid

I am looking for a way to activate the Process Model as soon as a user opens the record summary for the first time. Additionally, I want to record the time when the summary was first accessed. Is there any way to achieve this? One possible solution that I thought of is displaying a button to start the process model when the summary interface is launched.