-
Recently active
Created new record type for subscriber Added relationship with base record type Eventhistory eventType event thread configured. flowed below steps On the base record type, edit the record events configuration: Go to Events. Click EDIT. Configure the following Subscriber properties: there is no option to add subscriber record and unable to see the subscriber icon on event history in summary view anyone implemented please post your suggestion @Everyone we upgraded now to 25.1. while enabling subscriber am facing issue a!eventHistoryListField [line 736]: Unable to write to or delete from the source due to a data integrity violation. Error Details: Field 'ID' doesn't have a default value anyone faced the same issue, any suggestions or inputs helpful thanks in advance
Is it possible to create a dynamic Excel in Appian? Let me describe the challenge I am facing. I need to create a dynamic Excel in Appian that would have 10 different tables, each of which is displayed based on dynamic input (list of IDs 1,2,...10), possible scenarios a) If we pass 1,2, and 10 the tables with serial numbers 1, 2, and 10 should be displayed, b) if we pass all numbers, all 10 tables should be displayed, c) If we pass numbers from 1 to 5, only the first 5 should be displayed and so on. An example of the code we used to generate the Excel: local!dictionary: cast('type!{www.appian.com/.../2009}Dictionary', {}), local!dataExport: a!forEach( items: local!labelValue, expression: reduce( fn!insert(_, _, _), local!dictionary, merge( index(fv!item, "data", null), index(fv!item, "value", null) ) ) ), 'type!{urn:com:appian:ps:excel:types}ExportableDataSubset'(fieldLabels: index(local!labelValue, "label", null),fieldNames: ind
adding if condition in the label parameter of grid column, if local!docids are not available then column should be blank and otherwise Uploaded documents. Can you please help on this. Thanks for your thoughts on this.
Hi, I have a local variable with Map type. I have 2 fields inside a variable (Field label and Field Type) I need to save the variable in a loop by clicking on the Add dynamic link. Please help me out here since the current code is not working. local!manualDynamicField:a!map( manualdynamicFieldLabel:"", manualdynamicFieldType:"" ), a!gridLayout( label: "Manual Dynamic Fields", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Field Label"), a!gridLayoutHeaderCell(label: "Field Type"), a!gridLayoutHeaderCell(label: "") }, columnConfigs: { a!gridLayoutColumnConfig(width: "MEDIUM"), a!gridLayoutColumnConfig(width: "MEDIUM"), a!gridLayoutColumnConfig(width: "ICON") }, rows: a!forEach(
Which appian-locust form function do I use to interact with gridTextColumn? text or grid?
I have a process that needs to store entities and alerts in different tables. Flow of the process: First, I need to save the entity using the Write Record Smart Service. After the entity is saved, I need to get the ID of the created entity. Using this ID, I will then save the corresponding alert with another Write Record Smart Service. Question: Is there a way to get the ID of the newly created entity directly from the Write Record Smart Service, without having to perform an additional query from the record or database? Here is the example of process:
I have developed an Appian application in my environment (release 24.4) and I want to import it in an older environtment (release 23.x). I supose that the newer objects will crash but the old ones will run? Thanks in advance.
I need to refresh the browser page in order to refresh the layout change after switching language (From and to Arabic). How can I avoid manual refresh of browser page to better UX.
Hi , Recently i came across an interview question like how you will save and display different questions for different group of users in UI ? So have two doubts regarding this question, as follows Is this kind of use case exists in real time? Is there any best practice/way for achieving this? Requesting suggestions from everyone. Thanks in Advance, Pradeep
Hi everyone, is there a way to configure the content of the email that is sent when a user is @ mentioned in the event history list field comments? Thank you
What is the possible issue with the below code. I'm trying to make a selectable editable grid, I have given identifiers as well and converted raw data into datasubset but still the selection I do is selecting all rows whenever I click on any one. Note: Checkbox is not ootb grid selection. The problem is with ootb grid row highlight selection. { /* This is a lighter style of tabs that works well when you are on a page with record views or some other */ /* set of buttons right next to your custom tabs. */ a!localVariables( local!selectedTab: 1, local!customerId, local!selectedDetails, { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextItem( text: "Life", link: if( local!selectedTab = 1, null, a!dynamicLink(saveInto: a!save(local!selectedTab, 1)) ), linkSty
Hi All, One of our requirement is to merge the data from two applications into one. Both of the applications are created in same Appian instance and database is Appian cloud. One of the application uses default Appian schema whereas other one has it's own schema under Appian cloud. This schema is already added to Admin console. Now we need a way to connect this two schemas to be able to merge the application, is there any way to do that?
Hi People, I have input task USD 12345789. I want to put comma between the amount based on currency and I want output like USD 1,23,456.89. I tried several logics but not worked and output is USD1234,567.89. Can anyone help me? Thanks in advance.
I am working on a process model where I use an integration to call an API. The API contains about 82,000 records, but it returns only 100 records per request. To retrieve all the data, I use a loop. After each API call, I save the 100 records using a record type. Does this slow down the environment if I delete the instance after every successful run?
Hello All, We have requirement where we would like to trigger a process Model after receiving an Email. We have looked into 2 scenarios, Email Poller approach and Receive message Event via Email. We have a few questions regarding the Receive Message Event. 1) When the users use the processmodel<uuid>@subdomain.appian.com as the email, we would like to change the Alias of the email to the one we would like them to see. We work on Appian cloud. How do we make this change? 2) Once the Alias is changed, can we use the Alias as From email to use in the Send Email Smart service? 3) For the Email Poller Approach, apart from the Mailbox and the MsGraph Smart service plug in, do we need to configure any other settings in Appian for it to work? Thank you for your help.
Hi I need to validate if the correct excel is uploaded by validating its content . I have different excel upload for different activity. If the user uploaded wrong Excel and do the submit it should display that excel is not for this activity . Is there any way to do that. Can anyone suggest a way and how to implement it.
Hi all, I'm a bit new with custom record fields, so I'm probably doing something wrong. I have header and detail records (with a one-to-many relationship connected with a detail reference to the header key), and that data flows throughout the system just fine. But I added a real-time aggregation / sum custom field (for totaling amounts in the detail record for presentation) and am having trouble getting data into the new fields. When pressing the 'Test' button in the Edit Custom Record Field screen, I see data grouped and summed as needed which is great! After saving the new custom field, the 'Data Preview' test button does NOT return any data in the new field, and that is also the case with an interface that references this. I've done resync on both records. The new custom field exists on the detail side of the relationship and when defining the field, I use the format: headerRec.detailRec.amountToBeSummed. I've a
Hi team,I need help regarding to the Fetching the DB table names into Appian INV, using the table name,Example: i have table name called Students in DB if i select that name in Appian Interface I need to display that Students table details in InterfaceIs it possible or not if it's possible could anyone help me with it how we can do it
We have an oauth2 authorisation with client Id , client Secret & scope to connect to an api. We already have a connected system configured for this . This is working fine & we are getting expected response from api. Traditionally in our organisation we have a process model per application which runs every 60 mins which generates the token & writes to the token table. This token from db is accessed and set in the the header of the request as Authorization: Bearer ******. But it seems our code is working even if that Authorization header is deleted from the integration. It seems the connected system is adding the Authorization header to the integration request and the process model to token generation is not required at all. Does this a ring a bell ?
Hello, We need to export data from a database based on user-selected filters into an Excel sheet for reporting. Currently, our process queries data in batches of 500 rows and uses the deprecated "Export CDT to Excel" function to generate the report, as we need to export 80 columns. Since we are running in batches, we cannot keep the smart service into separate start process as we are appending the generated document with new values and incrementing the start index. However, as the data volume has increased, users are exporting data upto 50,000 rows, leading to memory heap issues causing Appian server to go down. The latest export functions have a limitation of 50 columns, which does not meet our requirements. We made process variables as hidden but still memory is hitting upto 6k AMU. We are using mySQL as database which is hosted on AWS RDS. Currently we are using a!executeStoredProcedureForQuery() to query the data from database. Before we wer
Hi I need to display the group name provided in the DB save as groupid for the users & groups but unable to do so DB group value: Kindly guide in order to rectify it
So, I'm building a record where i have all the items in the store, then i can drill down to 1 item and update ir, but when i click on update item related action i get this error: An error occurred while applying the context for the AS Items In Store related action [identifier=21]. Details: No process parameter found corresponding to override [name=pv!item]. Non-parameter process variables cannot be overridden. Any help?
I have to build a new application that is similar to another one so I wish to clone the application with another name in the same environment. How can I do it? Thanks
I need to check whether the documents uploaded by the user is not exceeded 10 MB. Apart from using document function which requires the document ID how this can be implemented
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
