-
Recently active
Hi Team, I need solution for this requirement, please help me on this. We are generating the QR code and attaching to the document and sending to document to external system people through mail. Requirement is like once the external system people open the document and scan the QR code, need to redirect to Appian portal and open the document. Thanks in advance.
I have a grid layout consist of dropdown, If I select a value on the first drop down then if I add new row it will show new drop down on the second drop down I need to hide the value that is selected on the first drop down. Here is my initial code. I just created it but the problem is in choiceLabel it's showing id. The requirements is to show the column "name". I try indexing it but it show an error. a!localVariables( local!service: rule!IBM_GetServiceByFilter( extractData: true, fetchAll: true, status: {cons!IBM_SERVICE_STATUS_PENDING_APPROVAL,cons!IBM_SERVICE_STATUS_ACTIVE} ), local!user: user(loggedInUser(), "firstName") & " " & user(loggedInUser(), "lastName"), local!now: now(), { a!gridLayout( labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "List of services"), a!gridLayoutHeaderCell(label: "" ) }, columnConfigs: { a!gridLayoutColumnConfig(width: "D
Hi, I have a date time field in DB stored with max value 9999-12-31 00:00:00.000000 i have a record type synced with this DB column field as date time type. when i am querying the record from Appian I am getting 4/10/2292 11:47 PM as result. when i verified the field in the record list this expression is used if( isnull(fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs']), fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs'], datetext(fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs'], "default") )
Hi, In DB we have one date set to 12/31/9999 (MM/DD/YYYY) which is a data source for a recordtype. When this record type is used in one of the site page the recordlist date and time column is display the wrong date as below Is it somewhere setting max date? Not able to find. Expected Date to display in recordlist: 12/31/9999
Is there a way to alphabetize user filters within a read-only grid? My thought process was to use the a!sortInfo() for the related filter, however using this function has not worked for me. I have spent a few hours searching documentation and have not come to the conclusion I need, so I have decided to ask.
Hi , I have created an interface using rich text field components to display text as mentioned below. Task Details 1. attribute1: Text1 2. attribute2: Text2 3. attribute3: Text3 4. attribute4: Text4 Now the requirement is to generate this text as it is displaying in the interface using expression rule (for sending to another system using rule input). Is there any way or function in Appian to create listed text item like above mentioned using expression rule. Any suggestions would be really appreciated. Thanks in advance. Pradeep.
I am getting this error screenshotted above when trying to click a link field setup for editing/updating a user. I will show the block of code from Line 52 and on within TB_QE_getPodCodes that it says it is complaining about. Does anyone know why this might be occurring or point me in the right direction? Thanks in advance! a!queryEntity_22r2( entity: cons!TB_ENTITY_PODS, query: a!query( selection: if( a!isNullOrEmpty(ri!selectionList), null, a!querySelection( columns: a!forEach( items: touniformstring(ri!selectionList), expression: { a!queryColumn(field: fv!item) } ) ) ), logicalExpression: if( not(local!checkAllFilterNull), a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(field: "id", operator: "in", value: ri!id), a!queryFilter( field: "podCode",
Hello, We have Rich Text Editor to take input from user which can contain special character . We are using stripHtml() to get the text and later on we are comparing the text with Regex to show validation on RTE.The issue we are facing with stripHtml() is that it is leaving some characters as html encoded in the returned text. But we require the character itself.How can we handle such case for all the special characters? For reference -In the output, the special character ( š ) is coming as html encoded whereas the other character which is <, can be compared using regex.We need the output as - "š<"How to handle all the such characters which will be coming as html encoded? Is there any other function which we can use to achieve the above result ?
Hi All, I have a requirement to upload attachments to a target folder location and assign them before perform submit on UI screen. Is there ant way I can achieve this? Thanks in advannce.
i want to highlight these two duplicate values when a user enter a duplicate value. Please suggest me validation code.
In my "Request " CDT , i have a field named "branch" of type number. I am trying to display the branch ID on the interface , from the query "GetRequestData". value: rule!GetRequestData(ri!documentID).branch, ri!documentID holds the ID of the request. when I test the query it returns the data correctly, but on the interface it doesn't show. when i debug the process model it shows ((Cannot index property 'branch' of type String into type List of Variant)) i don't quite understand the error message. how can i display it correctly ?
a!localVariables( local!selectedPermission, local!selectedArea, local!selectedComponent, local!selectedDepartment, local!departments: a!refreshVariable( value: rule!MECMS_getDepartmentList(activeFilter: true), refreshOnVarChange: { ri!refreshInt } ), local!area: a!refreshVariable( value: if( rule!APN_isBlank(local!selectedPermission), null, rule!MECMS_getRefArea( selections: {"id", "value"}, permissionId: local!selectedPermission, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ).data ), refreshOnVarChange: { ri!refreshInt } ), local!component: a!refreshVariable( value: rule!MECMS_getRefComponent( selections: {"id", "value", "areaId"}, areaId: if( a!isNotNullOrEmpty(local!selectedArea), local!selectedArea, if( rule!APN_isEmpty(local!area), -1, local!area.id ) ), pagingInfo: a!pagingInfo( startIn
I am trying to determine the shift based on datetime. Here is the use case: Shift 1: 07:00 - 14:59:59 Shift 2: 15:00 - 22:59:59 Shift 3: 23:00 - 06:59:59 However, it’s not working as expected according to the current code that I have ( Please see the attached screenshot) . The date in Appian writes with GMT adjustment .
Hi Guys, What is the most effective way to do error handling for multiple parallel API calls while loading the interface. Currently My code look something like this. a!localVariables( local!users:rule!APN_GetUsers().result.body, local!items:rule!APN_GetItems(id).result.body, local!info:rule!APN_GetBasicInfo(id).result.body, local!summary:rule!APN_GetSummary().result.body, {} ) If one of the API fails I will show some error in card. But how to effectively do this ? I need to this in multiple interfaces. [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]
Im getting Cannot index type Number (Integer) into type (DOCUMENT_DETAILS) - which is a cdt. local!indexNum is just a local a!radioButtonField( label: "Radio Buttons", labelPosition: "ABOVE", choiceLabels:rule!SKJ_GetForm( {} )['recordType!{228c141f-e2f8-4a93-bf0d-0dfed8c9c6b4}SKJ Form.fields.{af4b3fdd-a9a3-4ea7-82d9-8f16e323e35f}descEn'], choiceValues:rule!SKJ_GetForm( {} )['recordType!{228c141f-e2f8-4a93-bf0d-0dfed8c9c6b4}SKJ Form.fields.{d69bf265-893b-4707-965c-3512e6e1c9bd}itemCode'], value: ri!DocDetails[local!indexNum].docForm, saveInto: { ri!DocDetails[local!indexNum].docForm }, required: true, choiceLayout: "COMPAC
i want to cover the black space below the comment with column. And when we expend the comment then column size get auto reduce.
I have a grid column which should be displayed based on a condition. When the condition is true it will show a grid as below. and when the condition is false it should not show anything but instead it is displaying as below. I haven't configured anything to display something like this in the interface. Can someone please help.
Hi Experts, Is it possible to have this Horizontal Scrollbar at the Top of the Grid rather being in the bottom. Thanks, Gaurav Singh
So, I have a form for " Document Details", the user can enter as many documents as they want. and when they add a document, it should appear in the grid. I declared " local!indexNum" as index , so the user can enter many documents. And here is an example code of how i entred data: a!dropdownField( label: "Main Type", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels:local!type['recordType!{ba0dd34e-52a6-4f09-ba3a-dd6885feda5b}SKJ Main Type.fields.{e5eb76e0-4885-44d7-b9c3-263533a5f721}descEn'], choiceValues: local!type['recordType!{ba0dd34e-52a6-4f09-ba3a-dd6885feda5b}SKJ Main Type.fields.{4a008dc7-3ea8-466e-a515-75c5cb965a49}itemCode'], value: if( a!isNotNullOrEmpty(local!filled), ri!DocDetails[local!filled].main
Is there a way I can set visibility of a site page based on "DESKTOP" or "MOBILE".Both a!isNativeMobile and a!isPageWidth do not work on site object.
How to download multiple documents based on a caseId just with a single click... by using a!documentDownloadLink able download single document
Hi Please be informed that i am trying to provide validation for a one user input field in a pattern like P (upper case).7 digits.2 digits.2 digits (if applicable) i have tried like below but for two conditions it was not working if first letter P is lower case also it was returning true and for last 2 digits if applicable then only it will be having those digits but it was expecting those two as mandatory. Could you please suggest on this a!localVariables( local!input:"P.8790889.87", local!pattern:"[P].[0-9]{7}[.][0-9]{2}[.][0-9]{2}", local!output: regexmatch( local!pattern,local!input ), local!output )
Hello, I have a problem on my form interface that I can't figure out, I have a dynamic input that can add more paragraph fields if needed but when the form is submitted, two records are created with the same data saved, and only the last text from the different paragraph fields created by the dynamic input is saved in the duplicated records but with 2 differents ID. I'm new to development and to Appian and I'm not english so I have difficulties to understand what can be the source of the problem, I tried many things using documentation but it's unsuccessfull. All my form's data is saved in my record type "HELLO Evaluation", except for the text from the different paragraph fields who are saved in my record type "HELLO Objectif" by a one Evaluation to many Objectifs relationship. Here's my code, I suppose the problem comes from the paragraph field code (259 to 288) or the submit button (348 to 376) but I'll give you all of it in
hi every one i have some valus whih is representing in the precentage formate example 1)908743.2% and some other like 2)23% it was data population in grid field my query was if the value contain length of 2 then need to print asit is but if it was more that length of 2 like i shown in example 1 it should show only 2 digit value if value was 33% i want show same 33 % if the value was like 98567.23% i want like 98% note : there is no fixed length for the number which display on grid
Hi I am working on task where i am supposed to generate a pdf , using "XML" method , I created template and build this process model , but i don't know what to do next, can some one direct me through the steps or share an example maybe? Like how should i pass the data in the scrip in xml form ?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.