Discussion Categories

Hello All, I have forloop giving the values like this. "Test.txt" "Test - Copy.txt" "Untitled_1.log" "DB connection.xml" I wanted to form an array of this like {"Test.txt","Test - Copy.txt","Untitled_1.log","DB connection.xml"}. How can I do this.

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

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

Hii All, I want to add space between the string and first letter in upper case like: firstName : First Name lastName : Last Name Thanks

Hi there! I'm trying to have the dropdown menu display the previous selection for my interview application I am working on. In the app, you are able to edit questions that have a few categories (categories, difficulty, etc) and I want the drop down's menu to have whatever the value was before being in the placeholder spot. So, for instance, if a question was marked as Medium and I wanted to change it too Hard, then the drop down in the new interface would have Medium in the place holder. Please let me know what to include I am super lost!

How to find if logged in user is part of a group. I want to use it in visibility condition.

Hi All, I am Trying to Fetch Last login Details of some users by using getuserlastlogin() but it is returning Null values for users who logged in 1 week before. Does This function work only for last 24 Hrs? Thanks in Advance!!

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]

Hi,   I want to filter a record by its data types. Which type of filter I need to add on my records Type?.

Hi Everyone We're trying to write multiple records using write to record smart service on interface. But we're receiving below error -- The input "Records" must only include records from a single record type. can anyone please let me know what is wrong with the below code? a!writeRecords( records: { ri!taskDetails, ri!caseDetails }, onSuccess: a!save(ri!teadOnly, false()), onError: a!save(local!error, fv!error) )

what are the steps to follow in schedule a teams meet link in outlook and also how to cancel the schedule event and how to reschedule the existing schedule Meeting ? 

Hello, I am following a guide for Appian Developer Online (80 hours). I am stuck on the "Application Building Blocks", course 3  "Design Appian Records Part 1", "Build an Application: Step 5".  On the page 4 of the document I am supposed to select aavehicle database table. However I do not have such a table and  I do not remember any steps where I was supposed to create it.  Can anyone point me where exactly in the documentation was a guide for creating an "aavehicle" database table?

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?

Can we pass data of CDT type into a database table using Execute stored procedure smart service just like how it is done using Write to datastore entity smart service? Or else do we have to pass each and every data of cdt as a separate parameter using Execute stored procedure smart service? Thanks in advance.

Hello All, can anyone advise how to get the sql view in record list

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.

Hi All, I am able to see the user which is already selected previously in the pickerFieldUsers, how to hide/prevent the users' which already selected from pickerFieldUsers ? Thank You

Hi Everyone, Is there any plugin or approach to display the Realtime notification to logged in user in Appian. Example: Use case is, whenever the case created and assigned to any logged in member, should see the desktop/web notification saying case assigned to you. In Realtime users they opened the homepage,they would like to know whenever the case is assigned to particular person through desktop/web notification, so they act immediately. Otherwise, users need to keep on refresh the home screen. We thought below two approaches but see the couple disadvantages. 1. When the case is created, can send an email to user and user can enable the outlook desktop notification feature but at this movement we would not increase the emails.  2. Add the refresh interval to get the data but it is not that much of user focus. Alway need to focus on the screen. Could you please help us is there any other approach/plugins. Thanks In Advance!!

Hi All, I am adding and fetching data from database through integration object and displaying it to the interface. First time when add button is clicked it gets displayed on to the interface and when second time I click on add the data gets added to DB but its not refreshing to interface. I have used the refresh variable in the interface as well. Can anyone please help help me.

Hi I am getting an error message below. Could you tell me how to solve it. ■the whole message displayed by the Configurator -----------------------------------------------------------[INFO] Scanning for projects...[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[WARNING] Could not transfer metadata org.codehaus.mojo/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins:maven-archetype-plugin/maven-me

Hi,Can anyone tell the difference between Write to Data Store Entity Smart Service and a!writeToDataStoreEntity() function?? I am asking in the context of place of usage. As best practices, what are the specific places we can use the above mentioned? And is there a way to catch the error occuring while writing to DB using Write to Data store entity smart service???Thanks in advance