Foundation

Hi, Is it possible to add a link to Microsoft Teams User profile on Appian User Interface. Thanks.

Hi Team, I am using Appian with backend SQL Server database. I have observed that the IDENTITY column value of a table where I am storing data is skipping number sequence all of sudden. If you observe in my below attached screen, it started showing 1009 after 24. I was unable to trace the root cause of the issue. Can someone advice on this please. Thanks.

Hi, We have a three records . Record A has one to many relationship with Record B and Record B has one to many relationship with Record C We are displaying the all three record data in a grid. We are having issue when display Record C data if one of the row has no value for Record C. Here is the snapshot of the grid column. We would like to show each lineItem as numbered list. In this example P2P is top level record. a!gridColumn( label: "Tracker Entry Date", value: if( a!isNullOrEmpty(fv!row[P2P.invoice.lineItem.name]), "", a!richTextDisplayField( value: a!richTextNumberedList( items: fv!row[P2P.invoice.lineItem.name] ) ) ) ), This works fine in the design mode in the Appian designer. When we access this from the site it throws an error. "Text?list must be used within a SAIL component" We don't want to use for each to iterate over each item to check null as it is causing performance problem. This issue occurs when an invoice does

Basically the title. Is there any way to play a video that was uploaded to the Appian Knowledge Center in an interface for a user?

Web Video will not work since it only plays videos that have already been uploaded to the website by a different way

localvariables( max 10 max20 ) has to print 10 to 20  

Hi, When we have a user input task why do we use start form ? And what is the difference between both of this  What are the use cases of start form and user input form ? Can someone help me please?

I have a multi selection checkbox, so if i select any of the options in that checkbox then only that mail has to be sent to a group of users outside appian and also i want to link a record in the mail body can anyone please help how to achive this. Thanks in advance .....

Hi Team, We are using a paragraph component in our form-layout interface. We are saving its value in a rule input. Though the paragraph would be visible, it would be allowed for editing only when a specific condition is met. The rule input gets updated in an interface but in site page the value is neither getting updated nor reflected in the component. It just disappears. The form is called via a related action from a record type. Below is the code : a!paragraphField( label: "Closure Notes", labelPosition: "ABOVE", helpTooltip: "Maximum 1000 character allowed without extra space", value: ri!closenotes, saveInto: ri!closenotes, disabled : ri!status<>"Closed", refreshAfter: "UNFOCUS", characterLimit: 1000, height: "MEDIUM", required: if(status="Closed",true,false) ) Please let me know how to resolve this

Hi, I have a Multipledropdownfield where users can select multiple items. Based on the user's selection I have to update the value in another field. When the users un-select all the items and when I check the value which I am storing in the local variable, is not showing as null if I check using  isnull(selectedIds)

Hi, Is there an Out-of-Box function in Appian to get the list of all groups a user is member of. Actual requirement is to filter the active tasks assigned to a group which the logged in user is member of. User should be able to view an active task if user is member of the group the task is assigned to. Thanks.

Hi Folks, How can I have expand-all and collapse-all feature as a button/link in my interface which is having multiple section layout. I know we have is collapsible and isinitiallycollpased parameters which are present. But that works only on page load. How can I make it dynamic which is work on clicking of a button or link? Regards, Ghanashyam

I would like to add audit fields to the document type CDT in IDP, when a document is processed not only the extracted data should fill into DB, but I also need to have audit fields to be filled. So, when I was looking into it I am unable to open the interface, saying that this node doesn't allow custom forms When I was trying to configure it from a process model, I was creating a script task and wanted to save data from there, and save the data to DBSo when I Configuring the script task, I am unable to save the data to the particular parameter in the document CDT type, Because the type of the CDT is labelvalue, I need to save the data to the created by a parameter which is in value, so I am unable to do that. This is the error I was getting

Hi, A new vulnerability, known as Spring4Shell, has been notified. This vulnerability, under revision, affects applications that use JDK v9 or above that run Apache Tomcat as the Servlet Container in a WAR package and use dependencies of the spring-webmvc or spring-webflux from the Spring Framework. This vulnerability is being tracked under CVE-2022-22965. Please could inform us it Appian or any of its modules, development, plugins  etc, could be affected by this vulnerability so far known? Best regards, Jesus Salazar

I have four sub processes which are going in AND gateway as input but when control comes to And gateway iit s stuck?

Hi,  I am using a barcode scanner to read an asset and display its details. This part is working fine but I want to clear the existing entry in the barcode field for subsequent barcode scans.  How can I make it work? Thanks  a!barcodeField( label: "", labelPosition: "ABOVE", instructions: "Scan the QR Code of the Asset", acceptedTypes: "QRCODE", value: local!asset.partId, saveInto: local!asset.partId, refreshAfter: "KEYPRESS", validations: {} ),

i'm testing a very  inconsistent  database from an integration   and i'm trying  to get a especific fields if it is there but  the thing is that the  end limiter could be different in too many ways   and this throws me an error that broke my program i tried to many times of not breaking  it  like using index() but  nothing helps  also i tried to   use another function to obtain the values like  the func wherecontains() as a starindex   whitin a mid() function but i didn't fiind the way  of making it work

Hi, I am getting "Missing Keyword Syntax" icon besides my expression rule. There is nothing wrong in calling my expression rule. It is expecting 2 inputs and I am passing.  Not sure how to resolve this. Any recommendations please.

I'm trying to think my way through a problem. What I need is, given a list of groups, I want to see a list of users that are members of all of those groups. The existing tools almost, but not quite do what I need.  groupMembers() will give me the members of a single group, so I thought maybe if I got the members of each group and got the union() of them, that would solve my problem, but union only takes 2 lists and looping through with foreach  (I do so wish there were other types of loops!) would mean somehow getting the union of each member of the list, then unioning those results until I get down to just one list, but that sounds like a pain to code and probably not terribly efficient.  isMemberOfGroups() is nice in that I can take a user and see if they are a member of all of a list of groups, but then I have to loop through basically all users (or at least all users in some initial group) and ultimately I am not sure how many users there could be or whether the

Hi All, I have user interface with a read only grid and a button called "ASSIGN" to each row. When the user clicks on any of the button "ASSIGN" then for the respective record I have to update few columns again the selected database record. When I try to use a process model with a "Write to Data Store Entity" then it is making NULL to all of other column value except which I have try to pass. How can I update the specific column value when the user clicks on the "ASSIGN" button without touching all other column/field values in the database.

I have used query databse service in my process model. Here I wrote this query to update particular fields in database table. I searched on google and i found that active class parameter should be used in query to update database table.  I have made parameter like this and i used these parameters in my above query using ac! . But when i run this model it doesn't move ahead from this stage eventhough there is no error on this stage.  Is my configuration proper?

Hi all i have button layout and i am adding an additional button, with this one, when clicked, the button should go to external website, per say google.com. but a!buttonwidget doesn't have a link field. I found a workaround but that creates a linkfield that opens up once the button is click, the user than has to click the linkfield. but this is outside my acceptance criteria. once the button is clicked, it should go directly to the external website. Any ideas? Thanks.

I was looking for a function that converts standard unix millis to a timestamp. I came across datevalue() but that is based on an Appian epoch of 1/1/2035 instead of 1/1/1970. Short of figuring out the number of milliseconds between those two dates and subtracting the difference, is there some other way to get that time stamp?  Also, while on the subject, why did Appian choose to base their epoch on some time in the future? 

In my process i have two reasons not to put my start interface in the properties in (process start from): first because i have to check condition before start the interface second because the cycle contains loop and i can't loop to the start node  The Process Model works well in the debugging but it can't be added to site or initiated from Action button

is making reports using stored procedures is good practice or using expression rule ?? which is best and why?