Foundation

Hi! I'm working on version 24.3 with Spanish as the primary language, and I've added a document upload component (a!fileUploadField) to an interface with validation to receive only an XLSX document. I used a file originally with an .xlsx extension and it validates well, but if I manually change the extension to .pdf so it converts, for example, and then upload it, I get an error that I didn't capture in my validation: "File could not be uploaded. Reason: The file extension does not match its underlying file type." It doesn't actually upload the document, and the error persists even without the attached document. Or if I upload another correct document, I have to refresh the entire page for it to stop appearing. Is there a way to bypass this validation and just leave the one I have manually, or is there a way to update the validation when a new document is uploaded?

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".

Hello everyone and please help with this request:  1. Class Member Status Updates: We need class members who were enrolled in MH sessions to have their status updated from Active to Closed. When end dates were entered at the time of closure, we assumed the status would update automatically, but it appears those cases are still showing as active in the database.

Hi Team, I am facing issue while trying to append the data to rule input , I have editable gird with multiple components with add and remove option using same component i.e dynamic link, so I am trying to update/add some data based on the item getting added. Its working 1st time , if i change the plan, scenario they are like button to navigate. i try adding it to different plan its not appending  it. only 1st time added data is reflecting. localVariables( a!localVariables( local!customDataforNewPlan: { a!map( prcRequestId: 1, wmsRequestId: 101, annualfee: 1000, minimumfee: 0, sequence: 1, amount: 500, createdby: "user1", createdon: now(), updatedby: "user1", updatedon: now(), isactive: true() ), a!map( prcRequestId: 2, wmsRequestId: 102, annualfee: 2000, minimumfee: 0, sequence: 2, amount: 1000, createdby: "user2", createdon: now(), updatedby: "user

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.

Hi Everyone,I am trying to export a view from DB using "Export DSE to Excel" smart service but often it's failing throwing the error.The view is a simple view with 13 columns and with hardly 5k data, we are using filters also when we are trying to export using that smart service but still it's failing.Any leads would be appreciated.Here i am attaching the error i am getting.Thanks in advance.ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=28413, classname=com.appiancorp.process.runtime.activities.DataExportEntityExcelSmartService2 com.appiancorp.suiteapi.process.exceptions.SmartServiceException: Error accessing data store entity: Entity_Name. Please contact a system administrator for additional details. at com.appiancorp.dataexport.strategy.QueryExceptionStrategyDse.getOriginSpecificException(QueryExceptionStrategyDse.java:20) at com.appiancorp.dataexport.strategy.QueryExceptionStrategyBase.makeQuery

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

I have 2 synced records. The first one is notice and the second is notice history I have a grid that displays info from the notice history record, and I am trying to sync it when the related record of notice is updated, but it is not syncing.. My record type is: recordType!BTTNoticeHistory My identifier is: pv!notice[recordType!BTTNotice.fields.noticeID] Any help would be much appreciated!

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 have to trigger reminders to user a day prior 9 am their local time. For example, if user is from Asia/Kolkata time zone then he/she should receive the mail a day prior 9 am IST similarly if user is from Australia/Melbourne time zone he/she should receive the mail 9 am AEDT.Can someone please help with the approach?

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.).

Hello, we have implemented a send email and receive email process to process. When the send email process is activated, the receive process doesn't receive the email. The destination process ID is configured correctly. ¿Is there a log to identify what might be failing? Thank you very much.

Team, We are on 17.4 version and trying to remove all process instances from one of our lower environment around 100k+. Do we have any function or plugin which we can use to delete them at once instead of manual deletion . Thank you.

Hello folks, I would like to understand the Start Process SS behavior. From my understanding, we no longer need to perform chaining inside a child process if the child process is configured as a Synchronous Start Process. Below is the configuration I applied for one of my record-related actions. Here once action is completed we re query  the audit data in the interface which is set in refresh variable and refresh after "RECORD_ACTION". But this is not working as expected. I have to refresh the entire screen to get latest audit data. But if i put chaining between start process(Write audit) and end node, page is refreshing as expected and getting latest audit data.Please let me know if it is expected behavior. Thanks in advance

Hi all, May I please ask for some guidance here? I've got three record types: Consultant  Consultant Recipients  Consultant Emails To ensure data accuracy, I want to write all records records at the same. That way if the Consultant Certification write failed, there wouldn't be an entry in the Consultant Recipients  or Consultant Emails and vice-versa. Based on the following documentation is possible to do in one single Write Records Node: https://docs.appian.com/suite/help/24.4/Write_Records_Smart_Service.html#_ But when I try this, I see the related data in the interface itself under the main Consultant record - but when I pass it in the PM the related data shows as null. Thank you so much!

Hi all, May I please ask for some guidance here? I've got three record types: Consultant (a person, e.g. an Appian developer) Consultant Certification (certifications the consultant has, e.g. Appian Associate Developer) Consultant Audit History (audit log of changes to various parts of the consultant profile and related record types, e.g. updated a certification's expiration date) docs.appian advised against using Record Events to track changes to an individual record field (e.g. certification expiration date), so I created the Consultant Audit History record type. When the certification expiration date field gets updated, I want to add a row to both the Consultant Certification table and the Consultant Audit History table.  To ensure data accuracy, I want to write both records at the same. That way if the Consultant Certification write failed, there wouldn't be an entry in the Consultant Audit History and vice-versa. Is it possible to do this in

Hi all, I'm currently designing a post-deployment process and I need to be able to query database tables dynamically based on the application being deployed. I’ve tried using the Query Database smart service with variables such as ac!table, but I get an error each time. I’ve also tried setting the full SQL statement in an ac! variable to create the complete query and pass it, but this approach hasn't been successful either. Has anyone encountered a similar issue or can suggest a solution to dynamically query tables based on deployment context? Any insights would be greatly appreciated! Thanks in advance!

The variable sequenceNumberTwo has multiple values and I am looking for each value to be sent to GET Transit Image Front and GET Transit Image Back.  Can you help me achieve this?

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? 

Hi All, Is it possible to send custom email when the user reassigns the task using Appian default action 'Reassign' in a task instead of default email? I have a scenario where I need to send custom email for both task assignment and re-assignment. I can send custom email for task assignment (will uncheck default email), but if the user clicks on default 'Reassign' button, then no emails will be sent right, so please let me know if there is a way to achieve custom email using default Reassignment? Thanks in advance!

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.