Foundation

Getting this error how can i resolve it. I have given 2 different CDTs  Thanks In Advance

Hey everyone! I'm working on an email template which I'll be using inside a Send email node and I have to add a logo as a signature. Because of company requirements, I can't use href HTML attributes and I already tried using inline-css, svgs and base64 versions but those are not viable options due to email provider incompatibility. So the only option left I could think of was the following: Storing the logo inside the Document Folder in Appian. Creating a constant pointing to the logo file which is a PNG. Inside the process model I create a Document type process variable. That pv as a value has the file constant. Inside the Send email node I went to the Setup window an inside the Message body I inserted the logo pv as an expression.   But the received email doesn't show the image, it only shows the following message.  Do you know if there's a way to send files that are stored in Appian through the send email node? Also, attache

Hello,  I am trying to design an interface when a technician clicks on "Accept Ownership" will trigger a process where we capture the user who clicked on the link and update the database. Below is part the interface code for accept ownership. a!sideBySideItem( item: a!richTextDisplayField( label: "Technician Name: ", labelPosition: "ADJACENT", value: { if( a!isNotNullOrEmpty(local!technicianInfo['recordType!{668f9fee-8c8c-4ec0-8719-8fe261ecebe6}CG Technician.fields.{28788328-2480-438c-be68-4a5bfccfa974}assignedto']), local!technicianInfo['recordType!{668f9fee-8c8c-4ec0-8719-8fe261ecebe6}CG Technician.fields.{28788328-2480-438c-be68-4a5bfccfa974}assignedto'], a!richTextItem( text: "ACCEPT OWNERSHIP", color: "NEGATIVE",

I have a question, well I have a requirement which we need to extract files from appian from a directory on a server using the Sftp functions, the problem is that when we want to do that function the destination folder does not support SFTP, Well, is there any solution to send files to a folder if it does not support sftp? Thanks!! 

Hello, I want an event to happen (send email) after submitting a user interface (form) only if a certain attribute has been changed. I figured that I would need the old and the new value of this attribute in the process. What would be a good way to achieve this? Thank you in advance

I am retrieving a large JSON document from a web service and need to display this on a set of interfaces.  The JSON has separate sections for different aspects of the data and my plan is to create separate interfaces for each section then add each of these interfaces to a single master interface.  The end user will be directed to this master interface to view all the necessary information from the JSON document.  This data is strictly read-only.  We will have other JSON documents that may allow edits which are then passed to an integration to be saved in a database, and/or to notify other system components of the change. Some of these components are made available to multiple Appian applications which are created by other developers (not involved in the creation of these common components). The question I have is around passing data internally between Appian objects (process model to interface, interface to interface, interface to expression rule, etc).  Should

Hi friends, I got a chance to interact with [mention:115d03e07c2843c691ef69b0951c7286:e9ed411860ed4f2ba0265705b8793d05] on my podcast and she has explained a lot of things related to the Appian Community that should be very useful for all my fellow community contributors. The discussion includes topics like -  The solution to spams in the community Big plans with the Appian community  And the upcoming problem with the Appian World 2023 Live build challenge. Find it here - https://www.youtube.com/watch?v=PDiFsvfYWWY

Hi All, I need to extract the process completion date of process instances  which has been archived. Is there any way that I can extract the archival processes in report. Regards, Vikram Kumar Singh

Hi, There is an issue i am facing with query databse smart service, Where i am executing a stored procedure which fetches data from multiple tables and insert same data to a table. - It works if i execute the stored proc with same parameters by SSMS(SQL Server Management Studio) - By Query Database Smart Service it sometimes gives me error -  The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete. attached screenshot for reference Thanks 

Hi All,  I am working on a use case where i need to first convert CSV to excel then import converted excel with extra column to a staging table.  Reason to use import excel to database intend of directly using csv to database is i need to dynamically add process instance id in staging table. I didn't find any option to achieve same in CSV to Database.  CSV to excel is working fine. I am able to generate XLSX file and passing it to import excel to database. My process is getting completed successfully but i don't see data in staging table.  I tried converting csv to xlsx in my local machine and used locally converted xlsx in process model, it worked but same when i am trying to achieve from CSV to excel smart service generated excel, data is not getting imported. I don't have auto generated column in my XLSX file. Please advice what can be done resolve this issue.  Thanks in advance for your help. 

Hello Community, I have an interface that displays two types of data coming from two methods that delivers the json values. If this is an individual I have built out a CDT that ties into the method "individualResult".  If it's a group, I will have to tie into the "groupResult" method.   The properties are the same, but the methods are different.  I'm wondering if anyone has a recommendation as to how to build this out? Let me know if more information is required. Thank you.

Hi All, In our application folder more than 4000 child folder reside inside the folder. First of all, I want to extract all the folder and show in the grid and then I want to seach them by folder creation Date. Kindly guide me on how to do this. Regards, Vikram Kumar Singh

Hi  all,  may I know, how to extract data from an xml file Thank You

Hi There, I’m trying to use card as buttons pattern to call an interface. Interface is having gridfield used inside a!headerContentLayout() to display task lists. However, I’m not sure how can I call call this interface using card as buttons pattern. Is that a right way of calling ? Please do let me know if you need any more details.

Hi All,           I have a requirement that to display the month name & Year  from two particular dates .Is there any direct function or please give any valuable suggestions on the same. Ex:11/2021 --10/2022  It should display Nov2021,Dec 2021.....Oct 2022 Thanks & Regards Saidivya Minna.

Hi everyone, I just created one interface which queries data from a record type, to build a dashboard.  I want to call that interface into a bigger interface, in which if I click the card field, the dashboard will show up. This existing interface is using a!cardLayOut for displaying other field, and I couldn't find any solution to call the new interface into it, as the a!cardLayOut link parameter only accepts  a!documentDownloadLink(), a!dynamicLink(), a!newsEntryLink(), a!processTaskLink(), a!recordLink(), a!reportLink(), a!safeLink(), a!startProcessLink(), a!submitLink(), a!userRecordLink(), or a!authorizationLink(). Is there any way I can work around with it?

Example:  Rule input has no. of items 24, I want to retrieve in batches of 10. i.e at 1st I need to get top 10, 2nd time next 10 items and 3rd time should get 4 items

Hi everyone,  I'm quite new to process model things, so there were something that I have heard of but didn't understand.  1. What is process model engine? Is there any documents about it? 2. How to set the sub process to be executed on the same engine with its parent process? And is there any benefit on that?  Really appreciate your helps!

Hi team I'm needing some help to force an answer in a dropdown field where a given answer is selected in another dropdown field.  Here is a screenshot of the editable grid. I want to force "not used" in the "how important" column when "never" is selected  in the "how often" column The software names are returned from an existing table. This is how the answer table is set up: Answer Table id Name questionID 1 Daily 1 2 Weekly 1 3 Monthly 1 4 Quarterly 1 5 Annually 1 6 Never 1 7 Vital 2 8 Important 2 9 Useful 2 10 Not Useful 2 11 Not Used 2 The questionId corresponds to the two column headings. Here's the expression for teh editable grid: { /* For the Software Title Column*/ a!richTextDisplayField( value: a!richTextItem( text: fv!item.softwareID.name, color: "ACCENT", size: "MEDIUM", style: "STRONG" ) ), /* For the Frequency Of Use and Vitality Columns*/ a!forEach( item

I am creating a new record with id, as soon as I click to create I want to redirect to that particular record summary page but it's going our site home page, Can anyone help on this Thanks in Advance

Hi All, I am getting an error while adding a new page (which consist  a rule input  ) in the site . Previously I was able to add the pages with rule inputs but from today its showing error. Please help me to rectify this error.

Good Afternoon! I'm trying to deploy downloaded package in Appian environment using internal API of Appian. https://docs.appian.com/suite/help/22.3/Deploy_Package_API.html 1) Could you please advise how to use it more correctly. For example I need to describe name of the package - how I can set path for local downloaded package with the next deployment? 2) Can I use API body without sending DB scripts? Could you please provide examples for understanding? Thank you! Best Regards, Aleksandr

Hi, I am experiencing the problem with task "Write Maintenance Record" from the learning exercise. The problem goes on saying that it is impossible to write to the source due to system error. Error Details: Field 'MaintenanceScheduled' doesn't have a default value. Any ideas how to fix this?  Thank you.

Hi, when I try to configure a script task in a process modeler I cannot put anything in the Target field in the Data Output tab. It simply does not allow to open it. Moreover, everything that I save to the Data Input tab in the field Value is cleared afterwards, so when I get back to this tab, the field Value is blank again. How can I solve those issues?  Thank you.