New to Appian

Hi Community Team, Here, I'm using two Cdt's One parent table (Emoloyee Details) and one child table (Comments). I'm calling primary key in the parent table into the child table to fetch the values in the Child table.  I'm getting NULL instead of primary key of parent Cdt. Please help me out how to configure this error? Child PK                    Parent FK Comments_ID     Employee_ID  1                           NULL  2                            NULL  3                            NULL  4                             NULL  5                  &nbsp

Hi Community Team,  I need to set validations for 3 date field components. The following use cases are as follows: Commonly No filed is null or empty. 1. Field Name: Joining date validations are : I must be able to select the date which is over past 100 years and also able to select the future date which is One year from today. 2. Field Name: Access Start date validations are : I must be able to select the date which is from join date or I must be able to select the date which is one month from today. 3. Field Name: Access End date validations are : I must be able to Validate the date which is from one year  from Access Start date. For each filed, If the validations were violated, it returns error message. Please help me out to solve this use case. open for suggestions.

Hi All, I have a integration point in process and it is returning HTTP Response. I would like to know how to convert HTTP Response to CDT . in HTTP Response there is body attribute which i want to convert directly to CDT if possible. I have already created a CDT with the same structure. Example : body={coord={lon=-83.1801, lat=42.3349}, weather={id=501, main=Rain, description=moderate rain, icon=10d}, base=stations, main={temp=20.35, feels_like=20.84, temp_min=18.83, temp_max=21.73, pressure=1017, humidity=92}, visibility=10000, wind={speed=3.09, deg=80}, rain={1h=1.5}, clouds={all=90}, dt=1626440173, sys={type=2, id=2009516, country=US, sunrise=1626430214, sunset=1626484018}, timezone=-14400, id=0, name=Dearborn, cod=200} Thanks, Gaurav

Can I get a solution for which will be responsible for taking inputs from appian in json format and handing over it to UI(react js or javascript or html) and taking the response from UI and giving response back to appian which needs to display the UI in appian designer, is this possible in appian designer if so can you please provide me the solution?

i have to provide a link, once they click on that link the document has to be downloaded. for this i need to give 2 paramater 1. unituq id(we already have) 2. document id(we already have) can anyone help me with this?

I have a read only grid with select boxes enabled creating something like thisAlmost everyone says that you should used delete from data store entities to handle record deleting. However, this page https://docs.appian.com/suite/help/23.1/Custom_Data_Types.html says that most of the time you should not use CDT but CDTs are required for DSE.Where can I find a step by step walk though that does not use CDTs or DSEs to delete multiple records from a read only grid?

Is there a way to get editable grid to page through the entire data set similar to 'read-only grid'?  I have 10K records and each record needs to be classified based on a list of categories.  Right now, the entire 10K records are being shown. Thanks.

Hi Experts, Below Block-A code line is working fine, whereas Block-B is not working even though "tointeger(index(rule!AB_getReviewKey(key: 100),"reviewkey",null()))" is returned 2. Any comments please. ----------------------- Block-A ------------------------- a!localVariables(local!reviewkey: 2,local!excludeKeys: if(local!reviewkey = 2,{ 1, 3, 4},if(local!reviewkey = 5, { 1,3,4,5,6 }, {1,2,3 })),local!excludeKeys) ----------------------- Block-B ------------------------- a!localVariables( local!reviewkey: tointeger(index(rule!AB_getReviewKey(key: 100),"reviewkey",null())), local!excludeKeys: if( local!reviewkey = 2, { 1, 3, 4}, if(local!reviewkey = 5, { 1,3,4,5,6 }, {1,2,3 }) ), local!excludeKeys)

How can I change the Delete Note recordActionField to look like the buttonArrayLayout?Or, how can I add the a recordAction to a buttonArray? In the end I want to have something like thisPlease notice the Delete Records button and the Add Record button.The Add Record button also needs to keep a reference to a parent record.

Hello: I need to retrieve data from an external API which requires a parameter (ProductID).  The values for ProductID reside in an application recordType table and has to be passed to the integration.  So, the expression called to populate another recordType to store data from the API has a query.  However, I keep getting this error.  Any suggestions on how to resolve this issue? Thank you. Ma

Hi, I am using CDT "AM_Business" in one of the interface. I may get an array of values. Now, I would like to test the interface by passing multiple rows of data. I was able to test with single row of data, but not sure the format for passing multiple rows of data. Can any one help here. { 'type!{urn:com:appian:types:AM}AM_Business'( 'businesskey': 148, 'headerkey': 95, 'dbkey': 3 )}

I'm working on Appian Step-by-Step Exercise 9. When following this step, "7. Go to the AX Vehicle record type, and next to the record type name, click View Record List. Click on a VIN to view the updated summary view interface." When clicking on a VIN I am getting an error "Error Evaluating UI Expression Expression evaluation error [evaluation ID = RIBW5] at function a!contentLayout [line 76]: An array of components may only contain components. Received Text at index 1. (APNX-1-4198-000)". I'm not quite sure how to move forward. 

1. From where Tooltip  in record actions come. 2. How will I remove or modify tooltip in record actions

when i practice in the appian community i couldn't find generate record view in views and header it only has generate interface. can anybody tell me the solution?

Hi, When I used "Export Data Store Entity To Excel" and if there is no data in my Data Store, then I am getting below message inside an excel file. "No data available due to empty data source, applied filter/selection criteria, or fields visibility." Can we customize this message. Any ideas please. Thank you.

Hello: Is there a way to access the expression that shows the list view if I have to customize the look/feel of that page? Thank you.

Hi, I have to display a disclaimer message on a Appian page with "ACCEPT" and "NOT ACCEPT" buttons Once the user clicks on "ACCEPT" button, then only I should load the Appian. If the user clicks on "NOT ACCEPT" button and I should not load the Appian. Can someone advice how to achieve this. Thanks in advance.

Getting below error in a simple Add vehicle form that I created during training. File upload control is not working at all  This is how the File upload control has been configured a!fileUploadField( label: "Image", labelPosition: "ABOVE", target: cons!AX_DOCUMENTS_FOLDER_POINTER, maxSelections: 1, value: ri!vehicle['recordType!{2f4a1797-5b65-4891-a7cf-42ddbb49c8a6}AX Vehicle.fields.{ac064698-12ee-46cc-aebd-629ecc0dedae}vehiclemileage'], saveInto: ri!vehicle['recordType!{2f4a1797-5b65-4891-a7cf-42ddbb49c8a6}AX Vehicle.fields.{d5103e88-da32-42aa-9559-ec1004b4ce57}vehicleimage'], required: true, validations: {} )a!localVariables( local!category:rule!AA_QR_REF_getVehicleCategory({}), local!condition:rule!AA_QR_REF_getVehicleCondition({}), a!formLayout( label: "Add Vehicle", contents: { a!sideBySideLayout( items: { a!sideBySideItem( item: a!integerField( label: "Year", labelPosition: "ABOVE",

Hi team, I am Exploring the Decision Capabilities in appian, In other Tools for Example PEGA there is a concept of Models Like Adaptive and Predictive Models or Basic like Decision Table or tree. So I want to Know how those Capabilities are done in appian. In some Resources i came to know that we a seperate decision designer in Appian is that True ? if yes How we can get that to Use? Thanks' & Regards, J Vinay.

Hello: Is there a function that will convert a list of map-items to a string? I have this output but the input variable to an API-call is a string: "2404416,2257045,.......".  Guess, I could do a loop to concat the values to create the string but was wondering if there is an Appian function to do this. Thanks.

How I remove filter, refresh and download buttons from Record

data: local!noteData, columns: { a!forEach( items: local!fields, expression: a!gridColumn( label: fv!item, value: index(fv!row, fv!item, "") ) ) }, How do I convert the above code, this part: expression: a!gridColumn( label: fv!item, value: index(fv!row, fv!item, "") ) To something like: a!gridColumn(label: "Note",value: index(fv!row, "Note", "")), a!gridColumn(label: "Name",value: index(fv!row, Name, "")) Where both Note and Name are keys in a dictionary. Thanks

HI, I have a read-only grid with few column along with a column under which "update" buttons are there againest each row. Now, when I try to use "Export to Excel" icon, it is downlading all the columns inlcuding button column name like "update" against each row. Is there a way I can avoid "button" name in each row of export to excel.

Why is it so hard to create something like this in Appian? Filed 1 Field 2 Checkbox Field1Value Field2Value Checkbox Field1Value Field2Value Checkbox Field1Value Field2Value Checkbox Field1Value Field2Value Checkbox Field1Value Field2Value Checkbox Field1Value Field2Value 3/6 records selected I can get the check boxes and the Field 1 and Field 2 in a table as well as the selected count. What I can't seem to get the total record count.

Hi Experts, I am using executestoreprocedureforQuery smart services to retrieve data through stored procedure.  Can anyone help me that how to mention DataSource name ? Thanks