Discussion Categories

How do you change the dimensions of multiple dropdown field?

Hi, I have a summary screen which has list of columns that I generated using a Record Type list and not through an interface. How do I put a checkbox using a grid column? I found this link which talks about the delete functionality but not sure where do I enter this code as I am not able to access the expression editor to the entire summary screen instead I only see individual grid column expression editor. docs.appian.com/.../recipe-delete-rows-in-a-grid.html Basically I want to implement delete functionality by selecting each row using checkbox and delete them.  Appreciate any help and advance thanks!! Suneetha.

Hi all, Does someone has any clue why the "Show Objects" button, located on the bottom right corner, isn't working in some specific page? We've a lot of different interfaces/pages and, on some of them, the button doesn't show the highlighted objects in pink color.

I have a gridField where one of the gridColumn is displaying an icon for its value (icon is displayed as a richTextIcon in a richTextDisplayField). In this column, it can either have the icon or not (null). How would I go about configuring the sortField for these values since they're not necessarily field values. I would like to sort so all rows with the icon are at top (or bottom). Thanks

Hi,  Is there any way to prevent column widths from shrinking to fit the page? I am looking to force a horizontal scroll. Specifically, without using a grid. I need to display cards within each column that have multiple components within them. I've tried prevent wrapping, no luck with that. I can't leave any more comments for at least 2 hours. Are there any layout components that support horizontal scrolling?

Load CSV file to database gives error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=' at line 1" I am using same CSV file that was exported using export db to CSV have gone through all the discussions so far on the community we are using on-premise mysql DB so using this smart service rather than import CSV to DB which was also giving error anyway. will attach excel file I am trying to import: date is in proper format:'yyyy-MM-dd hh:mm:ss' since that was earlier error Anyone faced similar issue or knows the cause please help

Hi All,When I run the process, I am getting the error in "Send Email" node. Error Details - "index (Data Inputs)".Assignment of the node, it is set as run whoever started the process.Please suggest if anyone had an idea about this.Thankyou in advance!

Hi Guys, I want to identify for each status ( "Not Active", "Active", "Completed", "Cancelled", "Paused", "Paused by Exception" and "Processes with Errors"). I got only one paused by exception status Id is 8. The same way need all the status id. Please share your details. Thanks, Pradeep Sridharan

I have an interface with a grid, in which first columns is an ID, and you can click on one of the ids to go to another interface with specific details for that ID. Right now that link works with a process, but I need to change it so it does not trigger any process, I want it to open the interface with the details for the selected ID without going through a PM.How can I do that? Thanks you!

Hi, I am trying to implement a Box integration using JWT Authentication. I have set up the entire integration however while trying to generate the access token it is giving an error. Can anyone help how to fix the issue? Thanks in advance!

HI I am fetching data from appian report. I have applied filter also so it won't fetch all the data everytime. but for the very first time it has to fetch everything  from the reocrd and then store in database. Now just to be on safer side I want to fetch the data in batches and then want to consume it.I am doing it with the following way a!localVariables( local!latestDate: cast( typeof(now()), index( rule!MO_GetLatestAuditDetails().data , "endTime" , now()-60) ), local!processModelUuids: rule!MO_GetAllProcessModels().processModelUuid, local!totalCount: index( rule!NEW_MO_ExtractProcessMetricsFromPortalReport( batchSize: 1, startIndex: 1, date: local!latestDate, processModelUuids: local!processModelUuids ), "totalCount", 0 ), local!numberOfIterations: = fn!ceiling(local!totalCount / ri!batchSize), local!listOfIntegers: = enumerate(local!numberOfIterations), a!forEach( items: local!listOfIntegers, expression: rule!NEW_MO_ExtractProcessMetricsFromPortal

HII would like to understand if there is any way to export data to excel in appian if we have more than 50 columns? Any suggestions appreciated.  Thanks in Advance.

My local variable is showing 1 item, but it should show 6 items. That is referring to only one value from the referenced table.The dropdown using this local variable shows only 1 item in it. I need to make it show 6 items. I have used the referenced table({}) this function also.

Can we have a Audit History of Groups, just to check who added the user and when? and which user have been removed and also for the date of removal.

Hi All, I am using template to word doc smart service to create ms word doc from the input template. We have to replace few fields from the template. Now the problem I am facing is if the value is there then it's getting populated properly with underline(as there is a underline in the input template) but if there is no value it's getting replaced by blank and because of that there is no underlines available for those fields. So i want to know is there a way to replace the items only based upon some condition ? like if the value is null just do not touch that ? something like that can be configured ?

I  was working with the editable grid . i want the all the updated values from the editable grid from the cdt ?

Hi, Question for the community. I have a process id and which is the efficient way to find the process status. I don't need any other info from the status only whether it is completed or now.

Right-click on the video component or document component placed in the interface to display the context menu.Please let me know if there is a way to restrict the display of this context menu.

Hi, I am trying to trigger a process Model when we have received an email to a particular email. Is it required to include Process Model UUID in both subject and body of the email.

Hi Champs, I have a use case where I need to execute an action/process Model to update a column in a database table on user entry to a record view. It should be automatic. There is no user interaction required for this. Is it feasible? The functional use case is ,I am showing the alerts to the user in summary page if there is any message in history log table. Once User click the History log tab, I have to make all the unseen messages to seen automatically. To Better explain, I have two views in my record which is Summary View where I will show the alerts to the user if there are any new messages and the other is History/log message View. Regards, Ghanashyam

getting below error  2023-08-01 15:46:38,708 [main] ERROR com.appiancorp.ps.automatedtest.exception.ExceptionBuilder - Loginorg.jruby.exceptions.ArgumentError: (ArgumentError) expected #<Java::OrgOpenqaSelenium::By::ByXPath:0x35216a2e>:Java::OrgOpenqaSelenium::By::ByXPath to respond to #shift at RUBY.extract_args(C:/jruby-9.4.3.0/lib/ruby/gems/shared/gems/selenium-webdriver-4.10.0/lib/selenium/webdriver/common/search_context.rb:91) ~[?:?] at RUBY.findElement(C:/jruby-9.4.3.0/lib/ruby/gems/shared/gems/selenium-webdriver-4.10.0/lib/selenium/webdriver/common/search_context.rb:58) ~[?:?] at RUBY.login_with_role(C:/workFolder/RemoteTest/selenium_tests/ruby_methods/tempo_fixture.rb:510) ~[?:?] at RUBY.create_pr_with_role(C:/workFolder/RemoteTest/selenium_tests/ruby_methods/easi/pr_creation.rb:3) ~[?:?] at RUBY.<main>(C:/workFolder/RemoteTest/selenium_tests/features/step_definitions/easi/pr_creation_steps.rb:24) ~[?:?] at org.jruby.RubyBasicObject.instance_exec(org/jruby/Rub

Hi everyone, Quick reminder that our first Appian Community Quick Build to create a reusable calendar component is in progress and submissions are due by midnight ET on Friday, August 4! By just submitting a component, you'll be entered into a raffle to win 1 of 5 certification exam vouchers or three days of advanced training! Finalists will be featured during our Friday, August 11th livestream, where 1st and 2nd place will be decided to win $250 and $100 gift cards, respectively.

This part of the course wants you to create a new record type and from the database table select "AS_Vehicle" however, when I get to the "Configure Date Source" menu the only options that show up are "PF_ACCOUNT, PF_ACCOUNT_TYPE, PF_GOAL, PF_TRANSACTION".  Does anyone happen to know what is going wrong here? Or how I can access the "AS_Vehicle" database table? 

I have a dropdown in an interface where the selected label disappears once it is selected.  However, the value is stored. I have a Reference table, User Role with 4 fields. Role ID Role IsValid Sort I have a data table, User with several fields, but it has a field Role ID that is related to the Role ID in the reference table.  I have relationships built both ways between the User data table and the User Role reference table. I have an expression rule that produces a sorted lists all the Active Reference; QR_getActiveUserRoles.  This tests good. In the interface I have a local variable Roles which calls the Expression Rule QR_getActiveUserRoles. "local!Roles: rule!QR_getActiveUserRoles()". In the interface I have a dropdownField picker a!dropdownField( label: "User Role", labelPosition: "ABOVE", placeholder: "--- Select a User Role ---", choiceLabels: local!Roles['recordType![REF Role.fields.RoleName'], choiceValues: local!Rol

Dear Community, We encountered an issue recently regarding disk space, where it reached its full capacity two days ago. Upon further investigation, we identified a timer that was causing file duplication, leading to the storage becoming full with over 1.6 million files. To address the situation efficiently, we attempted to remove the entire folder (Knowledge Center > Artifacts > folder xyz) instead of deleting individual files. However, we are now facing a challenge as the "artifacts" folder is displaying 40GB of consumed memory, while there are only five files totaling 200KB in size. Despite our efforts, we have been unable to locate any hidden files or identify the reason for the excessive storage consumption. We are seeking guidance on how to identify the root cause behind this issue and optimize the storage usage effectively. Thank you for your support in resolving this matter promptly