Foundation

Hello everyone I noticed that  HTML to PDF smart service dose not  support Arabic language ? The PDF form Shown as the following page  is there any solution for that? or is there another plug-in that does support Arabic language for pdf? I also tried to use different Font types, all give the same problem! NOTE: I am using Advanced Rich Text for Tables and very large paragraph.

I have a table in particular sheet of excel file and the cell are all bordered for them till next 50 cells but when i try to read cell after 50 in that column it breaks just because of the below cells are not bordered. Can you please help me with the same excelreadcellsbynumber( excelDoc: ri!document, sheetNumber: { 2 }, columnNumbers: { 7 }, rowNumbers: { enumerate( 100 ) + 89 } ) Error: Expression evaluation error at function 'excelreadcellsbynumber' [line 36]: above expression breaks and the below one works  excelreadcellsbynumber( excelDoc: ri!document, sheetNumber: { 2 }, columnNumbers: { 7 }, rowNumbers: { enumerate(50 ) + 89 } ) only difference i can spot is the cells after 50 from cell line are all bordered. and when i border all those extra cells it starts working. Please suggest, if this is expected behavior or  am i doing something wrong

When a user adds a text value to a floating point field, Appian displays a validation message by default. However, when the user clicks the refresh button in the same UI, all validations should be cleared and the fields should be reset. Unfortunately, Appian's default validations are not refreshing properly in this scenario. Is there a solution to refresh the validations after clicking the button in the same UI, without using record actions?

is there any guidance for Associate developer interview i have passed certification of associate developer

Hi Champs, I have a portal having milestone section. I have a landing page and once user click the "Start Application button" in landing page, the milestone starts. In each of the page, I have a option to proceed next, back and cancel button. There are some mandatory fields in each of the pages without which the page won't proceed ahead and gives the validation message. It's working fine; but there is one issue. When I am cancelling the form, it's coming back to landing page and then when I am clicking next, automatically it's showing the mandatory field validation without even user clicking the next button. How can I reset it, so that it will only show the message when user click the next button only. Regards, Ghanashyam

Can we extract data from sail code to java code:Example : Sailcode present in xml file under definition tag <definition>a!localVariables( #"SYSTEM_SYSRULES_sectionLayout_v1"( contents:{ #"SYSTEM_SYSRULES_richTextDisplayField"( value: { #"SYSTEM_SYSRULES_richTextItem_v1"( text: "Click here to display Case(s) Information", link: #"SYSTEM_SYSRULES_safeLink"( label: "Company web site", uri: "">http://www.appian.com" ) ) } ) } ) )</definition>into java object to get data of text : "Click here to display case)s) information", link label :"Company web" , link uri :"http"//wwww.appian.com"

Hi while user trying to access the task was getting the UI error like below but i am accessing with service account i am not getting error like below checked the security of document and folder everything seems fine please suggest on this  Error Error Evaluating UI Expression Expression evaluation error [evaluation ID = c9b13:9d17a] in rule 'dm_attachmentreviewsection' (called by rule 'dm_executiontaskfor') at function 'document' [line 27]: User Does Not Have Rights to Perform this Operation 

Hello, 1.- I have a dynamic interface that show some data depending on rule input variables. 2.- In this interface I have a a!startProcessLink that execute a PMO with interfaces in it so the user is sent out of the first interface. 3.-Problem: When the PMO is finished the previous interface is shown with default values and I want to show it with the values it had before the PMO was executed. Is there any posiibility to solve this problem?

Is it possible to update the expiry time of an Appian task dynamically every time it is accessed? The initial expiry time should be set to 1 hour when the task is triggered, and the expiry time should reset to 1 hour every time the task screen is accessed?  I expect a smart service kind of a function to update the expiry time of a existing task which can help in the scenario. Your suggestions please. 

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.