Discussion Categories

I have a grid (in SAIL) that displays a number of rows.  When one row is selected, the details for that row are displayed below.  Any edits the user makes to the details need to flow back to the grid and be displayed.  This grid is not tied to a record set, but CDT data obtained from other parts of my application.  NOTE:  An editable grid will not work for my scenario. A greatly simplified version of my need is.... a!localVariables( local!data: { { name: "Springs", qty: 4, unitCost: 1.27 }, { name: "Sprockets", qty: 1, unitCost: 2.50 }, { name: "Gears", qty: 7, unitCost: 1.98 } }, local!selection: null, { a!sectionLayout( label: "Order Summary", contents: a!gridField( data: local!data, columns: { a!gridColumn(label: "Qty", value: fv!row.qty), a!gridColumn(label: "Item Name", value: fv!row.name), a!gridColumn(label: "Unit Cost", value: fv!row.unitCost), a!gridColumn(labe

Hi All, I got a read only view from Oracle where no primary key column exist but In Appian we have to make some column primary key how can I solve this problem. Appreciate your help! Regards Nishtha

Hi, I want to use the API of JavaScript in Appian, but I dont found a lot of information about it. Anyone has use it or have more details about it? This is the link that I found: https://docs.appian.com/suite/help/22.4/reference-js-api.html#api-reference Thanks in advance and regards.

hii guys, I have a requirement of design a record action called DELETE For this i have followed documentation and approached process model method to delete record action using DELETE RECORD SMART service but im getting following error plz help me thanks in advance

Hi all.. What is the best way to show more than a few record types? For example, lets say an application has below record types and related record types. Organization Customer Address Product Flyer Point Programs Point Credits Discounts Orders Order Items etc. etc. I'm just making up record types that may be related to each other in some imaginary business Now, given that Appian has 5 tab limit on a Site, how do we expose these many entities in a site if I have to?

Hi All,  I am facing an issue regarding process report. I have crated one process report to fetch process history with last seven days and using that process report in a interface, But as per my requirement i need to fetch process history with only two specific process model, not for all processes which i was performed in last seven days, for achieving this i have created one filter in Process report where I am using  Process= GPA Task Loader by using this i am able to fetch process history but it showing only today history. So there is any other way to fetch process history for  two process model with last seven days data. a!localVariables( local!statusFilter, local!processTask: { "GPA Activity Task Loader Excel", "GPA Activity Task Loader Excel Validation" }, local!taskReportData: a!queryProcessAnalytics( report: cons!POC_GPA_USER_REPORT, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 500,

Hello All, We are having 1 record which is having relationship with others record also. We are getting the data from the record by the function a!recordData( ) and displaying on the interface. We are having different buttons for child interface on the selection we filter on the basis of the different status related to the button clicked by the user we are fetching the data from the record. The requirement is to show the number of records with the button label. Anyone who have used some function by which we can directly fetch the number of filtered record and can display. Thanks in advance

Hi Everyone, I am quering the data from table and stroing it into local variable. On button click I am refreshing the data using refresh varibale parameter refreshonvariablechange , but the variable gets changed and data is not refreshing. Could you please help me out?

i want to convert json (text format data) into excel sheet data which Componentes or plug in i use ?

Hi All, Is it possible to read the data in the word document or PDF file, and perform some actions based on that data ? Thanks in advance. Warm Regards Vineeth

Hi All, Not able to fetch data from Oracle getting above error. Please guide how to solve. Regards Nishtha Bhatnagar

Unable to login suddenly (not sure why, the user does not seem to be locked).  Click [Forgot Password] sends a reset link, pressing (immediately) the link fails witn  "Your Link Has Expired" message.  Weird!

i Wanted to add few alerts like after submitting form i need custom alerts and after filling some fields i need to display alerts or info messages.

Hi,  in the grid one row need to populate by default is it possible to do? based on the id.. if the id is in db then populate row automatically else no Thanks  

I am very new to Appian. I just wanted to know that is there any otp related out of the box service available to connect with other messaging services?.

Hello, can someone help with this issue. I have a process model that retrieves data into  a variable defined as a multiple of CDT. The variable is then passed as a parameter to a sub-process, and because it is a CDT and may change it is also defined in the sub-process outputs. I can see multiple records being passed correctly to the sub-process but when the sub-Process ends, the output only has one record. Both variables in the main process and sub process are of the same type and have been defined as multiple. I can see in the process history of the sub-process that the CDT has two records, and this does not change and that the main model starts with two records and is changed to one after the call to the sub-process Any ideas why data is being lost? Many thanks SimonJ

Hi Everyone, I have an primary interface page and in that there are different tabs calling other interfaces. In primary interface page there is a button and on the click of that button all the tabs present in primary interface should be disabled. Can any one please help me how to achieve this?

After related action in report it refresh only 5 data in grid.suppose i have 16 row in grid after record action it reflects change in 5 rows only for all row i need to refresh manually. suggest some resolution for that.data is comming from data store entity.

I have nine different category types for any given main process. The requirement is to create an Excel spreadsheet with each category appearing in its own sheet. What should be the best approach to achieving this? Currently, I am creating an excel for the first category and then using that same excel for the subsequent categories in Export DSE to Excel smart service to add a new sheet via sheet number. But this process is sequential and not efficient enough if each category has a huge amount of data. I attempted to generate Excel for each category and use the merge excel document smart service, but it did not work as I thought it would. Basically, it is dumping all category data onto a single sheet.

I have created an apian web post API. api is working in appian and when i try to test it in postman its gives error 501. how can i test it in post man. need help. i already created outh credentials and also added the service user to the application groups.   a!localVariables( local!value: cast( 'type!{urn:com:appian:types:TFA}TFA_TESTING_RT', a!fromJson(http!request.body) ), a!writeToDataStoreEntity( dataStoreEntity: cons!TFA_data_store_constant, valueToStore: local!value, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!storedValues ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error writing to the data store" } ) ) ) )

Hi, We have a LDAP and AD Group process to sync AD group and its users into Appian. If a new user being added to the AD group, then same user is appearing under respective group of Appian using LDAP Sync. When the users have been removed from AD Group, after sync ran, user is also getting removed from Appian. If we remove the user in AD Group, I would like to understand if there is way to keep the user in Appian with "Inactive" status instead of deleting. Thanks in advance.

Hi Everyone, I have a requirement where i need to disable the button for particular user.

Hello Appian People, I have a test WEB API(POST) in order to test my integration process.  I also created a test datastore. { user: address: } Please see picture So what i want to happend is that what to add a test process condition: If the Request result normal, and statusCode 200 - body: received value will be "0" Incase parameter error,and statusCode 200  - body: received value will be "1" Anyone has any idea to add this test condition in my Test web API?

Hello Appian People, I have integration GET(Queries Data). Basically this integration search address. And I call this integration in the interface. In my interface I have a texbox and search button, whenever the search button is clicked if there is corresponding search result returned in the integration or if the integration search result is onSuccess the result value will print. So my problem is, how to check if  the result of the integration in the interface  fails/failure and gets the corresponding message of the integration error?

Do we need verify each Data Store every time when we change Data Source in Appian?