Foundation

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.

Team, I am having a requirement to generate an excel document from data available as list of CDT (Storing data to DB not allowed). Need suggestions on this.

Hi ,     I am having a drop down with 4 choice values A,B,C,D. Based upon the value selected for Eg; D, a  section will appear below. My requirement is when the drop down value selected is D, then below section should be refreshed i.e. set the section fields to null if the drop down value selected is either D to A or A to D or B to D or C to D , then below section should be refreshed i.e. set the section fields to null. if the drop down value selected is either B to A or A to C or B to C, then below section should not be refreshed. so for this requirement i want to save the previous selected value of dropdown to compare with the latest selected value in order to do the refresh. please provide your suggestions or any other idea to do this requirement. Thanks in advance Pradeep.B

Hello All, I have an issue wherein my validationMessage is not removing after clicking cancel button. My scenario is I have a User Form that whenever I click submit it will show a message "All fields are required". After that I will now click the Cancel Button. However, when I go back to the Form my validation is still there. Can anyone explain to me how can I prevent that from happening?Here's my validation a!validationMessage( message: "You must fill up both roles and email address!", validateAfter: "SUBMIT", showWhen: or(isnull(local!email), isnull(local!role)) ) Here's my field a!textField( label: "Email", labelPosition: "ABOVE", value: local!email, saveInto: local!email, refreshAfter: "UNFOCUS", validations: {} ) I put the validationMessage under the columnLayout.

Hi All, We have a use case where from parent process we will call a webapi and based on the data received the webapi triggers subprocesses dynamically and consider the subprocesses count is pretty high.  We need the child processes to communicate back the parent process as well ​ So the key requirement is: ​ 1) maintain the relationship between parent and child processes ​ 2) Have a way to notify parent process at regular intervals - lets say on completion of certain steps in child process One way to implement this is using a send message and receive message, do we have any other alternative way which doesn't include DB intervention. Please suggest Appreciate your help. Thanks!

Hi,  I have an interface with a section layout which displays a read-only grid using a!gridField_19r1(). The data is fetched from a DB view using a query rule and displayed in the grid columns. My requirement is to conditionally display the data in one of the columns called Proposal Type. There is a boolean column named IsEarlyRenewal which stores true or false and for every entry in the view, I need to conditionally display if(IsEarlyRenewal = true, "Early Renewal', whatever the original value of the ProposalType column) . So, example:   id= 12345, IsEarlyRenewal = false, ProposalType = Modification -> ProposalType returned as Modification  id= 56789, IsEarlyRenewal = true, ProposalType=Modifiction => Proposal Type returned as Early Renewal Both the Proposal Type and IsEarlyRenewal  are columns in the view and can be fetched on the interface.  TIA!!

Hi everyone, is the Associate Developer Practice Test representative of the actual exam? Will passing this Test guarantee you passing the real exam, or are there other materials of tips needed to pass the actual exam? Thanks in advance.

Hi All, Is there any possibility to showcase the Record Type VIEWS in Vertical order? Currently the VIEWS are in Horizontal order. Thanks in Advance.

Hi,  We are planning to migrate Appian to cloud from on premise. Could I please get some pointers on what needs to be changed in the code, what's not available in cloud but is available on-prem, and other important details?  Thank you!

Hi! I have a question. Can I change the message error that appears in the section layout when some other component inside has an error? Bellow its an image of that error message. Thanks for your help!

Hi, We have requirement to send an escalation email notification to assignee's manager ( Organization AD) if user input task is not actioned within stipulated time. Can you pls suggest if this is possible in Appian to obtain someone's manager name dynamically ?

Hi all, We are having problems when a user enters special characters ($,<,> etc) in an interface. The data is stored in the DB and later on reloaded in the form incorrectly. I have checked in our Oracle DB that value for NLS_CHARACTERSET is WE8ISO8859P1 and the value for NLS_NCHAR_CHARACTERSET is AL16UTF16 Does that mean that our DB is not configured to handle special characters? Should we ask our DBA to change the configuration in order to support the special characters? Alternatively, is there any way to solve the problem from the code? I have seen in similar questions that a clean or substitute function could help. I think the best option is to write a funcion with multiple substitutes to store < instead of "<" and so on. Thanks a lot!

Hi all,  we are at an early stage of a large migration project from a very heterogeneous system to Appian, we have still little informations and the question is how to approach the migration of process instances from the old system to the new one. Do you have experience in this regard? Assuming you have the data in db, is there a good way to generate the new instances? Or is there a convenient data format from which to generate instances (e.g. json)? I am also wondering if there is any connection with restoring processes during an Appian upgrade from Appian_OLD to the new version. Thanks in advance!

Hi Team, Getting an error while restarting the engine server. It says  'execution01 K engine process not running on port 5029 yet' Any help is appreciated.  Thanks, Anandita

Hey All, It seems like a common way to cast a value to the type "List of Dictionary" is via: cast(194, local!thingBeingCast) Does anyone know of a way to do this without hardcoding the "194" value? This approach doesn't seem very explicit (I personally have to remind myself of what it's doing in a blank rule whenever I see it), and god-forbid that type id changes one day and needs to be changed one-by-one throughout the codebase. Thanks!

Hi, Currently when user logs in in Appian with "Remember Me" unchecked, the user will be automatically logged out of Appian after a particular threshhold in case its inactive, however this is not the case when "Remeber Me" is ticked/checked. Is there any way in Appian to customize (Remove) "Remember Me" option while logging in for  a particular process ? The process contains PII and its not safe to keep the user logged in for long time when in inactive state.

Hello,  I have a use case where end users must be able to define "functions" that will be applied to values defined in the application.  I was wondering if it was possible for the end users to write an Appian function with SAIL format in a paragraphField and then "translate" the generated text into an actual function ? Is it possible maybe thanks to Appian Java API ?  Thank you in advance, Claire

Hi all, I need your assistance to solving the situation which is important for my project. I need to modify the logfiles which I know generated automatically. I just need to add some field in the perflog/web_api_details.csv file. How shall I do this?  Is there a way to manipulate log4jconfig.xml in Appian cloud environment to capture additional information in perflog/web_api_details .csv file. Please suggest. Thanks in Advance.