Foundation

Hi Folks, How can I schedule/ trigger my process model so that it will start on a row insert or update in da custom database table. Regards, Ghanashyam

I'm new to Appian and I'd like to know if there is a setting or solution to setup a daily remainder notification for the manager approval task until the task is completed(approved or rejected), as long as the task is pending, the daily notification will be sent. Any insight is really appreciated! Thanks, Tracy

Hi, I have a form which I am using to edit a record. I have a validation in the field like when the user tries to enter some number, I am have to ensure it is not existing. For this I have written a rule and ensuring the user is not enter the existing number. The issue here is,  the validation is firing in the page load itself. I was expecting it will fire when I star editing the content in the field. Any solution to this please. code:

Hi Everyone, I have a excel file with more than 50 columns of data and I need to convert that excel to PDF. how can I do that ?

a!localVariable( local!rtYearDatasubset: if( ri!isReviewTab, rule!AS_QRYE_getReviewTasks( selections: { "ReportYear" }, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1, sort: a!sortInfo( field: "Year", ascending: true ) ) ), rule!AS_getTasksData( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1, sort: a!sortInfo(field: "c9", ascending: true) ) ) ), local!YearArray:if( or( rule!APN_isEmpty(local!rtYearDatasubset), rule!AS_isNullOrEmpty(local!rtYearDatasubset) ), {}, if( ri!isReviewTab, tointeger( reject( fn!isnull, union( local!rtYearDatasubset.data.Year, local!rtYearDatasubset.data.Year, ) ) ), tointeger( reject( fn!isnull, union( local!rtYearDatasubset.data.c9,

How can I convert a Unix timestamp to DateTime?

My Community edition site is showing "Error Stopping " status, despite the fact that my last login was 2 days ago. Did anybody encountered this issue? Does anyone know how to resolve it?

'

Hello!I'm trying to create a list of groups for an application.What I am hoping to do is have an interface where I select a user and application then I get presented a list of groups in that application (groups will hold an attribute linked with a specific application) - I will then use ismemberUserOfGroup() to have two lists one which displays which groups the user is a member of and one which the user is not a member of.For example:User - John.Smith Application - RandomApplicationTest(Attribute in groups to filter groups RAT)Available Groups                                                                          Member OfAdmin                                              &nb

Hi,  I am not able to find the folder option to create folder after creating an application and navigating to application Page. When i click on new to add the folder , i can't see that folder option to create folder. Can someone help on this what may be the issue and how to resolve this.   Thanks, Shivappa

Hi, I am loading an interface  when a one of the sub action button was clicked and this interface will have 2 dropdowns along with "Submit" and "Cancel" buttons. I need to validate when user click on "Submit" and should not allow the form to submit when if some of the rule inputs CDT data is missing. How can I stop submitting the form when user clicks on "Submit" button and also, I have to show the error message by saying "you have missed some of the data fields before performing any option selection". How can I achieve this. I am missing some kind of trick here.

Any help will be appreciated. See error on the right. Thanks

I have a use case where I am displaying user entered data in a help tooltip.  The users would like the tooltip text to reflect returns and extra spaces that were entered.  Is there any way to do this?  Creative options welcome!

Hi Experts, With the latest update of Appian version my source filter have stopped working as it contains loggedInUser() and now() functions in it. What would be the workaround to handle this. Thanks, Gaurav Singh

Hi, I want to display a message informing an user to check their mail when a button is clicked. The button is for exporting the grid to excel.  How do I do that?  Thanks

Was wondering if anyone else have tested this new Appian smart service and got the error message returned from the Stored Procedure. I tried getting an Error message returned from the store procedure but nothing comes back. Error Message and Error Occurred in the output tab does not store anything into my variables after the smart service is ran. I get back data for result sets and parameters though. I used Microsoft SQL server management studio to create my stored procedures.  Execute Stored Procedure Smart Service - Appian 22.1

Hello AllHopefully very easy question for you!I have the User ID from the User Picker, I want to display in a separate field the User First Name and in another the User Last name.How can I do that? For example where user Id is: jonhssomething like .... toUser(johns.firstname) ?? Thank you!!

Hi, I have a read-only grid with a few columns, but there are quite a number of other columns from the other tables which need to be populated in excel. I have a Data base view where I have joined all the required tables to get the data. Can someone suggest the best way I can use the SQLServer view to get the data into excel? Thanks in advance

I want to use area chart in my interface.But when I use a!areaChartField () in my interface it gives me error :"Function not available"

Hi All, Is any plugin available to read the content of login-audit file in .gz file format? Appreciate tour help

Hi, I have a requirement to call SQL User Defined function in Appian Appian version : 21.1 

Hi, Is there any control in Appian which can give this type of look and feel. Thanks.

Hello All!I'm trying to figure out the best way to autocomplete a field with an Appian user name?For Example I start typing persons surname:SmiAn auto complete suggests:Smith JonSmith Dan Etc etc The idea here is an "Admin" will log into this start typing the users last name or first name etc and have Appian give suggestions which the user can then select one of this will then be used as a variable to confirm groups user is a member of so we can add or remove access to other groups.As always any help is appreciated thank you! :) 

grid data convert  to excel sheet format

Appian recently upgraded its version to 22.1 yesterday after which users are facing an issue of the UI being greyed out when using the scroll bar of the browser to scroll right in order to view the data. Before that, it was working fine.  Attaching the screenshots of the issue where the area is greyed out and the data is not visible. This happens in the forms where there is more number of columns Initial screen: When scrolled: When we use the scroll bar of the grid instead of the browser scroll bar then this is not happening. Used the scroll bar marked with red arrow Can anyone suggest anything how can this issue be resolved or will Appian resolve this issue in its next upgradation?