Foundation

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 doubt of different operator options available for script task output tab's custom outputs .  It have   3 options . I always used  is stored as .There is option called is appended to list . It was used in our applications existing functionality flow . But I couldn't understand it. Can anyone have any documentation related to it ?

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

Hello,  I have a simple form with 2 textboxes and a read-only grid. Text Boxes are "required" Grid is selectable and set to "selectionRequired :true" Submit button is set to "validate: true" Issue: 1) When the from is initially displayed and i click Submit button, the "required" validation works only for textboxes and after entering inputs into textboxes, i am able to submit the form. The required validation does not work on the grid. 2) however, if I select a row in grid and unselect it and then click submit, the "required" validation works and message is displayed. not sure if I am doing something wrong or if this is Appian bug.  Please let me know if anyone else faced this issue. JR

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 , we are using sync record in process model, and syncing the case details but in output of record its not storing the PV of case details. the same process model íts working in DEV envionment but recently we deployed to production then in production its not working the flow., could you someone suggest me how to figure it out? thanks

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 am trying to run a process that uses the Execute Stored Procedure Smart Service. The stored procedure can run based on 3 values (either the RoleId or the RoleExternalKey and the RoleTypeCode). I am passing a value for the RoleId in the pv and have confirmed this by checking it with a new PV and passing null values for the other two parameters. I have confirmed that the data types and parameter names all match those for the Stored Proc, however I am still receiving this error message: "One or more IN or INOUT parameters were not passed to the stored procedure. Missing parameter names: RoleId." Has anyone received this error and how did you work through it? Thanks

I'm getting this error when trying to start a related record action. I've double-checked that all of the process variables in the context are in fact parameters in the process model, and that the data types match. There are no unsaved or unpublished changes in the process model. What else could be causing this error?

I'm using the Sync Records Smart Service.I want to prepare for a situation where the sync fails due to a temporary network error, even though the value to be updated (in this case, pv!targetTrxId) is correctly set in Data > Inputs > Identifiers.To handle this, I'm implementing the following: 1. Save the value of "Data" > "Outputs" > "Results" > "Records Updated" into pv!updatedTrxId.2. In the subsequent XOR gateway, I check: If a!isNullOrEmpty(pv!updatedTrxId) returns true, proceed to "error script".Otherwise, proceed to "End Node". The current settings are as shown in the attached image. Inputs Outputs pv!updatedTrxId ("数字(整数)"=Integer)("倍数 変数は複数の値を保存できます"=Multiple) Even though pv!targetTrxId has a value and the sync appears to be successful, the flow still proceeds to "error script".(pv!updatedTrxId is null…)Why is this happening?

Need assistance to complete the taskitem without even interacting with the task.

Hi , I have configured a group to send alert mails in the process model. This has a list of users and for one user the email ID is a Distribution List(DL) and other user has their own email IDs . When an error is occurred in the process model, the alert mail was being send to different recipients. For Eg: I have received a mail with DL in the To, and one of my colleague received the same error alert with few email IDs instead of DL as below. Also the emails in the second image are part of the DL but there are other email IDs in DL which are not present in the To. Can anyone please help me why issue is occurring. 

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.