Foundation

I had an idea for how to make PM-generated Emails look on-brand, but I don't know if it's currently able to be implemented. Basically, storing the colors, logo, anything that can be defined with an Expression on the Site designer page in a database table.  Retrieve these branding attributes using an expression rule, and use them to display the Site appropriately. Also be able to access up-to-date branding using the same expression rule, which can be saved as a PV and thus influence an expression-based Send Email Smart Service. As I see it, storing Brand attributes in the database also allows for easy updates to a site's look, while making the transition seamless for any branded emails.  So my question is--can a site's properties/attributes be accessed using any native (or plugin) function?  I was also looking around to see if I can find the UUID of the site itself, but I can only seem to find the UUID for a Constant version of that Site.

We got a traditional task based process running in production. Currently the users don't know the assignee of a task. How do I write into a table as soon as  * the task assignee changed   * the task is accepted by someone in a group ? ( We can design a wait event in process, which will write into DB as soon as the task assignee is changed. But this is memory consuming approach as the event is always active. I'm looking for any better approaches) Thanks everyone

Hi,Could someone help me understand the concept and solve my below problem? I have a Two tables 1. VehicleTypesField Id   category1    Cars2    Buses3   Trains 2nd table SubVehicleTypes SubID Id SubCategory1         1     Sedan2         1     Suv3         2     Luxury4         2     Semi luxury5         3     Ac Trains6         3     Non Ac Trains Requirements:1. Drop Down 1 will have data from Table 12. Drop Down 2 will have data from Table 2 When I select category from DD1 the second DD2 should give Subcategory based on ID(Common in both Tables). ThanksFaisal

Hello All, I have a multiple dropdown that have values ex. "ACTIVE", "PENDING, "INACTIVE".  I need to display all the details with a status like ACTIVE and PENDING. However, I can't do it using a!queryFilter. Here's my line up code for filter. a!queryFilter( field: "status", operator: "includes", value: ri!statusSearch, applyWhen: not(isnull(ri!statusSearch)) )

Hi Everyone, If I select the fields Ex. -"name","email", etc. from the interface. Only the data related to the fields should only download in excel format. Please explain to me how to do it. Thanks in advance.

I have an interface that has four dropdown components with dynamic choiceValues based on a query. When a value in the first dropdown is selected, it filters the values of the second dropdown. The second dropdown filters the third and the third dropdown filters the fourth. Each dropdown is disabled until a value is selected from each of the previous dropdowns. This works perfectly in the interface.  However, in the process model there is an option to "edit existing equipment" that will query a database and fill in fields in the interface, possibly including the four dropdown components mentioned above. When I test this process, I get an error that seems to be telling me that a query for one of the dropdowns in the interface is returning null when it shouldn't.  Hopefully this makes sense, please feel free to ask for clarification on anything. I have included the relevant code below. Thank you in advance for your help! Here is the query in the interface that gene

Anyone willing to offer a step-by-step guide on how to download and store Images within Appian Application for use on the UIs. I have developed this application using a!webImage, but I would like the images to be instead stored on the application server. I have not had luck checking the documentation on how to do that. Thank you in advance

what is the release date for the community edition?

Hi, Can anyone clarify on following questions with sample use cases, we have seen this in Appian pricing sheet. 1. What is an external input user? Ans: An External Input User are users external to the licensee organization have the ability to submit forms/requests to the app. 2. What is an infrequent user? Ans: An Infrequent User has up to four, 24-hour sessions per month. Thanks.

Hi i have a summary view where Im passing an interface with a parameter user type. That User type is being converted into Text through a process model. How do I pass that variable through the summary interface? Thanks

Hi all, I have a requirment to add line item in an editable grid and fill data using dropdown component.on addition of 50th line item I am getting ( Expression evaluation error: Max compression size exceeded. Max size=200,000,000, actual size=203,374,063) error . help understand what caused for this exception and any solution .

As per current set up, we can't send an email exceeding the text length of 1000. Is there any way to increase this length? We need to add a table in the email that contains records and the length goes beyond 1000 chars. Thanks, Pooja

Hi , Can you help with below information for Appian? Does Appian set HTTP response header for web content cache. (for data should not be cached on user's local disk.) Cache-Control: no-cache, no-store Pragma: no-cache Expires: -1   Are XFS mitigation headers “Xframe-option”; “frame-src” are set for Appian?   Appian contain upload functionality but does it have Antivirus scan in place for the uploaded files.? Thanks, Pooja

I have 2 dropdowns at my form, If I select the option of the index 1 of dropdown1(car companies), I want that dropdown2(car models) has to fetch accordingly with that company name i selected. How can we acheive that in appian?

My case is to display error message in a popup window, which should be displayed when a interface is opened. I know there is a confirm option in buttonWidget and link but they are not applicable for my case. Can any help on this? Thanks in advance. 

When a query is performed the response is a dataset which contains a dictionary. The issue is that the dictionary does not have the proper type casting for the attributes (they are just any types). This means that anytime a comparison has to be done, or a wherecontains is used we must first convert the result of the dataset into a proper data type.  Side note, can we just make wherecontains perform basic type casting.

Can anyone explain why and(null)  is true

I would like to call one record with parameters from within a parent record list.Example: Assume that there are two record lists: one of all companies and of all products of these companies. Is it possible to create a link for each line of the company record list which beams me to the (same) record list of all products, just each time with a different active filter, so that you only see the products of the corresponding company?The only idea I have is to create something in the 1st record under "Views", which is then displayed when clicking a record element, namely an interface that contains a grid as one can give the record element to the interface as a parameter. Is there an easier than that? Somethin like a parameterised call to a record list?

is ther any google service that will use to do comparing the signatures tht comes from the digital documents 

Hi I am trying to filter the record type that should filter either phone or email are not blank AND effectivedatefuturechange = today(). The code below doesnt seem to work Code below: a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}Address Change Participant Update Extract.fields.{929ea42f-0313-4410-8b8f-2049b30883bc}phonenumber', operator: "not null"), a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}Address Change Participant Update Extract.fields.{c8a513f8-9294-4156-9e62-a68d1204107f}emailaddress', operator: "not null"), } ) a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}Address Change Participant Update Extract.fields.{f4749c47-5f0a-4b1b-ab9a-0cd2a6045e2b}effectivedateforfturechange', operator: "=", value: today()), } ) Any help is appreciated Thanks

We are using smart service Export SQL to Excel in Appian to generate Excel report. All columns are retrieved as expected but only date columns are transformed into Text fields and applied filters in Excel are Text not Date related. If columns are taken directly from database it works fine but presented formatting is Excel is "MM/DD/YY HH:MM:SS" but our requirements are that all date fields have to be presented as "DD.MM.YYYY HH:MM:SS" . Using TO_CHAR or TO_TIMESTAMP functions didn't work again exported date columns are formatter as a text. Columns which are part from the CDT are Date and Time format as well. Do you have any idea how we can convert date fields to the mentioned format without losing date format after export to Excel? There is a similar topic but without any answers:  Appian Community. Thank you!

I want to make this Form. It is not allowed to move to the next steps unless the person fills in the required fields. But I can't activate the "required" feature, even though I added it in HTML. Therefore, I want you to help me and add or activate a required feature to Exact field in that form. But I don't want all the fields, I just want them when I put the word required. And when I add new fields, I want them to work as well. I also want to increase the width of the form to 90% of the total area, while also increasing the size of the progress bar.here is my full (HTML, CSS and JS):  https://jsfiddle.net/Maroz/s19q3gnf/3/

Hi, I have two scenarios to edit a particular record in a form: 1. When clicking the Edit button the particular field should allow me to edit the field value(field should be highlighted). 2.When clicking the Edit button an another form should open for editing a particular field. Ultimately we should be using a PM to write the updated data. Could someone please help me here? Thanks Faisal

Hi All, This is the screen which we are planning to build, and the user tries to enter the data on each and every subsection in the screen. However i wanted to understand which is the best approach to save the data. Each tab in the left hand side will go into one table where these details if i am doing in process model, there might be more nodes. so i want to reduces the nodes and take the best approach. Could you please let me now which is the best approach.

Hi,  I want to disable document link from read only grid if document is not exists or deleted from document folder.I am using following code to show and download document from read only grid. a!gridColumn( label: "File Name", value: a!linkField( links: a!documentDownloadLink( label: index(fv!row, "myFileName", {}), document: index(fv!row, "appianDocId", {}) ) ) ) Please Suggest me any solution for this.