Foundation

Hi All I am exporting data into excel template from database table. In table there is one column having decimal value. But when exported to excel template the decimal values are truncated. Can anyone please help me out?

Hi, I need help, well I need to make an evaluation from a process some data of a constant, this constant contains two decimal data. I have something like this With( Pv!httpCall=200, Pv!evaluate<cons!DATA_TO_EVAL ) Assuming that my constant DATA_TO_EVAL, currently has only one data, I need to put two data in it, Before I put two data to that constant, (originally it had 100, now in an array that constant has 100 and 50) How can I do that evaluation from my process parameters as expression I have tried doing an if If( cons!DATA_TO_EVAL,100," IS HIGHER" ) But I don't get what I need, I don't know if I made myself clear, thank you very much...

Hi All,  How do we calculate node completion time.  Thanks in Advance!  Regards, VK

Can I edit a form up to 5 minutes after click on submit,

Hi all, Actually, by using Dynamic DOCX Template I am generating a PDF. Now I want that PDF ID to save in a process model. I tried by creating a process variable of type number integer and tried saving the generated document from the plugin into the process variable and didn't work out!! Can someone suggest me how can I achieve this. Thanks In Advance.

Hi, I have a plain Interface where there is a recordLink to the summary view of a Record Type.In preview mode the Interface works well: the link succeeds in opening iebr.appian.community/.../ [...]But when the Interface is launched as a starting module of a Process Model the link doesn't work anymore and returns a 403 message (Access Denied). In this case, it tries to open iebr.appian.community/.../ [...].My authorization levels seem ok.Where could be the problem? Many thanks

Hi I have a use case where I should navigate from my interface to another application and should  create an object and after saving the changes, once it is saved it should again redirect back to interface

Hi Guys, Can you please share the details how to get all object type and Description for my Application. I have tried with getcontentdetailsbyuuid and get the attributes of the objects with type. But not description. Kindly help on this. Thanks, Pradeep Sridharan

I want to implement a scenario where a User Input Task is getting assigned to a configured user in loop which is getting executed based on some real time data, please see the screenshot below to understand the scenario better. The issue here is when 2nd time I'm reaching out to Approval Task I'm not able to open the interface it says "The Task Could Not Be Submitted The task has already been submitted." Please see below Neither I'm getting any notification email for this Task.  Can someone please suggest what am I doing wrong here, or if there is anything wrong with this implementation.

I have a scenario where the user uploads one or many tiff files, and then wants to see them displayed in a gridlayout. I had already built out the process before realizing that imageField does not support Tiff. I have seen a plugin that converts tiff to pdf, but this doesn't help as I don't think there is a way to display a pdf in a gridlayout (please correct me if I am wrong!). Any suggestions would be greatly appreciated.

reject() function giving error when all the items in the list are null Example: reject(fn!isnull, {null(), null(), null()}) --> error Is this expected or it is a bug?

Scenario: User wants to bulk edit rows of data which have been stored in MariaDB. User is presented with data (ranging upto 150 rows) in an editable grid. The first column in the editable grid is a picker field whose suggestFunction calls an external REST API. When the user loads the page (clicks "edit" record), will the REST API be invoked per row of the editable grid?

Hi, I'm in an interface A, and I'm calling a process from a!startProcess.Inside the process I have an Input task to display interface B. Could you explain me why when I call the process, it works fine but the Interface B is never displayed ? (all the nodes are linked with chaining)

i am getting this error: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error in rule 'sm_stockdetailschart' at function a!richTextItem [line 89]: Invalid index: Cannot index property 'turnover' of type String into type List of Variant how to resolve this ?

Following code worked fine up until 23.2:xpathsnippet(local!xml, "//fs:PartyRoleCollection/fs:PartyRole[1]/fs:Party/fs:PartyReference/text()") Now we receive an error: "Namespace with prefix 'fs' has not been declared." Anyone else experience this?

a!localVariables( local!pressedButton: "cancel", local!getdata: rule!getRequestByID(ri!id), { a!sectionLayout( contents: { a!boxLayout( label: "Approval Form", labelSize: "MEDIUM_PLUS", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Comments", labelPosition: "JUSTIFIED", value: local!getdata[1].requestorComments, saveInto: local!getdata[1].requestorComments, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ), a!dateField( label: "Start Date", labelPosition: "JUSTIFIED", value: local!getdata[1].startDate, saveInto: loca

Hi, Any idea how to design a button with a style like below in Appian. Thanks.

Hi all, How to compare two lists in appain {1,2,3} and {4,7,6} IF the Comparision true then it will write true otherwise false. Please help me

I have a Site say "ABC". In that site, i have configured a record which has multiple tabs: summary, cases, audit etc.  My Requirement is, whenever i click on a tab, the name at the browser tab should show that. For eg, If i click on Summary, the browser tab should show summary. I have attached a screenshot for reference. I checked, it could be achieved by configuring dynamic display name in the Sites, but I don't know how to achieve that. Is there any code snippet or example for display name using expresssions in SITE. Thanks in advance

I am looking for ways besides cards to initiate startProcessLink from a UI. Initially I was trying to replicate the look of Card Record Actions, but when I use a card layout I run into issues on mobile or smaller screens where the card becomes hard to read, or a scroll bar appears. Card choice field does not support links. Or is there a way to remove the scrollbar from cards?

Hi! I'm trying to save values from a multiple dropdown into a rule input, but my code it's not working. I proved a!forEach in my submit button, but when i press the button only save the last item of my array.   a!localVariables( local!categoria: cast( 'type!{urn:com:appian:types:FDC}FDC_CATEGORIA?list', rule!FDC_ER_getAllCategoria()), local!organismo:rule!FDC_ER_getOrganismoByCategoriaId(id: ri!categoria), local!guardarOrganismo:local!organismo, /*local!prueba:ri!cartaOrganismo.idOrganismo,*/ a!sectionLayout( label: "Section", contents: { a!sideBySideLayout( items: { a!sideBySideItem( item: a!dropdownField( label: "CategorÃ%ADa", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!categoria.coNombre, choiceValues: local!categoria.idCategoria, value:ri!categoria, saveInt

Hi, my trouble here is that I don't know how can I save true or false in differents boolean columns in my database. I tried something like that: a!checkboxField( label: "", labelPosition: "ABOVE", choiceLabels: { "Limpieza","Plaga","Manipulador" }, choiceValues: { "Limpieza","Plaga","Manipulador" }, value: {if(isnull(fv!item.inLimpieza),{},"Limpieza"),if(isnull(fv!item.inPlaga),{},"Plaga"),if(isnull(fv!item.inManipulacion),{},"Manipulador")}, saveInto:{ a!save( fv!item.inLimpieza, if(contains( save!value, "Limpieza" ), true,false) ), a!save( fv!item.inPlaga, if(contains( save!value, "Plaga" ), true, false) ), a!save( fv!item.inManipulacion, if(contains( save!value, "Manipulador" ),

a!localVariables( local!fieldName:"5", local!operator:">", local!value:"2", a!textField( value: fv!item.fieldName, saveInto: fv!item.fieldName, validations: { a!validationMessage( message:"test", showWhen: local!fieldName & local!operator & local!value ) } ) )This is an example of what I want to achieve, the operators can be different, the fieldValues & fieldName can be of the other fields. I want the showWhen condition to work even if I give it a string.

If we have an icon on our interface, ("clickable icon") ---->  configured with a start process i.e. when we click on it, a report opens and shows on a new tab, is there a way to show that report in a pop up and not in a new tab? Icon image attached fyr:

In my application there is vendor who comment when submitting a form and when it comes towards reviewer the reviewer comment again.So I want to show it as history what vendor commented and what reviewer commented.