General

Hi all, I have an API to call from our application, in which we need to send message timestamp in ISO UTC format "2025-04-02T15:57:77Z" So now apart from formatting the date time with concatenating T and Z, do we have any other function which can directly convert time to this? 

I can see appian is allowing to give lead developer exam directly, is that possible without associate and senior certifications. Please tell your thoughts about it.

Hi all, I’m getting a 403 Access Denied error when trying to open a workspace. There’s no visible owner for this workspace on my end. Does anyone know if access must always be requested through Appian Support, or if there’s another way to resolve this? Thanks in advance!

Hi, Can you please help me how to give validation to the Textfield, where it should accept only Alphabets. If any special characters or numbers entered it should throw an validation error message. Is there any function is there?

Hi everyone, With Appian 25.3, a new version of a!queryRecordType() was introduced, and the previous version is still available as a!queryRecordType_25r2(). This evolution brings more control and clarity over which fields are retrieved. Key difference between the two versions 25.2 - a!queryRecordType_25r2() When no fields are specified, all base record fields are returned automatically. Even if only relationship fields were passed, the base record fields would still come back unless explicitly narrowed down. 25.3 - a!queryRecordType() When no fields are specified, only the primary key (id) is returned. To retrieve all fields, the new a!selectionFields() function should be used with its allFieldsFromRecordType parameter. Why this matters for wrapper rules In our applications, most queries are wrapped in a reusable rule that takes a single fields input. Callers of these wrappers don’t (and shouldn’t) need to worry about the function version or its internal

Hello,Consider the following test code: a!localVariables( local!Torerance_Name:"Mean", local!test_0: and( local!Torerance_Name = "Mean", "15.0" ), local!test_1: and( local!Torerance_Name = "Mean", "8.2" ) )Here test_1 has value : false and test_0 has value true.What is the cause of this? Please find the screenshot as follows:

Hello Everyone, Is there any approach to retrieve a user's last login details without accessing log files? For example, is there a function or method we could use to capture login information when a user accesses a specific link or application? Thanks & Regards, Srikanth.

Dear Support Team, I am trying to schedule my Appian Certified Associate Developer exam, but I encountered the following issue when accessing ProctorU: "This Institution does not permit creating a ProctorU account. Please navigate to your course Learning Management System for scheduling and rescheduling ProctorU reservations." I attempted to register directly on ProctorU, but I was not able to proceed. I understand that scheduling must be done through the Learning Management System, but I am unsure where exactly to do this inside Appian Academy. Could you kindly assist or guide me through the correct steps to schedule the exam? Thank you in advance for your support. Best regards,

Hi , when we are uploading the document in the folder directly is appearing in the recent objects with the uploaded time.but when the document is uploaded or generated by the flow is not appearing in the application recent objects.we have to go into the specific folder where we configured to store and there only we can find it specifically.those kind of documents are not appearing in the all objects.why is the difference.

Hi, need suggestion for the following requirement. We want to place a CSV file generated through Appian within a specific folder path in NFS(Network File System). Appian runs in an EC2 AWS instance and the NFS is a on-prem file location. We are not permitted to mount the NFS and hence looking for solutions.

This is my usecase. i have editable grid of data  and also providing user to do the (custom) filter and sorting. But now user want the export those data into excel.we have used EXPORT DSE to Excel smart service to do that. But here the challenges is user applied sort is not working when we export the data. I don't know how to configure that. Can anyone help me here.

I have a read only grid that is supposed to populate with all entries in a record with a certain flag and put that into a read only grid. The problem I run into is that despite the grid displaying only 3 entries at a time, the query keeps timing out because of how large the number of entries is. I need all entries to be available for my functionality and it is set to load as async. Is there a way to bypass the query timeout error?

Hi , I have a multiple dropdown inside a grid layout , so choice values for that dropdown  previously static one coming from database , but now we have changed it as cascading one based on condition the dropdown choice value will change. Now the existing request are all throwing error. I thought of based on the request created date to change the choice values to be selected but i am not sure where that condition can applied inside the dropdown choice or before , because for new request also for choice values i have applied some if condition . Its not working properly. Can anyone help me to identify the option which is efficient?a!localVariables( local!fundlookup: { a!map(lookupId: 1, value: "Comment A"), a!map(lookupId: 2, value: "Comment B"), a!map(lookupId: 3, value: "Comment C"), a!map(lookupId: 4, value: "Comment D"), a!map(lookupId: 5, value: "Comment E"), a!map(lookupId: 6, value: "Comment F"), a!map(lookupId: 7, value: "Comment G"), a!

I have below grid of data but i want to sort the below data by Month. User have dropdown option to select sort field as month and sort by like ascending or descending. The challenges am facing here is , since we kept month as text field its sorting in an Alphabetical order. can anyone help how do i do the sorting to get the month in a calendar order (Jan to Dec). Month        Vehical Brand    Repair  NewApril           BMW                 Yes      yesJanuary     Tata                    No       yesDecember Toyato                yes      No March        Audi                   Yes      yesMay           Kia  &

I'm facing an issue related to timestamp precision in an Oracle table that’s used with Appian. The table has two timestamp columns: one with zero precision (Datatype - TIMESTAMP(0)) one with six precision (Datatype - TIMESTAMP(6)) When I insert data into these columns without any triggers enabled, everything works as expected: the zero precision column doesn’t include milliseconds, and the six precision column includes milliseconds. However, when I add a trigger to the zero-precision column, I get an error saying the actual timestamp precision is 7, but received 11 even though the column is defined with zero precision and the trigger only defaults it to SYSTIMESTAMP if null. Why would the trigger suddenly cause exception , wanted to understand the logic better 

if( rule!APN_isBlank(singlePV: ri!date), "", /*left(text(ri!date, "mmm",3), ri!format))*/ left(text(ri!date,"mmm",3), ri!format)) Following is the error  Expression evaluation error at function 'text' [line 7]: Signature length (2) does not match parameter length (3)

Hi i have a process variable called request_data which is cdt type and in that there was one column called casettnotes which is a cdt casenotes cdt has currently 4 rows of data in that there was a column casenote which i need to update which is 4th row case note column data for this i dont have primary value it was null so i tried using other column which is issuetype like if issuetype is failed then update casenot for that issue type like that, all i want the casenote column which is 4th row column in casettnotes cdt need to be updated how to acheive this tried using many alforeach with update function but nothing working kindly suggest on this

Hey everyone, I need to use the Fill PDF plugin in my Appian project. I have to create PDF documents where users of my application can add items, such as their name. I've built an interface that includes a 'paragraphField' containing the text of my PDF. I've used this interface as a form for my Fill PDF plugin. Can anyone help me better understand how the Fill PDF plugin works? I couldn't find any documentation.

Within the Appian interface, the date field typically accepts dates separated by a forward slash ("/"). However, in our use case, there are scenarios where we need to support dates separated by a hyphen ("-") or a pipe ("|"). To accommodate this requirement, I’ve written the following piece of code a!localVariables( local!onlyNumbers: cleanwith("1.22.1957", "1234567890"), local!length: len(local!onlyNumbers), if(local!length = 8, concat(left(local!onlyNumbers, 2), "/", mid(local!onlyNumbers, 3, 2), "/", right(local!onlyNumbers, 4)), if(local!length = 7, concat("0", left(local!onlyNumbers, 1), "/", mid(local!onlyNumbers, 2, 2), "/", right(local!onlyNumbers, 4)), null ) )) It seems that the Appian interface is not executing the logic as expected, and the error still persists.

I suddenly find when I use Dependents to check the dependents. I can not see any process model in the dependents tree. I also check the other env, they can see it normally. I want to konw why it occurs, is it wrong setting or a bug of Appian. How to fix it. 

I am planning for ACD300 certification so anyone kindly share valid suggestion

I'm getting this error in my application  I call the interface with the upload field in the forms and at one of the primary buttons i call the function a!submitUploadedFiles().    "at function a!buttonWidget". I cant understand what can i do for this to work. Already checked the version of the buttons and forms. It's all up to date. Can some help me ? 

Hi all,  i'm encountering trouble with my Admin Profile in a Cloud enviroment. Whenever i try to open properties of a node in Process Modeling or in Modifying a Process, i do not see all the related tabs but only the languages tabs.  Here is a screen:  This problem is present only in production enviroment of a single cloud system. In test, dev and production of other client i dont have this problem.  I've checked my profile in Admin Console and try to find difference with other admin profile that works perfect, but i dont seem to find any.  Tryed even to change browser and cancel cookies and chronology but without any success?  Does anyone encountered and knows something about this problem?  tks for reading 'regards

I have a form where we are showing multiple sections which is collapsable. I made couple of sections as collapsed initially thinking that contents would not load until user expand the section. But its not the case, contents are still evaluating even if section is collapsed by default.  I need certain data to be collapsed to improve the initail loading screen and need to do validation on clicking submit even for collapsed one. Section layout is perfectly doing the validation but its loading the contents in the background. Any suggestions or thoughts?

Hi together,I have a "map" value in a process. I realized that an IsNull/emptycheck rule I used in a gateway down the line, was failing of evaluating that there was (in my understanding) an empty valuecast( 'type!{http://www.appian.com/ae/types/2009}Boolean', length(a!flatten(ri!value)) = 0 )Even the new rules a!isNullOrEmpty ..... are not recognizing this properly. Does anybody experienced this as well? (not difficult to solve, but it was pretty unexpected) Kind regards, Richard