General

I am getting some strange values from todate(). { todate("02/28/2025"), todate("02/29/2025"), todate("02/30/2025"), todate("02/31/2025"), todate("02/32/2025"), todate("06/31/2025"), todate("RR/28/B025") } It seems to try to auto-correct an invalid date to a valid date.  But it also seems to allow characters in the date which it evaluates somehow and comes up with wild dates as a result. First Question:  What's going on with todate() that it results in off-the-wall values? My scenarion is this.... I have a webApi that receives a json string which contains structured data that includes multiple date fields.  The webApi uses cast/fromjson to convert the json input string directly to a CDT that uses Date fields.  The CDT is passed to our expression rules that operate on the data. For example... CDT  (SH_Test) Expression rule (faking the WebApi) a!localVariables( local!inputString: "{ ""name"": ""Bob Smith"", ""birthDate"": ""GG/28/2025"",

Hi All, i have editable grid in my ui, on that i have textfield which i marked as required. (note: when page loads grid is disabled based on the button action grid will get enabled). but i have couple of validation for that textfield  that is working but with respective to required condition it is not working. please find below the screenshot and code snippet. Kindly help me on the same. a!textField( label: "Dental Members", labelPosition: "ABOVE", value: fv!item.dentalEnr, saveInto: { fv!item.dentalEnr, if( contains( touniformstring(index(local!editList, "intakeId", null)), tostring(fv!item.intakeId) ), { a!save(

I have scenario where, I need a link in email body, this link should open a current task for which we have different process model and interface, but I want to open that task in current step once I click on the link from email. How can I achieve that?

When I am trying to create pdf using this smart service if content contains other languages characters for example Hebrew language characters then it replaces with #, is it limitation of this smart service or we can fix it. 

in version 24.4 isuseractive function is not available, is there any other way to achieve this? I just want to validate if user is acitve or deactivated or even if doesn't exist anymore in the system, we are trying to validate the scenario if for any reason the user saved in DB was deactived or deleted from the system, cause currently we are saving the result of calling the funcion loggedInUser() in DB, this is storing a text value, however we have the requirement to display the fisrtName and lastName of the user in the frontend, but if the user doesn't exist in the DB we are getting  invalid user exception at the moment to use user(username,property) function, since we don't have a try-catch similiar function in version 24.4, I would like to know if there is any other way to catch the exception or change the approach following your recomendations. Any help will be greatly appreciated, thanks and regards!

Hi there, I hope you all are doing well. Has anyone been able to successfully install a local version of Appian on a Mac(M2, M3, M4 chips)? If so, what documentation did you use and how did you go about it?  Many thanks.

I have a folder containing several RAR archives that I need to convert into ZIP format for easier sharing and compatibility. Manually converting each file takes too long. Is there any reliable software or method that supports batch RAR to ZIP conversion on Windows? I’d prefer a tool that maintains file integrity and doesn’t require extraction. Any recommendations or step-by-step guidance would be appreciated.

I have a requirement in Appian.Let's assume I'm logging in from India, so my Appian application time zone is set to IST. However, the requirement is that — regardless of the user's time zone — all date and time values should be displayed in CST on UI How can this be achieved in Appian?

I have the following code snippet from an interface expression that is not updating the refresh variables. I have confirmed that local!refresh updates on record action as it is supposed to, but I cannot get local!selected_tasks or local!expired_tasks. I have tried multiple different configurations of the refresh parameters inside a!refreshVariable() as you can see from all the commented out portions, but none of them seem to work. I removed all of the record type references in the code, but I assure you they are there in my actual expression. Any insight would be greatly appreciated.local!refresh: a!refreshVariable( value: rand(), refreshAfter: "RECORD_ACTION" ), local!selected_process_ids: if( a!isNotNullOrEmpty(ri!clientSignOffProcess), ri!clientSignOffProcess[], null() ), local!selected_workflow: ri!clientSignOffProcess[], local!selected_tasks: a!refreshVariable( value: a!queryRecordType( recordType: , fields: { }, filters: {

Hi All, We have a simple requirement: a Record Type with ID (Primary Key), AccountID, and DataSeqNumber. I need to retrieve the MAX(DataSeqNumber) for a specific AccountID. The record type is AccountInfo. Could you share a sample code using a!queryRecordType with the Aggregate function "MAX"? -Thanks in Advance.

Hi, I have a form which has the checkboxes.  I have a screen to capture the inputs of the form from user where I am using multiple checkbox field to capture an answer.  Then I need to generate the PDF of that form.  I am facing the challenge to fill the tick mark or X in the box in the checkbox field in PDF.  How can I accomplish this? Any help? Thanks, Brinda Sateesh

i have a dropdown list with values as links which are to be opened upon selection in a new tab?

Hello guys,I wanted to ask if there is any way in appian to execute a process if no action was taken after a certain period of time.My scenario is very simple. I do have a process model that updates the task status to completed through a script task, save the changes with write records and sends an email notification afterwards.What I am trying to achieve is changing the status to completed if no action/button click is taken in lets say a couple of days. 

I have created a new appian account and emailed community.appian.com from the new account to transfer the certifications to new account as my old account was deactivated. How may days will it take to transfer it new account. Could you please help me here.

Is it possible to build a web api in Appian to receive documents through multipart/form-data as body?In my case appian is adding following metadata and making the file unreadable(corrupt) --TnQmfygKfP801A_kE1bGL-7YAFk_k6gl9 Content-Disposition: form-data; name="file"; filename="Profile Picture.jpg" Content-Type: image/png Content-Transfer-Encoding: binary

Hi all, I'm working on a scenario where, upon opening the Appian application in the user's browser, we need to execute JavaScript to retrieve an XML file containing contextual data from external Proteo 4 applications. The goal is to use this data to continue the process in Appian with all relevant information from the previous application, without having to pass everything through query parameters. What the client wants to achieve: Execute JavaScript or listen to window events when the Appian application (or interface) loads. Retrieve an XML context file based on an ID passed via the URL. Convert this XML to JSON so Appian can consume the relevant data. Store and use this contextual data within Appian to restore or continue the user's workflow seamlessly. Has anyone encountered a similar situation where JavaScript execution or window event handling was needed to retrieve external contextual data on Appian startup?How did you approach it? Are there any best practices, work

Hi, I received mail saying I can't get my passed "Appian Certified senior developer" certificate since I don't satisfy the pre-requisite which  I was not aware  of for the exam. So, My question is if i pass "Appian Certified Associate Developer" will I get my " Appian Certified Senior Developer" certificate?  or again I have  to reappear for the same? Thank you.

Hi, I am generating PDF from DOCX  value is displaying correct in doc file , but it is overlapping in PDF How to reslove this ? DOC FILE: PDF :

Hello All, While updating CDT, got below error An error occurred while trying to write to the entity "SEC_IPOMarginMapping" [id=a6da64a0-8b67-4c95-9eee-0073b364a76c@705410, type=SEC_IPO_Margin_Mapping_List (id=9412)] (data store: SEC Securities DS). Details: javax.persistence.EntityExistsException: A different object with the same identifier value was already associated with the session : [SECIPOMarginMappingListDT22360#2] Data: TypedValue[it=9413, v={array of values}. The Unique identifier column is set to auto increment. Please advise. Regards.

Dear Team, When I am working on a case in workspace, I observed that unless I manually change the case status and assignee from the 3 dots button, these fields do not change automatically. Is this an expected behavior? For example, even if all the tasks of a case are completed, and I manually do not change the status, the status remains "open".

I passed the ACD101 certification exam, where can I see the breakdown of how many answers I got right by category? The screen closed immediately after I finished the exam.

How to remove duplicate letters from the string without changing case of letters input "Deleted" output "Delt"

I have a textField that I do not want users to be able to enter in a space unless it is a part of the case number. For example, users should not be able to enter this:  But if there are spaces in the case number, then it should be allowed I've tried regexmatch, I've tried a if / isnullorempty statement  example:  if( a!isNullOrEmpty(ri!notice), "Case Number is invalid.", null() )

We currently have a system that allows users to upload documents. We are currently filtering out password protected documents using the ispasswordprotected() smart function. Recently we encountered a document that was "Restricted" (Please see attached image). Is there any function currently within Appian that allows the system to check if a document has any "Protections" on it at all. the above smart function does not account for the additional types of protections outside of passwords. 

I have a requirement where I need to send reminder emails to clients one day before at 9:00 AM as per their respective timezones. My environment timezone is Australia/Melbourne, but clients can belong to different timezones (e.g., Asia/Kolkata, Europe/London, America/New_York, etc.).