Discussion Categories

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

Hi, I need to compare two Hebrew names if they are equal. Tried using exact function, regex but it doesn't work as expected. Thanks, Preethi

Hi all, what is the difference between Build Apps Faster with Sync vs Disable sync and related features. Thanks & Regards, Kiran Sajjan 

if anyone know let me know

Hi My application is currently running on Oracle, and we have more than 1000 entities created as CDT's in Appian for the database. Now we are migrating from Oracle to MySQL. Now Can I change the source of the existing CDTs from Oracle to MYSQL from their XSD files without creating new CDT's. Any suggestions please. Thanks, Srikanth

So, I need to use visibility/showWhen to display a dropdown if a certain choice of radio button is selected. The format is kind of like this, the two dropdowns are supposed to be hidden until 'Yes' is selected in the group of the second radio buttons. This is currently the code I have. I'm still fairly new to Appian and trying to figure things out! I have experience w/Python/C#/Vis Basic so explaining in those terms could be helpful as well if( a!radioButtonField(choiceLabels: "Yes"), showWhen:true()

Hi, I want to get the List of Reporting persons Usernames by giving Supervisor Username as rule input. Based on below screenshot the code is working fine but the function usersearch() is 3rd party plugins so need to replace that with Appian cloud function. Kindly suggest the which need to replace usersearch() function for fetching the same data like below

Hi everyone! I'm a product manager at Appian and our team is working on measuring which recent features have helped you the most in Appian, what's still slowing you down, etc. If you have 5 minutes to spare, we would greatly appreciate your participation in this survey--thank you! 

I have a process model and interface set up so when user clicks save and continue it exits the form to write to DB then a XOR gate that checks the user action, if it's save & continue it loops back to the interface. All of the nodes are activity chained. But for some reason it keeps exiting out of the interface instead of just loading it back up. Could it be because there are a lot of writes to database so it's delaying the loop back? I do have less than 50 nodes.

Hi All, I have two interfaces in which one is embedded to another. Is that possible to pass value from one to another without submitting the form or by just selecting the dropdown value in one interface? Thanks in advance.