Discussion Categories

Hi everyone,Is there any way to maintain an audit trail of user queries and responses monitoring for review purposes of any chat bot mentioned above.thanks in advanced

I am storing the values to sql in gmt format ,when I fetch  The data back and show it in grid Iam changing to clients timezone but it stores in db as gmt while querying and showing in grid making difference in the time I checked separately but the issue is in sql we need to conver to local timezone and use it.Is there any way,please suggest I'm using view to fetch data and show in front-end

Hi everyone, I have a use case where I need to send files to external system for validation. I'm submitting the form which is chained to itself, so that files are persisted in the Appian file system and then I'm sending this to an external system. User gets to see the progress percentage.So the problem is when Appian is very very slow ( due to other colleagues playing around, Appian internal apis are taking some time to write it  down. Any way I can check file exist in actual so that I can have some sort of delay retries?

Extract data from database tables and populate a PDF form. The PDF should contain editable and fillable dropdown fields that allow users to select values dynamically

I noticed that if I use sql to update data, the data in record type need to sync manually.  I want to know is there any way that the record type can sync automatically once I update data in db. In sync options tab I only saw Schedule full syncs, but It can't suit my require.

Hi, I am getting this issue when selecting value from dropdown for one particular user at function a!gridField_19r1 [line 71]: A grid component [label=""] has an invalid value for "columns" and "value". All "data" arrays must not contain more items than the specified "batchSize", but "batchSize" was 10 and the largest column data array had 17 items.

I have four tables; Event, Parish, Parish Profile and Parish Event. Event holds all possible events a parish can sign up for.  It has a unique key of Evemt_ID and fields Event (name of the event) and Start_Date Parish holds Parish data and has a unique key of Parish_ID. Parish Profile holds some additional information about what type of speaker they would like at their event.  Not every Parish has a Parish Profile. Parish Event hold the history of all the events a Parish has signed up for.  Not all Parishes with a profile sign up for all events.  Some chose to participate last year, but not this year. It has a unique key of Paris_Event_ID and foreign keys, Event_ID and Parish_ID. I want to display in the Parish Profile Record List the latest Event the Parish signed up for. I currently use an expression rule to display this value in the column. However, i can't sort and the filter i wrote pulls all Parish Profiles with that has the event in its relationship.

Hi,  I am doing some research in to the Google Chart Plugin ... https://community.appian.com/b/appmarket/posts/google-charts-component-plug-in?CommentId=209280fe-6dcb-45e6-9bf7-81336dc6e24d Would anyone know if an item on a chart could be stored in to a variable? I can see there is an onSelection parameter, I am curious as to how an item from a chart could be saved down such as an ID to enable further drilldown behaviour? Thanks.

Hi AllWhen i am doing filtering not getting expected output.Below code is mentioneda!queryEntity( entity: cons!LOCALE_TRANSLATION_NEW, query: a!query( selection: if( rule!P3_utils_checkIsNullOrEmpty(ri!columns), {}, a!querySelection( columns: a!forEach( items: ri!columns, expression: a!queryColumn(field: fv!item, alias: fv!item) ) ) ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "label_txt", operator: "=", value: ri!label_txt, ), }, ignoreFiltersWithEmptyValues: true ), pagingInfo: if( rule!P3_utils_checkIsNullOrEmpty(ri!pagingInfo), a!pagingInfo( startIndex: 1, batchSize: cons!P3_BATCH_SIZE[7] ), ri!pagingInfo ) ), fetchTotalCount: and(ri!isFetchTotalCount))=======================================When i searched "Research". It is giving me expected outputIs it default behavior of Appian ? Expected result - It should not return anything because there is no label like "Research  "

Hello, We need to download .msg files (Outlook mail) from an External System using an integration that receives the document as base64. The current problem is that Appian is able to download that document but without its extension, using the "convert base64 values to Appian documents". I suspect it's because the MIME Type "application/vnd.ms-outlook" is not supported by the integration object as established in the following documentation I found: https://docs.appian.com/suite/help/25.1/Integration_Content_Types.html#document-(auto-detect) https://www.iana.org/assignments/media-types/media-types.xhtml Is there any way to workaround this? Any help is appreciated Thank you!

Hello, We need to download the data from the read-only grid to Excel. We used the record type as a source for the grid and used the OOB export grid feature. The file name downloaded with this is "Record Name" - YYYY-MM-DD_HHMM.xls Is it possible to customize the file name generated with this? please let us know. Thank You, Sneha

Hi Appian Community, We recently ran a Health Check on our application and encountered a performance finding related to a Record Type. The specific issue is with the "Data Query and Default Filter" step, which is taking 4322 ms to execute. Context: We have a Record Type (recordType!ABC) that pulls data from a database view containing all case types. A default filter is applied using the "Expression" option. The expression used is:             a!queryFilter(   field: 'recordType!ABC.fields.transactionId',   operator: "=",   value: 46 ) Note: The transactionId field is indexed in the main underlying table Any insights or recommendations would be greatly appreciated!

Hi, I'm using the Open Browser action in Appian RPA to launch a legacy web application. Occasionally, the website may be down, and when that happens, the bot execution fails with an error like "unable to navigate to URL." In such cases, I would like to trigger a notification (ideally an email) to inform the support team immediately about the failure. My questions are: Is there any default mechanism in Appian RPA to send notifications (like emails) on task failures? If not, what’s the best practice to implement an email notification when an action like Open Browser fails? Any guidance or examples would be appreciated! Thanks in advance.

if "Data type" and "Data Store" are not showing in our environment in Appian Designer,here are the possible reasons and how to fix them.

I want to invite my friend to join my shared workspace, but I failed. I got a message. "You seem to already be in a shared workspace. If you wish to join this cohort, you must leave your current workspace before accepting this invite." But my friend is not in any workspace. He is new  member.  Please tell me how to deal with it?

Basically im developing a start form where i get a list of records that contain a a docID and a dropdown.  The interface has a editable grid where the user can add rows and per row the user can add a document (file uploadField) and a dropdown.  My issue is that on both fields i selected the value and the save with ri!VALUE and when i add a document it makes it so that in all the rows that document is selected and the same for the dropdowns. How can i make that per row created the save and the value creates a new array? In the interface i have already selected the ri! as multiple.   ill leave the code here , and thanks in advance to all,  a!localVariables(   local!rowsTemp: a!gridRowLayout(     contents: {       a!fileUploadField(         label: "Input File",         labelPosition: "ABOVE",      &n

Hi everyone, we are currently evaluating different approaches to automate our tests. We're aware of the tools officially recommended by Appian (Appian Selenium API, FitNesse for Appian, and Cucumber for Appian), but we’re interested in knowing if there are alternative solutions.

Hi everyone, I have a challenge where I need to classify more than 10 different types of documents. I understand that the traditional Classify Document approach in Appian requires a substantial amount of training data to build an accurate model. Is it possible to use generative AI (Gen-AI) for document classification in Appian instead? Or is Gen-AI generally not suitable for handling multiple document types like this? I’m aware that the current Appian AI Skills for document classification do not use Gen-AI, but I wanted to check if there are any alternative approaches or best practices. I also tried using extraction with unstructured Gen-AI for classification, but it turned out to be more complex than I expected—especially converting the output to JSON and so on. Thanks for any advice or suggestions!ps; currently lacks of documents so i not using the classification document method xD

I'm currently preparing for the Certified Developer Exam having no prior experience with Appian. I see other threads mention it is best to use Appian for a few months first, but my company encourages pursuing this exam (and the Senior developer certificate) before employment begins. I am completing the associated course (inculding all optional and practice content) but others have noted that this may be insufficient for the difficulty of the exam. Even the practice test indicates that the real exam will be more difficult. Does anyone have an reccomendation for how else to prepare or links to more in-depth practice resources?

Hello, I'm currently learning about the various functions of Appian to understand how powerful it can be. At the moment, I'm facing an issue with creating an approval process that has a condition where at least 2 out of 3 approvers must approve in order for the flow to continue. This is what I have configured in the user input task node so far.The problem I'm facing right now is that I don't know how to update the value of pv!approvalResults (which is a list of text) when each approver takes an action. Could you please give me some advice?

Hi Team, I'm currently stuck at a point and would appreciate your input. I need to display different colors for different countries in a column chart. Below is the database structure I'm working with country ListId(pK), .countryId(int), isAllowed(boolean) Note: I want to show only allowed countries data in column chart. I grouped the data by countryId, and I want to display different colors for different ranges of country IDs in a column chart. For example: Country IDs 1, 2, 3, and 4 should be shown in blue Country IDs 5, 6, 7, and 8 in yellow Country IDs 9 and 10 in another color These colors are just examples. If this approach is feasible, I will apply it to the actual requirement.

I have question like can we make editable grid to have a scroll after 4 rows.

the pickerFieldCustom field is replacing the user selected data to its identifier value , please suggest how to solve this.  my datasubset is as below : a!dataSubset( data:a!flatten(local!output.data), identifiers: a!flatten(local!output.identifiers) )  

Is there any way to recover deleted documents in Appian Environment. We had the docids for the deleted objects, Is it possible to recover them? 

hi team, we have a recruitment , user want to add emoji's and need to store DB. could you please suggest me. thanks