Discussion Categories

hello everyone, I created a form action that allows me to insert records into a record list I created. I have modified some fields in the insert form so that they are automatically filled with automatically calculated values; I noticed that the moment I submit , the inserted record has the said fields empty, would you know how this can happen? I made sure that the data types entered are equal to the type declared in each field of the record list, so I am sure I did not accidentally enter a text type inside an integer :) . For more info I attach the error, and an example code of a modified field : ERROR: Problem:  An error occurred in executing an Activity Class. Details:  Each item within the input "Records" must be a record data type. Received: LBOWI - RegistroFirme. Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority CODE: a!localVariables( local!value : now(),

Hi reader! I configured an post API (whose purpose is to write in database from outside Appian) which works well when I test it inside Appian. When I try to invoke the API outside Appian (that is through PostMan), it throws Error 500 - Internal Server Error. I have used basic authentication in PostMan Authentication. The user possessing this credential, is being made as the Administrator of API, data store and other required objects. 

Any suggestions around it: I have requirement where user want to edit a column in editable grid and that column should be pickerfield. I have a table to store existing data and pulling from it on grid. For picker data, i have a reference table that pulls all the populating data as needed. I am getting an error while i try to remove the existing column data and fetch new data. I tried different ways to define this but somehow ended up facing different issue for each attempt. ONE ATTEMP: Below code is one way of my attempts!! TWO ATTEMPT: This is working fine if I do something like below but is not appropriate for business use case:  local!existingdata:  Record type uuid: 5bf7f7cb-2b7c-430f-93b1-102a13b4f3af from error is the Record that pulls existing data.

Hi All, Multiplying the below values by product function and expecting to return output as 16956.0843 but it is returning the output as 16956.08.  product(16746.75 * 1.0125) Regards,Sandeep

I was making a query today in which I wanted to find entries based on a particular field and if that field happens to be null, I want all the entries that have that field null. I ended up with 2 filters, one that looks for entries when the value is not null, and one that looks for entries when the value is null. It works and all, but the thing is there's a parameter called ignoreFiltersWithEmptyValues that is usually true by default. But you can make it false and now instead of ignoring those filters with empty values, it gives an error for each filter with empty values. My question is why does this parameter even exist if all turning it off does is cause an error on null values? Wouldn't it make more sense to search for null values instead? 

Hi All, Input code: a!toJson( value: {test: { assuranceText: "Jag försäkrar att uppgifterna jag har lämnat är riktiga och bekräftar att jag har tagit del av informationen och villkoren ovan.\n\nDin ansökan grundas på automatiserad behandling av dina personuppgifter. På vår hemsida och under inställningar kan du läsa mera om hur vi behandlar dina personuppgifter och om dina rättigheter.\n\nNär du skickar in din ansökan kommer en kreditupplysning om dig att hämtas in ifrån UC" } }, removenulloremptyfields: true()) I am geeting the out put as below: in the output you can observer that one extra backword is added for the newline character

Hi, I am handling documents in Appian using "a!fileUploadField". When we upload the files/documents using this component it is allowing to upload the files/documents to a specific Folder which we have created inside Appian. I would like to check if there is a way I can upload the documents to the network folder which is mounted. Any advises please.

Hi, I am using a smart service called "Export Data Store Entity to Excel" and generating a document and storing in a pv! variable. Now, when I try to attach the same document in the "Send E-Mail" service, I am getting an error. I passed the variable to the "Attachments" like pv!reportName and tointeger(pv!reportName), but still no luck. By looking into an error message I was unable to find the root cause. Can someone advise please. ERROR: Problem:  An error occurred in executing an Activity Class. Details:  Failed to process attachments Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority

So I need to make a list of groups and what users are in those groups in Excel. There are a lot of users and groups so I'm trying not to have to do it manually. I can't just make the email addresses with the concatenate formula because I don't have any first/last names to go off of. I'm using groups in Appian and I just want to know how to quickly get these emails into Excel. There's at least 60+ groups I have to add into Excel. Thanks for any suggestions

Hi all, I'm creating user filters for a variety of fields in a record-backed read-only grid. How do I make it so duplicates don't show up in the user-filter drop down list?  For example, if you want to filter by status, there are two statuses available for all the records: Forecasted and Posted. How do I get it to just display Posted and Forecasted once, and not for as many times as there are records? I've tried union() on the 'name' parameter of the a!recordFilterListOption() function but that didn't work. Thanks for any suggestions!

Hi, Please let me know the solution for this, with proper justification. You have data from two unrelated tables. Which Appian objects can easily relate data from these two tables? a)custom data type b)Expression rules c)Record Types d)process models

How to use Embedded interfaces. Need all related examples and videos to learn. Please help me with step by step instructions to use embedded interface with real time samples. Also please share videos from the Appian Academy - needed the video link to work on Embedded interfaces. Thanks in advance.

Hi all,  when i want to save data in UI and then page jump out。 but i check the whole pm, chain every node and no error and the whole workflow in pm is fine .but just jump out . Below is my design.(just a mock) after i click save button in  UI and run the yellow part ,then the page will jump out. BUt if click save but dont run yellow part ,the page will keep. the yellow part is a sub process model to save data into db. all sub process model node chain. any idea for this? looks like yellow part is root cause.

What all cases are covered while using validateemailaddress() ?

Hi, I have a data in an an entity. I would like to pass two different dates and fetch the data between those dates and at the same time I would like to export to excel. Can someone advise how can I can achieve this. I found "Export Data Store Entity to Excel", but not sure whether this service will support date ranges to get the data from Data Store Entity. Thanks.

I have a use case to check if a group already exists. And if not, we should create the group. Is there any way to check a group exists in an environment already.

Hi All, We need to integrate with another application using their Sybase DB. I just wanted to know whether we can have sybase DB as a secondary DS in Appian .

Hi All,I've experienced an issue with the data store. After an upgrade to 22.4 we face the below error. The data store "XXX" [id=0000] was saved but cannot be published:   The data source schema does not match the type mappings: More than one table found in namespace (, ) :  Just to explain the background we're using synonyms for many db objects (because the target objects are in another schema that is not default for the Appian FID). I've seen a comment from an Appian employee under below article that 'support for Oracle is coming in 22.4.'https://community.appian.com/discussions/f/data/10323/unable-to-find-table-or-view-for-oracle-dbDid anyone else have this problem? Any tips? Thanks in advance!

Hi, I have observed many a times that in a script task with multiple inputs or outputs, that have some complex operations like queries, each input/output of the script task is stored in certain pv!. During execution only few pv! hold values and rest remain null, but if I use two script tasks instead of one and split the work among both the script tasks it works as expected. What could be the issue, is there any limit on processing a script task?

Hello!Context:  i have One page with 2 StartProcessLink: Link 1: List of sell Processes Link 2: Sell Procees Creation When i select the second link(Creation), it shows an Start Process Form, in wich i have a sumbit button. When the process starts, i want to have an interface showing a link to the Link 2 Form(Sell Processes List), so ive configured an user input task inside Link 2 Process, as shown in the image below: The thing is, it does not show, instead, when pressing submit, the main page its shown. Thank you for your help.

While configuring Execute Robotic Process Smart Service I am getting the Error "Node 2 contains a notification escalation with no recipients.". Any idea how to fix it ? 

Do you have any idea on how to check if all values in array matched in appian? example arrayValue = {true,true,true} returns "All Elements are Same" else returns "Not the same"

Hello Everyone, In recent days, We are seeing this error in the tomcat-stdOut.log. In the front end, we are getting, An error encountered while processing the request. ERROR com.appiancorp.rest.shared.FallbackExceptionMapper - Internal Server Error on REST API invocation. com.appian.komodo.api.exceptions.SignalException: At least one referenced Activity Class Schema is invalid: ,304 Can you help us on solving this issue? Thanks in Advance

Hi Experts, Our client have a specific requirement for which we need to migrate all the data from Oracle on Premise database to the Appian Cloud Database i.e Maria DB.What all are the step involved for the effective data migration.Note: Tables are yet not created in the Cloud database. Thanks, Gaurav Singh

Hi Team , As per installation documentation , Appian suggested to use oracle OpenJDK for JAVA_HOME. But the linux machine we have has already IBM java .  Will it be possible to install appian with IBM java. or  Do we need install open jdk which comes with appian installer for JAVA_HOME. is there any advantage of using openjdk