Foundation

Hi, worday function is used when weekends are need to be excluded to calculate workdays. We have requirement to calculate including weekend. Below is our expression we need help to calculate finaldate when include weekend is true. here expectedholidays is list of holidays. a!localVariables( local!expectedDays: if(ri!days > 0, ri!days, 0), local!exceptedHolidays: if(isnull(ri!holidays), {}, ri!holidays), local!startDate: today() - 1, local!initialEndDate: local!startDate + local!expectedDays, local!FinalEndDate: a!forEach( items: enumerate(local!expectedDays)+2, expression: if( contains(local!exceptedHolidays,local!FinalEndDate), local!initialEndDate+1, local!initialEndDate ) ), local!exceptedDeadline: if( ri!days > 0, if( ri!excludeWeekends, workday( today() - 1, local!expectedDays, local!exceptedHolidays ), local!FinalEndDate ), cons!CORE_MAX_DATE ), local!exceptedDeadline

Hi All, Can we add hyperlink in tooltip?If yes can any one provide as the solution.

I have the requirement to find the difference between two record values of a record type like we do in case of cdts using cdtdifference(). I have the previous value of record type and then new value, I need to populate Audit table using these difference values. Any function like cdtdifference() or any workaround to do this?

Hi , i am getting this error after selecting a dropdown value :- Expression evaluation error [evaluation ID = GUC5I] in rule 'td_additemforbasicdetails' (called by rule 'td_tenderdetailsmaster') : Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!dropdownField [line 57]: A dropdown component [label=""] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was 37 and choiceValues was 32; 34; 36; 37; 38. How can i resolve this ?

Hi everyone, I use a!startProcess() in an interface, so that the process will be kicked off once clicked the button. I want to disable that button until the process completes. Is there anyway to do so? Thank you!

Hi! I wanted to create a dropdown for each id generated in one of my records. How can I reference the values into the choice labels and choice values? I thought about pointing to a constant of the record type column "id", but I´m not sure how to generate it Thanks a lot!

How to use error() function and what is the  best use of error function

Hi all, I am working to create a Word doc in a Process Model w/ DOCX from Dynamic Template that should include text, dynamic text, a table with text, images, and small icons. I have included the bookmarks/links as described in this post: https://community.appian.com/discussions/f/plug-ins/20335/sending-multiple-images-over-a-dynamic-docx-template-smart-service . Below is the template I am currently working off of- [View:/cfs-file/__key/communityserver-discussions-components-files/14/File1.docx:320:240] The document I would like to create should look like this (images should be actual images): [View:/cfs-file/__key/communityserver-discussions-components-files/14/File2.docx:320:240] The parameters in the process model:  XmlDataModel: "<slide>" & rule!ERR_formatFieldXML(field: "name", text: ri!slide.slideTitle) & rule!ERR_formatFieldXML(field: "poc", text: "test") & rule!ERR_formatFieldXML(field: "pocType", tex

Good morning, We have to generate a pdf from a given template (we are using the pdf doc from template node), this template will be filled with text fields that we get from the database but we also have to attach a loaded signature to the end of the pdf in an image that we obtain previously.But we were not able to load it inside any of the tags that the template has, we have tried to mount the two pdfs separately and then do a merge but this would not work for us because as I mentioned we need the image to be in one of the template fields.Has anyone had this same problem? Greetings and thank you

Hi All, Hello Team, There seems to be major issue post Appian was upgraded 23.2 to one of our environment yesterday. All the test scripts for our application are failing since it seems yesterday's update have introduced new locators. Same issue was observed by other Appian users as well which can be seen on community page https://community.appian.com/b/appmarket/posts/cucumber-for-appianAre there any solutions which can help prevent happening this? Or is there any way Appian communicate to us letting know that there will be a change in locators? I could not find it in release notes

I really like how Appian is evolving over the last coupe of years since i've stared using it. It is good to see regular release with new feature but there are a few that I'm really missing in Appian and could be game changer. At the same time i would like you community what you are looking for to be added to Appian? My most missing features: 1. More flexible filtering options for Grid. I would like to filter by any column in place having only values that are available if filter is added on other column. It should work similar how you can do it in Excel or in most tables on the web with simple JS dll.  2. More control over Grid appearance. It would be good to be able to decrease the font size, spacing, padding and margin to make table more compact. It also would be good to prevent word wrapping and have more control over column width if text is long. 3. Possibility to write expressions as Java/Python code within Appian if there is such need. 4. Dedicated component for navi

Hi, There is a form in our project that is running very slow for any kind of postback that is occurring. Even if we are just showing 25 records on one page and then moving to the next page then also it is taking a lot of time to move to the next set of records. Also, we are fetching the records from the SQL server and not from the Appian db. And, there is no complex code written that would make the performance slow. Are there any suggestions why this is happening?

hi Team, we are going to use OKTA Authentication to login into Appian and BOX, DocuSign and Salesforce Connected System. But we got a Question from my internal Team that can we the OKTA Access Token with in the Session for connected System for Authentication.  Please help me in understanding can this be done? Thanks & Regards , J Vinay.

Hi, Can anyone help me on how an active process instance in prod environment can be updated?

Hi Team, Is there a way to dynamically execute the record actions within Appian, with the action name saved in DB.  I'm aware that we can dynamically execute the process model by passing in the UUID (which can be save in DB as a text) but the business ask is to open up a task/UI in a dialog box which cannot be achieved through a!startprocessLink. And this was why we configured the PM as a record action and opened it as a dialog. Is there any means to dynamically execute the record action by retrieving its name from DB. TIA

I am getting values from database and I am displaying it and the filter is working fine. Now the Requirement is i need to add NULL Name in dropdown and display those names that are NULL. I am using append(local!dropdown,"NULL Name").  local!dropdown-- It has a rule that is used to display Dropdown value. My doubt is I need to Display NULL Name dynamically, i.e: if any value is Null then only i can see this option in dropdown. I am using below code but its wrong(as am comparing directly with NULL and value can be like: {Name1,Name2,Name3,Null}) can someone help me on this local!dropdownList: if(local!dropdown="NULL", append("NULL Name"),local!dropdown)

Hi,  In the interface I use the rule input as my record A1. A field in this interface, I need to populate value from the other record B1.In other to use the relationship in the interface or expression rule, how to define the relationship.  I tried giving the relationship in "relatedRecordData" in a!queryrecordtype. But, I am getting the below error: Expression evaluation error at function a!queryRecordType [line 26]: Could not cast from Record Relationship to RelatedRecordData. Details: CastInvalidCould not cast from Record Relationship to RelatedRecordData. Details: CastInvalid Can someone pls help here, 

Hi, As the log files are generated in Appian and we too can view and download them. But I have a doubt about a few. Can you please solve them? I listed my questions here:     1. What is Appian Default log clean-up configuration?     2. What is the log generation frequency?     3. As the log files are generated and stored, do they delete automatically or can I delete them manually?  Thanks.

Hello People,My requirement is to select grid values using shift key, [Eg: like we in gmail], Is there any way to implement it?Thanks in advance,Achuth

Hi All, If we go with the Appian Cloud Database Encryption,(https://docs.appian.com/suite/help/23.2/Appian_Cloud_Database_Encryption.html#default-encryption-for-tables) 1.  What is the performance impact - the article mentions small performance impact. Has anyone done this and what was the impact on performance(specific in milliseconds,seconds)? 2.  We have views defined in application which are used to display some dashboards on UI - will these be impacted as well? 3.  As per article,the phpMyAdmin will continue to show data as before encryption so how do we verify that encryption is working correctly

Hi! I´m trying to update a value (recepcionado = true) by clicking a button in an interface (button --> changes a field of the record to "true"). I created the interface and the rule input (record, from my record type) changes its value correctly, but it´s not saved. I did a process model to save the records, but when I try to use the write records component, the following message appears: ID pedido is my primary key in this record type. The interface (process start form) is a summary view for each ID_pedido, so I don´t know how to fix this error. When I run the process, even though the write records fails, my process variable (recepcionado = true) is saved What can I do?

am getting this error in PM, but i didn't find the issue.. i guess it's in user input node is throwing the warning. can anyone tell me what might be the issue

Hello, Does Appian allow for backwards compatablility with applications OR objects? I put one interface object in a package, and tried to import it to another appian environment that was not running the current version. I got another error displaying this: Is there something wrong with the object itself or does happian just straight up not allow backwards compatability?thank you

How does appian generates valid web address link in portal? what happens in the back-end?can we generate valid web address using SAIL?

Hi! I was trying to create a button in an user interface. This button should change de value of the field "recepción" (boolean) to "true", and save it into the record type ("CPF_Maestro_Pedidos). With my configuration, I can pass the "true" value to the rule input (record) associated with the record type, but I´m doubting about which is the best way to save (overwrite) the value into the record. Also, I don´t know if I should create an action associated with the button or not.  Additionally, the interface is a record view interface.  Options I thought: 1) Use an expression inside the button code (like WriteRecords) to overwrite directly from here --> ¿how would be the structure? 2) Make a process model and use this interface as the start form and use write records component. The problem is that when I try to do that, an error appears (rank ---> data inputs). But the variable "recepcionado = true&qu