Records

I am using a!eventHistoryListField() with comments enabled and the mentionableUsers parameter so that users can @mention colleagues in record event history. However, in our production environment end users do not have access to Tempo at all. They only use Sites.The problem:When a user is mentioned in the event history comments, Appian automatically sends the built‑in @mention notification email. The link in that system email takes them to Tempo → Record → Summary, not Site → Record → Summary. Since they have no Tempo access, clicking the link results in an error. We would like to keep the @mention search/picker behavior, but: Either replace the built‑in @mention emails, or Use the mentions only as a way to identify users and then send our own custom email with a Site-based record URL. ( with no automated emails)  

 We have a form called in the record action , a new row is added when the form is submitted in a grid. Based on the grid values we are displaying a card for above the grid for achievement rate. But card is refreshing with the current achievement rate only after manually refreshing page or switching tabs,its not updating immediately after this record action is completed.Where as for editing grid values and saving we are using a save button which is updating immediately after the process completion.How to solve this issue?  

I am currently facing an issue where record actions configured at the interface level are completely inaccessible.Security settings: Checked and verified,all configurations appear correct.This behaviour started occurring within last few days.Has anyone else faced this recently?(For workaround  we have set “securityOnDemand “ parameter to false to all recordActionFields which are using at interface level) 

Hi everyone,We're using the native Export to Excel feature on a records-powered read-only grid, and we've noticed that export time increases significantly as the number of columns grows, even when the row count stays roughly the same. I wanted to check with the community on a few points: Does the native export re-execute the underlying query? When a user clicks "Export to Excel," does Appian re-run the same query that populates the grid (re-fetching data from the data source), or does it reuse the dataset that's already loaded/paginated in the grid? Where can we check logs for this? Is there a specific log (e.g., tomcat-stdout, application server log, or a dedicated export log) where we can see the actual query being run during export, along with timing/duration details? We'd like to confirm whether the slowdown is on the query side (DB) or on the Excel-generation/serialization side (building the workbook itself). Thanks in advance!

Today all my query entity started giving below error suddenly even I tried with batch size 2 Not sure if this is an issue in DB or in appain. connected system is getting verified  Expression evaluation error at function a!queryEntity_22r2 [line 21]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [MRCPFCompanyDT63035], query: [queryentity expression], order by: [[Sort[defaultOrder asc]]], filters:[(active = TypedValue[it=26,v=1])])

Hi, I need help understanding why record sync is not occurring when using the "Write to Datastore" smart service in one environment, while the latest data appears in the records in another environment. In the environment where sync is not happening, a manual sync is required to view the latest data. Can someone help me understand the cause of this issue?

Hi All,I need to show some details when i place cursor on the sample id which is a clickable link .Is it possible to show tooltip for a record action Field function or are there any other alternates.a!gridColumn(label:”Sample Id”,value:a!recordActionField(display:”LABEL”,style:”LINKS”,openActionsIn:”NEW_TAB”,actions:{a!recordActionItem(action:recordType.task,identifier:index(fv!row,sampleId,null)})

Hello Appian Support Team,I am using the Appian Community Edition environment for learning.When I try to create a new Record Type using the “From Scratch” option, I receive the following error:“The data source cannot be reached or its configuration is invalid. Please contact your system administrator.”Could you please check whether there is an issue with the database/data source configuration in my environment?I would appreciate your help in resolving this issue so I can continue with the learning exercises.Thank you.

The related actions are not working, when I click on it is showing the loading icon, but they are not working as expected and not displaying the list of related actions. 

Hi,Could you explain me why the mix of relationShips and fields in “index/value”, does not work in a a!update() function  please ?Do I have any other choice but to call 2 consecutive a!update()?/* Works fine: */a!update( data: local!data, index: { recordType!Project.fields.createdBy, recordType!Project.fields.createdOn } value: { "my.user", now() })/* Works too: */a!update( data: local!data, index: recordType!Project.relationships.Document, value: local!docs)/* Does not work: */a!update( data: local!data, index: { recordType!Project.relationships.Document, recordType!Project.fields.createdOn } value: { local!docs, now() })Regards

I’m trying to write to a recordtype in Appian but I keep getting this error and I have no clue why.  “Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = 88f9f:179c1] : An error occurred while executing a save: Expression evaluation error at function a!writeRecords [line 124]: Record Type constructor must use keywords”…a!buttonWidget(            label: "Submit Request",            disabled: not(local!bookingResult.isValid),            saveInto: {              a!writeRecords(                records:                   'recordType!{UUID}CRBTN_Booking'(                    'recordType!{UUID}CRBTN_Booking'.fields.roomName: local!roomName,                    'recordType!{UUIDCRBTN_Booking'.fields.roomCapacity: local!roomCapacity,                    'recordType!{UUID}CRBTN_Booking'.fields.attendeeCount: local!attendeeCount,                    'recordType!{UUID}CRBTN_Booking'.fields.requestedBy: loggedInUser(),     

Hi, I have an URL of the format : https://www.google.com/<unique_id>_<fileName>_<remaining url> Now my requirement is I want to fetch the filename out of the URL ... the first part will always remain the same  i.e. first is https ... till .com/ then comes an unique identifier  then followed by '_' then followed by filename then followed by '_' and the remaining URL  Can anyone help me fetch the filename ? 

Hello All, I’m currently using a View-based synchronized Record Type in Appian to display data on the front end(Dash Board). While the underlying data in the source has been updated and the latest information is visible in the database view, the changes are not being reflected in the Record Type as expected. Could anyone share suggestions or best practices for ensuring that modified data is refreshed and synchronized correctly within the Appian Record Type? Any guidance on how to retrieve the latest updates efficiently would be greatly appreciated. Thank you in advance for your support and insights.

How to create a record type from scratch?

Hello The instance has got paused at the write node the record value is not going as empty there was no error msg also after running the instance again i have got this error msg ERROR:Work item cancelled (Data Inputs) 

I am new in Appian application development. Can any one please help me to know how can I get and use the Import CSV to Database smart service? Should I use any Plug-ins? If yes where from I can get it? I searched for it but did not get it.

Hi All,I have a record type with one of the filters on this record is a Date Range filter on a due date field.Several departments want to save a view where the filter always defaults to "Today". but when Users save the filter with today's date selected, it saves the literal date (12-08-2026) rather than a relative reference. So the saved filter becomes stale the next day instead of always reflecting the current date. ( Default in the user filters doesn't make much sense because users will combine this due date filters with several other filters).Is there a way to save a Date Range filter so it stores a relative value rather than a fixed date, so it stays dynamic across days?As a option B, I'm considering adding a new filter with a dropdown that offers options like "Until today" / "Future Cases," which I could implement with relative date logic. But that would mean maintaining two separate filters for the same column (the original Date Range plus this new dropdown), which isn't my prefe

I know Appian internally tracks the Last Sync Time for synced record types and displays it in the Monitor View → Record Sync Status and Sync History screens. However, I haven't found any documented or supported way to access this information programmatically within an application. Specifically, is there an expression function, query API, record metadata API, or other supported mechanism that exposes a record type's last successful sync timestamp for use in interfaces, process models, or expression rules?If not, what is the recommended approach for applications that need to display or validate the most recent sync time?

We have a use case as below:We fetch the data using an external systems (eg: Servicenow) for few fields, remaining are either manual entries by user. Now can we setup a integration with external system and write the data directly to DB using Write Records smart service or first we save the data using Process model and save in DB and then for updating records we use write records smart service.option1: External System-->Integration-->ProcessModel (Call integration-->Parse response data to CDT structure-Write to data store entity)-->Records--->UIoption2: External System--->Integration--Write Records-->Save DBwhich one is possible and can be implemented. Please advise

Hi, Im facing an issue in queryLogicalExpression where 'AND' operator is used and there are 3 query filters in it with applyWhen parameter is passed which is evaluated as false in all the 3 filters but still this expression got executed instead of ignoring it. Is the applyWhen parameter will work only for separate queryFilter and not for the filters added in logical expression? Could someone help me to understand the behaviour?Thanks

Hello everyone, In the recent update (version 26.1), we received a feature that allows us to create sync-enabled record types using a view as the data source. In our case, we have a view where we aggregate three fields (e.g., Name, Type, and ID). Since these fields are aggregated, each row is unique, and we have configured this combination as a unique key in the record type. Whenever a user updates information in the related tables, the view reflects the latest data. However, since we are using sync-enabled records, the updated data is not immediately available in the record. To handle this, we added a Sync Smart Service at the end of the process. But whenever a new record is created or updated with Name, Type, and ID, the smart service fails with the below error. Since the aggregation ensures there are no duplicate values for this column, and even in the view we see only a single row for each combination, I need guidance on how to handle or resolve this error.

Is there a best practice to handle a one-to-many relation in a record so that I can save and update the items selected from a multiple dropdown? (basically a use case where my object can have a list of related features, that can be changed). In https://docs.appian.com/suite/help/26.6/Multiple_Dropdown_Component.html#usage-considerations, I see that I can use a foreach to settle my data. But how do I say to Appian that it must remove the items that are not mentioned in the data I try to save? From what I am able to do right now, it is necessary to remove the unwanted items from the relation before inserting the new ones.

Hi everyone,  We are currently analyzing the performance of record views in our application to understand what contributes to the overall record view load time beyond the interface itself. During our analysis, we observed that the interfaces configured for the record views perform well when tested independently (around 2 second). However, when the same interfaces are rendered as record views in a site, the overall load time increases significantly (around 4 seconds), with an additional 2–3 seconds spent during record view loading. This isn't isolated to a single record view—we're seeing the same pattern across multiple record views. We also notice that the additional delay is more pronounced in Production and higher environments than in DEV, which makes us wonder whether larger data volumes or other environment-specific factors could be contributing. Fun fact is DEV has more data volume than PROD. So its weird. Maybe its Infra issue? We're trying to un

I have two records related to the same project, "Template" and "Area." Both records share the same EVENT_HISTORY and EVENT_TYPE tables. Each of these records has a 1:m relationship with the EVENT_HISTORY table, but we did not relate the EVENT_HISTORY table to either record. We have a recordType column on the EVENT_HISTORY table to differentiate what type of record each event is referring to. Our devs prefer this approach to creating a new EVENT_HISTORY and EVENT_TYPE table for every record for the sake of organization. In each record, I have configured the events comment field to be a distinct event name for adding comments following these instructions. Template Record -> "Comment on Template" Area Record -> "Comment on Area" The template record was created first and behaves as expected.  Whenever I attempt to add top level comments to the event history list for the Area record, it stores the event

I am exploring the possibility of integrating RDF (Resource Description Framework)-based semantic data into an application developed in Appian. The objective is to leverage RDF's interoperability and reasoning capabilities, as well as its integration with technologies such as SPARQL and standardized ontologies (e.g., OWL, FHIR, SNOMED CT). Given that Appian is a low-code platform focused on flexibility and integration, I would like to ask: Does Appian natively support managing RDF data or executing SPARQL queries? If native support is unavailable, what strategies or external tools does the community recommend for integrating RDF systems (e.g., via APIs or custom connectors)? Are there any known cases of successful RDF implementations in Appian, either directly or through integration with systems like Apache Jena, Virtuoso, or Blazegraph? Any guidance on how to approach this integration would be greatly appreciated. I am particularly interested in: Managing RDF triples within Ap