Foundation

How we will covert ("INDIA") TO {"I","N","D","I","A"}. How we will write in expression rule?

We are using smart service 'export data store entity to excel'. While downloading the excel it has 4036 rows but in table in database it has more than 4036 records. We tried same with different table, limiting number of columns but each time it only generates 4036 rows in excel even if data in table is 4080 or more.  Can anyone suggest is there any limit in number of rows being generated through this smart service, or we can find any alternative method to this issue. 

Hi , I need some calculation logic in appain that gives difference of ration numbers example shown below in the screenshot. Can someone help me to write the logic for this on priority? Here actual and threshold values are user inputs based on those inputs variance col data to be shown .

Hi, I have a record action which shows "Add Artwork Milestones" and after completing/adding the artwork details the record action should get updated to "Edit Artwork Milestones". But it is showing to Edit Artwork Milestones Action only after page refresh but not immediately after the action submission.  I used a local variable to call the record action with a!refreshvariable() but still it is not getting updated dynamically without refreshing the screen. PFA code and help me resolving this issue.a!localVariables( local!recordAction: a!refreshVariable( value: a!recordActionField( actions: { a!recordActionItem( action: 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.actions.{9cb9fc4e-57ad-4aaf-b21b-6dabf15c4a55}addOrUpdateArtworkDetails', identifier: ri!labelChangeCountry['recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c137b66-e39e-49a

Hi everyone, Please help me How we can make the start process synchronosly 

Iam trying to add a new row link to the editable grid, The data entered in the new row shoud be saved to Database. anyone give suggestions. 

Hi Team, I'm using API Key approach to access web api, is there a automated way to disable the web API to show error between 4pm to 8pm. Is there a approach to do that?

Im trying to add a new row to the editable grid using record Type data, getting error while saving the row . Anybody help me to Add new row and data entered by user to new row would be synced to record and DB.a!localVariables( local!data:rule!IT_getProductDetailsFromRecord(), { a!cardLayout( contents: { a!gridLayout( label: "Product Details", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Product Id"), a!gridLayoutHeaderCell(label: "Name"), a!gridLayoutHeaderCell(label: "Category"), a!gridLayoutHeaderCell(label: "Price"), a!gridLayoutHeaderCell(label: "Brand"), a!gridLayoutHeaderCell(label: "Rating") }, columnConfigs: {}, rows: { a!forEach( items: local!data, expression: a!gridRowLayout( contents: { a!integerField( value: fv!item['recordType!{271a

!*** Click on all the tabs !| script ||click on menu |News ||click on menu |Tasks ||click on menu |Records ||click on menu |Reports ||click on menu |Actions ||click on action |IMS Order |***! !*** Log out and tear down !| script ||logout ||tear down|***! ----- Requested you please help me to add code to take item Name, Quanlity, Unit pirce, Total Price

I am getting the following message in the log when attempting to send emails outside Appian users like a gmail account. Different recipient domain on a smart-hosted and non-authenticated email. Sending server should retry this recipient separately next.

is there a way to allow sophisticated formatting such as bullets / underlining / bold etc. in any of the input component in Appian.?

I have a requirement to generate a PPT files from Appian. Did anyone come across similar requirement. Will appreciate any suggestions.

what is the differance between map & dictonary data types. when we will get this map type and dictionary type

I had written some logic that queried a record (expecting, and getting a single record, by passing a unique filter value) The query actually could return multiple records, so returns a List of the relevant cdt Then I tested a boolean field in that record is true or false, and returns one of two lists of items, for example something like this: if ( index(my_cdt, "booleanField",false), list_one, list_other ) My list was being returned but only with the first item in it! The issue is that the query returns a list of records, so the if statement parameter 1 is on a list type. An example of the logic I was actually executing was therefore: if( {true}, {1,2,3}, {4,5,6} ) This actually returns {1}, not {1,2,3} if( true, {1,2,3} {4,5,6} ) will return {1,2,3} as expected. Further example to show what's actually happening: if( {true,false,true}, {1,2,3}, {4,5,6} ) This returns {1,5,3} !! An easy mistake to make, so hopefully some one wil

Hi, I have a question regarding Activity Chaining? Activity Chaining is useful only for User input task  to show synchronosly or any other reason?

Hello, I'm currently building an audit history for my job. The way our client wants the history displayed is grouped by the date that the history action is created on. So that the list sometimes displays 1 action per timestamp and sometimes 2 or 3 actions by timestamp. We have found a way to do this but it is complicated. I get all the values in the histActionOn, then I uses union() to get only the unique values. From this point I can do more complex indexing to organize all the actions by date, or I can throw a a!queryRecordType() in a for loop and filter it by the histActionOn field. This gets exactly what I need. A record list with actions separated by date and time, but it's incredibly inefficient as it puts a query in a for loop. I'm sure there's a way to group all the actions by unique dates, but I don't know a way at this point. Any thoughts?Thank you Jason

Hello All-  There is a requirement to display all the tasks name along with other details in an interface and the data should be filtered by the task owner/ assigned group. When task owner or the user of the assigned group logs in, the user should be able to view all the details along with the tasks which are assigned to the user.  I am using query process analytics to fetch details from a task report within read-only grid. Any advice? TIA

Hey, I try to find components through Object View search that still uses 23.3 version as we updated to 23.4. But, when I searched(in the expression), nothing showed up and there are no of objects with what I searched. Searched for 'buttonWidget_23r3' and no object is available: Just one of the component that uses 23.3 version component.

Hello, I am currently working on an application for training purposes. I have a process for adding a record and editing it. I had a sub-process for both, where I am sending an email to a user group whenever a record has been added or edited. I was able to make parts of the email dynamic (e.g. "Information about [dynamicName] has been [changed/added]), but I would like to embed a record summary view link in that email, so that users can navigate straight to the updated record from that email. Now, the urlforrecord() function generates a working URL, but it links to Tempo, and not the summary view of my record. I have been trying a few things, but nothing seems to work. I would be very much obliged if someone helps me figure this out. To sum up: I need to dynamically generate a URL to a record summary view on my site to embed it within the email body. Thanks!

Hi, I am trying to get the PDF preview to work in a grid. I tried using the a!documentViewerField() but apparently, its not supported or is unable to be recognized in the grid rows. Any ideas how I can get this worked around ? At present using the below field to display the any image extension files. a!imageField( size: "SMALL", isThumbnail: true, images: { a!documentImage(document: fv!item.imageId) } ) Thanks Neil

I want to complete my L1 exam but the account I'm using is created by company's mail Id ,is it possible to merge 2 id's to same account so that i can have my certification linked to my personal account as well

Hello everyone. I am new in Appian and am trying to build a web app "Canteen" as part of my learning path. Couldn't find anything in other posts as I don't know how to search it. So my issue is the following... I have a Canteen Menu where each user can select products to add in the cart. On the interface I build a list of product variations (with a tempId in order to update something since I haven't saved anything on DB). When I press the "Place Order" button, I want to create a new "Order" with some fields and then get the ID of the created record. Then I will use the orderId and create the related "Product Variations" from the selected products list. How can I do this in the process model?    This Thread is duplicated by mistake. Please see this post: community.appian.com/.../129343

Hi there, I hope the title makes it a bit clear what I am currently struggling with. I would like to set up a process that is triggered by inbound e-mails. As part of the process some information of the mail shall be written into the database via the "Write to Data Store entity" smart service. When I tried it first I encountered the error 'Details:  An error occurred while trying to retrieve the data store entity [id=]. Verify that the data store and entity have not been deleted, and have the correct security settings. Details: User Does Not Have Rights to Perform this Operation '. After I adjusted the Data Store security settings to Viewer rights for ALL users, the process ran successfully and the data entry was written to the database. However, I have some concerns about keeping the security settings of the Data Store set up like this. Except for the handling of the inbound mails only dedicated users of the company shall/need access to the application

We have a process model (process A) with unused variables and we have a warning message in Process that "variableA" is unused. We went ahead deleted that variable and published the process. The sub process called in Process A has same variable name ("variableA") in it. In the setup of sub process we had a some logic to pass to that variable from Process A. Strangely after deleting "variableA" in process A erased the code in the setup of sub process for "variableA". Did anyone come across this behavior?

I am using the Create User Smart Service in my process model and passing the required parameters through the start process smart service on the interface,  and I am able to create an user with the username, first name, last name and email fields but I also need to set the Title field for the user during creation itself. Is there a way to do this without using Admin tab manually?