Foundation

We need to generate excel from table having 40 MB data via Appian. Out put excel will have 200 columns based of user selection in Appian UI. We are thinking do this via Batch during non business hours to avoid the load but checking is any limit on number of columns or excel size. As Export sql to excel seems to be having 36 MB limit. Can some one suggest? Thanks

Hi,  A user task with notification setting enabled - sends mail when it reaches the node. This user task has a Save button, which brings the control back to the same node in the process flow. Upson save, mail notification triggers again.  Tried activity chaining to avoid 2nd time notification upon save, but triggers mail. Is it possible to avoid this?  Note: I can have a split gateway and have a mail notification smart service and disable the automatic config. But wanted to check if there is any OOTB. Any help/ideas are appreciated. Thanks,Keerthi

Hi All, while user trying to upload file from the site its taking 30 to 40 sec time to open file folder,. thanks

Dear Appian Community, I hope this message finds you well. I am writing to bring attention to an issue that many of us have encountered and to encourage everyone to submit an enhancement request to prioritize its resolution. Issue: Saved User Filters Removed When Adding New User Filters #PreserveUserSavedFilters Many users, including myself, have experienced a significant inconvenience where saved user filters are removed when a new user filter is added to a record type and interface. This issue disrupts user experience, especially for those who have invested time in customizing their filters to optimize their reports. Example Use Case: ----------------------------------------------------------- * Description: In our application, users extensively utilize the feature to save and manage their filter settings on record type-based interfaces. Recently, we encountered an issue where adding a new user filter to the record type resulted in the removal of all previously saved user filter

Hi Team, Validation should be triggered if the user enters two consecutive dots in the text field. How can we handle this?

Hi, I was wondering if  we can export the readonly grid to text file (.txt)? any suggestion on the user interface and process model? The current build in function can only export the data to excel. Thanks,

I had a related action which will update the form . Now Instead of related action I need to keep a button to update which should call same processmodel to update the form with . a!columnLayout( contents: { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Update Form", saveInto: a!startProcess( processModel: cons!_UPDATE_FORM_PROCESSMODEL, }, align: "END" ) } )when I click on that button ,It is calling the processmodel at backend but getting error and the form is not opening up like in relatedaction . If I do update from related action it is working as expected.Can someone pls help

Hi, We have a requirement from business asking is it possible to enter text and paste images/snips in a single field? We have a field called Notes, which is a Paragraph Component- accepts only text. Any leads here? Thanks in Advance. Keerthi

Hi, I am using a grid field and a rule input to save the selected rows, but all the selected row values are not saved in the rule input. Suppose I am selecting four rows only the value of 2 rows is saved in the rule input. When I select all the rows at once this is a problem. But if I select one row after other it doesn't create a problem.Attaching the code snippet for reference: Any help in this regard will be appreciated.

Hi,  If a user is part of 2 groups: Assistant and Manager. Same user who submitted a task as an Assistant shouldn't be able to access next task in the flow as Manager. Is there a way not to show/disable the accept and reassign buttons when the same user tries to claim the task? Or can we show an error message when trying to accept? Any help/ideas are appreciated. Thanks,Keerthi

Hello, I have a use case where a read-only grid displays a list of projects, with one column showing statuses such as Complete, Cancelled, Design, etc. I want to enable users to click on the status, which should then display a dropdown containing all available statuses. The user should be able to select a new status, and the update should be saved to the database accordingly. Requirements: Clicking on the status field should open a dropdown with all status options. Once a new status is selected, it should be immediately updated in the database.

We have four user roles: Admin, Manager, Supervisor, and Agent. The Agent performs certain actions that are accessible to all three higher roles (Supervisor, Manager, and Admin). The Supervisor performs some actions that should be accessible only to the Manager and Admin. The Manager performs specific actions that only the Admin should have access to. The Admin can perform exclusive actions that no other role can access.How to configure security?

Is there a way to identify the objects with more than certain lines or sort objects by lines count or characters count?

When the "index+1" script task is reached, I would like to wait 1 second and then execute the script task.I tried to solve the problem by setting the timer, but I don't know how, so I would like to know how.

Hi Team, I want to create two columns in Interface, one column will have Calander and when we click  on the date , it will display on the second column, anyone got the answer, plz share the code

Hi Appian community members, currently we are using a!columnChartField to display some columns in a UI. Recently there are many columns added, is there a way to make the column chart scrollable from left to right so all columns not squeezed? a!columnChartField seems don't have any parameters can control whether scrollable. Any suggestions? Thanks.

Hi! Has anyone implemented an interface with a similar visual style? A grid field with rows and the rows have an icon that when you click expands a section. I could be wrong, but I think Appian doesn't currently have an out-of-the-box component/layout for this, hence I'm trying to find a workaround.  I am looking for ideas on how I can at least mimic a fraction of this style in Appian.

I have a requirement wherein I need to download multiple files (say 30 files) at a button click to the local system I have seen posts to try Zip plugins to add documents to zip and unzip the same. Please can someone suggest a way on how i can achieve that on a button click the files are downloaded to my local system. The number of files are dynamic.

While sending the email, some of the text is getting removed and receiving only partial text. Below is the html text: <p><span style="font-size: 10pt;">Dear colleagues,</span></p><p style="text-align:start;"><span style=""><span windowtext="" 1.0pt;mso-border-alt:none="" 0in;padding:0in;mso-ansi-language:en-us'="" style="font-size: 10pt;"> </span></span><span style="font-size:10.0pt;"></span></p><p style="text-align:start;"><span style=""><span windowtext="" 1.0pt;mso-border-alt:none="" '="" style="">Please note that the EU approval by CHMP Positive opinion has been granted on 05 December 2024 for </span><span style="">KEYTRUDA (pembrolizumab) for variation EMEA/H/C/3820/II/016 which removes the instruction &quot

I have a following Use case- 1- Need to extract 40+ MB data from different system as per Ondemand request from Appian Interface 2- Dump this data into some staging table residing in Appian Business Database schema and perform operation afterwards Which solution will be most usefule in terms of Scalability and availability 1- Use SQLtoExcel plugin? will this support to get the dump into excel via User on demand request 2- Export Datastore entity to Excel? will it support 40+ MB data or will it be timed out? Any other approach we can adopt? Here major concern is On Demand request for processing the data via Appian Interface.

Hello everyone, { a!columnsLayout( columns: a!columnLayout( contents: if( ri!showAllLinks_bool, {}, rule!CR_APP_RT_displayApproverInfoNote( message_txt: "New workflow cannot be initiated as another child flow is open/in-progress" ) ) ) ), /*Release & delete to be shown where action proposed = Release or Delete*/ /*No other Child process to be shown when release/delete proposed*/ /*process button shown to DU users only*/ if( contains( cons!CR_APP_CHOICES_ACTION_PROPOSED, tostring( index( ri!crAppSelected_cdt, "proposedAction_txt", null ) ) ), a!columnsLayout( alignVertical: "TOP", columns: { if( and( contains( { cons!CR_TXT_CCAD_UNIT, cons!CR_TXT_SYND_GROUP }, rule!CR_FN_getUserRole(loggedInUser()) ),

I was sending a data in json format like { a!tojson("fruit": "apple") } but the output i was getting { "fruit": ["apple"] }but i need without square brackets . Could anyone please help me on this and thanks for advance

I want to set up a simple process in Appian Community, which starts when an email inbox receives an email, and from that email, a form is generated. Is it possible to do this in Appian Designer, or do I need a license?

I have a dropdown field that is giving me trouble. It used to work, but just started today. It throws, "An error occurred while executing a save: java.lang.IllegalArgumentException: Invalid index: Cannot update integer index from type List of Null". I am interpreting this error message to mean that I am trying to save a Null value into an integer index. [View:/cfs-file/__key/communityserver-discussions-components-files/13/Dropdown-Field-Error.mp4:899:244]  I am limiting the drop down to the latest event.  I do not want the applicant to choose any other value except the latest on. Here is the code: a!sideBySideItem( item: a!dropdownField( data: null, choiceLabels: rule!PMSO_getEventforLU()[1].event, choiceValues: rule!PMSO_getEventforLU()[1].eventId, label: "I am applying for the following Event", labelPosition: "ABOVE", placeholder: "--- Select an Event to apply ---",

Hi All, We have a requirement, where we have to import excel file data into Appian database stage table. Once data is loaded into stage table we have to validate the date format for date columns whether the date is invalid or valid using query entity or any custom function. In-valid records should be removed and only valid records be there. Can someone help us with this kind of scenario in Appian how we can avoid the in-valid date rows in Appian.  Regards, Dheeraj G