Discussion Categories

I have a textField that I do not want users to be able to enter in a space unless it is a part of the case number. For example, users should not be able to enter this:  But if there are spaces in the case number, then it should be allowed I've tried regexmatch, I've tried a if / isnullorempty statement  example:  if( a!isNullOrEmpty(ri!notice), "Case Number is invalid.", null() )

Hi How do you use Sync Records Smart Service to fully sync a record type that was just modified by a back end stored procedure My case is new data comes in daily in CSV files - which gets uploaded into a set of temporary tables After this a stored procedure inserts them into the main tables that are connected with the record types. As of now we are syncing these record type manually from the web page I though this smart service would have an option to do a full sync, but it needs the IDs of the record types to sync - well these are unknown since they were just inserted by the stored procedure in DB so not available yet. Do I need to come up with another data base query to retrieve the new ID - form the database?

Hi, could you please suggest me better approach like how can get inactive user list in the environment and last login inactive user ? I have seen, we can get to know in admin console but if we want check without admin console like any functions to check? thanks

Hi everyone. The client has asked to use a particular Typeface. I have the Woff2 URL's on the admin console. However, when entering and inspecting the site, the typeface/font gives a 404 error. Investigating further, I notice how on the initial HTML script, the URL for the typeface/font starts with a "/suite" instead of the actual "https://" Has anyone dealt or experience a similar problem before?Thanks!

If multiple applications are hosted on the same Appian platform, and I want to create a separate schema in the Appian Cloud database for each application's tables, how should I reference a specific table within a specific schema when creating a Data Store in Appian? I initially tried querying using schema_name.table_name, but it didn’t work as expected. However, when I ran SHOW TABLES FROM <schema_name>, I was able to see the tables listed under that schema, which confirms that the schema and its tables are accessible.

Hi All,We had a process model in Appian that was scheduled to send a report every Sunday at 11:59 PM. Later, we discovered an issue with the report it was generating. Due to business requirements, we exported the process model, saved it locally, and then deleted it from Appian. I had assumed that the scheduled activities were tied directly to the process model, so deleting it would stop the scheduled execution. However, this Sunday, we received an error stating: Problem:  An error occurred in executing an Activity Class. Details:  Process Model has been deleted. Process designer could not be retrieved Recommended Action:  Examine the activity class to correct the error and then resume. Can anyone please help me to understand this scenario?

We currently have a system that allows users to upload documents. We are currently filtering out password protected documents using the ispasswordprotected() smart function. Recently we encountered a document that was "Restricted" (Please see attached image). Is there any function currently within Appian that allows the system to check if a document has any "Protections" on it at all. the above smart function does not account for the additional types of protections outside of passwords. 

I have a requirement where I have to trigger reminders to user a day prior 9 am their local time. For example, if user is from Asia/Kolkata time zone then he/she should receive the mail a day prior 9 am IST similarly if user is from Australia/Melbourne time zone he/she should receive the mail 9 am AEDT.Can someone please help with the approach?

I have a requirement where I need to send reminder emails to clients one day before at 9:00 AM as per their respective timezones. My environment timezone is Australia/Melbourne, but clients can belong to different timezones (e.g., Asia/Kolkata, Europe/London, America/New_York, etc.).

Hi, I'm attempting to upload a CSV file to SQL server database on Appian V23.2 The database table has been an existing one for the upload process which was originally an Excel document which got converted to CSV within the process model.  We're in the middle of changing this to do straight upload of CSV file. Issue we are having is that the CSV column names are produced from a third party site (Salesforce) and cannot easily rename the column names to match the database table names. sample CSV Column names: Opportunity ID# Account Name: Account Name Stage Opportunity Owner: Full Name sample database table names OPPORTUNITY_ID | ACCOUNT_NAME | STAGE | OPPORTUNITY_OWNER  Using the "import CSV to Database" smart service, it seems that both have to match if the file is headered.  No ability to have different csv column names to that on the database, even if the number of columns match.   Changed to java.lang.

Hello, we have implemented a send email and receive email process to process. When the send email process is activated, the receive process doesn't receive the email. The destination process ID is configured correctly. ¿Is there a log to identify what might be failing? Thank you very much.

Hi Appian Community, I'm currently developing a multi-regional application in Appian that will be used by Spanish-speaking users across different countries, including Spain, Mexico, and Colombia. While they all share the same language, I've noticed that number formatting conventions vary significantly between regions, especially in how thousands and decimal separators are used. For example: In Spain: 123.456,78 (dot for thousands, comma for decimals) In Mexico: 123,456.78 (comma for thousands, dot for decimals)  My question is: Does Appian automatically distinguish between regional variants of the Spanish language (like es_ES vs es_MX) when applying number and date formats? Or do we need to explicitly configure the full locale (e.g., es_MX instead of just es) for each user to ensure the correct regional formatting? Additionally, has anyone implemented custom logic to handle formatting based on the user's country? What best practices would you recommend to maintain co

I think is not possible to access directly to an Informix and dataverse databases directly from Appian Cloud but do you know if is there any work around? Thanks in advance.

Hi everyone, We recently encountered performance issues in our development environment and requested a restart. Before the full sequence could be executed, we have ran only: Code: appian_services_stop followed by starting it again without stopping the other components: appian_appserver_stop appian_searchserver_stopappian_services_stopappian_dataserver_stop We’d like to understand from the community: What are the potential risks or side effects of restarting only appian_services_stop? Could this lead to instability or partial recovery? Is there any known impact on data integrity, indexing, or service coordination? Appreciate any insights or experiences you can share. Thanks,

In docusign integration Generate the Recipient Signing url operation where should get the client User ID, what exactly it means ? Can you please guide me for this?

Team, We are on 17.4 version and trying to remove all process instances from one of our lower environment around 100k+. Do we have any function or plugin which we can use to delete them at once instead of manual deletion . Thank you.

Hi, looking for some guidance on how to send Teams messages from our App directly to a user. We tried using the Teams Plugin but found we were limited by only being able to send messages with authentication Authorisation Code Grant (Delegated Permissions), this was forcing each user to individually authenticate from the app, which isn't what we're looking for. We want to send chat messages directly from a System(Application) user. (I think this is a limitation of Teams rather than the plugin itself). We have found the below link on "Activity Notifications" in Teams rather than chat messages, has anyone had any experience with this? I'm just looking for confirmation that this method will achieve the results before I go down the rabbit hole. learn.microsoft.com/.../teams-send-activityfeednotifications Or if not, does anyone know any other way for us to achieve the desired behaviour? Thanks!

I have a complex database view that should be converted to an Appian Data Fabric (synced records) model for performance reasons.  I am able to recreate all functionality from the database view with the exception of the string_agg() function. It looks like the only way to access fields from one-to-many relationship record is in the list view/display layer. I need the data to be concatenated and available in the data model (i.e., custom record field) so that this column can be used upstream in a parent related record type.  Is there any way to achieve this functionality in data fabrics?

Hi, I am new to using the interface component a!dataFabricChatField.  ( I've used record chat component, and that worked as expected. ) With Data Fabric chatbot, how should we implement security?  We only want the users using the chatbot to have access to recordType records that pertain to their company.  I tried using the instructions field in the chatbot component to specify which company the logged in user belongs to, but that did not work either. What is/are the best to accomplish that? Thanks.

Hello Community, Recently, our Appian environment was experiencing performance slowness. To address this, we executed the command: appian_services_stop / appian_services_start After doing so, the system came back up and was running fine with improved performance. Later, when our vendor connected, they insisted that we should only follow the manual stop order described in the documentation: 1. Stop application server 2. Stop search server 3. Stop data service 4. Stop engines They blamed our use of appian_services_stop for later issues. However, when they followed the manual stop/start sequence, the system failed to come back online and has remained down since then. My question is: Is there any risk or problem associated with using appian_services_stop / appian_services_start instead of manually stopping/starting in order? Thanks in advance for clarification.

We are receiving the below error in Mail server to database, after replacing the expired server certificates with new ones in the admin console . PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target Most of the online help redirecting to update the certificates in java key store. I don't think we did something like this earlier for certificates. Any thoughts?

Hello folks, I would like to understand the Start Process SS behavior. From my understanding, we no longer need to perform chaining inside a child process if the child process is configured as a Synchronous Start Process. Below is the configuration I applied for one of my record-related actions. Here once action is completed we re query  the audit data in the interface which is set in refresh variable and refresh after "RECORD_ACTION". But this is not working as expected. I have to refresh the entire screen to get latest audit data. But if i put chaining between start process(Write audit) and end node, page is refreshing as expected and getting latest audit data.Please let me know if it is expected behavior. Thanks in advance

Hi all, May I please ask for some guidance here? I've got three record types: Consultant  Consultant Recipients  Consultant Emails To ensure data accuracy, I want to write all records records at the same. That way if the Consultant Certification write failed, there wouldn't be an entry in the Consultant Recipients  or Consultant Emails and vice-versa. Based on the following documentation is possible to do in one single Write Records Node: https://docs.appian.com/suite/help/24.4/Write_Records_Smart_Service.html#_ But when I try this, I see the related data in the interface itself under the main Consultant record - but when I pass it in the PM the related data shows as null. Thank you so much!

In the development environment I have installed two plugins Google Maps Connected System and GoogleMaps (the latter gives me the map and direction fields components). When making the transition to the UAT environment, only the Google Maps Connected System was deployed correctly, however the second plugin was not, I checked the logs and did not see any errors, could you help me. THIS IMAGE IS RELATED TO THE DEPLOYMENT OF THE GOOGLEMAPS CONNECTED SYSTEM PLUGIN THIS IMAGE IS RELATED TO THE DEPLOYMENT OF THE GOOGLEMAPS FIELDS

Hi all, May I please ask for some guidance here? I've got three record types: Consultant (a person, e.g. an Appian developer) Consultant Certification (certifications the consultant has, e.g. Appian Associate Developer) Consultant Audit History (audit log of changes to various parts of the consultant profile and related record types, e.g. updated a certification's expiration date) docs.appian advised against using Record Events to track changes to an individual record field (e.g. certification expiration date), so I created the Consultant Audit History record type. When the certification expiration date field gets updated, I want to add a row to both the Consultant Certification table and the Consultant Audit History table.  To ensure data accuracy, I want to write both records at the same. That way if the Consultant Certification write failed, there wouldn't be an entry in the Consultant Audit History and vice-versa. Is it possible to do this in