General

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

Hello folks, In Tempo, when adding comments, we can also upload attachments. Is there filter or server settings that will prevent uploads of .exe files?  Thanks in advance.  Best, Mahesh Pillutla

Hello, In which case will use views and stored procedures in Appian ? I know the basics about it but I am not sure when will use stored procedure and views.

Hi, Is it possible to add a link to Microsoft Teams User profile on Appian User Interface. Thanks.

localvariables( max 10 max20 ) has to print 10 to 20  

I have a multi selection checkbox, so if i select any of the options in that checkbox then only that mail has to be sent to a group of users outside appian and also i want to link a record in the mail body can anyone please help how to achive this. Thanks in advance .....

Hi, Is there an Out-of-Box function in Appian to get the list of all groups a user is member of. Actual requirement is to filter the active tasks assigned to a group which the logged in user is member of. User should be able to view an active task if user is member of the group the task is assigned to. Thanks.

I would like to add audit fields to the document type CDT in IDP, when a document is processed not only the extracted data should fill into DB, but I also need to have audit fields to be filled. So, when I was looking into it I am unable to open the interface, saying that this node doesn't allow custom forms When I was trying to configure it from a process model, I was creating a script task and wanted to save data from there, and save the data to DBSo when I Configuring the script task, I am unable to save the data to the particular parameter in the document CDT type, Because the type of the CDT is labelvalue, I need to save the data to the created by a parameter which is in value, so I am unable to do that. This is the error I was getting