Discussion Categories

Hii, I am trying to concat multiple strings a!localVariables( local!data:{ a!map(id:1,visitorId:11,name:"John",comment:"hii john"), a!map(id:2,visitorId:12,name:"Jacob",comment:"hii jacob"), a!map(id:3,visitorId:13,name:"David",comment:"hii david"), a!map(id:2,visitorId:14,name:"Bobby",comment:"hii bobby"), a!map(id:3,visitorId:15,name:"Mark",comment:"hii mark"), }, local!distinctIds:{1,2,3}, a!forEach( local!distinctIds, { Id:fv!item, comment:concat(index(local!data,where(index(local!data,"id",null)=fv!item),"name",null)," - ",index(local!data,where(index(local!data,"id",null)=fv!item),"comment",null)) } )) Above code gives me the output as: Id: 1 comment: "John - hii john" Id: 2 comment: "JacobBobby - hii jacobhii bobby" Id: 3 comment: "DavidMark - hii davidhii mark" But I

Hi. I was setting up some save functionality for the one spot in my code that saves to a particular variable. I had a rule that outputs null under certain conditions, but kept watching it show up as {null} instead. I have tried to simplify the issue and have found saving into the localvariable something like {"Apple", "Banana"} results in straight null instead.  What is happening in my interface? If i save the same value to a random debug variable it works fine.

Hi All I have a requirement where I have to query the data from database for a particular column of type varchar(max) which has data more than 1 MB . While fetching the data from query entity, I am getting memory threshold error. Please recommend me some way of how can we fetch more than 1 mb data. Many thanks in Advance!

Hi All, I'm not having the desired result when using proper() with words including special characters.  We receive the error when the user's name has special characters.  EXP)  O'Neal is being saved as O'neal, Aube-Kubel as Aube-kubel, etc. I need to implement a rule for capitalizing letters after special characters, but not sure how to proceed.  Any assistance is appreciated, thanks!

Hi Experts, Need your help in the following issue: I have created one view that is getting data from a table in a DB. Then I created the CDT for the same from that DB and then the DS is also verified and published with no error. But on retrieving the data from a DB rom a query entity I am getting the following error:   Using the Record Type also I am getting the following error while viewing the Record list, We have only 194 records in that view:  Please help me to identify the cause of the error. 

Hi Folks! I have a scenario here which seems impossible to solve. We have an excel template where column A has formula that increments row number if we add data in column B. This excel is used as template in Appian where we are querying a view and dumping the data in this excel. When we tried doing this, the formula is overridden by the values from the view. So the formula doesn't work anymore if we add more rows in the excel. If we keep column A blank while generating template from Appian, we need to update something explicitly in column B for the values in column A to auto-populate. We don't want to use VBA code as well since macros are disabled by default. Is there any way that the formula could work even if we dump data in column A from Appian, any plugin or configurations we could do in Appian or anything on excel side? We want to avoid the situation where we are keeping column A blank just for the formula to work or manually enter values in column A on every row

I have one requiremnt where i need to just convert the raw data into respective CDT. Is it possible to convert into the CDT without expression data. I have used cast but it is not worthy to be work. If same case is used for this using expression then it is working [RecordID=4, CatalogID=, ScopeID=6, VendorID=, InHouseTechnicianID=, WORemediationID=, BidID=, Category=, Description=, GLCode=, GLSeg=, IsExterior=false, LineItemApproval=, MatCost=, Pass=, Price=0, Quantity=1, UnitOfMeasure=, ResidentResponsible=1, Room=, SubCategory=, Summary=, TechCost=, TechTime=, OriginalPrice=, VendorPrice=, Modified=, Deleted=false, CreateUser=henryfok, CreateDate=2/15/2018 12:00 AM UTC, UpdateUser=henryfok, UpdateDate=2/15/2018 12:00 AM UTC]

Hi Team, Is there any way to open Modal pop up window in Appian , our requirement is to open chat bot like popup on the right hand side of the page when user clicks on button.  The Record Relation way I have already tried and its opening on the entire page as popup, and also have tried the show hide way of showing interface. besides these two ways is there any other way of showing popup window in Appian for chat bot. Thanks Bihitak

Hi Team,[Deprecated] Export SQL to Excel smart service is failing in our DEV environment Appian version 23.2. Geeting below mentioned error:"The following error was raised by the Export to Excel function:  null"Same smart service is working in another DEV environment of same version.Please do the needful on this issue. Regards,Sandeep

Do you any of you guys know how to add a button in an interface with the function of converting a query or a record type to an excel and downloading the converted excel in a push of that button without needing a grid and its built in export function?

How to get all records using a!queryRecordType() since batch size -1 is not applicable here therefor any hard coding the batch size might fail in some scenarios. Help will be appreciated..

Recently my Appian cloud environment got upgraded to 24.1 and have advanced level Appian support. But I am still not seeing Case Management Studio, do I need to submit additional request or how can I access it?

Using | Open User Profile | and | Open Settings Menu | as they appear in the Cheat Sheet  results in an error: Input Must Be Set.  Are there examples of how to use these correctly?

Hi All, I have a scenario where Appian task is already created with the task display name, for example as 'Task abc with amount $100". Now when the user opens the task form, the amount will be recalculated in local variables and and are updated in database using Store Procedure execution function in local variables . So, every time when the form loads, the amount will get refreshed and updated in Database as well. Now my issue is ,when the amount is refreshed, the task display name should also get refresh, for example if the amount is refreshed from $100 to $200 , then task display name should be 'Task abc with amount $200". Note: The amount in task will get refreshed at the time of form loads, without any user interaction inside the form. Please help me to achieve this. Thanks in Advance.

getting this error while loading data to DB table using import excel to DB smart service (conn=246144) Incorrect date value: '4/24/24' for column `Appian`.`bwauserdobcdt`.`dob` at row 1

Hi Everyone, Can anyone please help me, Is it possible to display image in radio button as shown in screenshot below:

Hello, everyone, I need to create a PDF from a template that requires a dynamic hyperlink. When I tried using a DOC template, the link wasn't generated. When I attempted to use an HTML template, the link was generated, but after converting it to PDF, the link didn't work in the converted PDF. Could you please suggest a way to create a dynamic hyperlink in a PDF?

Hello, We are building a site which will be used to gather request and I'm trying to find if there is a possibility to make bulk upload of these request using excel. The form which need to be submitted contain single rows and also arrays of data. We want all of these bulk uploaded request to stay in "draft" mode and not being push to the backend databases, because that can lead to incorrect information to the database since we have some validations which need to pass. We need to give the client the agility to edit these information when they are loaded as bulk. What are the capabilities of Appian to load bulk data, what are the limitations?  Thank you!

Hi everyone,I have a process with a PDF from HTML task. The problem is that the pdf that is generated only has one page, so only the content that fits on one page is displayed. How can I modify this process to generate multpiple pages? This is the process:

Hello, im new to appian and we have a requirement that after submitting the Form it should go to the Record List interface next and i have checked and "Confirmation URL" should do the job done. but im having trouble configuring it. i have used : "site and tempo links" dev.appian.com/suite/sites/sandbox/page/record-list dev.appian.com/suite/tempo/reports/view/KQPHyA please help. thank you very much!

Hello, we have a locally hosted production environment and a cloud development environment. We want to deploy the application from the cloud to the local machine. When we export in dev and import the app to prod environment the database tables are understandably not linked to the record types. However when I connect them and tell Appian where they are (I am running a local MariaDb and connected it to Appian via admin console) they are connected up until I import another version of the application. So on each import I have to go through each record type and add the data source which is the database table. How to solve this? There has to be a better way to do this.

Hi 

How do we go about inserting a TIFF file into a Word document using ADT? Currently, we're able to insert a TIFF file with a single image into Word without any issues. However, when attempting to insert a TIFF file with two images, we encounter a problem - only one image is inserted successfully while the other is not. What could be causing this issue?"

Hi All  I am calling one web service through Appian Integeration and getting the below error. I want to send the appian document in base 64 string. I checked in appian community and found that appian automatically convert document to base 64 string but facing issue. the request body of web service is in xml format. Please refer the below screenshots. In below request i have to send document in content tag and it should be in base 64 string. the ri!Attachments is document type. Many Thanks in advance.

Hello everyone, I have a field for created date of type varchar(255) and it has the value in string, for example: "20220505101000345600", what I did before was converting it to date before saving it to database with this expression:  concat( mid( index( ri!pulsarMessageValue, "CREATION_TIMESTAMP", null ), 5, 2 ), "/", mid( index( ri!pulsarMessageValue, "CREATION_TIMESTAMP", null ), 7, 2 ), "/", left( index( ri!pulsarMessageValue, "CREATION_TIMESTAMP", null ), 4 ) ), but now I am required to do store it as timestamp so then I can show it in the interface. My question is if is there any way to store it as datetime and then in the interface part I can use the formatted column or I need to convert it in the interface like this: