Foundation

First let me start this off with some good news.  The left-hand object bar has been further tweaked and reorganized.  I previously commented that "process model / interface search results" being at the top of the list (as they are in 22.3 and lower) makes it harder to access the Smart Service Nodes we're after when that's what we're actually searching for.  It looks like they listened! Yay! But for the main point of this post: i've noticed that Grid Lines are now turned off by default and there is no way to undo this except by turning them on manually every single time you load a process model. At first I was hoping this was a bug in my Community Edition instance, or some incomplete feature or temporary break.  But other users are now posting screenshots from 22.4 versions around community and it seems like it may have been "intentional". Hey Appian folks?  This may have been intended to "look cleaner" or something

How do I convert the   "Thu, 10 Nov, 2022"   this text to date? I am getting this data from IDP in text format.

Hello community I am trying to recreate this screenshot from another application  .

I have a need to send  All the open orders (orderid, total amount)  , in a word report document to email .This should be send once in a week 1. what activity i should use in process model for this 2. how to create a report with multiple order details dynamically  Please help

Hi everyone, I have a line chart showing the number of cases created/ closed within the day, and I want the color scheme of the trend lines and legends consistent, which are: Case Closed: Blue, Case Created: Green I have a filter list for case type, and this is where I found the inconsistent issue. For example: If I choose case type = 1, the color theme is consistent with above setting (Closed: Blue, Created: Green)                       However, if I choose another case type = 3, the color is other way round (Close: Green, Created: Blue), which might confuse users. If I set pre-defined color scheme different than CLASSIC (E.g. SUNSET), the color scheme will be consistent after applying filter, but then it become inconsistent again if there is any new closed/created case. a!lineChartField( data: a!recordData( recordType: 'recordType!Case Status',

Hi, here is Chenyang from Japan. Is there any methods to change the first site view after an end user logged in appian. actually, appearing the Tempo view first after logged in is not fit for our project. What configuration should I do to change its setting? Thanks in advance.   [emoticon:c4563cd7d5574777a71c318021cbbcc8]

I'm using record type to create a column chart. The field which I am using is stored as text in the database.  See line 14 in the attached screenshot. Can I change it to decimal to use in measure?

Hi, I am doing a process model where in I am mailing a person a table of contents. Now the contents are dynamic, and I need to populate the contents from the process variable. I am aware about the  " ### " syntax, but not quite sure how to display multiple rows in a table. Can anyone please help me in this.    Also, While reading community, I read about the ncolumntables function, but its been discontinued now. If there is a replacement for the same please suggest.

Hello. I have a process where i want to monitor status of a Record and to save the details about each step with timestamp. Lets say i have 3 statuses: Id 1 "it started" Id 2 "first mail" Id 3 "second mail" And I have Record type "History" with columns Id(primary key), status id, timestamp. I want this Record type to save the data like: Id1, status id1, 23.12.2022 12:55:00 Id1, status id2, 23.12.2022 12:57:00 Id1, status id3, 23.12.2022 12:59:00 Id2, status id1, 23.12.2022 13:01:00 And so on... So i can see the precise time when each step occured without overwriting Id1 with last status3 (and only showing this last status on database/Record type). How can I achieve this? Currently I'm saving the status id with Script task, but dont know where to tell Process Model that I want to save each step separately. And as i complete the process IT only shows last status on database. Help will be much appreciated.

Dear Team, I had a query, what steps need to be followed for deploying application from one cloud to whole new different cloud.

Hi Team, I am working on the history table of my Appian application. I created a new table in the database having a similar column of my application in addition of 3 new columns modifyby, modifyat, and operation(create/update/delete). I created a corresponding record type/data type as well. The entity mapping on the Datastore is also successfully done. Now while I am updating my code on create/update/delete interface to fetch the action history of my app, I am getting errors. This is the code:- buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", saveInto: { a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{b5d840ba-2408-425d-b829-510414356ac2}serialnumber']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{d7f705b2-c020-47c9-95c4-cbe0e6df18a2}addedby']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-94

Dear all, I'm finding a solution for a phone screen, when the user scrolls down then show an icon on the bottom right so when the user clicks on that icon the page scroll to the top .... ???

When converting docx to pdf using Arabic font, I want to prevent numbers to change to Hindi numbers.

Please forgive me if there is a way to do this already... I find cases where I have a fault in a process model during debugging. I track down the fault and fix it (either in the instance or in the process model itself) I then have to re-run the process  BUT Sometimes one wants to have a live run of an older version against a newer version rather than looking at the static comparison view in Versions SO I would like to be able to: go to my instances in Appian Designer Monitor view be able to right-click (or other method) to select a different version of the process model (i.e. either a previous or an updated version) run the same instance through  the newly selected process model 

Hi, We are creating performance test scripts in JMeter, after recording the flows and running them, the scripts run fine for 1 day however they fail after 1 day, on inspecting I came across several dynamic values like CacheKey, SaveInto and Context which change often.  Now the problem is there are several CacheKeys, SaveInto and Context in multiple responses before the requests where these values are used, how can I know which values to grab dynamically and use in the further requests.  Can anyone please help as this is a blocking issue! PS- I have already handled the appian csrf token and I am able to login successfully.

Hi All, Trying to refresh using a refresh variable in grid. Facing issue with refresh. Please find below code and let me know if any changes are required. a!localVariables( local!refreshCounter: 0, local!startIndex: a!refreshVariable( value: 1, refreshOnVarChange: local!refreshCounter ), local!pagingInfo: a!pagingInfo(local!startIndex, 5), local!data: a!refreshVariable( value: rule!S_getAPI(), refreshOnVarChange: local!refreshCounter ), { a!buttonArrayLayout( a!buttonWidget( label: "Refresh", size: "SMALL", style: "SECONDARY", saveInto: { a!save( local!refreshCounter, local!refreshCounter + 1 ), } ) ), a!gridField( label: "Data", labelPosition: "ABOVE", data: local!data, columns: { a!gridColumn( label: "First Name", sortField: "firstName", value: fv!row.firstName ),

Hello! I'm currently having an issue where I make the selections in the dropdown, but when it saves to my DB it saves the first selection 2 times or 3 depending how many selections I make. Currently I'm using a local variable to save the selection. Any suggestions to make sure it saves correctly to the rule input? thanks in advance

Hi, I need to pull values from DB which does not starts with "ABC" for example. a!queryEntity(entity: cons!entity,query: a!query(filter: a!queryFilter(field:"office",operator: "not starts with", value:"ABC"),pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1))) But this is ignoring null values, I want null values also to be returned along with other values. So I just tried fetching only null values to see how it works.  a!queryEntity( entity: cons!entity, query: a!query( filter: a!queryFilter( field:"office", operator: "is null" ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1) )) this is giving me 0 results. Nots sure what might be the issue. Can anyone please help? operator "not null" returns correct values, problem is with fetching null only.

Hi everyone, This is my process model, and I'm trying to find the cause for above issue: So the process starts with receiving the Excel file that user uploaded, then parse the file to get data into CDT type which looks like below: Then I use another script task to index and get all the case Ids. The problem is that when I run it in debug, the Parse File node generate multiple instances, however I check the output variable and the results are not duplicated. I didn't config the MNI either. 

So I was finally able to get some phone number validation working. However, it only works in the interface and not when I'm actually using the record action. Here's the code the error message I'm getting. I think this is happening because the record action relies on user input and perhaps starts off as null. I'm just hoping there's a way to fix it.When I try to create a new contractor through the record action: Error Evaluating UI Expression Expression evaluation error [evaluation ID = 0932b:f622d] in rule 'ds_createcontractor' at function 'search' [line 65]: A null parameter has been passed as parameter 2. a!textField( label: "Phone Number ", labelPosition: "ABOVE", placeholder: "### - ### - ####", saveInto: ri!record['recordType!{d327a5dc-18d4-4ffd-8bdf-6a22b134677f}DS Contractor.fields.{f4c57b1e-a70b-4b5c-abfd-91fbfa77c38f}conPhoneNumber'], ref

I'm looking for function to open interface2 in new tab" not the same tab"  by clicking a button in  interface1  

The audio of the video is fragmented..... what can I do about it?

I want to generate a report showing where list of users who are not logged in 30 days or 60 days or 90 days. How to do that?

How can I create the nested bulleted list in Appian 

Hi everyone,  I want to set a start timer for my process model, in which start date time will be provided in advance, and if the given start date time is within work hour (9-6pm Monday to Friday), the process model will send an error message stating it can not proceed during business hours, and the process model will not be run.  I haven't had much experience working with process model, so really appreciated if anyone can give me some guidance :)  Thanks a lot!