Foundation

Hi All,I have multiple individual excel files and i have a requirement that each file should be made aa a sheets in a  new single excel file.is there any plug-in/way to achieve this ? Thanks in Advance,SSP

I am trying to achieve a functionality where a user upload an excel then added a function to check the format of the excel file whether it matches with cdt or not. if matches, then user can proceed otherwise a hidden section layout will appear with a warning and download option for correct excel sample format but i am getting error in readexcelsheetpaging() as it shows null value error for document parameter.i try to fix it by using if condition and it solves the null error but now when i try to upload an excel file it shows other error "Interface Definition: Expression evaluation error at function 'readexcelsheetpaging' [line 2]: com.appiancorp.suiteapi.content.exceptions.InvalidContentException: Invalid Content ID".a!localVariables( local!excelFormatFromFile: readexcelsheetpaging( excelDocument: if( isnull(ri!excelFile), cons!SD_EXCELFILE, ri!excelFile ), sheetNumber: 0, paginginfo: a!pagingInfo(1, 1), numberOfColumns: 11 ).

I want to verify an excel file after uploading, whether the order of columns in excel file matches with CDT. for example, I have fields like PhysicsMarks,ChemistryMarks as second and third column respectively in excel file and want to ensure that this order of column matches with my cdt like if my cdt have 2nd and 3rd column as PhysicsMarks and ChemistryMarks. How can i achieve this function?

I want a form to be popup upon click of button in UI (a form will be there to enter details and open click on button a new form needs to be displayed)

We have imported our certificate in the admin console => Integration =>Client Certificates,  is there any way of retrieving the signature form here to  sign the xml  document ?

Hi all, I have encountered an issue in an interface while switching from expression mode to design mode in Appian. The issue is mainly cause of nested indexing (An alternate approach that I have used in UI). Below are 2 code snippets, while switching to design mode, the second snippet causes the error to appear. I am trying to use a single index() instead of nested index(), is there any sort of performance difference between these two approaches, or any benefit of one over the other? a!localVariables( local!list: { a!map(key: "test1"), a!map(key: "test2"), a!map(key: "test3") }, a!textField( value: index(index(local!list, 1, {}), "key", {}) ) ) /* Works well */ a!localVariables( local!list: { a!map(key: "test1"), a!map(key: "test2"), a!map(key: "test3") }, a!textField(value: index(local!list, 1, "key", {})) ) /* Gives error in switching to design mode */ Error: Cannot switch to Design Mode The function 'index' [line 7] has 3 p

Hi Champ, I am using document download in my portal application. When user clicking the link, it usually flickers and download it in a next tab and comes back to main page.  Can we somehow stop this flickering behavior? Regards, Ghanashyam

Hi Champs, For one of the requirements, I have to enable the masking for the account number field. It's working fine but when we are navigating from one screen to other, the browser is asking for store the password. can we disable the feature by somehow? Regards, Ghanashyam

Please Check the sample of data i am getting from big query ,,.. I am creating Row id and Unique id after retrieving the data ..  how to filter data on based on npiMap unique_id "1.591111183E9_1902142920_INDIVIDUAL_RIDER_NOT_CHECKED_INITIAL"(Text) row_id 2(Number (Integer)) event_timestamp "1.591111183E9"(Text) npi "1902142920"(Text) rider_type "INDIVIDUAL_RIDER"(Text) trinary_status "NOT_CHECKED"(Text) roster_type "INITIAL"(Text) Map unique_id "1.591111225E9_1922475623_INDIVIDUAL_RIDER_NOT_CHECKED_FINAL"(Text) row_id 3(Number (Integer)) event_timestamp "1.591111225E9"(Text) npi "1922475623"(Text) rider_type "INDIVIDUAL_RIDER"(Text) trinary_status "NOT_CHECKED"(Text) roster_type "FINAL"(Text)NOTE: I dont have an access to the big query where i can filter from initial stage .. but i have this data i only want to filter this retrieved data . 

I am trying to show Student Data in editable grid through excel with marks in subjects. there is a field with total marks which is depend on marks from other fields. Problem is i am able to when i change marks of any subject changes get reflect in the MarksObtained field which is the sum of marks of all subjects but when i submit it does not store the changed data in Marksobtained field. it stores the original data which is in excel file.a!localVariables( a!formLayout( label: "Student Details", contents: { a!sectionLayout( contents: { a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "RollNumber"), a!gridLayoutHeaderCell(label: "FullName"), a!gridLayoutHeaderCell(label: "Hindi"), a!gridLayoutHeaderCell(label: "English"), a!gridLayoutHeaderCell(label: "Maths"), a!gridLayoutHeaderCell(label: "Physics"),

I have uploaded multiple images in the document folder in my application using 'Upload File' option in the Action and Image Id of these images is stored in the database table. Now I want to display these images in the record grid for which I am using the below method in the 'Edit List' feature of the List option of the record: a!documentImage( document: fv!row[recordType!Car.modeldetails.Image] ) Where image is the name of column storing image IDs in the modeldetails database table. But by executing this I am getting the below text as the result in place of image: [@attributes=[@anyAttribute=[_cId:7ea9cd6ac69bf45fb67452fc4de3351f], @nil=], document=[Document:405304], caption=, altText=, link=, actions=, backgroundColor=, version=] Please help me as I want images to be displayed in place of text (image details).

Hi All, I have a table Emp_personal_details and i have around 200 records in that table. Now I need to Insert around 400 new records into the same table. But the new records have some duplicates which are already in the DB. How can I write a sql script to check duplicates in the table and insert the remaining records into the Appian DB. Thanks

wherecontains(null, {"a", "", "b"})   returns 2 i need to get an index of non null values , e.g. in above case it should return {1,3}

load( local!empStatus: { { name: "Ajay", status: "test1" }, { name: "Ajay", status: "test2" }, { name: "kumar", status: "test3" }, { name: "phani", status: "test4" } }, local!empDetail: { { name: "Ajay" }, { name: "kumar" }, { name: "phani" } }, a!boxLayout( label: "Form", contents: { a!gridField( label: "grid", data: local!empDetail, pageSize: 5, pagingSaveInto: fv!pagingInfo, columns: { a!gridColumn(label: "Name", value: fv!row.name), a!gridColumn( label: "Status", value: a!forEach( items: local!empStatus, expression: fv!item.status ) ) } ) } ) ) Hi All, I have added the sample code and the output where I need to display the corresponding status for that particular name. for example: Name: Ajay   Status should be Test1, Test2 and similarly for       

Hi All, I have a scenario where I am getting a URL of the attachment through an API , So I need to hit that URL , So that my file are downloaded . How can I achieve this with the help of Process model or is there any other way  Thanks In advance 

Dears, I have a problem in the calendar interface when the appian language is in ARABIC. The date shows and saves in Persian numbers such as : ١١٠٥٢٠٢٣. how can I keep the date language for all dates in English even though the user language still Arabic? the Persian numbers are causing me massive errors when I map them.

Hello  Team, In Appian  we have a Inbuilt function for sentiment score calculation for Text . "a!sentimentScore() " - only for text. And we do have Google Cloud Natural Language connected system to perform entity and sentiment analysis to collect information from HTML or plain text. But,my question is how do we calculate sentiment score based on voice. if the person who is taking Interview , how his voice is analyzed and get Sentiment score. Could you please help me in understanding How sentiment score calculate for Voice in Appian. Regards, J Vinay.

Hi Team, I have a csv in which I am receiving "11 May 2021 07:08:12 GMT" as text in one of the columns, Is there anyway to cast  to Appian datetime type Regards Bihitak

Hi, We are trying to generate a CSV file from CDT and the first heading on the file starts with @ symbol. Now when I open the file in a text editor Appian/plugin adds some extra characters to it. How do I get around this? Example --  the file generated in Appian -  "'@ENB"NE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 The output we are expecting - @ENBNE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 Also, we don't want any space in front.

Where can we find the slide decks and other content from Appian world 2023? I attended Charle's Tsui's UX session and would like to reference those slides. 

Hi all,  I have this issue: i want to select somehow a specified row in a!griedfield component, like ID 24 in the picture below, then start a process with some value taken from that row, with a submit buttom or something similar that can appear when the specified row is selected. Is it possible to achieve this goal? This is a screenshot of my site in which the element of the only read grid are taken from a recordtype, so this is why the ID is coloured in blue.  Thank you in advance for the responces. 

Hi, how to read mails from gmail using Appian BPM using smart services?

I am getting the error some time page is opening it is getting reloaded after 3-4 sec and showing this error.

HI team, iam using Zoom connected system community.appian.com/.../zoom-connected-system How we get the recordings by giving Meeting id for locally saved? i have recorded a meeting and save it into local folder.so i know that cannot fetch the local files. but to get the recordings where should i save the recordings can anyone help me to get recordings. Thanks & Regards, J Vinay

Hi, is there any way we could start the process model with start form and pass some input parameters from external URL. We have a request where we will have to search some customers in external system, and pass the related customerId to appian process model which should open a start form. So the similar behavior as appian actions, but being called by using URL in external system and being able to pass some parameters to a start form which should be displayed on a link click. For example, we have to search for a customer in external system. When we find a customer we need, we have to start an appian process for that particular customer only by clicking the http link in external system. Another requirement is to avoid starting the process instance if start form for particular customer is not submitted. So, for example, we find a customer with custId=1 in external system, we would like to generate some URL like http://appian.host/start_process/processModelId=2&custId=1&