Discussion Categories

I have an expression rule which returns data for some ID's and for some it returns 0 items. Based on this rule, I need to display a message to the user.If it returns 0 items, then "in progress". If not, the usual data.  How to check if the rule returns some value or 0. I used isnullorempty, but it didn't work

Exception: "Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = c36d2:2c0ec] : An error occurred while executing a save: java.lang.IllegalArgumentException: Invalid index: Cannot update integer index from type List of Null" While converting the list of terms from a rule input to a local variable, I get this error. When using without local variable, I do not get this error.  local!terms, ***gridlayout***  rows: a!forEach( items: local!terms, expression: a!gridRowLayout( id: fv!index, contents: { /* For the First Name Column*/ /*a!integerField(*/ /* Labels are not visible in grid cells but are necessary to meet accessibility requirements */ /*label: "term " & fv!index,*/ /*value: fv!item.termnumber,*/ /*saveInto: fv!item.termnumber,*/ /*required: true*/ /*),*/ a!dropdownField( label: "termnumber " & fv!index, placeholder: "-- Select -- ", cho

Hi, is it possible to have a search field (a!pickerFieldCustom), which looks for existing values from record and integration data. But disable selecting existing data and convert the field into a text field to add a new value? I essentially want to use the picker field as a search and new value text field in one.

base64 is not supported in gmail in email template. what should I do for displaying image in email template.

Hi We are using SAML Group Synchronisation to sync Azure AD groups to our Appian groups. All works correctly. However, due to a temporary situation, we will have two Azure AD groups which should be mapped to the same group in Appian. See below, where we have the attribute 'memberOfValue' and a group name, we would need that attribute repeating. e.g. Attribute - Value memberOfValue - Group1 memberOfValue - Group2 I am thinking this is not possible and that probably we have to set up a second saml sync group with the correct attribute, then add this group as a member of the Appian group. Anyone had this scenario? Thanks.  

Hi everyone, sorry in advance for a confusing question. So I have this expression rule with two rule inputs, ri!innitiator and ri!excelSheetJSON, the code works well but I have to create the test cases for each of the rule inputs and I have no Idea how I'm supposed to structure the excelSheetJSON one. I provided the code used in the expression rule, in the PM node where we included the JSON code and the test case page where you can establish the parameter for the case. My question is what do I write in the red box to give the appropriate output?  (In the expression rule) (In the PM) (In the expression rule) Thanks for the help!!

User will enter start date while creating the request and then after approvals .it should start process model on its own upon reaching start date

is this true ? Refresh variable's control is only limited to single interface not in nested interfaces ?

Hi Team,I'm having a function which calculates the time difference between a date time( output of a rule) and now(). then applying hour() to find how many hours it differing. But incase I'm checking this at 06-11-2023 7:00 am(output of rule) and my current time is also today 7 am , it generating Interval (Day to second) in negative like  -0::00:06:37.727 due to millisecs difference, so while taking hour for this converting 0 hour to 23 . but what I need is  0::00:06:37.727. so that my hour difference calculation will return 0. Anyone know how to do the conversion or any better solution?Thanks in advance[mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]

Hi, We did a below setup to trigger a process model once for every 2 weeks on Tuesdays. Everything was working. One fine day we did some changes to the process model and deployed during weekend we expected the process model will trigger. But, it did not trigger. Question: Process Model will count the weeks starting from the day when we did re-deployment? will it not remember initial processed day/week and trigger accordingly.

Hello Team ! I am new to Appian Community , While requesting access for Community site for practice i am getting below error . Can anyone help me to get access. Thank You!

Hi All, I need to add filters to the columns in record list, just like filters in an excel sheet. Can anyone please suggest me how to achieve this?

Hi, Can you please suggest that what need to be changed or checked..The scipt is not able to fill login and password in window.

Dear Appian Community, I'm seeking clarification on process upgrades in Appian and how to address failed requests in production. I've been unable to locate a specific plugin for process upgrades. Currently, I have numerous requests in production that are failing due to exceptions. I need to update the process for these old instances to resolve the issue. Could you please advise on the following: Is process upgrade functionality still available in Appian? If so, how can I perform a process upgrade? How can I effectively handle failed requests in production and update the process for existing instances? Your insights and guidance would be greatly appreciated. Thank you for your time and expertise.

Hi All, Through stored procedure how to sync record? If anyone know pls let post your comments.. Getting all values through stored procedure smart service but couldn't able to sync record. https://docs.appian.com/suite/help/23.3/Execute_Stored_Procedure_Smart_Service.html

Hi Experts, I need your help in resolving my issue. I have one HTML template which is being attached in send email node in a process model. I want to add one image in that template. But up on adding the image via a document constant that we are passing in a template   its not showing up like this in the email that we are getting:  But when we are using URL for adding an image in the template its working fine. My question is how to add an image in an HTML template that it will display in the email but using Image file document constant in Appian?

I have a problem to run quiz using 10 questions answers in in foreach loop. I want to save values in a local or rule variable. (question id with selected answer value)  If user modify his answer, then selected Ans value changed with new selected option. I want to do with record type.

I  have a requirement for an organizational chart.  I have an employee-specific table in the database containing the reporting manager column and role.I tried the code but it doesn't expand to down-level resources. I require a dynamic chart to add employees and roles. a!localVariables(local!user: loggedInUser(), a!orgChartField( value: local!user, saveInto: local!user, showAllAncestors: true, showTotalCounts:true ))

hi, i want to know is there any way we can extract data from this kind of string. "[place_id:519fcdaacfd556c0bf591a4bfd61f0c04940f00101f9014600010000000000c002089203064c6f6e646f6e,address_line1:London,city:London,address_line2:ENG, United Kingdom,country:United Kingdom,state:England,county:Greater London,formatted:London, ENG, United Kingdom]" i want to get data as { place_id:"519fcdaacfd556c0bf591a4bfd61f0c04940f00101f9014600010000000000c002089203064c6f6e646f6e",  address_line1: "London", city: "London", address_line2: "ENG, United Kingdom", country: "United Kingdom", state: "England", county: "Greater London", formatted: "London, ENG, United Kingdom" }

on click of submit am getting this error what might be the reason

 Does it means that, for local variable 'outage' the value from database is given through recordtype power outage.

Hi all, I have a use case I have build a webpage using HTML and JS and I am calling it using a Web-API from Appian interface which will be triggered by a safelink.But whenever the user clicks the safe link the page is re-directing to the Web page, but i want to show it inside the Interface , i tried using webcomponent object but it's error saying internal appian urls cannot be used in webcomponent.Is there any alternate way to achieve this. Thanks in Advance.

When triggering a process model from the Receive message event by sending a simple mail, it works fine. I'm having an error like the above when adding an Attachment to the Start process triggering mail also, I'm having an Error with Create Eml File from OOTB Poller "An error occurred while creating the note. (APNX-1-4101-005)" These are the PV ...

Hi Team, I have requirement to get the groups names which has the input value which we pass. For example: If I pass input value as "United States" I should get the group with the name "<App prefix>_United States", India => "<App Prefix>_India" Can anyone please help.

Hello everyone, I am using plugin HTML to PDF. I have used two nodes in process model "HTML DOC from template" and "HTML to PDF". In first node("HTML DOC from template") I am passing process variable for  ###name###  (pv!customer.name) and so on for others. Successfully converted HTML to PDF file but I am having issue with multiple entries. Like: I have total 10 records but in pdf all records shown up in one line with comma separator. Note: Created a rule for this where I get all records but getting issues passing this rule in process model node ("HTML DOC from template"). for example: <table> <tr> <td> <h3> Name </h3> </td> <td> <h3> Address</h3> </td> <td> <h3> Unit </h3> </td> </tr> <tr> <td> ###name### </td> <td> ###address### </td> <td> ###unit### </td> </tr> </table