Foundation

Hello, does anyone know how I can make a custom picker to save the value if it is not in the list? The code is that: a!pickerFieldCustom( label: "Tipo de entrada", labelPosition: "ABOVE", maxSelections: 1, suggestFunction: rule!ERYM_FiltroComponente( filter:_ , labels: local!tipoEntrada, identifiers: local!tipoEntrada ), selectedLabels: a!forEach( items: ri!expediente.tipoEntrada, expression: index(local!tipoEntrada, wherecontains(fv!item, local!tipoEntrada)) ), value: ri!expediente.tipoEntrada, saveInto:

Please tell me how to send email to multiple recepients using send email smart service

Hello Community Users I am not able to rename the web apis in Appian Designer though it is mentioned in documentation that we can rename web apis?  Any insights, why? Btw, I am able to rename other objects.

I have a read only grid with data sourcing from a record type. One of the columns in the interface has a record link field enabling it to drill down into a record summary. Is there a way we can redirect back to the interface from the record summary view? Ask is to have a cancel button that will take the user back to the read-only interface where the user started.  safe link is not an option.

a!localVariables( local!data: a!localVariables( local!dateList: todate( union( index(ri!taskProductionList, "asDate"), index(ri!taskProductionList, "asDate") ) ), a!forEach( local!dateList, a!localVariables( local!dateData: index( ri!taskProductionList, wherecontains( fv!item, todate( index(ri!taskProductionList, "asDate", {}) ) ), {} ), local!taskProduction: if( and(rule!INO_isBlank(local!dateData)), "-", ( ( todecimal(local!dateData.taskId) / todecimal(local!dateData.taskDuration) ) * 100 ), ), if( rule!INO_isBlank(local!dateData), { taskId: 0, taskProduction: 0, taskName: "-", asDate: "-" }, { asDate: fv!item, taskId: if(rule!INO_isBlank(local!dateData.taskId),0,local!dateData.taskId), taskName: if(rule!INO_isBlank(local!dateData.taskName),0,local!dateData.taskName), taskProduction: local!taskProduction, } ) ) ) ), { a!richTextDisplayField( labelPosition: "COLLAPSED", value: a!richTextItem( text: "Selected

Hi, is there an option for a modal pop-up in Appian? Like when a pop-up will appear and the entire screen will be greyed out except the pop-up and until you select any option in the pop up the screen will remain greyed out. Can anyone let me know if possible then how can it be done?

I have two local variables storing list of numbers: How can I get coordinates from this like 1,1 2,1 3,1 4,1 based on column and row value together?

Hi, Is there any functionality in Appian to show pop-up?? If not, how can we show a pop-up without using interface and button confirmation?? Thanks in advance, Gousii.

Hi Appian folks! I want to add rows dynamically in a pdf file using PDF Doc from Template smart service. I created a CDT with multiple values and mapped that variable to the pdf field. Although it won't create one row for each value. Is it possible to create a new row in a pdf dynamically for every value in CDT using PDF Doc from Template smart service?   

I've looked into a!documentViewerField, a!imageField (with a!documentImage), and a!richTextImage (with a!documentImage) and tried to display the contents of a TIFF file with no success. Does anyone know how to display a TIFF file on an interface? Thanks

Hello Appian Community, Use-case - We have a process containing 8-9 stages(UI Screen), each stage having "Next", "Save" & "Back" buttons. Requirement - Need to capture the time spent by the user on each stage and use this for auditing and generating reports for business owners to understand, how much time users are spending. Approach - Appian provides a process property name "starttime" and we can configure a script task with a custom process variable with "endTime" as the "now()" function. Need Suggestion -  Is there any better OOTB feature to achieve the requirement? What is the value of "starttime"?How to capture "endTime" without configuring an additional script task after each stage? Appreciate your suggestion. 

Hello Community,Is there any way to convert a pdf or word document into base64 string or binary format ? TIA Arun

Hello Team, Is there any way to get the currentloggedInUser site page tab URL Dynamically?. More details about my requirement...Assume that there is a record A, Site A (User1) and Site B (User2). Once User1 navigate from the Site A to the particular record weshould show related action for that User1.If User2 logged in and navigated from the Site B to the same record user shouldn't see any related actions. Is there any way to achieve this functionality without create separate record for site?. Thanks!!

Hi, I'm working on aprocess model to update data form a record type. If after 5 min the user has not submitted the form an exception end the task. The problem with this option is that after the exception there is no way to close the dialog box. Is there any possible solution for that?

Hi, PFB my code snippet. when i click on button my data in the readonly grid is not refreshing. The source is a expression rule which calls an integration to get the data to display in grid. Kindly provide suggestions. a!localVariables( local!currentUser: rule!CORE_GetLoggedInUserName(), local!refreshCounter: 0, local!employees: a!refreshVariable( value: rule!PM_GetCurrentAddresses( tenantId: "77b50320-5f06-5740-84f4-18d4a8cda51d", identifierId: local!currentUser, serviceLocationId: "cac14c53-a058-4824-86dc-f24cea29b948" ), refreshOnVarChange: local!refreshCounter ), { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Refresh", size: "SMALL", style: "SECONDARY", saveInto: a!save(local!refreshCounter, local!refreshCounter + 1) ) } ), a!gridField( labelPosition: "COLLAPSED", data: local!employees, refreshOnVarChange: local!refreshCounter, columns: { a!gridColumn( label: "Address Type", value: fv!row.addressType

What is the difference between functions todatasubset() and a!dataSubset()  ?

When attempting to save a process model, an error message “An unknown error has occurred while saving the process model” appears and the changes to the process model are not saved: Appreciate for the suggestions/solution..

I need simple solution for document to binary conversion within appian. As request body I should be able to pass a document into a binary format while calling a REST API POST method. I've followed below links and those are not helpful for me. https://community.appian.com/discussions/f/general/20675/convert-any-document-to-binary https://community.appian.com/discussions/f/integrations/14913/web-api---send-binary-string-of-document https://community.appian.com/discussions/f/integrations/18923/convert-appian-document-to-base64/75414#75414 https://community.appian.com/discussions/f/general/19821/problems-with-a-binary-document

Hi all, I'm trying to create a generic save process which will take a map list as a parameter that will be converted to different types of record types for a write records MNI node (since I can't do 1 write records for different record types). I want to know if there's a way to iterate through the map and convert it to it's appropriate record type. Better approaches are welcome if you believe this is an anti-pattern. I want to centralise a few a!process saves through this process cause it seems like creating a save process for each screen is overkill.   

Hello everyone! I need to display 5000 rows of editable rows in the grid - it’s about 2mb of data. First thing I have thought of is to fetch data from database with batches - to set a start index and a batch size and pass it to query entity expression, and then provide that result data subset to editable grid with implemented paging option (clicking back and next will trigger an update to a start index as well as a new batch to be fetched from database) And I’m facing a problem finding an approach to update that data in the database after editing on the form when switching pages. Most probable storing 5k items in a local variable along with other data will cause memory issues while manipulating it for example Is there any approach to achieve a desired goal?

Hi all, i want to select a speficic color for this pie chart, for example if the status is "DA RIASSEGNARE" the related colour is orange and so on.  Here is the code, and in attachment the pie chart. Thank in advance.a!localVariables( local!save, local!save2: a!refreshVariable(value: local!save,refreshInterval: 0.5), local!array, local!record2: 'recordType!{2def5f7f-c651-48be-9fce-fe502682f30f}GEC_Dettaglio_Task', a!sectionLayout( label: "", contents: { a!pieChartField( data: a!recordData( recordType: 'recordType!{2def5f7f-c651-48be-9fce-fe502682f30f}GEC_Dettaglio_Task' ), config: a!pieChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2def5f7f-c651-48be-9fce-fe502682f30f}GEC_Dettaglio_Task.fields.{6d87248b-9f66-495a-b736-3e539bcad481}STATO', alias: "vehicleMake_primaryGrouping" ), measures: {

Hi Guys, I am facing dead lock issue while executing Stored procedure Parallelly through Multiple Instances. Error Message : Transaction(Process Id : 1234) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the Transaction. Please post if you have anything related to this issue.

Hello All, I need your guidance and assistance regarding the creation of a cascading dropdown interface that supports an unlimited or variable number of levels. The purpose of the interface is to display data retrieved from a reference database table, where the values of the child level dropdowns are determined by the parentId field in the table. The cascading dropdown interface will be used to present hierarchical data from the reference database table. Each dropdown level represents a different level in the hierarchy, with the child level options being dynamically populated based on the selected value of the parent level. The goal is to enable users to navigate through the hierarchy seamlessly, regardless of the number of levels it comprises. The database table looks like this . ParentId is FK refer to Id field. Id, level parentId 1   l1v1      null 2   l1v2       null 3   l1v3       null 4

I have a DB table with Data. I have transpose the details in front end. Please help me how to do that. Below are the screens shots for reference. In Database table is like below Desired in Appian Interface

Hi,  I have this process model in which there is a complex node. This node I have configured to execute all the outward flows only when it receives exactly 2 inputs ( because at no time will it receive more then 2 inputs ) But then the problem here is that complex gate never ends, its always in green .. and because of this the parent process model does not complete. Is there a way to rectify this ?  The configuration :