Discussion Categories

How can I create the nested bulleted list in Appian 

Hi All, I have the requirement to close the task after clicking over the button in interface? Can anyone please help me out?

I have a application , where customers can see their invoices . For ever customer we provide a user id . we store all the invoices across the customers in a recordtype  INVOICES. Now when a specific customer logs in this is the start page. I want to show only the records (invoices) speciifc to customer I am using SITE and Invoices as Records/List

Hi everyone,  I want to set a start timer for my process model, in which start date time will be provided in advance, and if the given start date time is within work hour (9-6pm Monday to Friday), the process model will send an error message stating it can not proceed during business hours, and the process model will not be run.  I haven't had much experience working with process model, so really appreciated if anyone can give me some guidance :)  Thanks a lot!

What will be the number of users the getallusers function retreive? Can this retrieve 20000 users?

I have a requirement with one text field ,adjacent to the label of text field i need to have a check box of boolean type how can i acheive this? Thanks..

Hello,How I can transfer my Certifications from Previous Organization to current organization.

Hi Alll, I have a fileupload control allows multiple files to upload. I should write a validation should not allow duplicate file names uploaded and should not be there in database too. Does anyone had this situation. Your thoughts will highly help me.

Hi Team, After creating a CDT properly, I am unable to verify  Entity mappings in the data store. It is giving me the below error. Note:- Record type is generated and synced with the table already available in the DB. I want to keep my table name in uppercase [NT_NH_Handover_History] but during entity mapping i downloaded DDL, it is asking me to create a table with the name in lowercase ntnhhandoverhistory. I have to keep the table name in upper case. Could you please suggest?

Hi, Scenario: I am trying to make an interface where, there will be data coming from the database and I will be displaying the data in cards. eg: Database will contain data of Different courses offered by a university, and the cards will contain data like University Name & Course Name (the rest data will be displayed separately after clicking on the card) Now to avoid clutter, I want to display only 3 cards in a row. i.e. 1st 3 cards in 1 row, next 3 in the 2nd row and so on ... I am not quite sure how to achieve this goal. Can anyone help me on this ?

Hi All, How to get the documents which are uploaded only by the reviewers (list of reviewers uploaded)? Regards, Supriya

We have requirements to build out document retention policy management features: * Define purge policy definitions to define business epxression for when documents should be purged (e.g.,  delete after X years and other business conditions met) * Create purge records to capture list of documents which will be deleted in upcoming purge cycles to allow users to define hold/exceptions which should not get purged) Has anyone built these type features in Appian and what implementation approaches were taken?Regards, Bob

I cannot able to sort it out  I am passing id that id is not having degree certificate document but still the document download link is showing

On my Appian application website, I have used two record views using a single database table. Now I am using a radio button with the choice value Yes & No. If I select Yes the row should go to another record view if I select No it should be on the same record view on the website. Please suggest to me how to write the conditional statement to achieve the expected result.  a!radioButtonField( label: "Move to NOC Standard Handover", labelPosition: "ABOVE", choiceLabels: {"Yes","No"}, choiceValues: {"Yes","No"}, value:ri!record['recordType!{2eff113d-30b2-4e57-8fa0-e59fe7e0115e}NH Handover.fields.{d6c838a0-cfff-4d11-bff4-e6a26c63564f}standardHandoveritems'], saveInto: ri!record['recordType!{2eff113d-30b2-4e57-8fa0-e59fe7e0115e}NH Handover.fields.{d6c838a0-cfff-4d11-bff4-e6a26c63564f}standardHandoveritems'], required: true, choiceLayout: "COMPACT", validations:{}

I am trying to use record type's export to excel feature for that I need to convert my data which is in list of maps (image below) to record type. Please hep me with it.

Regarding configuring an Appian Server, we are aware of the following configurations' default/recommended values:   vm.max_map_count=262144server.conf.processcommon.MAX_EXEC_ENGINE_LOAD_METRIC=120   If we were to fine-tune these values, is there an ideal formula we can follow?   Also, what possibly could be the merits in raising/lowering those values? Meaning which parts of Appian will be affected and how far will it improve Appian performance?

Using the a!syncRecords function is there any way to see that the record has synced? I looked at the actual Record and the sync history was not updated.  I looked at the tomcat log but can't tell what would indicate the synced record?

I am using Smart process smart service which is used to do load balancing and executing in Loop. Variable contains 500 rows As of now it is taking 40-50 min which is very high even loop number is not much. Is there any way we can optimize it further. We are passing few parameters into called process but as Start process smart service is asynchronous, so performance is not having any dependency on called process.  Appreciate any quick suggestions.

Hi , Requirement : I want to download a file using RPA but when the bot click download the file, The file is saving in download folder by default but we need (save as popup) so the we can save the downloaded file in specific location  when i am trying to download manually save as pop-up is showing  and i can save in specific location but its not showing when RPA bot download's the  file  I have tried changing settings of chrome but its not working , please suggest with some solutions  Thanks & Regards  Shashank 

Hi All, I have to check whether the current time(irrespective of any user time zone) is between 7pm EST to 9am EST. So we tried to convert the current time to EST first and then to compare it with "7:00 PM" & "9:00 AM" EST (by creating text constant). We just tested with below code to check whether comparison works fine by changing the constant value, but it fails  totime( gmt(  local(now(), "EST" )    )  ) > totime(cons!xyz)  where cons!xyz = "7:00 PM" (a text constant) So please help me how to make this work. Thanks in advance.

Hi, I would like to restrict a user (Business User) to access only site access using site menus. At the same time, I would like to restrict business user to "Appian Designer". How can I achieve this. Any suggestions please. Thanks in advance.

EDIT: Got the value to save but the dropdown box doesn't show up when the correct value (boolean true) is selected a!radioButtonField( label: "Is Jira Access Required?", labelPosition: "ABOVE", choiceLabels: {"Yes", "No"}, choiceValues: {true, false}, value: ri!record['recordType!{d327a5dc-18d4-4ffd-8bdf-6a22b134677f}DS Contractor.fields.{2463d484-b544-48a5-813c-701935313606}jiraAccess'], saveInto: ri!record['recordType!{d327a5dc-18d4-4ffd-8bdf-6a22b134677f}DS Contractor.fields.{2463d484-b544-48a5-813c-701935313606}jiraAccess'], required: true, choiceLayout: "COMPACT", validations: {} ), a!dropdownField( label: "Which Department Requires Access?", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: cons!DS_deptChoice1,

Hi all, We are switching to a full record centric approach for our new projects. In our old projects we used to have an expression rule "XXX_setCdtDefault()" this would set the fields createdBy, createdOn, lastmodifiedBy and lastModifiedOn for each CDT right before saving. if( a!isNullOrEmpty(ri!cdt), ri!cdt, a!update( ri!cdt, { "createdOn", "createdBy", "modifiedBy", "modifiedOn" }, { a!defaultValue(ri!cdt.createdOn, now()), a!defaultValue(ri!cdt.createdBy, loggedInUser()), loggedInUser(), now() } ) ) Since we will now use the Write Records smart service, we are no longer working with CDT's. Is there a way to do the same thing as before in a generic way for record types. If we want to update a record type, we need to pass the references to the record fields, so we cannot use the generic "createdOn" etc..I have come up with a workaround as shown below, but I would prefer it if we could j

Hi I am using The "Import From Excel to DB" smart service. The data so written into the DB is not synced with the record type for the same DSE. For using "Sync Records" smart service it is asking the identifiers of the newly added records, which i do not have. How do i force a sync after the data is extracted from Excel to DB?

Here I want to get the most visited top 3 destinations and the count of journeys on each location.(relationship between 2 tables) So make an expression rule for that. but I need to do with record type with the use of a custom record field, here i found the custom expression rule, anyone guide me on how to use this code with a custom expression rule in record type? code below here a!localVariables( local!data:a!queryRecordType( recordType: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey', fields: a!aggregationFields( groupings: { a!grouping( field: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey.relationships.{324614a4-84f3-45b4-bce2-95cbc8b65b6d}vsDestination.fields.{dbe0e7f1-b3d7-456b-9d82-e81a9042d256}name', alias: "name_grouping1" ) }, measures: { a!measure( function: "COUNT", field: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey.fields.{1209585a-f527-4ad9-b1fc-cc7ccc5dd973}de