Foundation

Hi! I was creating a PO interface and I want two of the fields to appear automatically: 1) Field 1: NomProv (supplier name) - In this case, I have a record type in which a "NomProv" value (and also, the NIF number, an extra field) is assigned to each username ("usuario"). It is an static record, and I want it to make relations between the fields, and obtain the "NomProv" for each username ("usuario") To obtain the nomProv for each user logged in,  I created the following rule expression: In this case, I´m logged in as carlos.paz.pelaez@pwc.com, so it returns the value "Proveedor 2" as a test output (works fine for me) But the fact is that I want to pass this test output ("Proveedor 2") to a field in my interface so that the user cannot change it. But I dont know how to pass the rule expression output to the text field! Also, I tried to pass the value as a local variable, but it is not allowed: 2) Field 2: NIF -

I am trying to show HTML data in rich text editor but the html we are receiving from api has some hidden tags with visibility: hidden. I know that hidden items still take up space in the layout but the content is hidden. Rich text editor is not hiding those elements or tags. The data and elements inside those hidden tags are still visible in editor. Any possible way to resolve this? Also, how to make rich text editor open hyperlinks in another tab rather than in same editor window?

I'm having this issue while trying to search anything at the "all objects" search box. I don't know why this is happening only in the development environment. Can someone help me ?

Hi,  I would like to know how I can append data inside multidimensional/record or record relationship array ? Please check the example bellow append( local!sections, 'type!{urn:com:appian:types:SN}SN_DATA'(id: null) ),

Hi! I´m trying to make a simple record filter of a dropdown list, which contains a list of text. To make the dropdown, I point to a constant which contains a text array with the name of the suppliers: But the fact is that, when I try to make a simple filter, it doesn´t work. If I put a text value, nothing appears. If I try with an expression ("Proveedor 1") I have the following error: I think it´s because of the list, because the filters work properly in individual text fields. What can I do to fix it?

Hi Team, How to send an email from outlook to start a process model in Appian ? and how many ways we can achieve this ? Thanks in Advance

I am implementing a gridRowLayout. Inside the gridRowLayout I am implementing a fileUpload field.  So that I can add a new row dynamically and for each row I can upload 1 document. But the demand here is ... I cant upload same files again and again (i.e. I cant upload same files in different rows) . But I am not quite sure how to do the validation for it. Can anyone help me with this ?  This validation I have added for fileName. But as you see I could upload same files. I need validation to say that File Already Uploaded. Is there a way to do this validation ?

We have a unique user request that the user wants to submit change request to an approver group without having to close the interface and click another start process link in the read only grid. Currently the process model has a Process Start form that the user can edit changes. Here is the issue they want to send the changes to an approver group while keeping the interface page open to use a dropdown to select another entity and submit a request multiple times. Basically he users want to be able to submit change request and not have to keep going back in to the interface page from a link each time.

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,