Foundation

Hi All, I have defined the visibility of site in such a way that if user is part of a given group and his status is approved in DB then only the site page will be visible to him. We are facing challenge with one user who is neither part of the group n nor his status is approved in table is able to view the site page. what could be the possible reason for it..? Thanks, Ankita Singh

Lets say you have a form with a textbox name. The form populates from a DB tableA. What is the recommended way of saving it into DB tableB? I experimented with the following: 1. a!pickerFieldUsers( label: "Name", labelPosition: "ABOVE", value: if(isnull(ri!tableB.firstlastname), ri!tableA.requestaddedby, ri!tableB.firstlastname), saveInto: ri!tableB.firstlastname, readOnly: true, validations: {} ) 2. putting   a!save(ri!record.requestdateadded, now()), in the submit button etc. Another idea was to keep the same rule input and handle it at "Write to DSE" in the process.

Hi Team, We have a requirment in which when the user clicks a button there should be a pop up message dispalyed for 15 secs and then it should get auto refreshed and the user should land to the home screen.As far i know, we dont have any such thing in appian to create a pop up screen but can utilize the a!buttonWidget where we can use confirmMessage property to achieve the pop up. In my case, we dont need the buttons in that message, but it appears by default in button widget.  How can i remove these buttons and also how do i achieve the auto refresh thing? Please suggest. Thanks.

Hello community, I am trying to make UI which has a read only grid which is populated based on data from integration, we passed a cdt as an input to this grid, now I wanted to put filters on that data using drop downs and date filters (start date and end date), I did came up filtering the cdt using wherecontains() function and foreach() loop and got different index for them. but I couldn't make them work like record filters. how do I group them ?some code below for understanding. Thanks. a!localVariables( local!selection, local!responseData: rule!PNK_DataForGrid(), local!actualData: local!responseData, local!customerAddress: union( local!actualData.customerName, local!actualData.customerName ), local!customerNameSelection, local!ftaNames: union( local!actualData.customerAddress, local!actualData.customerAddress ), local!customerAddressselection, local!startDate, local!endDate,

Hi Everyone, I am getting this error for paging A grid component [label="Search results"] has an invalid value for "value" and "totalCount". "startIndex" must not be greater than "totalCount", but "startIndex" was 11 and "totalCount" was 0.   For Paging i am using the below code,  a!pagingInfo( startIndex: 1, batchSize: 5, sort: a!sortInfo(field: "Id", ascending: false()) ) How to Reset Paging I am not getting solution.

Is there any possibility to have vertical scroll bars for read-only grid??

Hello all,  So I have a process, where the stakeholder wants to handle a feature more restrictively.  So before starting a process prompt a new question. ( I already have an interface working fine, but with the new requirements should  I create a new one with the questions ?) What you would like to amend?  ( I already have an interface working fine, but with the new requirements should  I create a new one with the questions ?) Distribution Fee amount only (->only Distribution Fee should be editable)  -> process works the same as before, BUT once approved and processed by Documentation the task does NOT go back to other team in the end anymore KID, Target Market, Cost&Charges only (->only these fields should be editable) -> process works the same as before, BUT once approved and processed by Documentation the task does NOT go back to the other team in the end anymore  Others (might include the above on

Hi all, I have a row of two columns. I have image field in the first column, and read only grid in the other one. The two items are inside columnsLayout. They are not with the same height, so the design doesn't look good at the moment. Is there a way to make these two items fit all the column height ? thanks,

Hi, i have a list of items I want to save to the data. The output should be ID=4, ID=5, ID=6 However, when submitted,  it duplicates first ID:  ID=4, ID=4, ID=4. please help. thanks a!localVariables( local!list: { 4, 5, 6 }, a!formLayout( label: "Form", buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", saveInto: { a!save( target:ri!Data.ID, value:a!forEach(items: local!list, expression: fv!item) ) }, submit: true, style: "PRIMARY" ) }, secondaryButtons: { a!buttonWidget( label: "Cancel", value: true, saveInto: ri!cancel, submit: true, style: "NORMAL", validate: false ) } ) ) )

Hi, We're getting the following error when trying to hit an endpoint (with both webservicequery and Call Web Service smart node) by checking the sys logs: Expression evaluation error : org/apache/james/mime4j/MimeException We've tried to refresh the cdts and restart the environment, but with no luck. Thanks,Riccardo

Hi Team, I have a dropdown field in which once user selects the value, based on it the grid below displays the result.  a!dropdownField( label: "", labelPosition: "", placeholder: "Years Available", choiceLabels: local!years, choiceValues: local!years, value: local!selectedYear, saveInto: { local!selectedYear, a!save(ri!selectedYear, local!selectedYear), a!save(local!GridData, wherecontains(tointeger(local!selectedYear), tointeger(index(ri!engagement,"clientYearEnd",null()))) ),a!save(local!selectedIndex, null), a!save(ri!selectedEngagements, null), a!save(local!data, null) } ) The local!GridData is used in the data parameter of the gridField but here it is not getting any value. Can anyone please suggest what needs to be done? Thanks

I have created template that contain Appian input structure ( ###sample### ) to replaced by the the smart service "MS Word 2007 Doc from Template" but it read some fields and give this  as in the figure in others what is the issue ?

Does Appian support multiple versions of same application for different environment(Dev/Test/Production)? If yes, how it will be achieved, can we create multiple settings file.

It seems this question keeps poping up. But I ll keep it simple: 1. What is the best way to store checkbox values, when multiple choices are selected? 2. Is it possible to show such record on a read only checkbox? I also checked Checkbox Component - Appian 21.2, but I could not find the information I am looking for. I also tried changing the DB and CDT from integer to varchar/text. Additional topics I looked at: Appian Community Appian Community Appian Community Appian Community Kind regards,

I have a requirement to have my read only grid which is populating from a process report only show the tasks for groups which a user is a member of (located in column c2). I have tried using a filter with isLoggedInUserMemberOfGroup(LoggedInUser(),fv!row.c2) but this yeilds an improperly scoped variable. Please assist.

Hello, Does anyone know if there is a correct way to estimate the memory that I will need in a production environment if, for example, I have a process that runs 1000 times a year, consumes approximately 100 AMUs per instance and is active for approximately 5 days. I need to make an estimate of the resources that I will need in the production environment according to the volume of active processes that I will have

I want to get all active or inactive Appian Users list in a Expression Rule. Can anyone please help me regarding this?

Hi, How can I trigger external page or other web-page on button submit in interface? Button in interface (submit) -> other page. Thanks.

Does appian support custom setup? for example - backends in-memory database engine not required on one server when using load balancer and multiple application servers for scalability. Can we also use any third party services (like Azure Redis cache) as cache engine?

What are the best practices recommended for Disaster recovery for Appian application and data?

Which tool/database Appian used for in-memory database engine? What file format Appian used to store application artifacts?

Does Appian support changing configuration settings without downtime? Does Appian support existing database components like stored procedure for querying data? Can we implement custom styling for existing Appian UI components?

Hello Community, I want to make an editable grid with fields having below details Column Names -  studentCountry  , studentName, subject , status - (Pass or Fail)I've Created the grid where the studentName will be repeating and read only because of the different subjects  & also  subject will be read only-> the user (teacher) should fill the studentCountry and his status - (Pass or Fail) in editable grid,Now my requirement is such that when a teacher selects student country for a particular student it should update the studentCountry for all the rows having that particular student name.How should I achieve this. Any suggestion will helpful.Some sample data for better understanding      studentCountry    studentName   subject        status1)   dropdown             Student A         Maths          Ye

Hi all I am trying to export data store entity into excel via the process model and am receiving the following error. Kindly help out in this regard. Error:  An error occurred while attempting to setup the export for VOPS data. Please contact your system administrator for additional details. (APNX-1-4505-054)

Hi, Reg: Need an advise in pushing the huge volume of XML data to database tables. Using the SFTP smart service, I am receiving the complex structured .xml file which holds ~200 MB of data in Appian. Now I am looking for a optimal design/solution to push the entire file data into staging tables of the mariaDB. Could anyone help me out with the steps how can I approach this particular situation? Any suggestions would be really appreciated.