Foundation

a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDate: {}, local!holidays: { if( a!isNullOrEmpty(local!holidayslist), {}, text(local!holidayslist, "DD") ) }, local!currentMonth: { a!forEach( items: local!selectedDate, expression: if( tointeger(text(fv!item, "MM")) = local!month, t

Hi All, I am trying to display a HTML document in interface. How can I do this any suggestions. Thanks in advance

Hi Community, I have a requirement involving a multi-select dropdown in an Appian interface. Here's the scenario: First Screen: I have a multi-select dropdown that is a mandatory field. Users must select at least one option. The selected options are saved in the database table, with each option stored in a separate row. Next Screen: The same multi-select dropdown is presented, but it is not a mandatory field. When the page loads, it should pre-select the options that the user selected in the previous screen (fetched from the database). The current user should be able to select more options or deselect previously selected options. Upon submission, the form should save the updated selections. I am looking for guidance on how to: Pre-select the options in the multi-select dropdown based on the user's previous selections. Allow users to dynamically update their selections (add or remove options) and save these changes. Any help or examples on how to implement this would

Hi Team, currently working  to display a calendar to select some dates. so all months dates years are working fine but DEC Month is showing extra cards to select. I am providing my Devlopment need Support in understanding and Fixed code. a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDate: {}, local!holidays: { if( a!isNull

Hi team,  New here to Appian and i am trying to develop a calendar to select Multiple dates and it is working fine my problem is the calendar shows the extra cards in DEC 2024 month. the cards are selectable. i want to know the reason where my code fails and need support in fixing this. a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDat

Can somebody tell me if both are the same, if ACD101 is the newest or they are for different levels?  Thanks

Hi all, I am trying to capture Mail sent by user and save the attachment in a folder. I am using Receive Message Event for the same and sending mail from my Gmail account to the Process Model UUID as mentioned in the forum "processmodeluuid<UUID>@subdomain.appiancloud.com". Mail is not getting sent in Gmail and used another Smart service, 'SEND EMAIL' for sending mail for the above ID. Then also the process is not working and error "No Valid recipient" is displayed. I have done everything as per documentation. Can anyone please let me know the flow on how to Send the mail and start the process to receive the mail with attachment? Thanks in Advance. Please find screenshots below for reference and let me know the changes to be done.    Receive Message Event properties:      Process model properties.

I have a variable that contain list of items, items are ;- year , category , value 2024, cap internal , 20 2024, cap external, 60 2024, cap material, 50 2025, exp internal , 20 2025, exp external , 30 2025, exp material , 40 I want to sort this like :-  year , category , value 2024, cap external, 60 2024, cap material, 50 2024, cap internal , 20 2025, exp external , 30 2025, exp material , 40 2025, exp internal , 20

If i enter the value ,the value should be like 56.00 ,i tried , unable to achieve it  it is in  floatingPointField function 

Hi, I am preparing Certified Associate Developer(ACD101) Exam from last month, The materials which is available on the community learning path is sufficient to pass (73%) the exam or I need a hands-on experience which I learned? Also is 1 month of preparation is sufficient to take the test? As I am confused, please suggest your valuable comment on this,   Thanks in advance. Regards, G Udhayan 

How can I update a user attribute with an empty value? The "null" value is being passed from the interface but then those attributes with the null value in the pv do not get updated in the user profile.docs.appian.com/.../Update_User_Profile_Smart_Service.html

There are 300+ Constant in  my application but i need to filter the Env specific Constant . How can i do that 

Hi I am using below code but my value is not saved in the database. Please suggest. a!paragraphField( label: "operations", showCharacterCount: true(), value: local!cashNotesval, saveInto: { ri!comments, a!save(local!cashNotesval,ri!comments), a!save(ri!comments,save!value), a!save( ri!Transaction.comment_txt, ri!comments ), }, I am saving local value into rule input but it is not passing in database. Basically this local!cashNotesvals is autopopulated when on selecting dropdown value.But this value is not save in database. If i am typing manually in this paragraph field then value is saved.

HI everyone , Is it safe to remove the unnecessary heap dump files from the bin folder without stopping the services? If I delete these files, will it cause any issues? We've resolved the heap memory problem, and the application is functioning properly, but I need to clean up the storage. Thanks, Udhaya

I have an expression rule that returns a value based on rule inputs. When I run this rule as a stand alone rule, it gets the data I expect. When I run this rule in process model A, I get the result I expect. But when I run the rule in process model B, I don't get the results I expect. These 2 process models are child processes that get called at the same time, and have the same inputs. The node that runs the rule has the exact same inputs, settings, assignments, etc. I can't see any reason why the rule would work correctly when run manually, or when run from process model A, and not process model B. For context, they are expected to return the same value in both process models. Am I missing something? If it helps, I'm using Appian Cloud v22.3

I’m working on an interface where I need to display the latest update for each case dynamically. Here’s the setup: Data Source: A record type (HistoryCase) that logs all movements for cases. Another record type (CASE) storing the status of each case. Goal: Show the latest "Update" (LogText = 'Updated') for each case on a dashboard. Exclude cases where the status is "Close." Add filters for a specific date range (e.g., 2024-11-01 to 2024-11-30). Challenges: How can I efficiently query and display this data in an interface, ensuring performance for large datasets? What’s the best UI design pattern to display the results dynamically as the user applies filters? I’d love your suggestions on: How to structure the query for this use case. Best practices for designing an interface that’s user-friendly and responsive.

Hi All.  Am using Set External PV plugin to update process variable of two different process. Lets say process ids 12345 and 54321 and both PM are having same security. But I could able to update PV for process 54321 whereas I couldn't do the same for other process. Its showing below error.  "An error occurred while trying to update the PVs of process with id 12345: Insufficient permission" Can anyone suggest how to troubleshoot this? Thanks in advance!

On the Landing Page, I have a Navigation menu on the left and Record List on the right, When I click on the Loan Id hyperlink on one of the Record, it takes me to the Summary Page for that record clicked. Issue I am having is, the Summary page is taking up full page and overwriting the Navigation pane on the left hand. Please see 2 screenshots I have attached. How do I get the Summary page to be restricted to the right side of the Interface section and not go over the Navigation pane on the left?

hi I am trying to implement an editable grid , which should have collapsible rows  I am trying to avoid nested loops and wanted a check box option for all the rows . Any coding examples will help. Thank you

We currently support a site with a static image on entry for our internal users and customers. I was wondering if it's possible to have a video loop play in the background on entry navigation in Appian before progressing into the applications? As an example of a website that depicts a real pop in what the business offers: Kirby Corp has a great video of how the business moves chemical pressurized, dry bulk, or heavy product while still allowing the users to interact with the interface.

Hi, I have a process model where a rule is processed in a script task running parallel to a user input task. At the second AND gate, there are two possible scenarios: First API Call Path Reaches the AND Gate First: The API path reaches the AND gate before the user submits the task. This scenario works as expected, triggering the next chained User Input Task (UIT) in the process after the submission of first UIT. User Submits the Task First: The user submits the task before the API path reaches the AND gate. In this case, the next UIT is not triggered as expected. anyone knows what's the reason for this to happen ?note : the script task is not an actual API call but just an expression rule with some dummy dataThanks

Hi All,I have few records and out of those if i am trying to open any sync enabled records it's taking more than 30 mins ,not only opening if i am trying to sync these records it's taking forever.At the same time if i am trying to create or update any value for these synched records using "Write Records" in process model it's taking minimum of 15 mins, in some cases it's throwing "system encountered an error" , but when I checked in the database the write happened quickly (<1 min). We are using Oracle Database.We are not quite sure why this is happening,any leads /ideas? Thanks in Advance.

a!localVariables( local!map1: {    a!map(Id: "Map 1", key1: "A", key2: "C", key3: "C"),    a!map(Id: "Map 2", key1: "C", key2: "A"),    a!map(Id: "Map 3", key1: "C", key2: "B", key3: "C") }, local!map2: a!map(     Key1: "ky1",      Key2: "ky2",    Key3: "ky3" /*This list can be very long e.g. Key4: "ky4", Key5: "ky5" etc.*/ ), /*code here*/ /*desired output starts - swap the keys based on mappings in map2 */ /* {   a!map(Id: "Map 1" , ky1: "A", ky2: "C" , ky3:"C"),   a!map(Id: "Map 2" , ky1: "C", ky2: "A"),   a!map(Id: "Map 3" , ky1: "C", ky2: "B" , ky3:"C"), } */ /*desired output ends*/ /*Is it possible ?*

I have an expression rule will return 2 types of record type - Case - Error depends on if there is any error occur during the expression rule process so when I get the result from the expression rule, I do need to know what type is the returned value, how can I achieve that? I tried to use typeof(), but it does not work. I am wondering if I need to use type!, but I do not know how to write a valid reference using type!

I've got a requirement that needs a expandable readonly grid, I saw Expand/Collapse Rows in a Tree Grid - Appian 24.2 in other post but this is a gridLayout which seems can't be paged But I want the grid to be paged and expandable, the collapsed rows should be just same to the main row that can be selected and has recordactions in every row How can I implement this