New to Appian

Hi everyone, I was doing Lesson 5 Challenge in the Developer course that has an if() function and the condition to be tested is isnull(ri!test). So my expression looks like this: if( isnull(ri!test), "null", ri!test) Now my issue is, whether the input I put in is 0 or not, it always returns the ri!test. I tested the isnull() separately, and it doesn't return True if the value i pass is 0. Can someone help if I'm doing something wrong here? All I can think of is that 0 is not being read as a null input.  when I specifically type in isnull(null) , it returns True. But when I type in isnull(0) and test, it gives a False.

Hi Everyone, When I am selecting the value in the dropdown the selected value disappears from the field. Can anyone please guide me to resolve this bug. Thanks, Shubham Yadav

I have a form where a user needs to fill it. I have an email id field in it. So, now when a user enters the email I need to check whether the entered email id is already there in the records or not. If email id already presents it should throw an error in the interface saying "email id already exists". Can anyone please let me know how to apply this scenario in my interface! 

How to use process model or smart service interface jump from one interface to another? Thanks

FitNesse for Appian , I am getting this error when trying to run a simple test to open the URL. WARNING: A terminally deprecated method in java.lang.System has been calledWARNING: System::setSecurityManager has been called by fitnesse.slim.instructions.SystemExitSecurityManager (file:/C:/FitNesseforAppian/FitNesseApplication/FitNesseForAppian/lib/fitnesse-20200501-standalone.jar)WARNING: Please consider reporting this to the maintainers of fitnesse.slim.instructions.SystemExitSecurityManagerWARNING: System::setSecurityManager will be removed in a future release

Is it possible to migrate for instance a CDT but change the values to hide the real values?

Hi Everyone, Is anyone have any example of using a!writeToMultipledatastoreEntity to update multiple tables. Thank you

load( local!data:{ rule!KONE_Development_trail_flatten("song","wang") }, local!updateColumn: tointeger( updatearray( local!data.user, a!forEach( items:rule!KONE_Development_CSE_TENDER_PHASES_Rule(), expression:fv!item.id ), a!forEach( items:rule!KONE_Development_CSE_TENDER_PHASES_Rule(), expression:fv!item.id ), ) ), updatecdt( local!data, { user:{(local!updateColumn)} } ) ) Expression evaluation error at function 'updatearray' [line 7]: The indices are not of the expected type. Type of indices: List of Variant. Type expected: List of Number (Integer) AnyOne can correct?

As pictures show, i wish to save all list of value to database, but once i add attribute under it, it one keep returning value of the list's first value, why? Is this the defect of appian software it self?

So I recently deleted some rows of my table from the Cloud Database and using a process model, I tried to enter user values via a form. The primary key in my table is ID and the rows that I deleted had ID's = 4, 5 When I entered new values via a form, the new row generated in my table had an ID = 6 and not ID = 4 So how do I make changes in the XSD file so that my ID value starts again from 4 ?

Hello, i have a record type mapped on an expression rule that calls an integration service. I'm able to create a grid which displays every record type's element; this is easy :) I would need to insert a column at the end of each row that calls an integration service passing a property of the record type. I created a related action that calls a process model that contains the integration service call; i can't call this related action from that column. In the last column, the one that calls the service, it has to be present a "play" icon.Thanks in advance.Marco

I was doing a tutorial: Building a Form I follows the instructions and create a new Maintenance Request Form but when I try to Save as Action, it jumps to my Appian Process Modeler and I don’t know what should I do, What should I Write in between StartNode and EndNode? Can Anyone Please give any suggestions !

Hi Everyone, I need to pop up a prompt when user click on update button, if the required fields are left behind. Can anyone please guide me how to achieve this.

please anyone help me to solve the problem

Am looking for an example i.e, am selecting values from checkbox. values are in hierarchy like global value(main), multiple parent and multiple child values. when I select a particular child then parent of that child value need to be selected automatically even the global value also. whenever I select the parent then global value need to be selected automatically. 

Hi All, I have a use case to display pop up on click of a button. However it should be displayed only if specific flag is set to true. Can this be achieved ? local!isDataEdited : false(), /*Confirm Message should only pop when this flag is set to true*/ a!buttonWidget( label: "Back", icon: "repeat",saveinto: {}, submit: true, style: "PRIMARY", validate: false(), confirmHeader: "", confirmMessage: "Any changes will be lost if you continue to navigate away from this page.", confirmButtonLabel: "Continue", cancelButtonLabel: "Cancel" )Thank you and Appreciate your time and effort  !!

Hi, I have a requirement to create a grid something like the one below : first row first column has one cell, first row second column has two cells and first row third column has two cells. Date Name Code Monday September 20, 2021 Dave 1122 Frank 1133 Tuesday September 21, 2021 Maria 3322 John 1324 Joe 3444 Thursday September 23, 2021 Adam 3432 Please suggest

So I'm building an interface and part of it the user can change address and add credits to his account, but when i add credits I need to update the browser in order to display the new balance value, I've been told I need to use refreshVariable but doesnt seem to work for me can someone help? heres a code snippet: a!localVariables( local!filter, local!imagesdetail, local!selectedtab: 2, local!addingaddress: false(), local!addcredits: false(), local!user: rule!AS_Get_Account(loggedInUser()), local!newaddress, local!addedcredit, local!changeaddress:{name:loggedInUser(),balance:local!user.balance,address:local!newaddress}, local!changedbalance:{name:loggedInUser(),balance:(if(isnull(local!addedcredit),null,local!user.balance+local!addedcredit)),address:local!user.address}, local!filtered: rule!AS_Get_By_Category(local!filter), local!visivel, local!id, local!querycomments: rule!AS_Get_Comments(local!id), local!info: rule!AS_Get_By_Id(local!id), local!

... local!cart: rule!AS_Get_Cart(), ... a!gridLayout( label: "Editable Grid", labelPosition: "COLLAPSED", headerCells: { a!gridLayoutHeaderCell(label: "Item"), a!gridLayoutHeaderCell( label: "Price" ), a!gridLayoutHeaderCell( label: "Stock" ), a!gridLayoutHeaderCell( label: "Quantity", helpTooltip: "The number of items you want to buy" ), a!gridLayoutHeaderCell( label: "Total Price" ), a!gridLayoutHeaderCell( label: "" ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 4 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 1 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig(

Hi, Anyone who knows the definition of database view? and what is database view used for? I'll appreciate it if someone answer my question. thanks a lot. [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hi Everyone, I have to update multiple tables when submitting a from using interface. Can anyone please guide me how to achieve this? If there is any example, it would be more helpful. Thank You

So, I'm building a record where i have all the items in the store, then i can drill down to 1 item and update ir, but when i click on update item related action i get this error:  An error occurred while applying the context for the AS Items In Store related action [identifier=21]. Details: No process parameter found corresponding to override [name=pv!item]. Non-parameter process variables cannot be overridden. Any help?

Hi,  Does someone know the difference among Service-Backed Record, Process-Backed Record and Entity-Backed Record? and the definition of them. I'll appreciate it if you would like to answer my question. Thanks! [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hi, I am trying to compare two dates one is stored in DB (lets call it dbValue) and another one is from now ( ). Now, where I have : dbValue: 10/02/2021 09:00 AM now: 10/1/2021 9:18 AM EDT dbValue<now it gives me true dbValue: 09/30/2021 09:00 AM now: 10/1/2021 9:18 AM EDT dbValue<now it again gives me true Not sure what's the issue, please help me.

What is the use of Foreign key while creating a CDT in Appian? Please give a brief understanding on the same with an example.