Discussion Categories

I hope this email finds you well. I am currently working on a project involving the use of a process model to write records. While I understand that, by default, matching primary keys result in the overwriting of existing records, my specific objective is to partially overwrite data in the existing record and simultaneously create a new record with a different historical record type. Could you kindly provide guidance on the recommended approach or configuration to achieve this purpose? Thank you in advance for your time and support.

I am having a problem navigating back to the home screen when clicking on a site tab that is supposed to redirect to the main Interface. The tab click is perfectly reloading the interface in the desktop view but it is not working in the mobile view. Does anyone have any idea how can this work in mobile view too?

Hi, Actually we are trying to select an object in an Application to duplicate. when we select in check box, it will enable the options like duplicate, add package, move etc.. when we try and test this through bot, in Appian RPA  result it is showing green marks but it will not reflect in the bot running application. could you please help in the configuratiion to select the check box and enable the duplicate. It will be very helpful for us. Thank you.

Hi, I need to export data from multiple data store entities into excel sheet. Current I am using "Export Data Store Entity to Excel" smart service but this services takes only one Data store Entity value as highlighted below. How can I take multiple Data Store Entity values and export to excel at once? Please advise.

Hello everyone, I'm currently working on an interface in Appian, and I'm looking to implement a record action that allows users to customize the displayed columns in a grid. Ideally, the user would be presented with a checklist containing the column field names, enabling them to select the specific columns they want to see. The unchecked fields should then be hidden from the grid. Is this functionality achievable within Appian? I appreciate any insights or guidance you can provide. Thank you!

Hi Community, I am trying to generate a JWT using createtokenwithsecretkey() in JWT plugin (using HS256). When I use the generated token and hit the Tableau signin API, I get signin error and JWT is invalid ( details error code: 10083). However, I use the same parameter details in a python code and use the token generated, the API returns me a successful response. Can anyone help me with the issue on Appian side please?  createtokenwithsecretkey( externalSystemKey: "jwt", /*Set the third party credentials in Admin Console */ iss: <tableau connected apps clientID>, aud: "tableau", typ: "JWT", /*jti: fn!generateuuid(123),*/ exp: 43200 )

I am facing issue in interface when I am preforming action on  my records or form it not showing the updated value until I refresh the whole browser it will be helpful if anyone sugggest how I can resolve this issue.

Hello, Need a dashboard screen in Appian which shows the daily schedule runs on whether they run successfully or there was a failure, and show relevant logs messages to help debug issue in case of failure to load data into Appian from third party OR failure during downstream integration. Any thoughts? How can I implement? Thanks

I have created a Process Calendar in DEV environment, how to promote it to UAT? Does any DevOps flow to follow up ?

I am facing a weird issue when comparing two arrays of dictionary type. As in the code attached, I have two arrays of dictionary from which I am converting one of them to be similar to other one using foreach loop. I am pretty much sure that output after conversion is same as "array1" in code snippet. But, still their comparison returns {false, false, false} as output of it. And, when I run the commented comparison below, it returns {true, true, true}. Why direct comparison is returning correct output but not the output from foreach besides the fact that formats and outputs are exactly same. a!localVariables( local!array1: { { value1: "abc", value2: "cde" }, { value1: "fty", value2: "yui" }, { value1: "uiu", value2: "dft" } }, local!array2: { { value1: "abc", value2: "cde", value3: "gdh" }, { value1: "fty", value2: "yui", value3: "hyu" }, { value1: "uiu", value2: "dft", value3: "kol" } }, local!convertedArray2: a!forEach( items: local!ar

Hello Community members, I am using the 'Get Base64 document from database' smart node to fetch a document from the database. As part of the new requirement, I need to fetch multiple such documents from db, create a ZIP file and allow users to download it - all in one click. I tried creating a web API to call an Appian integration that starts a process. The process uses either MNI or looping flow to fetch all the documents, creates a zip and terminates. Both options seem to be unreliable as not all the docs get downloaded using a loop or MNI with activity chaining (plus it's not best practice to use MNI + activity chaining). Have you encountered similar problems in your project? If so, do you have a solution for me?

Hi All, Is it possible to have some type of "Workflow" to show the user where a task is at the moment? I know we can see it in the actual process model in the monitor view but is this possible in an interface? for example,  a submitter fills in a form then it goes to the manager he approves then it goes to the supervisor and he approves or denies and then it completes the task. Is there a way to have some kind of visual in an interface to show where at is the task at the moment? something like submitted----------------------> Manager-----------------> Supervisor---------------> completed . Just so for example the supervisor will know at what part of the workflow is the task at. Thanks in advance

What should I persist in the db to identify a group? I may need to migrate this to another system IE: Dev to Test

how much time difference pp!timezone to IST  which timing =pp!timezone is following

Unable to write to the source due to system error. Error Details: INSERT command denied to user 'dbadmin'@'%' for table `dbo`.`CM_AUDIT` Facing Above error when trying to insert data to CM_RECORD Table  After Creating Trigegr using below SQL code CREATE TRIGGER `Audit` AFTER INSERT ON `CM_RECORD` FOR EACH ROW BEGIN INSERT INTO dbo.CM_AUDIT (COMPLAINT_ID, ENTITY_TYPE, CREATED_BY, CREATED_ON) VALUES (`CM_RECORD.COMPLAINT_ID`,`CM_RECORD`, SUSER_SNAME(), GETDATE()); END

Hi All, Is it possible to send a form in an email and have the user fill it out in the email itself and submit from there without ever leaving the email received with the form?  thanks in advance

What is the most common use case for an Appian application? A. A reporting tool that uses complex aggregation across different systems. B. A workflow that requires extensive database data extraction, transformation, and loading. C. A workflow for multiple groups that needs to be accelerated while reducing mistakes. D. A backend process that requires management and no user interaction.

I am using write record smart service, sending record fields but not primary key as it is a auto generation. when I am trying to retrieve the primary key, the primary key is not updating in the pv variable. Can anyone helps why it is happening.

Hi All, is it possible to show the user input task in a specific site of the application or a link with no other tabs, I do not want to show Tempo itselft ( Like where it shows new,report etc).  Is this possible? Thanks in advance

I have requirement to call service now API before every manual deployment. Appian support team should not be able to deploy package in Production if change ticket from service now is not approved or not in  start time and end time window. I have achieved the integration by calling service now API but I am not able to restrict the "DEPLOY" button on Appian Production screen based on the check. Is there any way we can restrict the deployment here?

Hello, I'm currently testing the Selenium Appian API and we have this component (richTextField) from the Rich Text Editor Component plugin used to style sent emails. I cannot populate the field even though the verifyFieldIsPresent method returns true, I've tried using the populateFieldWith method and Selenium findElement directly without success. Thank you so much!

I want to pass data as template in email service . in that template i'm passing an expression rule but in the email i'm not getting the value .just getting the column name as below 

Hi All, I have a requirement where I need to merge 2 selected rows in read-only grid and merge them into one row and the displayed name will be the first selected row. Where the whole data related to both selected records will be merged into one.

Hi All I am using getLastLoginDateTime function which is in the below plugin  [mention:f77937a217d845edaa4c53ff358f0f09:f7d226abd59f475c9d224a79e3f0ec07]  But facing weird issue.  below are the code snippet It is working fine without typecase but while typecast it is showing errorNote :- loginDateTime has date and time data type and it is not working for 2-3 users and for rest it is working fine even while typecast.

Hi Team, Currently am writing data to table from stored procedure. Can someone help that what is the best way to improve its performance, Since in Healthcheck its coming as High Risk.  Number of records added is around 4Lakh.