Data Fabric

How to filter records using time (like created time) .? In the same way we filter for dates like using date range, Can we create a filter for time range?

Hi,  I have a use case where while updating an already created Form, I want to limit the user to only update a particular attribute / field in the form where the rest shows as "Read-Only" For example, in the above case, I want to give an access to only update the Ownership % for particular users, and rest fields be "read-only".

Hello, Why forms are not submitted in my record views? I've made an example with a simple interface :  a!localVariables( local!tfiValue:"", a!formLayout( label: "Form", contents: { a!sectionLayout( contents: { a!textField( label: "Text", labelPosition: "ABOVE", value: local!tfiValue, saveInto: { local!tfiValue }, refreshAfter: "UNFOCUS", validations: { if(local!tfiValue="test","not defined",null) }, validationGroup: "testGrp", required:true ) } ) }, buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", submit: true, style: "PRIMARY", validate: true, validationGroup: "testGrp" ) }, ) ) ) In the designer it works fine : if the field is empty, the submit tests the value and as it is required the warning appears  Validation is

was not able to select a field in record type in appian as it is greyout in configure fields tab

Record Grid refresh option is not refreshing 

Hi there, I have problem setting up the SQL sentence "SELECT .... IN " in query database smart service.  if I directly writing "SELECT .... IN ('1234','5678')"  in the SQL Statement, it will work. if I have create a process variable to be the string '1234','5678', then put the following sentence  SELECT .... IN (ac!str)       and assign the process variable to this ac!str, it will not work. I dont know what's the problem here, as I can't hard coded in the SQL sentence, the string need to be dynamic. Can anyone be able to help? regards, Lin

Hi, I am getting the above error when trying to access the product details. The process model is working fine.  This is my Asset Management Record. When I try to select a product, I get the error message. My CDTs and DB fields match. So what field is missing?

How many types of records are there in appian and differences between them? Please provide document link as well for reference .

Hello All, We have created a record type and some related actions. The related action is based on process model and process model is activity chained. When we configure this record actions using "DIALOG BOX" then after record action gets completed, The data inside summary view is not getting refreshed automatically. User has to refresh the page to get updated data. Does anyone has any idea as to why is this happening? Or is it something appians default behavior?

Hi All, I have a Record type configured in a Grid and the Grid i have configured some set of columns which are coming from the Record Type. The Export to excel button works in Tempo. However in the Grid when we configure the Export to Excel button It is throwing an error.  It says expression evaluation error at function if parameter 2 line 73 invalid symbol found comma. But when i validate the interface it is working fine. Can someone help me out.

It seems that CDTs created in Appian and/or created from database tables then modified in Appian cannot be used with Generate New Action wizard in Record Types. It also appears that we cannot use CDTs made from scratch in Appian with Generate New Action wizard in Record Types. What is the root cause here? It seems as soon as you touch CDT from within Appian editor you cannot use it for Generate New Action wizards anymore (the Replace with existing object feature is not available or not working). Please advise. Related: Generate new action assistant Appian Community

I recreated the Record Type for my project to troubleshoot an issue with some fields not displaying, and now I'm not getting this "Generate Interface" button to automatically configure a Summary view. Is there a dependency I need to clear for the Record Type to recognize that there is no interface?  

Hi!, i´m trying to use the new action assistant, but each time i use it it creates a new cdt for each action, and it doesn´t allows me to choose my cdt. It´s rare because now you can create a record from a cdt, and then auto create a form to add record ¿but with another cdt?

I'm trying to review data offline for a scenario if user was to go to a location without internet connection but still wants to be able to review his data. Can I populate a grid field with the data from a record type that has data synced or do I no longer have access since I'm offline? In documentation it mentions to load everything onto a local variable and access the data from the variable. But by doing this I'm having trouble making user filters when using the local variable instead of the record type.

how we can assign task to user on site and where do task save? i dont know if i am asking the right question. Can anyone tell me concept about task s, process report task and related things?

Currently getting the error below Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 29]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Team Lead"] has encountered an error. Expression evaluation error at function 'user' [line 29]: Null argument not allowedany ideas on how to solve this issue

what happen with CDT if we add extra column with database table?

How to have Record Level Security for my Appian Application where it restrict some users from editing a Record via a Site URL.

I couldn't get my DataStore to to republish a DataType association that's been around for a year. Finally, I created a new DataType from the same view and compared the downloaded xsd's Old one: <xsd:appinfo source="appian.jpa">@Column(name="isMultiplePlan", columnDefinition="TINYINT")</xsd:appinfo> New one:<xsd:appinfo source="appian.jpa">@Column(name="isMultiplePlan", columnDefinition="BIT")</xsd:appinfo> The view hasn't changed. It's still a TINYINT(1). Is BIT new with the MariaDB version? Thanks, Colin

We have a user input task assigned to a group and a user accepts the task, is there a way we can capture those task details to separate table in DB when that task is in accepted state before the task gets completed.

Hi, I would need to colorise a a!linkField. I've tried with a!richTextDisplayField() and a!richTextItem(color: ...) but it does not work. How would you do (if it is possible)? a!gridColumn( label: "contract", value: a!linkField( links: { a!recordLink( label: ..., recordType: ..., identifier: ..., ) }, align: "CENTER" ), align: "START", width: "NARROW_PLUS" ), Regards

Hi, I'm trying a simple code using an Interface containing a RecordType based grid, and I need to pass the 'fv!row' to an ER to make some fields calculations/traitements for the current row. In this example (below), all works fine because I've used the workaround to add the column "year" in the grid (showWhen = false, because I do not want to display this column in my example). If I remove this column from the Grid, it seems that the "year" field is reset to null in 'fv!row', so the ER can not work with this field anymore as it is always set to null. Could you tell me why there is such an issue ? passing RecordType 'fv!row' automatically casted into CDT seems to work yet. How would you do to make it working (removing definitively the "year" column) ? *** Interface : a!formLayout( label: "Grid with RecordType", contents: { a!gridField( label: "Vehicles", labelPosition: "COLLAPSED", data:

I have a Web Service backed records with SYNC. It seems that any change to the model, like adding a field causes reference change to the identifiers. they become ciphered through out the application, like:     value: ri!record['recordType!{b5a3ddfe-bf55-4e0a-899f-94116fd09520}DE SuperReport.fields.{982f3d1f-3e61-43e0-a22f-9d692ff770af}'] Please advise.

I have created a sync/web based record type. However after changing the underlying data in the source, I do not see an option to modify the  model.  Pleas advise. 

Hi everyone i am new at Appian and i m trying  to understand how i display the labels and the choice values that comes from a DB . into a dropdown and save it in a rule input after its throwing an error that i dont understand. can someone explain what is my error and what is the better solution for doing this ?  thank your