New to Appian

Hi, How to compare a any day (this day is added 3 hours)  with today anyDay : 10/02/2021 03:00 AM now: 10/2/2021 05:00 AM it will return anyDay > now

Hi, Few weeks back I was able to create DSE as part of creating Record Action.  But now in the new release of Appian 22.3, I do not see that object getting created while creating Record Action.  What is the alternative? Thanks in advance, Suneetha.

Hi All, I am using read excel function to read the excel file and mapping these values to CDT. I am giving timestamp field in excel and trying to map with CDT having data type 'Date and Time', and in postgres Db it has timestamp field, but it is not getting mapped to CDT. NOTE: If I enter only Date then it is getting mapped to CDT and updating the DB, but If I am trying with timestamp field the CDT values are null.   Thanks, Kiran

Hi Team, I have a use case where if some user clicks on a link, then first, some data needs to be deleted and then second, an api integration needs to be triggered with a query parameter whose value basically is the value of the link clicked.(local!selectedSuiteName) See below screenshot:  So, if someone clicks on the first link, then first I need to delete the related data from db and secondly then I need to call an integration which is configured basically to call an API. But I want to pass the selected link value as a query parameter to the API, I am not sure how to do it in expression. What I know is I can call an integration using rule!<Integration name>, however I don't know how to pass the parameter which is basically saved in local!selectedSuiteName. So the full flow is like, 1. When user clicks on a link, some related data need to be deleted from an appian table. 2. Now, I need to populate the same table with some data and that data basically I want to fetch

Hi guyz, Could you pls help in verifying the way by which I am passing the parameters in the process. I am trying to pass the parameters in the following integration I have created a process variable for the above process which can be seen below- Let me know if I am doing things correctly or not ? Thanks in Advance.

Hi team, I am facing an issue where My data is not getting saved in data store. I am using a process model which can be seen below- I have set up the process variable 'Result' for tracking the integration result. Also, in the 3rd node,i.e., Write To Data Store Entities, I have used the following setup, But Somehow data is not able to get stored in Data Store. To track the output of the write To Data Store Entity node, I have used an output variable, Now see the below Screenshots while process was in Execution, the process variable details I can see the storedValues is returning empty.  What's the wrong with the above process ?  Please help in this regard.

Hi, I am trying to understand the relationship between CDTs, data stores, and data sync and how they all work together. If I have a CDT with data sync enabled, do I still need a data store object? What is the role of the data store object when data sync is enabled for a CDT vs when data sync is not enabled? It sounds like having data sync enabled on a CDT is the most efficient way to go when possible, is that accurate? Thank you

Hello? Is there a way to bring back objects that has been deleted or disappeared to the application? Thank you.

Hi team, I am trying to return a hardcoded json value from an expression rule but I am not able to do so. I have tried even with escape sequences i.e, /" but still I am not getting the proper output. Could u pls help ? original JSON: { "uuid" : "6722c859-76b4-4aa8-ac82-3b3f93d903ba", "name" : "ContainerisedApp", "description" : "", "jiraId" : "REP-4783", "mappedCases" : [ { "caseUuid" : "8fcfc7a7-d989-4592-b321-d456460c7f0d", "casePath" : "ContainerisedApp", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 1, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "ValidateAppRej" } }, { "caseUuid" : "2e010c2e-6b4e-42c5-bea7-5cfe03f242e6", "casePath" : "ContainerisedApp", "runMode" : false, "reportable" : true, "caseExecutionSequence" :

Hi team, I am looking for a way by which I can delete a data from a data store entity having some conditions. For example, I am having a cdt having the following structure and values, ID - Name - email 1 - Jai - jai@vijay.com 2 - vishwaas - vishwaas@nahihai.com 3 - jignesh - jai@vijay.com Now above, id is a primary key but I want to delete the data having email as jai@vijay.com I am not able to achieve the same using a!deleteFromDataStoreEntities smart service. Can you pls help me in writing an expression rule which can delete the two rows (1 and 3 having email as jai@vijay.com)? Consider name of the constant for data store entity as : myDataStoreEntity

Hi community, I do not understand the different use cases for adding objects to an specific application or just referencing it (e.g. in an expression). Assume we habe 2 applications: app AAA app BBB Both use onjects from a a "shared" application "ZZZ" providing core functionality (e.g. an interface and other to manage comments) Let's say I want to use some commenting functionality in app AAA. My approach would be to just "use" (reference) the objects from the commenting app, but definitely NOT adding these objects to application AAA. Yet I have seen implementation where (in app AAA) some objects, e.g. ZZZ viewComments are added to the application using the same object in multiple applications. I would assume it would be a good idea to keep each application as isolated as possible. Thank you for some explanation! Dan

Hello... I am trying to  develop a simple HR application, with few tables like Employee, Department, Compensation etc. I have already created an interface for each table for CRUD actions.Now I want to create an interface for HR admin user, who can navigate to these interfaces to perform CRUD actions on these tables.So, I picked the interface pattern - Navigation. I see the left side links like Workspace, Tasks, Requests etc. I have replaced these items with my Interface names like Employees, Departments etc.  Now how do I link the Employee on left tab to load Employee Interface I have developed on the right section.  I dont find an option to load an existing Interface under section layout. What are my options/alternatives?  ThanksSuneetha

Hello, Is there a method to restrict the use of special characters other than "space, (), [], and <>" in the text field or paragraph field? Kind of thinking using validation. Thank you.

Hi Everyone, I have the requirement data is displayed to UI through grid and provided the facility to user to export data in excel using export CDT to excel smart service. But when user applies sorting on UI and click on export the downloaded excel is not in the same sorting. can anyone please suggest me how to achieve this? Thanks, Shubham

If I have a list of integers as inputs in an expression such as: 8.651.134;7.236.458;6.124.536 etc, how can I remove the thousand separator dots to leave them as 8561134;7236458;6124536?

Hello, If the function hour(now()) is used, the output value is the "gmt hour" instead of now() time. Is this right?  Then do I have to adjust the hour time by adding or subtracting time to make it match with my timezone? https://docs.appian.com/suite/help/22.1/fnc_date_and_time_hour.html Thank you.

Hello, Can "Multifactor Authentication" be applied to Appian Applicatoin login? When logging in to Appian Community, there is a Multi-Factor Authentication, and need something like SMS authentication to log in. Is it possible to provide these features to users in Appian Application login as well? docs.appian.com/.../SAML_for_Single_Sign-On.html Thank you.

Hello, I placed text field in the editable grid and applied required function.When testing in the interface, the required function is well applied after clicking on submit button.However, requried function does not apply when testing in the site page. Are there specific conditions for required function to be applied on the site as well? Could it be because I tried to use the required function in the record's summary? Thank you.

Hi!I create the interface as advised in the exercise, however, after I add the image component, the error message that displays does not disappear after I test the values. I type the following expression: : rule!AX_GetVehicleByID(1), I click Set as Default Test Values, then click Test Interface. After all this the error message is still there and prevents me from moving forward. Please advise! Thank you Rida 

I have two record types, what I am trying to achieve is, when I click on the Orderid (below) from record type one,    the second record should be displayed with only row where OrderId is 2345.   I have been able to display all the data (above image) from second record type but not the one which order Id I selected. Please help me with it.

Hi! I have an issue with refreshing a page. I've got a read-only grid and a delete button. After I choose some of the rows a press delete, which launches "a!startProcess" function; the problem is that I don't know how to refresh or redirect in that case. I have no rule inputs or variables...

Hi! Is there any possibility to use the same model for different interfaces? In my case: I have an interface where I insert an ID and delete the data with that ID, I used this interface as a start form for my process model. Now I created an interface with a possibility to select multiple rows in a grid and I want to be able to delete all of them by pressing a button. My question is: is there any possibility to use the same process model or I have to create another one? Thank you!

Hi! I'm working on a training project and my aim for now is to send an e-mail when a form is rejected.  I managed to send the e-mail, but I also wanted to mention in the e-mail the ID of the rejected data. However, when I use the following expression: =pv!customerDetails.customerID The rejected data is called "CustomerDetails" and contains a "customerID". In the process I also used a process variable - customerDetails, in which I save the CustomerDetails. I also tried to add an input variable which would have the id value inside, but I didn't manage to use it in the mail either. Thank you, in advance!

hey all ! I' am new to here, are you thinking using the Appian knowledge can get a job in a short time?  

Hi,       i am new to Appian. I am not able to find out why Appian agent ( AppianRPAagent.exe ) is not running in my windows machine. I just downloaded the agent i my system, I am using windows 7,  RAM 8 GB . But when i double click on the exe file it is not executing. What may be the cause?