General

My requirement is to display the date-time field in (dd-MMM-yyyy hh: mm a z), I am able to format using the date text function but the timezone is coming as GMT +5:30 when the user changes the timezone setting for eg (IST) other than the system default timezone. I wanted to know if there is a workaround to display timezone in short form, for eg IST, EST, etc.

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 ?

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

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

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!!

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 

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! :) 

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?

I have two rule input of type Any Type When we append both in a!save() , it throws error "Requires writer object". when we cal from one interface. We are calling from multiple other interface where it works fine. Anyone faced this issue? a!save(ri!var1,append(ri!var1,ri!var2)

Hello? can I use "update constant smart service" with process model? thank you.

Hello, I recently found out about 'Create Expression Rule Smart service' and 'Update Expression Rule Smart Service'? I am no sure these smart services provide what I need. Is there any guidance that I could follow to use these smart services? Thank you.

Hi Everyone, I have the requirement so that users can upload excel sheet to the application and save into database table and if the records already exists in table then it will leave that duplicate record. meaning, duplicate records from the sheet should not be uploaded to the database table. Please suggest me how to get this done. Thank you, Shubham

I have a requirement, i have a dropdown filed where if i select a particular group (lets say technical group) then the mail should be triggerd only for that group. Note : im fetching the dropdown values from ref table

I have to upload data(rows) from excel sheet to Db  and maximum number to rows in excel sheet can be 100 rows . What is the best  approach to get this?

Hi I need to start different process models in a WEB API based on the path segment. One of the process models would upload a document from an external system.A web api is created using "upload document" template. This web api is called in an integration where the document is passed as a part of "multipart/form-data" and other parameters are passed as query parameters and headers. I tried calling this integration in parent web api, I get Internal Server Error. If I try calling upload document code in the parent web api also I get the same error. How can we resolve this? Appian version : 21.1

Hello everyone, for a few days I have a complication, I don't know how to remove the (; ) after each of the array I have a rule that is responsible for extracting information and I build an array for each element, at the end I have an array of arrays that I print in a plain text document. when I run my rule it returns something like this:   0WF20220210630 14 2/14/2022 22/04/20225678 n453049 MXP 1.00000020220445678 P 11556020122010081089 944,414.101234121212121231089 944,414.1000000000022023/06/2020; 0WF20220210631 14 2/22/2022 22/04/2022234567 n525487 MXP 1.000000202204ERTYUI P 11556020122010081089 777,777.801234121212121231089 777,777.8000000003042005/10/2020; 0WF20220210631

can somebody explain this  Combin(64,2) returns 2016 

Hi Team, I have deployed the data store and CDT to higher environment and able to view that " A modified draft version " message is available on the top. But when trying to click on "Modified Draft" link to verify and publish the datastore,the appian tool is not navigating to the modified version. This is happening for us in all the environments and hence blocked with deployments . Regards, Divya Jyostna Dasari