New to Appian

I upload a excel and saved into database, then report such error

as title, when i start an interface it always report this error, what is wrong?

what should i fill in each blank of smart service in process model, or in interface smart service code?

Hi, Can we implement this for readonly grid? https://docs.appian.com/suite/help/21.3/recipe-use-selection-for-bulk-actions-in-an-inline-editable-grid.html

Hi guys, I am new to appian, anyone explain this code line by line briefly. if(rule!AF_RULE_General_isBlank(wherecontains(cons!GCC_DSE_cons_getReadOnlyDrillStatus, tointeger(local!drill.drillStatus))), remove(local! facilityFloors, wherecontains (false,local! facilityFloors.isActive)), if(not(rule!AF_RULE_General_isBlank(local!drillfacilityFloors)), local! drillfacilityFloors, remove(local!facilityFloors, wherecontains (false,local!facilityFloors.isActive))))

what i fill is batch size 1000, datasource name:jdbc/Appian, excel document:cons!ofuploadedexcel, newcolumn:null, newcolumnvalue:null, Number of columns to read in row: column number of excel document, sheetNumber:1, table name:constant of table name but it report error index:1 size:1, what it mean?

Hi All, I am using the export datastore entity to excel smart service to export records from database. But it gives duplicate records. I am using the filter condition as given below in data input section of smart service: = a!queryLogicalExpression( operator: "AND", filters: { if(isnull(pv!study), {}, a!queryFilter( field: "study", operator: "in", value: pv!study ) ), if(isnull(pv!category), {}, a!queryFilter( field: "rootCauseCategory", operator: "in", value: pv!category) ), if(isnull(pv!siteDepotLoc), {}, a!queryFilter( field: "siteDepotLoc", operator: "in", value:pv!siteDepotLoc ) ), if(isnull(pv!excursionType), {}, a!queryFilter( field: "excursionType", operator: "in", value: pv!excursionType ) ), a!queryFilter( field: "dateReported", operator: "between", value: { pv!dateReportedFrom, pv!dateReportedTo }, applywhen: not( or( rule!APN_isEmpty(pv!dateReportedFrom), rule!APN_isEmpty(pv!dateReportedTo) ) )), if(isnull(pv!otherRootCause), {}

Hello, I have this error in an Interface and I don't  how to solve: Se ha producido un error en la expresión a!forEach() durante la iteración 1: Error de evaluación de expresión at function 'tointeger' [line 118]: Could not cast from User to Number (Integer) Could you help me , please?

if I toString(1-groupname) just return group:1, but if i want to transfer (1-groupname) return "1-groupName" both then how to do it?

Hi, I have a editable grid. https://docs.appian.com/suite/help/21.4/recipe-add-edit-and-remove-data-in-an-inline-editable-grid.html In the summary page, the entered values in the grid has to be displayed. The values of the grid are displayed only after the view is refreshing the page.  How can we handle when the grid is updated and after submitting it is re-directed to summary view. And values should be displayed by Auto-refresh.

Hi, I have taken my exam on 4th December. I have failed that attempt. When can I take my second attempt? Is it possible to write after a week? 

as title,I want to get a user's group name and extract info save to other place, user() don't contain user's info, how to do it?

I am using function, user(fv!row.userName,"email"). In this if the username is null I am getting the error: Expression evalution error at function 'user': [InvalidUserException] Is there any way to put validation that if username is null then it should not throw error or show like no valid email ID

Hi everyone, Hope everyone is doing well and safe. As I am new to Appian, Could anyone of you help me with how can I set the Site as default start page? Thank you all in advance! Regards, Shubham Kumar

a!queryFilter( field: "compliantFlag_txt", operator: "=", value: "yes" ), a!queryFilter( field: "compliantFlag_txt", operator: "=", value: "No" ), a!queryFilter( field: "proposedAction_txt", operator: "=", value:"Released Proposed" ), a!queryFilter( field: "proposedAction_txt", operator: "=", value:"Delete Proposed" ) how can i write these 4 filters into 2 filters... 

Hi, i want to know if i build an aplication in English for exemple and i want the same application in another language, but i dont know how t write in that language.Should i create a duplicate of the aplication an try to use some translator tool like google translate for every text? Or there is some tool that allows me to incorporate in the same app diferente languages? (note: i dont want to translate for developers, i need to translate for users of the application)

I am writing this as of December 6, 2021. Just like to ask if I can just use the auto generated folders for this exericse? It's confusing since in the videos, these auto generated folders do not exist. In this screenshot, the only folder I created on my own is the AX Rules, which is what the pdf instructed. Auto generated folder does not exist in the course video. PDF instructions: Concerned course: https://academy.appian.com/#/online-courses/7dc54e85-7f6e-4e64-a073-202a2f471e39

I lost my phone with okta verify and cant get access to work account. Is it possible to request verification mail to @ or mobile phone?

Pls answer the below questions  1.When will be use Start Form.? What is the purpose?.Pls any simple example  2.How to modify the Process Model?  Thanks in Advance!

Pls answer the below question with examples What is the best way to call a process model from within a process model Thanks in Advance!

I am trying to delete a folder's all documents, at interface expression mode, how to write the code and how to express the document name at a!deleteDocument(document:??????). Thanks

How to display profile image when after file upload in the interface. Do we have any function?

a!localVariables( local!file, { a!fileUploadField( label: "File Upload", target:cons!fileUploadConstant, labelPosition: "ABOVE", maxSelections:10, validations: {}, fileNames:"testFile", value:local!file, saveInto:local!file, uploadMethods: "SIGNATURE" ) } ) I tried file upload but the file didn't get upload successfully to the appointed folder? Did i miss any smart service?

Hi All, Our company would like to create ERP system in Appian and I would like to know how to create Trial Balance records in Appian and use web API to access the Trial Balance data. Thanks. Yiming ZhangPwC | Senior AssociateShanghaiPricewaterhouseCoopers Information Technologies (Shanghai) Co., Ltd.pwc.com

Unable to access Record Actions on interface by Basic user I gave visibility as "true" for the Record Action. The Record Action is visible for Admin user but not for basic user. Please give suggestions to haddle this. Even tried the below code, did not work for basic user. Note: I have a process model to update the form. =if( a!isUserMemberOfGroup( loggedInUser(), cons!New_group ), true, false )