Community

Hi, When I try to add date using Today() ,value is saving into the database properly (Refer to the below attached screen shot) Whereas when I try to load into the grid using RecordType, it was showing like below. Any advises on this please.

Hi, I am trying to substitute few characters from input string and store/display in the rule input variable (i.e. target). SAIL:  a!localVariables( { a!buttonArrayLayout( buttons: a!buttonWidget( label: "Add", value: "Add", saveInto: a!save(ri!target,"2323432345,2343234543,4433443323") ) ), a!forEach( items: ri!target, expression: a!paragraphField( label: "Target", labelPosition: "COLLAPSED", value: substitute(fv!item, ",", char(10)), saveInto: a!save(fv!item,substitute(fv!item, ",", char(10))), required: true, refreshAfter: "UNFOCUS", ) ) }) In the image above I have used substitute( ) function to replace all comma ( , ) character with char(10) but as you can see the display value is converted to desired format where as the data stored in rule input remains the same (comma separated). Please help me convert the data :  From :  2323432345,2343234543,4433443323 To :  23

Hi, I am using a Execute Stored Procedure smart service and it is returning 2 result set and each result set is returning with multiple values. Now, when I try to grab the store procedure output  result into a variable like below, I am getting an error. An error occurred while evaluating expression: keys:AC!ResultSets[0] (Invalid index (0) for list: valid range is 1..2) (Data Outputs)

Hi all, How can I cast True or false into yes or no?is there any function to convert like this? Thanks in advance

Hi, I am trying to use "Sync Records" smart service after using "Execute Stored Procedure" I found in the documentation that in order to use "Sync Records" smart service with a service-backed record type, you must first configure a Sync Expression on your record type. As per the documentation, in order to generate a new Sync Expression, I have to follow the below steps  docs.appian.com/.../records-data-sync.html In the record type, go to Sync Options. Under Sync Changed Records, locate Configure Sync Expression and click + GENERATE EXPRESSION RULE. But, unfortunately I am not able to find the "GENERATE EXPRESSION RULE" under Sync Changed Records.  Any advise here.

Hi, I did set up from and other options as per the below specified screen shot, but still I am NOT getting email from IT Service Desk. I am getting an email from "appian-alerts@nsroot.net; on behalf of; XXX, XXX.com". Do I need to change any other setting any where to reflect this.

Hi, Does anyone knows how to fix this?  And also what configurations should I set to run my test in headless chrome? Thanks.

Hi, I am very new to Appian and i am going through some of the courses, which i think are very helpful. I am reading and learning about CDT and Record Type. They look similar to me but i am sure there is something that i am missing. When would you use one vs another (example)? Appreciate your help and comments as i navigate and learn Appian. Thank you!

Hi, How to setup to reach to "End Node" if there is any failure in the "Send E-Mail" smart service. Any advises please.

Hi, In the below table of an Appian form, I'm trying to read all data from the 'Title' column using the Appian API. Is there a way for me to read the data?  So far, I have used the following methods: fixture.getGridContents(),  fixture.getGridIndex(), fixture.getGridColumnRowValue() but with no success Regards, TIA

Hello, I am basically looking for something very similar to triggers in databases. In my asset management app, employees have been assigned some assets. Some assets have a returnOn date. I want to send email reminders to every employee (employee user group)u if any of their assets is approaching their return date. Maybe 1 day before the returnOn date. I am aware of the escalations and exceptions in the process model. But I do not need to do anything else just send email reminders. What will be the best approach for this? Any help is appreciated. Thanks!!

Hi, My question is how you could create a dropdown with the list of months and another dropdown with a list of years and when selecting a value, filter by date. I currently have a date field in my database. I have created an expression rule with a series of filters and one of them is the date with the operator between and the value: {datetime(year(ri!date), month(ri!date), day(ri!date), "00:00:00"),datetime(year(ri!date), month(ri!date), day (ri!date), "23:59:59")}. But how could I do it with a dropdown for the year and another for the month? Thank you very much for the help.

Hii all How to create a report using query entity not using report type ?Can anybody help me .

Hello, I'm creating an asset management website application for a company as my school project. I have used the same summary view for three pages (My Assets, All Assets, Available Assets) on my site but with different filters according to the required use cases. I have also created multiple related actions (Request Asset, Retire Asset, Update Asset) and configured their visibility according to the user groups' accessibility criteria.  My Assets and Available Assets pages are visible to the employee group. If the employee selects a particular asset, it will take them to the summary page where two related actions - Request Asset and Retire Asset are enabled for them. Currently, I see both related actions on the summary view. My problem is that I want: 1. Retire Asset Button to be visible only when the employee is visiting the summary view via the My Assets page, and, 2. Request Asset Button to be visible only when the employee is visiting the summary view via the Available

Hi, Can I get Expression rule to retrieve specific fields only from data store entity in expression rule.Because while trying with index I am able to get only single field data, If I use the just .data I am getting data of all fields. But my need is to get only specific fields data from data store entity. Thank you

How to convert an expression rule output to a particular type. Do I need to do something in expression rule itself or can I do something when trying to use along with local variable.

I'm new to appian and I want to explore on HierarchyBrowserFieldTree using CDT. So, if possible any one can give me example to try

i am new appian. logged in through mu gmail account. trying to access community.appian.com site.(get my site) it is erroring out with my creds. could you please hlep us on this.

An error occurred while trying to retrieve the data store entity [id=Approved]. Verify that the data store and entity have not been deleted, and have the correct security settings. Details: java.lang.IllegalArgumentException: The id of the data store entity must be a composite id with a "@" as separator: Approved error please check

The error above used to happen occasionally but has been getting worse & worse to the point I am unable to do anything in the Interfaces 103: Build Complex Interfaces by Adapting Patterns course I was working on today.  It only happens when I am using my works laptop which connects to the internet using my own internet to connect to my companies network via a VPN. This is the only way the works laptop can connect to the Internet. And also happens when in the office connected directly to my companies internet. I get this when trying to drag & drop components using the design view. This can also happen when using the palette and trying to change from the components tab to patterns or design library.  I also have had it when working through the developer  training course again same scenario as above or when using the Monitoring tab and trying to change to the other tabs to check the health of my app or processes.  It can also happen why try

I am re building the Dev training app and this is only thing I cannot get to work from the training guidance and I am not sure why.  I have rebuilt up to step 13 and every thing else and other tips have worked.  On the add Vehicle form. a tip is "TIP: Use the Visibility Setting to Conditionally Show Interface Components ● In some cases, you might want to display a component based on a condition. ● To do this, use the Visibility setting in the Component Configuration pane. Select Only Show When and enter an expression in the Expression Editor. ● For example, imagine that you want to display a Comments field if a vehicle’s mileage is above 150,000 miles. You can enter the expression ri!vehicle[recordType!AX Vehicle.fields.vehicleMileage] > 150000. ● This expression determines whether the Comments component is displayed on the interface. When set to false, the component is hidden and not evaluated. The default is set to true." I have the following in How

Hi, I was able to pull list of users from the group call "AA ADMIN" by using a contact "AA_ADMIN". Now, is there a way I can pull the email addresses of these users. Any advises please. a!localVariables( local!listOfUsers: getdistinctusers(togroup(cons!AA_ADMIN)), local!listOfUsers )

Is there any log which will tell which object is causing the exception ? 

Hi Team, Can we download the list of users present inside a user group in a specific app on Appian.  What is the best way to get the list of the users that have access to specific app on Appian.

process model