Discussion Categories

Hi Team, I am Self Learning appian and now creating  interfaces, i want  a requirement to create Repetitive Section Layout based on input integer value Scenario is let a integer input vale named Number of clients count.  now i have collect the first Name, last Name and some other fields of clients, i created a CDT for those client data and created a Rule input as the interface is as shown below, when the number of client value is empty , we are displaying only one section layout as default. When i entered 2 as number of client, i got 2 section layouts how since i use for loop to display the recursive section layout, when i enter the details of first client , its is copied into second layout also i tried using indexing , but i faced problem when i am inserting data into fields. How do store Values into list type rule input in this situation. please help me, Thanks in advance I am attaching code for review. let me know if I made any mistakes { a!cardLayout(

Due to the Appian upgrade there is a significant impact in DOM element of the webpages, most of the web elements and structure of the elements (of webpages) got changed. Due to which our selenium script is unable to locate the elements in a page anymore.Hence Automation Scripts are not working. Earlier we tried using Unique ID as a Identifier to locate elements  but due to restrictions from appian product we have to use xpath to identify element on UI.  After Appian upgrade,  plugins related to Appian also got updated and due to which Xpaths we have used in older versions are not working in new appian version. As Selenium is dependent on DOM elements for automation , hence its creating a huge impact. In order to make our script work, a significant amount of efforts are required. So How to minimize the effort and ensure that for Future appian upgrades our automation scripts doesnt fails?

Hi there, I'm trying to get details about a typical error that I constantly seeing on a process.  A little background: This process is suppose to read rows from the uploaded spreadsheet, based on row validation it has to complete two sets of DB updates. In current configuration these uploads are done when the valid rows are passed through a start process smart service. Since we have to update two different tables we have created a parallel flow after AND gate to complete the same. But the problem arises when one of the node completes and hits the end node and the other node waiting of the sub-process to complete. Please check the screenshot attached. Consider to share the reason for this error and suggest the possible methods to avoid this. Thanks, Vishnu Devalla 

Hi, Is there a way to restrict APPIAN basic users to access tempo site? Thanks/Mp

Hi, How to extract data from email using Email Classification AI, I have created Email Classification AI Skill , and provided some sample emails , on using the "Classify Emails smart service" its only returns some prediction of the email type.  Can anyone please help to guide what to do with the prediction of the email type, as I was looking more towards extracting the data from email using AI ML Email Classification. Same goes for Document Classification AI Skill, basically I want to understand what is the practical use of it? Thanks Bihitak

Hello Everyone, I am using rich text display field to capture ranting from user. I want that field to be required and i am not able to figure it out how to do that. Your help will be appreciated. Below is the code i am using. a!richTextDisplayField( label: "Rating", value: { a!forEach( items: enumerate(ri!totalStars), expression: { a!richTextIcon( icon: if( fv!index <= ri!rating, "star", "star-o" ), link: a!dynamicLink( value: if(ri!rating=fv!index, 0, fv!index), saveInto: ri!rating ), linkstyle: cons!MMS_DG_LINK_STYLE[2], color: cons!MMS_DG_BOX_STYLE[2], size: cons!MMS_DG_LINK_SIZE[1] ) } ) } )

Good day, I am new to Appian, I am trying to use the specific values in a return from a record query in a portal interface. I am using the interface for a customer data card using an expression, I now want to expand the information on the card to include bank branch information (name, address, etc) I have an expression that gets the branch information from a record type based on the branch Id and I am calling that into a local variable in the interface. My problem is that I do not know how to access specific parts of that local variable in order to display the data. I have tried a read only grid but get an error Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 105]: A grid component [label="Read-only Grid"] has an invalid value for "columns". A grid column [label="Branch Id"] has encountered an error. Expression evaluation error: BNK Branch can only be indexed into using squar

Hello.I'm new to Appian.When I try to output the contents of the data store as CSV, the following error is output.I am using "Export Data Store Entity to CSV", what should I fix?I haven't changed anything other than the capture.==================問題:  An error occurred in executing an Activity Class.詳細:  新しいドキュメント名を選択するか、既存のドキュメントにアクセスする場合は更新するドキュメントを選択してください。 (APNX-1-4505-008)推奨されるアクション:  Examine the activity class to correct the error and then resume.この問題の優先順位: 高い優先順位==================

Working on the "Send Email" smart service in Appian.  I've set up a custom sender. In the admin console, during email verification, it prompts me to create DNS records. I'm unsure about the process. Can someone provide guidance on creating DNS records for Appian verification? Please find below attachment as reference. Thanks & Regards, Nisha Vincent.

Hi Team, I have created new category and case types in the case management studio. While trying to configure the case type data in the case management studio site, i am getting an error, PFA error screenshot. Kindly help to resolve this.  

Appian recommends using history tables + triggers for storing historical data. Why not use MariaDB's OOTB feature? https://mariadb.com/kb/en/system-versioned-tables/  This approach requires very little configuration for each table. ALTER TABLE t ADD SYSTEM VERSIONING; I tested this out in our Appian Cloud instance and the only downside I've found so far is that ALTER operations on versioned tables may need to be run manually in combination with  SET @@system_versioning_alter_history = 1; The solution may be to change the global config (set global system_versioning_alter_history = 1), but it requires SUPER privileges.  So, what's the catch? This approach seems to be the simplest solution for storing historical data. 

Do to security concerns of iFrames our risk team wants us to pass the sandbox attribute on our webContentField that displays a thrid party website within our Appian application.   Bassically we need the equivalent to this:  <iframe src="demo.htm" sandbox="allow-scripts">    Is there a way for us to achieve this in Appian?

Hi All, Is there a way to export entire columns from the database table/view when using Appian Record Type and in the Grid we should be displaying only few of the fields from the database table/view?

Hello, I have a local variable that contains an array of text retrieved from an API Call as seen below:  a!save(local!transactionList, { id: local!Transjsondata.GetTransInfo.TransInfo.Id, time: local!Transjsondata.GetTransInfo.TransInfo.Time, amount: local!Transjsondata.GetTransInfo.TransInfo.Amount, }) so let's assume for example that i have 5 items in my transactionlist, each with their own id, time and amount, how can I represent each item accordingly in a gridview in its own row? I tried the below implementation:  a!gridField( label: "List of Transactions", labelPosition: "ABOVE", data: local!transactionList, columns: { a!gridColumn( label: "Id", value: fv!row.id ), a!gridColumn(

Hi Team, I want to display the single row of array data into multiple rows in read only grid. pls find the below screenshot.   one invoice reference number multiple order items in database, but i want to display one invc numer and one order item 1 row. Again, same invc number second value vale of order item number 2 different row. pls refers first row data. Thanks, Nagesh   

Hi Community team, I have an requirement to fetch all the Schema Names and their associated 'Table Names with their Sizes'  to display them in the appian interface. In order to achieve this, From the cloud database I have executed the following SQL statement which gives me the output:  SELECT table_schema as `DB`, table_name AS `Table`, ROUND(((data_length + index_length) / 1024 / 1024), 2) AS `Size` FROM information_schema.TABLES WHERE TABLE_SCHEMA IN ("Appian", "SchemaA", "SchemaB") ORDER BY `Size` DESC; On executing the result: EX DB Table Size Appian data 30.56 Appian example 28.52 ScheamA customer 3.52 Appian document 3.52 SchemA CaptureDetails 2.64 SchemaB Controls Library 2.52 Similarly, I'm trying to implement the same functionality in Appian using Query Database Smart Service in Process Model, on the set-up tab I'm able see only one schema(Selecting Pre-defined schema ) details: Instead of that I need to retrieve a

Want To fetch the data more than 5000 . let me know how to fetchrule!PPO_qrtName( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 7000) ).data,

Hi Team, I want to export read-only grid data to excel with headers, pls find below snap. Thanks, Nagesh.

Hi Team, In Excel sheet, as per rows I want separate BoxLayout with the separate entries into it. For Example, I have a 3 rows with column firstname, lastname and city as per first row of data I want to put in 1st BoxLayout, 2nd row of data in 2nd BoxLayout, 3rd row of data in 3rd BoxLayout without hardcoded. I am getting 3 seperate BoxLayout with column name firstname, lastname and city that I am satisfied I am getting in UI but result for all the rows of records in excel sheet is showing in all the three BoxLayout not showing in 3 different entries in 3 BoxLayout. So if you can suggest it how to do it per records will having seperate BoxLayout with rows of records in excel sheet? I am sharing a screenshots for reference In 1st BoxLayout data would come firstname - rakesh, lastname - sharma, city - mumbai In 2nd BoxLayput would come firstname - rahul, lastname - dongre, city - gondia In 3rd BoxLayput would come firstname - priti, lastname

What could be the possible fix to the below issue. 8 calls, 1199 ms peak average, 0.0% of total

How to insert tiff file into Word Document using ADT?

Hi I am querying a record type to get usernames. I am getting all the records except one record. There is no such filter too. I also checkd whether recordtype is syncing or not. It is also syncing properly. The usernane is also in the record type and database table. What can be the reason? Please suggest a solution.

Hello Team, I received a health report indicating a risk related to the extensive use of SAIL contexts in record views, related actions, and reports during the period from December 1, 2019, to January 15, 2020. This issue is present in an interface that originates from a process model. Within this interface, all code appears to be handled by a load function. I'm uncertain about what changes need to be made to address this issue. Additionally, could you please clarify the significance of the mentioned date range (2019-12-01 - 2020-01-15)?

Hello, I have used the smart service "Import Excel to Database" to import a huge Excel Data(200 rows and 150 columns) into a table. Issue 1.  When we add more than 10 columns to import excel to DB we are getting an Error  (conn=935099) You need to set exactly 15 parameters on the prepared statement.  Issue 2. we tried Importing 10 columns from excel to DB, even though we have 100 rows in excel, it was importing 20,000 null rows in DB. Could any one help me with these issues, Thanks Gopala Krishna Raju

I am trying to make a simple app for IOS and am running into an issue with the provisioner tool not working due to not having the paid Apple Developer subscription. Are there any work arounds for this that could be recommended?