General

HI, Does appian takes care of Day-light saving when the time changes in winter?

I am trying to build a simple application which allows users to log hours worked. In the summary page, there is a table of logged shifts, and the ID field has a link to a page with details about the shift with the particular ID. I have an Expression Rule called TST_getTimesheetSubmissions which returns an entity with specified a!queryFilter( field: "id", operator: "=" Currently, in my summary view, I have the following configuration: rule!TST_TimesheetSubission( TST_timesheetLog: rule!TST_getTimesheetSubmissions(rv!identifier).data[1], cancel: null, readOnly: true ) The page loads without any error. However, the hyperlink from each ID redirects to the same entity with ID=1. Can someone help me fetch the appropriate row of data from the table? Thank you!

I've been following a tutorial to build a simple system which allows users to record their work hours and date. When I try to edit record type using rf and rp, I receive an error message "Improper scoped variable". For example, I try to edit the "summary" view using the rules defined in an Expression Rule: rule!TST_TimesheetSubission(rule!TST_getTimesheetSubmissions(rp!id).data[1],null,true) I receive an error because I have rp!id, and  and when I try to edit the List so that the ID of each row becomes a hyperlink to an individual page about the shift logged, I have: - Label: rf!id - Record Type: rp!type - Identifier: rp!id the above three get an error, so when I access the Site, I receive an error "The Requested Record Type Is Not Available". Before the edit, it is a Text field and uses fv. How do I access rf and rp, or alternatively, how do I use the rp equivalent with fv to fully display the page? I'm new to Appian and the forum, if I

I have an array where I would like to replace the zero values with the previous non-zero value. i.e. convert { 15, 0, 0, 23, 0, 0, 0 } to { 15, 15, 15, 23, 23, 23, 23 } Any ideas?

My requirement is to find out all the unused objects of the Application, unused rule inputs from of the Interface and unused Process variables from the Process Model. I know manual work is very lengthy so can someone suggest me any shortcut method or any plugin can help in this. Thanks in advance

We have a requirement where user wants to upload bulk data in Appian. A file upload option in an excel or CSV format is desired. Once uploaded, the file contents should be written to DB and later available for user to view data in a grid format. File can contain a maximum of 200+ columns & 10K rows. What is the best practice to address this requirement in Appian. Thanks in advance.

Hi All, i am getting following error on my summary view. Error Evaluating UI Expression Expression evaluation error [evaluation ID = EEBZL4J1] in rule!APN_qry_xyz at function a!recordBodyWrapper: An error occurred while retrieving the data. Details: Cannot open connection (APNX-1-4198-000) I can see rest of my code(expression rule, qry rule, interfaces, integration and all other objects) working fine except summary view. Kindly help me. Thanks in Advance.

In case that we developed an application system through Appian and have it delivered and implemented to our client, one of their documentation requirement is the full source code of the application/ system given to them. Is there an option or facility in the Appian that we can generate the full source code of the built application? Thanks..

Please provide the code for printing the below pattern: a ab abc

Hi , we are using Export Data Store Entity to csv smart service (pipe delimited) and for few columns ' and " prefixed/suffixed in the generated csv file even though it does not exist in the actual data. Below is sample data: -  Phone number in the database is started with +, but generated excel column has ' prefixed - Actual text in the database doesn't have the " but there " prefixed and suffixed in the generated execl.  Observed ' is appended when there is + in the beginning of the string and " are getting appended in a couple of scenarios. Is this the expected behavior of plugin? how can we avoid these characters?  pls advice.

Hi, I am not sure if I get it right but I am now trying the hands on for the low-code app in the Free Trial version. I am following what is indicated in the lessons but i can't seem to proceed to in Picture 1 after I created Group, Folder and then Record Type. In the video, once he saved the added Record Type he was directed to Picture 1 but when I tried, it only saved and only stayed in Picture 2. Did I miss something? Thanks for your help! PICTURE 1: PICTURE 2:

Hello. In my send email activity, part of my message logic uses the workday function in an expression. =if(  isnull(pv!request.value),  workday(today(), 5),  workday(today(), 6)) While testing last night (July 1st), we expected the date returned to be 5 working days ahead (July 8th) since the value is null (verified). The resulting email was 6 working days ahead (July 9th). My only assumption is that Independence Day is observed on Monday, July 5th so the workday function excludes Monday in its calculation. Is this true? The workday function allows for an array of holidays to exclude, but the sample seems to want specific dates, not just a identifier of the holiday name. Are we expected to write every year of dates? It can be done, but was just interested in this approach.

Hi, I have a scenario where my Database is in GMT and I am trying to convert it to EST time by using GMT function  gmt(property(local!data,"XXX",{}),"EDT") its working fine during night time but when this function is executed during day time its giving current date-1. Any solution for this would be really appreciated.

Hi all, I am getting the following error when I try to execute a robotic process in Appian RPA console: [ERROR] 2021-06-17 10:27:07 33s (0h) - Exception thrown on agent...com.novayre.jidoka.client.api.exceptions.JidokaBrowserInitFailureException: Browser initialization failure. Make sure the browser is installed and the driver version is compatible with the browser version. Can someone please guide me to fix this issue? Thanks in advance, Brinda 

Hello everyone, I kindly ask for a piece of advice doing this query. I have a CDT called PurchaseOrderDetails and another one called ProductOrderedDetails. In this case, my PurchaseOrderDetails is pointing to an array of ProductOrderedDetails, like in the image below. I was wondering what can be done in case I want to get all the information regarding the ProductOrderedDetails for a specific Purchase Order. I already tried a few variations pointed in this page (https://docs.appian.com/suite/help/21.2/cdt_design_guidance.html) but I'm still unable to retrieve that information. In the MySQL database, the PurchaseOrderDetails doesn't have a specific column called "ProductOrdered", but my ProductOrderedDetails column has one called: On this case, what it's the best way to build queries around nested CDTs like this example? Kind regards

I have just started exploring event management part of appian and I have few doubts, 1.  If we configure start node in process model with receive message event with config 'External to Process' it would mean that once message arrives from an ext system the process would start.     Doubt is that how would external system trigger this event? what component or configuration would be used by external system? 2. What is the difference if we, - configure start node with receive message event (with external to process config) - if we create a web api with start process configuration  as these both would allow external system to start process Any leads would be appreciated.

I am working on a interface where in top of header of interface I am showing count of any column data for eg: comments(15), and it fetch from data record view .I want to refresh this record view when I will click on submit button on my present  interface, but refreshing is not working for record view. Please suggest the best way to implement this functionality.

Hi, I recently subscribed to Appian Free Trial to evaluate this for our company. Upon login, it offers guided learning experience and courses. I am already in lesson 5 and I haven't tried simulating the Admin Console. Is there a way that I will have an access in the Admin Console so that I can try developing my own site/ program?

Hello, I have a question regarding the text field type within a CDT. This type has a character limit of 255 characters. Is there any way to increase this or is there another type that is used for longer form text such as paragraphs and paragraph fields within an interface? Thank you.

Hi  We have a requirement to show the data in the grid and we are using recordtype in the interface.  Steps followed: 1) Created recordtype 2) Using read only grid (RecordType option)  Everything seems to be working but all of a sudden site throws error with the following message even though the record type and it's security is proper. Screenshot is attached for your reference. And this error will be resolved once the interface or recordtype is opened in the designer mode(No changes done) Any help would be appreciated. Thanks in advance.

Here is the error when we tried to import our application into a trial environment. Thank you. group _e-0000e684-5738-8000-9b2e-01075c01075c_368 "ABM_Admins": An error occurred while creating group [uuid=_e-0000e684-5738-8000-9b2e-01075c01075c_368]: Insufficient permission (APNX-1-4071-007)

Hello everyone, Our client asked for a requirement where we should allow our users to subscribe to a "watchlist", allowing a user to click and be aware of any kind of changes that occur on a specific object and receive a notification (email, mobile...) whenever the object suffers any change. What would be the best way to accomplish this? Does Appian support this function OOTB? I couldn't find any information regarding this process. Kind regards

Hi, Is there any Notification (bell) functionality is available in Appian. I am implementing a interface where I have to show all recent (only new comment's)  count group wise. Please suggest the best way to implement this functionality.

Hi, I have to implement  @mention tag  functionality in appian inside Paragraph field. example : If  I type @a inside Paragraph field then it will be show all the "a"  name user from that group user  list inside Paragraph field. Please suggest the best way to implement this functionality.

HI, The appian health check was scheduled on specific day in non prod environment but it has not run and stopped at a node with the following error "The number of tasks per node for 'Wait' would exceed the limit of 1000". please suggest me how to run the health check in non prod or how to overcome the above issue.