Foundation

Hi All , I am build an interface in which two card layout are there for Approve and Reject , and In link field of card Layout I am performing an action . I am facing an issue while refreshing the page when an action is performed via link field of card layout . Please tell me how to refresh a page automatically . Thanks in Advance

Hi All, We have a requirement of closing the current tab in a browser when user clicks on link/button in Appian. For Instance, in a browser I have multiple tabs opened and among that one of the tab is Appian. I have a screen built in Appian and when user clicks on that particular link/button the current tab should be closed. Any thoughts would be helpful in this area. Thanks In Advance!!

Hi ,We are generating report using HTML and converting it into PDF. We are using HTML to PDF smart service for conversion.Now we need to show/hide few section in the  report based on some conditions. We used style="display: none" in html. but this is not supported by HTML to PDF smart service.P.S: We already tried using PDF from HTML smart service, but due to some design issues we started using HTML to PDF smart service.Is there any other possibility to hide/show some sections in report which is supported by HTML to PDF smart service?Thanks in Advance.

Hi team, my requirement is : I called my record type into a interface to show in grid format, want to show all the images i have uploaded for all the respective  id's of grid and i tried using expression rule and but facing problem in passing the id of the record into the expression rule, please help me with this.  a!localVariables( local!selectedInterface, local!ammenities:'type!{urn:com:appian:types:SHA}SHA_newAmmenities'(), local!list:'type!{urn:com:appian:types:SHA}SHA_listType'(), local!Document:'type!{urn:com:appian:types:SHA}SHA_document'(), local!docImage:rule!SHA_qe_getDocuments( entityId:ri!listing.listingId ), /*local!data: a!recordData(*/ /*recordType: 'recordType!{f5a15e34-42fe-43a9-b8c0-e51ffd299618}Student list type',*/ /*filters: a!queryLogicalExpression(*/ /*operator: "AND",*/ /*filters: {*/ /*a!queryFilter(*/ /*field:'recordType!{f5a15e34-42fe-43a9-b8c0-e51ffd299618}Student list type.fields.{listingId}listingId',*/ /*operator: "=",*/ /*va

Hi Team, We have a requirement to place a signature in PDF. We created two ways of solutions. Please find the below details, 1.Signature Component and PDF Utilities plugin. 2.Docusign integration As per my organization suggestion, Docusign needs to purchase a license. But here we want a solutions for R&D purpose. Hence we are not able to purchase any third party license. We used signature component and PDF utilities(Image to PDF) to merge the signature into PDF. Question: But we need to send X and Y coordinates to place a signature in right place in PDF. Is there any way of solution can User picks X and Y coordinates in Appian else share your suggestion too. Thanks, Pradeep Sridharan

Is there a way to restart the course. I am not able to see the activities again. Only course vedio can be restarted.

Hi, I have defined the below process model and an interface with milestone. I don't have any mandatory fields inside the "Previous Employment" tab (form), but still by current process is creating an empty record inside PreviousEmployment table with an employeeId. Can someone advise, how can I stop creating an empty record. Basically, I need to check whether PreviousEmployment CDT is empty or not. Where and how I can do this? Thanks in advance.

Hello, is there a way to optimize the reading of excel file with Excel Tools Plug-in. In general the reading time it takes to long, for example to read 70 cells it takes about 5 minutes, for something like that :  a!localVariables( local!data: 'type!{urn:com:appian:types:BTR}BTR_D1_B'( /* 18 */ c18_1: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {4}, rowNumbers: {39}), c18_2: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {10}, rowNumbers: {39}), c18_3: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {12}, rowNumbers: {39}), c18_4: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {14}, rowNumbers: {39}), c18_5: tointeger(excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {17}, rowNumbers: {39})), c18_6: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {20}, rowNum

How to hide custom picker field and display a textbox for creating new record when there is no matching data available in custom picker in selection coming from DB & Vice-versa. Can anyone help me out for this logic??

Hi, I have an expression rule. Please refer to the below screen I have designed a horizontal milestone inside an interface and calling the above expression at  local!steps. When I run the interface, I was able to see proper tabs (Main Employee Form & Review). But, the Issue is when I navigate to "Review" tab, it was showing hidden tabs layout also. Any one is having any idea, how can I avoid this issue. I would like to show only the screens which are visible during load. I don't to see hidden tab screen details in the "review" tab.

Hi all, Recently been facing issues with the Email Smart Service. Often, it will fail to send an email if there are multiple attachments (PDFs). Has anyone faced issues with it before where it says "failed to process attachments" although the documents are available? It's causing me a major headache, so I'm thankful for all kinds of input. Thanks in advance, Matthias 

Hi there, can "Newline" (Enter Key) character be accepted in "Text" field on the interface? and can be checked if "Newline" (Enter key) character being input (Enter key pressed)? what I am trying to do is that finding the user finishing inputting the data, while dont want to move the focus (the text field is set as "Keypress" for "Refresh After"). regards, Lin

I have created a CDT and it has passed a verification too. But when I try to insert that in the Data Store it throws below error: The data source schema does not match the type mappings: Missing column: a_id in "table_name" (APNX-2-4056-000) Please help

I have created multiple records for my applications .I have configured them using record relationships to my main record . I have to display the record data in a summary interface and when i use the record rule input the related record type surrounding the main record displays the integer value such as 1,2,3 as they are connected using foreign keys.  can anyone describe how to display the original outputs or is it okay to use multiple record rule inputs  as they are connected using foreign keys.

I have this local variable local!variable: {2017,2018,2019,2020} local!variable2: a!forEach( items: local!variable, expression: if(fv!item

Hi there I have an interface which has three barcode fields, what I am trying to do is that once I scanned the first field, the focus can be automatically move to the second "barcode" field, so I can continue scanning without need to click the second "barcode" field on the interface, so on with the third "barcode" field. and also the similar thing with "Text" fields, once I type in the first "Text" field, then press "ENTER (new line character)", then the focus will move to the second "Text" field, so I can keep typing in without the need to click the field to move the focus. Could you please help if you have the experience/knowledge about this? Regards, Lin

Hi All, I Am getting Error in Complete Task Node. "Failed to complete task. Task ID: 1231. Username: UserName" I am passing Task Id of Assigned Task (tp!id), Task is Assigned to me and Assignment of Complete Task is also me.

Hi I have this code written local!productgroup: a!queryEntity( entity: cons!MPPCONSCDT_megaMasterFile, query: a!query( /*selection: a!querySelection(*/ /*columns: {*/ /*a!queryColumn(*/ /*field: "productline",*/ /*alias: "productline",*/ /* */ /*)*/ /*}*/ /*),*/ aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "EOMYear", alias: "EOMYear", isGrouping: true() ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true ).data, I returns below result Is there any way I can remove the null one?

a!dropdownField( label: "Type Of Loan", labelPosition: "ABOVE", choiceLabels: cons!LM_LoanTypes, choiceValues: cons!LM_LoanTypes, value: ri!LM_CustomerDetails.loanid.typeOfLoan, saveInto: ri!LM_CustomerDetails.loanid.typeOfLoan, searchDisplay: "AUTO", required: true a!floatingPointField( label: "Interest Rate", labelPosition: "ABOVE", value: if( ri!LM_CustomerDetails.loanid.typeOfLoan,rule!LM_LoanRates(LoanType: ri!LM_CustomerDetails.loanid.typeOfLoan )," " ), saveInto: ri!LM_CustomerDetails.loanid.interestRate, refreshAfter: "UNFOCUS", readOnly: TRUE, i want to display interest rate through the type of loan with decision i have created.but it is not displaying

Hello  how to convert this text string: "2022-11-12 00:00:00"(Text) to text string in format "dd/MM/yyyy" ? Thank you!. 

Hi All, I required to generate JSON in the below format for the data that needs to be sent to another system thru integration: Req format:  "[{\"ods_service_affected\":\"testetset\",\"ods_outage_start_datetime\":\"2021-11-30 13:00:00\",\"ods_outage_end_datetime\":\"2021-12-01 22:18:45\",\"ods_utage_duration_requested\":\"02 01:00:00\",\"ods_effect_on_site\":\"off\"},{\"ods_service_affected\":\"1213546\",\"ods_outage_start_datetime\":\"2021-12-01 13:00:00\",\"ods_outage_end_datetime\":\"2021-12-02 22:19:09\",\"ods_utage_duration_requested\":\"01 05:00:00\",\"ods_effect_on_site\":\"lor\"}]" As you can see there are escape characters that were added to the JSON. I tried adding those escape characters however I noticed an additional double quote is getting added to the string. It looks like by default double quotes are added to the values by JSON Below is my code: """ods_service_affected""": """" & fv!item.serviceAffected

Hi, I have uploaded an image using "Document" object under the folder "AT_Images" Now, I have created an HTML template which I am using to send an email using Send Email smart service. When I use below code in the .html template document, there were no image in the actual email which I have received. <img src="AT_Images\companylogo.jpg"></img> Can some throw some idea on this.

Hi All , I am showing a pattern like bar chart in an interface i.e Total , Approved , Rejected etc . Now what I am doing is showing total count in the respective field but now as per requirement I want to show the count based on user filter . For example Approved total request is 10 , now user filter the approved , and  the data displayed in the grid(1-5) has only 3 Approved . Then I have to change the 3 instead of 10. How to achieve this . Thanks in Advance

Hi, I have a CDT and it is linked to a form and fileds are linked to CDT columns. Now, when user submit the form, data should save in the main table as well as another Audit table. Any idea how can I achieve this requirement.

I am using user filter in recordtype . Type of filter is daterange. Filter is done by expression rule not by selecting field of record data. I want  start date and end date from daterange picker . How will i get both date? or how can i find data whose date is between this date range.