Foundation

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, 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.

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

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?

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.

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

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

There a CDT with number of fields, I'm trying to update one field X as Array. In this case when I try to publish my Datastore it creates a separate table with random table naming and fields to store multiple values of field X. Is there a way we can give our own naming for that table being created in the above case. I have tried downloading the DDL script and try editing table name and field, But that doesn't seems working. Can anyone give me an insight why it's taking the random table name or is there any workaround in the above case ? Thanks in Advance

While creating a drillable chart I have the month value stored as an integer. Like :  Jan =1, Feb =2, How do I create a record filer to display records that are from that month only? Here is chart for reference :

Hello, I've noticed in couple process that I'm not able to open a process instance and somehow the process instance gets bugged and jumps nodes (Doesn't happen on every instance). Have anyone faced this issue and how you got it fixed. 2023-01-11 07:11:45,191 [ajp-nio-0.0.0.0-8009-exec-595] ERROR com.appiancorp.security.cors.CorsFilter - CORS request rejected; invalid request from xxx.xxxx.xxxx to /JSON-RPC org.apache.jasper.JasperException: java.lang.IllegalStateException: getOutputStream() has already been called for this response

Hi Everyone, I am using the script a!groupsForUser(loggedInUser()) to get list of groups assigned to user but it gives the id along with group and I only want group name. Can anyone please suggest?

I have column chart as shown in image and have made it drillable. How do I filter records to show corresponding months records?

Hi, There is processmodel causing JDBC exception due to long data inputs for STATUS column  local! externalReq: "resourceName=Employee,employeeDetails=[empId=,empEmail:external@yahoo.in,  status=married,married,married,married , age: 30], companyDetails=, serviceProviderDetails= ", There is a process model where its receiving some details from external API and for some reason i am getting few duplicate fields in a running process instance .For example: status column in employeeDetails table. if the resourceName =Employee then there is employeeDetails been received from API and for some reason i am getting status column as duplicated.Expected thig is status=married . and as the status column has 10 character length in DB ,my process is causing error . how can I modify the existing payload to this :-   "resourceName=Employee,employeeDetails=[empId=,empEmail:external@yahoo.in,  status=married , age: 30], companyDetails=, serviceProviderDetai

Hi everyone, I am creating a process model which starts and receives some data from email due to a Receive Message Event, then processes this data with some logic and finally sends summary email in response using Send E-Mail Smart Service. I want that the summary email that my process sends to be displayed in outlook (or any other email program) as a conversation, that means to be grouped and displayed in one thread. Case: - Person X sends email A to Person Y that triggers my process model,- Person Y receives email A,- Process model executes and sends to person Y summary email B as a response to email A,- Person Y receives email B and both emails A and B are displayed in one thread in person's Y outlook Usually in high code to do this, I need firstly set headers parameters as References, In-Reply-To for my summary email B before sending. I get this headers values of email A with Receive Message Event but I do not know how

Hi Everyone, I am saving value of loggedinuser() function into cloud mysql db, but everytime it saves the "Administrator" instead of the my username. I test this function in expression rule where it gives my username. Can anyone please help me out?

Here I have a Plan TypeWithin Plan Type Sum Insured (Min Val and Max Val)Within Sum Insured Year Range (Min Year and Max Year)Within Year Range service center (Agency or Garage)1. I should be able to duplicate the whole transaction2. I should be able to add multiple Sum Insured (Min Val and Max Val). 3. When I add this, within Sum Insured I should be able to add multiple Year Range 4. Within the Year Range I should be able to add multiple service centers ( 1 Agency and 1 Garage)Now with the current code If I add a Transaction, 2 Transactions are getting addedAfter filling details if I add another transaction, all the values getting disappeared from the 1st transaction If I add Year Range I am getting the following error message (An error occurred while executing a save: Expression evaluation error at a function a!map parameter 3 [line 328]: Cannot add incompatible operands of type Null and type Number (Integer).) a!localVariables( local!index: 1, local!planType: {a!map(planType: ""

If isReachable throws an IOException in Java, what is the right step to do and why? The application, I believe, should halt the process and output the system message: the host is not accessible. Because isReachable throws an IOException, the host cannot be reached. But I'm not sure what the solution is. I would be grateful if you could assist me. Thank you very much

Hello Appian People, Do you have any idea how to to implement this case: So for example variable arr must be the same length value of variable value: local!arr:{1,2,3} local!value: {"a","b","c"} But if incase of variable arr is not equal value size of variable value. It needs to add null value on the local!arr  , example: local!arr:{1} local!value: {"a","b","c"} local arr expected ouput must be : local!arr{1,null,null} another case example: local!arr:{1,2} local!value: {"a","b","c","d"} local arr expected ouput must be : local!arr{1,2,null,null}