Foundation

Hi,  I'm trying to create an email template for outlook using the following code snippet,  a!safeLink( uri: concat( "mailto://", ri!email, "?subject=", "Random Text", "&cc=", "abc.com", "&Body= Hello", ) ) I have to add the company logo in the signature of the email body, can someone please let me know if this is possible? If so, direct me on how to do implement this.  Thanks in advance. 

 this is the code related to start form  a!localVariables( local!groups,a!formLayout( label: if(ri!readOnly,"Meeting Information","Request New Meeting"), contents: { a!columnsLayout( columns: { a!columnLayout( contents: { if(ri!readOnly, a!textField( label: "Meeting Subject ", labelPosition:"ADJACENT", value: ri!MMS_Meetinginfo.subject, saveInto: ri!MMS_Meetinginfo.subject, readOnly:true ), a!textField( label: "Meeting Subject ", labelPosition:"ABOVE", value: ri!MMS_Meetinginfo.subject, saveInto: ri!MMS_Meetinginfo.subject, required: true, validations: if( len( ri!MMS_Meetinginfo.subject ) > 50, "Value may not be longer than 50 characters. You have entered " & len( ri!MMS_Meetinginfo.subject ) & " characters.", null ) ) ), if( ri!readOnly, a!paragraphField( label: "Meeting Body", labelPosition: "ADJACENT", value: ri!MMS_Meetinginfo.body, saveInto: ri!MMS_Meetinginfo

Hi Everyone, I have a Request dashboard with few filters. This dashboard includes all the active tasks part of the application.I am facing a timeout issue (> 2 secs) when I use the filter for assignees (intermittent). User can select a particular group or an user to filter. I am looking for suggestion on this filter for assignees. To fetch the active tasks we are using a process report that filters all the active tasks with the report context being all the process models within the application.We have around 70 process models and currently active tasks in the Production is around 5600. When it was below 4000 active tasks the filters were working great. Key points:1. The tasks can be assigned to multiple assignees which could be group and/or multiple users.2. On the report I have a column "Task Assignees" which I has: - Definition: =joinarray(task_assignee_owner(),";") - Formatting: Normal Text The "Task Assignees" column was made this way because of mu

local!vehicleBaseLocations: append(local!vehicle,"ALL"), I have written a rule and called that in local!vehicle(i am fetching data from DB). Am calling that in local!vehicleBaseLocations,I need to add ALL option also, I have used append to achieve it but its throwing error "  Could not cast from Text to AB_location. Details: CastInvalidCould not cast from Text to AB_location. Details: CastInvalid  Can someone help what exactly am missing

Let us say I have array of dictionary    {{id:1,name:"Faisal",department:"EEE"},{id:2,name:"Hasan",department:"E&E"}, {id:3,name:"Faridi",department:"E&C"}} and I want  to return id and name only based on department="EEE" How can this be achieved using functions? I have tried the below but not able to get the result and from this query I am able to return only one field. a!localVariables( local!employees:{ {{id:1,name:"Faisal",department:"EEE"},{id:2,name:"Hasan",department:"E&E"}, {id:3,name:"Faridi",department:"E&C"}} }, a!forEach( items: local!employees, expression:if(fv!item.department="EEE",fv!item.name,{}) ))

Is it possible to add attachments to 'mailto://' while generating email popups for Outlook?

Hi Team, I'm having an old grid layout. I'm having a field "Classification", Currently if the data is null its showing as emply(rounded below). Now i want to put a condition, if any of the value is null/emply i should display as "None'" otherwise as it is value existing data              Classification          Insurance          Banking        Null/Empty Expected:        Classification          Insurance          Banking          None Using the following code a!gridTextColumn( label: "Classification", field:local!gridDatasubset.columnConfigs[31].field, data: if( rule!APN_isEmpty(local!gridDatasubset.data.c61), "

In a!richTextDisplayField() , helpTooltip is used as a parameter. When I used it, the tooltip symbol(?) comes above the label. It should be appearing next to the label like it happens helpTooltip is used as a parameter for a!textField(). Can you suggest some way by which I can place the tooltip symbol(?) next to the label.

Hello, In the "user input task" there is an option "Allow users to save a draft of in-progress tasks". I'd like to know if there was a way to launch the save draft by the system, I mean if we can do the save without an user's action (click on the button or do the "ctrl+s" shortcut). We need to be able to have kind of "auto save" of the current form. Do you think that is possible ? Thank you

Provided the getdatasubsetdownloadlinkfromrule plugin is no longer available, do we have any alternatives to export datasubset into excel

I have a component that contains user picker field which is a required field. This component also has a submit button. Something like the code snippet below. { a!pickerFieldUsers( label: "Request Owner", maxSelections: 1, groupFilter: cons!EEP_GRP_ESTIMATORS, value: property(ri!request, "cdo_owner", null), saveInto: ri!request.cdo_owner, required: true, showWhen: ri!request.status_id_fk cons!EEP_VAL_STATUS_COMPLETE ), a!buttonArrayLayout( buttons: { a!buttonWidget( label: " Submit for Review", icon: "arrow-right", saveInto: { a!save( ri!request.status_id_fk, cons!EEP_VAL_STATUS_IN_REVIEW ), rule!EEP_UT_saveAuditData( createdBy: ri!request.created_by, createdOn: ri!request.created_on, lastModifiedOn: ri!request.last_modified_on, lastModifiedBy: ri!request.last_modified_by ), /*Save Audit History Data*/ { a!save( ri!auditHistoryUpdate.estimation_id, ri!estimation.id_pk ), a!save( ri!auditHistoryUpdate.event_timestamp, now() ), a!save( ri!auditHistoryUpdate.initiator_name, lo

i need to append the dictionary in the left pic with the list of text strings mentioned in the right pic. First dictionary should have title:task Name appended after id and 2nd dictionary should have title:Due Date after id. once when first 7 in the dictionary is appended with the values from  list of text strings, the 8the value in dictionary should start to append from 1st again in the right pic. i tried looping using foreach but it never worked. Any help would be appreciated. 

Hi All, Want to open local system path/network path link from APPIAN SAIL form. How to do it? Thanks,

Hi, I need to access process variables in a "record type" object. I need the value of the variables that the active task of the process has in their data inputs. Is this possible? How can I do this? Thank you, Rita Ferreira

Hello, I have a table that contains the document id and some document metadata. I want to display a grid with these data and a link to the document but all documents are not accessible by the logged in user. I want to display only row that refer to a document accessible by the user. I try something like this: if (isnull(todocument(fv!row.docid)), /* do not display */, /display the row */ ) I also test if (todocument(fv!row.docid)="[NO PERMISSION]" but it doesn't work. How can I tests if the user have access to a specific document ? Thanks for your help

Short of creating a constant that contains all valid icons and richTextIcons (which is suboptimal given that icons are updated between Appian versions), is there a way to make icons "invalid icon"-safe?  i.e. Checking if an icon is in the list of supported icons on a given appian version before passing it into icon or richTextIcon? Context We have a (larger, complex) application that dynamically determines which icon to use in a richTextDisplayField. One can be thorough and investigate the root cause of why invalid values are being populated but I would like to be thorough and double-check. Thanks!

Hi, Could you tell me how a filtered RecordType grid (placed inside an interface) can be refreshed please ? My RecordType data are retrieved from the a!recordData() function, and is filtered on the field "deleted" (all rows are visible if delete = "false"). I have a button that calls an Expression Rule to update the underlying table to set the "deleted" field of the selected row to "true". (I use the WriteToDataStoreEntity Smartservice). After the table is updated in database, I have click to click on the "refresh" icon of the RecordType to see that all is working fine : the lines are hidded. How would you refresh the RecordType, without a manual user action please ? (I intentionnaly do not use any process model for this example)

Hi All, I am aware that this error occurs when the time taken to fetch the data exceeds the threshold. We get these errors randomly for multiple expressions which use query entity on different tables/views but not frequently. I am afraid it may become worse when data present in DB increases in terms of rows. Can you please suggest some of the best options to mitigate this risk or avoid these errors, at Appian end, DB end or Server end? Thanks.

Hi team, We are getting below error while trying to open record summary view via record link. Can anyone tell me where the issue could be? Record is expression backed record. We tried testing individual rules and they gave proper output. Expression evaluation error at function a!recordBodyWrapper parameter 2 [line 55]: Invalid symbol found (comma) (APNX-1-4205-003) Let me know if additional information is needed. Thanks, Akshar

Hello community members, can you help me with the syntax for a array of CDT? i tried: 'type!{urn:com:appian:types}EBLE_Test'( {item: 1, checked: true, item: 2, checked: false } )

load( local!carriers: rule!CAS_getPayeesAndCarriers( getOnlyCarriers: true ), a!gridField_19r1( totalCount: ri!processData.totalCount, columns: { a!gridTextColumn( label: "Last Updated", field: "c12", data: a!forEach( items: index(ri!processData.data, "c12", {}), expression: todate(fv!item) ) ), a!gridTextColumn( label: "Assignee", field: "c13", data: a!forEach( items: index(ri!processData.data, "c13", {}), expression: if( isusernametaken(tostring(index(fv!item, 2, null))), rule!CAS_formatUserName(userName: index(fv!item, 2, null)), null ) ) ), a!gridTextColumn( label: "Carrier Policy ID", field: "c6", data: index(ri!processData.data, "c6", {}), links: a!forEach( items: index(ri!processData.data, "c5", {}), expression: a!processTaskLink( task: fv!item ) ) )

Hi, I've created a simple RecordType based on a MySQL table, and when editing the grid list (tab List), I have added a new column that does not exist is the underlying table (ex : "total" that is the sum of fields "nb1" and "nb2").  When using this colum in a Grid of an interface, why does the "Recordtype!Vehicles.Fields.total" is not available ?  Does the Fields object contain only the fields that exist in the underlying table ?

Hi Team, I have a grid Layout which is having couple of fields. But one search field "Classification" is not working as expected. Please find my below code. Code: a!gridLayout( label: "Legal Entity Overview", totalCount: local!entitySize, headercells: { a!gridLayoutHeaderCell( label: "Name" ), a!gridLayoutHeaderCell( label: "Tax Identifier" ), a!gridLayoutHeaderCell( label: "LOB" ), a!gridLayoutHeaderCell( label: "Classification" ), a!gridLayoutHeaderCell( label: "Region" ), a!gridLayoutHeaderCell( label: "Country" ), a!gridLayoutHeaderCell( label: "Reporting Type" ), a!gridLayoutHeaderCell( label: "Client Institution ID" ), a!gridLayoutHeaderCell( label: "Milestone" ), a!gridLayoutHeaderCell( label: "Deadline" ), a!gridLayoutHeaderCell( label: "Completion Date" ), a!gridLayoutHeaderCell( label: "Reportable Status" ) }, columnconfigs: { a!gridLayo

Version : Appian 20.3. I have a process with 2 Event Receivers : "External_Escalaion" & "Escalation". I have a User Input node which escalates, sending  a message to destination called "External_Escalation" (in the same process). I would expect to receive the message only on the "External_Escalation" node, however it triggers the other as well. Any clues ? 

Hi all, I need to filter the data based on dropdown which have a value {"P","NP"} from Date field , if dropdown value is P then i need to filter all not null dates value in grid and if it NP then all null value in date field . is there any way to achieve the requirement, a!queryFilter(field: "dates",operator: "=",value: ri!dates)