General

I am currently using Smart Service "Import Excel to Database".  The process works fine if I upload an Excel file with correct column headers and data values. In the excel file I purposefully changed the data values like changing a date value to a text value XYZ, changing Text value to a date value. When I upload this modified excel file: 1. The process does not error out. Process Model is showing everything as success. 2. The incorrect data did not get inserted. But my question is, how do I catch such data errors? I thought the Smart Service "Import Excel to Database" is going give some information on the errors. Please advise this.  In the real world we will not have perfect data all the time. Hence trying to figure this out. Regards, Mahesh

I am just looking at this rule and find this unsupported function can anyone tell me that what is the behaviour of this function .reduce( update_unsupported(_,_,_),{},{} )what we can use instead of update_unsupported to remove (_,_,_)

I have a process for bulk action in a grid, in which there is a MNI, in each instance it writes records to db. I want all records auto update after user submit without extra refresh. How can I achieve this? Currently only one row can be auto updated, rest of all need a refresh to show latest record

Earlier today I was helping another developer understand an issue involving links using a urlwithparameters() function. They were experience an issue where a datetime passed as a query parameter was reading out one minute behind in the linked interface. When I investigated the issue I noticed that the query parameter was showing as a timestamp; however when I ran some small-scale tests I noticed when I passed datetimes as query parameters they were formatted appropriately (see screenshots for context). Ultimately what we discovered is that their use case they were passing two parameters, one an integer ID and the other the datetime. In my testing I was initially only testing with a datetime. When I included a similar integer parameter I was able to get the odd behavior to replicate. The solution for us was to cast the other parameters to strings. What is more interesting is that the behavior only occurs when the datetime is taken from a record. If I replace the datetime query param wit

I have configured showExportButton=true in my grid, I wonder if it is possible to specify the columns I need for export

We are planning to build an application using Appian that will be used by 5 to 10 users. According to pricing, we fall under the ≤ 200 users category, where each user costs $75. My questions are: Do we need to purchase licenses for each user (e.g., 5 users × $75), or is there a minimum user (threshold) purchase requirement that applies regardless of the actual number of users? If there is a minimum purchase requirement, what is the minimum number of users we would need to pay for?

I have connected to the proctor and confirmed my details related to my exam. My proctor asked me to open the camera video, but the camera froze in between the verification process. The proctor asked me to restart my system but the same error is going on. i have try many times but not able to solve the problem, i did not aware with this error before. than proctor told me to connect to the support for retake the exam due to this condition and problem. can i get a reschedule coupon for it

When I try index({1,2,3},{3,4},"") returns {3,null} whereas index({1,2,3},{3,4},{}) returns {3,1}. Looks like when curly brace is put in default parameter, when there is no 4th index, it goes back to start and picks the first index. i don't think this behaviour is captured in documentation either.

I had exam today due to some reason I lost my Internet Connection and proctor told to me we cant start exam due to inconsistency of my Internet and she marked it Incomplete.I have sent email on Appian Certification and Appian Support to have it rescheduled but I haven't heard anything yet. If anyone help me that would be great.Thanks

I can't find my exact issue, so I'm starting a new thread.  I created two interfaces - one that shows a single survey and its answers in a grid and the user can download the data to Excel. That works fine. Then I made a copy of the interface and instead of filtering on a survey the grid displays ALL surveys and answers. However, when you try to export to Excel, I get the error "Couldn't Download - Network Issue". The number of records is LESS THAN  20 and so it's not a size issue. This happens in the DEV environment. I haven't tried it in the TEST environment because I'm not ready to push my code yet. Any thoughts why? 

A very helpful addition to SAIL programming would be single-line commenting. The current block commenting method creates hassles when commenting and uncommenting chunks of code for troubleshooting, or when nesting comments, should we follow best practice and document functionality with /* Dev Notes */. We are currently unable to block-comment with single /* and */ around a section containing actual comments (nested), the first trailing */ ends the surrounding block comment early. This occurs when collapsing a large section spanning a few pages, and add these 2 lines around the collapsed section, which is sometimes easier than highlighting multiple pages for ctrl+/. Example: /* a!boxLayout( label: "Submitter Info", marginBelow: "STANDARD", contents: { /* Submitter Info */ a!textField( value: loggedInUser(), readOnly: true ) } ) */ Additionally, if you highlight a section containing comments, ctrl+/ to comment all, then ctrl+/ to uncomment all after troubl

Good morning, We have an Appian configuration with three servers. I would like to know if anyone knows whether I can access the log data-metrics/system.csv from the other two servers from any of the three servers, and how I could do it? Thank you very much

I’m currently exploring the benefits of the Appian Instructor-Led Course and wanted to get some insights from those who have participated in it. Specifically, I’m curious about the following:  Does the course provide access to an upgraded instance similar to a real-world production-like environment, or is it limited to the Community Edition for practice exercises? Benefits over the online free course provided other than personalized training

Hi Everyone, I have a use case where I need to get the date difference between two dates ; but using the calender available in Appian. Due to some performace issues, all date differences I am doing in stored procedure and calling the same from Appian to get the value. But If I have to consider Appian calender, how to pass to the stored proc, so it will provide me the correct date difference considering the calender. Regards, Ghanashyam

Hello All I want call Procedure that take more than 300 seconds.   when call it using expression rule the result is (ORA-01013: user requested cancel of current operation) and maximum timeout is 300 second how can I call this procedure?? Is there a plug-in that increases the maximum timeout?

In the Pricing Model of Appian Software, it mentions - This represents the entitlement per application for Standard User, Advanced User, and Premium User. For Platform - Standard User, Platform - Advanced User, and Platform - Premium User, this represents the total entitlement across all applications. What exactly is the difference between a "Platform User" and an "Application User" ? 

Lets say I have an Interface with 2 Dropdowns. Lets call them Dropdown1 and Dropdown2. Both have Values Yes and No. If User selects Dropdown1 with Value Yes, then Dropdown2 should automatically be set to No and it should be greyed out or disabled so that User cannot change it to Yes. Please advise how we can accomplish this. Regards, Mahesh

HI All, Example -- I am forty-five years old. from above text i need to get 45 in integer form. How to achieve this? Thanks, Ganesh. 

I am currently reviewing the Appian pricing structure and plans, and I’m a bit confused about the difference between "Platform User" and "Application User". Could someone please clarify the difference between these two types of users in terms of access and entitlements?

There is a requirement to trigger a scheduler at 2 PM , 10 PM and 6 AM. When scheduler will trigger, it will invoke an API by passing the last execution time to fetch set of data between last execution time to current time. Say for an example, if scheduler runs at 2 PM, then it will pass 6AM as parameter to the API so API can return data between  6AM to current time (i.e. 2PM )interval. any suggestion how to implement this following the OOB configuration? TIA

We work with several clients. Some want their environments in spanish or portuguese, so most of our envs are in english for our dev team and the client's requested language.A LOT of time is spent with naming our process nodes twice: once in english when we develop, and the other in whatever other lenguage the client wants. The only reason we do this is because Appian won't let us deploy packages if even one node in a process does not have the other language node name.This really hinders the devexp for something no one will see. Is there any configuration to allow for English to be a fallback language for the process? Lets say the process has no "Spanish (MX)" names attached to the nodes. In that case, appian would automatically fall back to whatever other name the developer added to the node (in my case "English") 

Hi Community,   I am working on a POC where a third-party system interacts with my Appian Web API. The setup involves the following: 1. The third-party system is configured to call my API endpoint: https ://appianCloud.com/suite/webapi/endpoint1 for a GET operation to retrieve data using query parameters. 2. In subsequent calls, the system appends /action or /response to the same endpoint URL and performs a POST operation to modify the data for the same record.   Given this requirement, I would like to know: • Is it possible to handle this type of scenario within a single Appian Web API object? • If not, are there any known workarounds or best practices to manage such dynamic operation variations?   Looking forward to your insights. Thank you in advance!

We got the above error from production. We are not able to replicate the error in lower environment. Can anyone tell what is the root cause of this issue?

Hello! We are in need of a Slovenian locale/translation for appian and I'm wondering if any of you have any suggestions as to how would we be able to get that specific locale? Is there any way to do a custom translation and import it into appian?  Thanks, Jan

Even i gone through the documentation i cant get the exact difference plz can anyone explain in easy and simple words