General

Hi, have a requirement to short a record field which have integer value how can i do that ?

Hi All, The requirement is that we do get a time value with time zone in a CSV in text format (ex: 12:00 CET), which we read and display on UI. When displaying the time on the UI we need to display it in GMT. With the current datetime functions this seems to be difficult to achieve. Other thing in mind is that maintain a table with time zone off set values for different time zones we get and use it to calculate the correct display value. This has its own issue like day light saving adjustments. But before going into that route we need to find if we can still do this easily programmatically.  Any advice is appreciated. Ex: Time value received in CSV : 12:00 CET on UI we need to display 10:00 GMT

here in richtext editor, on click of save values should be null, but after saving the values to DB again can see the values here.  on click of save values should store to DB and on UI it should not show - how can I achieve this?

Hi  Team,I am having use case where we are using IDENTITY feature available in Oracle in substitute of Sequences. and it is working fine from database insertion. But Appian is still expecting sequences.I went through few of the posts regarding  the same but there is no solution available rather than using sequences.I wanted to know if Appian is upgraded with the similar feature ? Anyone has used any strategy to accommodate the IDENTITY change ?Any feedback help is appreciated.

When designing an interface for a record action, I noticed I am having trouble optimizing the UI for the specific dialog box size, since its width and height are fixed. I think we could benefit from dialog box sizes (large, medium, small) being available options alongside device widths in the preview pane of the expression rule designer.  

Hello,I'm currently utilizing intelligent document processing to extract data from PDFs. However, in line with our client's needs, we are interested in exploring the extraction of text from handwritten PDFs or images. Can anyone confirm if this is achievable through Appian? or any other way.

Hi All, We have developed an application. We have designed UI with front-end technologies and back-end with java,  But UI front-end technologies are not acceptable in Client side, Can we use Appian to design front end interfaces and link with backend java code?

can we declare  local variables inside a!foreach() inside expression rule 

Hi Team, I have group - Group1 In the group 1, we have 3 users user1, user2, and user3. Now, I have loggedin with user1 account. In the pickerField now the user1 should not be listed out. Can you please help with the approach.  a!pickerFieldUsers( label: "Users", labelPosition: "JUSTIFIED", maxSelections: 5, groupFilter: cons!Group1, value: local!selectedApprovers, saveInto: local!selectedApprovers, required: true(), validations: {} )

Hi, I am trying to get the next day from today's date. For eg: today is 18/9/2023. I need to get 19/09/2023. I tried using some day function to get the day and add 1 to it. I was testing with different timezones. now() - 9/18/2023 10:50 PM PDT now() + 1 - 9/19/2023 10:50 PM PDTwhen I used day function on now() +1, its giving 20 instead of 19. I am not sure what is the issue or maybe I am missing some timezone offset. This is occuring when I tested for Pacific timezone. Its working fine for IST. Please help me on this. a!localVariables( local!date: now(), local!endDate: now()+1, local!day: day(local!endDate), local!day )

Greetings to all the Appianites out there! I have a client organization who adopted Appian, over a decade ago, to build one application in its own data center. They didn't keep up with the product upgrade (like any undisciplined DIY jobs). The application is now wrought with all kinds of issues and the stakeholders is second guessing Appian and contemplating changing horses, though I believe a more sensable approach is just to rebuild the app on latest version of Appian on Managed Cloud.  To convince the client to stay with Appian, some facts on the revolutionary Appian product improvements could be super helpful. I started my Appian journey only about 5 years ago. Hence I have little knowledge of what it might feel like working with decade plus old Appian platform. Would be grateful if anyone care to share his/her perspectives, traveling down the memory lane of Appian product evolvement.

When you and your colleague are working on the same expression rule, you need to have a common test case to be used for both of you, what will you do?? Select multiple actions required[Multiple Choice][a] Create Test case[b] Add it to a testing group[c] Use Ad-hoc Test Cases[d] Create a new testing Expression Rule

I have below record Data {'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':3, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11107, 'recordType!PRO Lead Documents.fields.pdmDocumentId':110604, ), 'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':4, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11108, 'recordType!PRO Lead Documents.fields.pdmDocumentId':110605, ), 'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':5, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11109, 'recordType!PRO Lead Documents.fields.

I have a parent Interface calling 2 child interfaces. Both the child interfaces are grids.  The first grid shows previously added data and has capability to select a row and add it to the bottom grid using Select button. The second grid has search fields to search for an item and add it to the grid. I'm passing these 2 different data as 2 different variables to the Grid 2. (Though I tried passing as single didn't work). Here is my scenario:   I select first item from Grid1 it gets added to the Grid 2 Then I search functionality and add data to Grid 2 Now I select another item from Grid1 and try to add. Problem: This time when I select my second item from Grid 1, I don't see the newly added item in Grid 2. I see the newly added item is seen in local!submissionSubstance_HTTP but not in the Gri 2 This is the local for my Grid 1 selection local!submissionSubstance_HTTP: a!refreshVariable( value:rule!DCC_castSubmissionSubstanceData( s

We have freeform paragraph field, where user can enter any text string except the emojis. I have tried some of following regexreplaceall function which works fine to remove emojis but it also removes some of the special chars as well. Any suggestion on how to just eliminate emojis by completely removing it or just replace it with text string. input: "afs saf [emoticon:4191f5ee34e248a29fa0dbe8d975f74a][emoticon:5ced9b85a4a246058e4772ef2b9956f4][emoticon:33306c418930400bac28808410f8ac8b][emoticon:ac85b29e2ff049dd9278224b337cdf43][emoticon:ccfc0979d5bf49dc92a54d454ae8fe68] sdfa sdf___~!@#$%^&*()_+{}|:<>?" Function:  regexreplaceall("[^\u1F600-\u1F6FF\s]", ri!input, "" ) currentOutput: "afssafsdfasdf___~@^_{}|:<>?" desireOutput: "afs saf  sdfa sdf___~!@#$%^&*()_+{}|:<>?" Thanks! Ajay

a!forEach( items: ri!pdmDocuments, expression: a!update( ri!DocumentDetails, { 'recordType!PRO Lead Documents.fields.pdmDocumentId', 'recordType!PRO Lead Documents.fields.updatedBy', 'recordType!PRO Lead Documents.fields.updatedDt', }, { index(fv!item,'recordType!PDM Document.fields.documentId',{}),loggedInUser(),now()})), input ri!pdmDocument is {110407,110408}, input ri!DocumentDetails is  List of PRO Lead Documents - 2 itemsPRO Lead DocumentsleadId6699(Number (Integer))workItemId:31206(Number (Integer))createdBy:"test@scar.com"(Text)workItemFolderId:110429(Number (Integer))isActive:true(Boolean)updatedBy:"test@scar.com"(Text)documentId:110444(Number (Integer))documentName:"_Test_Contract_2_"(Text)updatedDt:9/14/2023 2:49 AM EDT(Date and Time)leadDocumentLookupRefId:278(Number (Integer))createdDt:9/14/2023 2:49 AM EDT(Date and Time)description:""(Text) PRO Lead Documents leadId:6699(Number (Integer))wor

Hi is there any function as if i change the count to 2 in list item of 4 it should return only 2 items..as shown below this is list of record type ... now based on count i want to retrive items.. like if count is 2 it should give me first 2  list of record types shown below from 4 . List of PRO Lead Documents - 2 itemsPRO Lead DocumentsleadId6699(Number (Integer))workItemId:31206(Number (Integer))createdBy:"test@scar.com"(Text)workItemFolderId:110429(Number (Integer))isActive:true(Boolean)updatedBy:"test@scar.com"(Text)documentId:110444(Number (Integer))documentName:"_Test_Contract_2_"(Text)updatedDt:9/14/2023 2:49 AM EDT(Date and Time)leadDocumentLookupRefId:278(Number (Integer))createdDt:9/14/2023 2:49 AM EDT(Date and Time)description:""(Text) PRO Lead Documents leadId:6693(Number (Integer))workItemId:31206(Number (Integer))createdBy:"test@scar.com"(Text)workItemFolderId:110429(Number (Integer))isActive:true(Boolean)updatedB

Dear Forum users, How can we know the appian generated custom mobile application is compatible with which version of android and what is the Api level of the apk file.

Hi, is it possible to have 2 eventlogs loaded and connected with each other in Process Mining? Following use case:  - eventlog A with activites for a customer order as case ID - eventlog B with activities for a customer shipment as case ID It is a 1:n relationship between customer order and customer shipments. I can analyse each eventlog seperatly but as they are connected in real life, is there a way to connect them within Process Mining and analyse them?  Thanks for a reply Himanshu

Hi, I have an requirement to trigger appian rpa based on email body content to download file

I have a use use case, when any developer uploads their package in one interface  and that should go through the XML code and return if any objects in that package are using any deprecated functions. To achieve that , is there any function that would read the XML file

.

I have an HttpResponse type pv holding following value: [statusLine=HTTP/1.1 500 Internal Server Error, statusCode=500, headers=[object Object], contentType=application/json, body={"type":""title":"Internal">www.w3.org/.../rfc2616-sec10.html","title":"Internal Server Error","status":500,"detail":"Error connecting to underlying system","instance":"XXXXX/error/uuid:XXXXxXXXXXXXXXX"}] I am passing it to and expression rule and indexing "body" into a local variable responseBody , which is wprking ok, However when I try to index any of the attributes within body , such as "title", "type","detail","status", Index is not working and returning default value. I am trying as follows: errorDescription: if(ri!success,"",if(a!isNullOrEmpty(local!responseBody),"",index(local!responseBody,"type",""))

Hi Team, I am given a task to create users in Production. There is an account already existing in Production which I have to use as a mirror account. The mirror account is a part of lot of groups, and I have to enter these users in each of them. Is there an easier way to do this? Since it is production environment, I cannot use any smart service directly without approval from higher mgmt.  Any help is appreciated. Thanks, Ritika

Do we have any process model/plugins to capture basic fields for field level audit - property that changed , old Value, new Value, last updated by, last updated on