Foundation

So I have a question if something is possible. In this application we are going to be developing there are two ways to submit a form. (and when I say form, I mean a paper form, not the formLayout component in Appian. You can fill it out and mail it in, or you can fill out the information online (We are revamping an old legacy system with Appian). But what the client wants to know if it's possible is after you fill out the information on the appian application, on the "Review" part of the process where you review all the information you just entered, is if they can "view" it in the form. So instead of just using Appian read-only fields which is what I've done on other applications during similar Review steps, an image of the paper form is displayed on the interface and the information is imputted into its proper place on this form. Does this make any sense? Hahah. I just need to let the client know if this is possible or not. Thanks!

I am trying to navigate between 3 pages with a "next" button, i also need to highlight the circle that indicates the page i am currencly in ,  ex:   I declared a local variable for the "NextPage" and gave it a value, but it seems to be null ,  The error i am getting is " Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!stampField [line 47]: Cannot compare incompatible operands of type Number (Integer) and type Null." why is it not saving the value of the local "NextPage"? local!acc, local!requestDetails, /* Defines whether or not to collapse the side nav */ local!stampNav: false, /* The selected navigation section */ local!activeStampNavSection: 1, local!NextPage: 1, local!MaxPages:3, /* The navigation sections */ local!stampNavSections: { a!map(name: "Customers Details", icon: "user-circle"), a!map(name: "Request Details", ic

so i  have a requirement. here can see for the collateral type and description need to generate two separate documents. but here i have to check for the customer collateral type is their or not if type(451) is present then generate 4 docs in 2 colms.  we need to show the it gird how is in the requirement  can someone plz let me know how to proceed. i have checked for the customer the type is present or not then next steps am not getting

Hello all -  I have a process model, where the first task is to call the database for a view (image1). This view has a unique column that is saved to a CDT with other columns (roleid and rest of columns). I save the output of the query database results to an array variable that has the view CDT. My next task would be to iterate through the array variable to update the table that matches the roleid. How can I loop through each array with roleid from the variable and match it to the table roleid? I don't think using a Query Database with the following is correct as the variable propert doesn't seem accessible. Thank you for your help.

Hii I have created SQL query rule based on filter and integrated in process Model and there i have called export to excel SQL smart service when I am downloading on the basis of filter it is working but only small letter value is working capital letter value is not working when I am downloading the report through export to excel. How we can get on the basis of capital letter. What I need to do in SQL query.

I am trying to implement send e-mail activity. The instance is working fine with no exception or error but I haven't received any mail.

Can someone help with example. How to do batching in Query. I have clear understanding of how it works but need clarity while implementing.  Eg: create a query entity rule such as : a!queryEntity(entity: cons!entity, query: a!query(filters{whatever filters you want},local!pagingInfo(startIndex: 1, batchSize: 100)))after this what i need to do? I need to fetch 7000 records

The expression rule below should return a list of dictionary containing loanAmount and monthlyPrincipal. It gives me a strange Expression evaluation error : with no specific errors. If I change ri!loanAmount <= 0, to be ri!loanAmount <= 28824, it works for some reason. Not sure why and not sure what's going on. This rule has a rule input called ri!loanAmount of type number(decimal) which I am testing with 100000 as a test scenario to make this work.  Any ideas what's going on? If there are any other ways to get this to work without doing recursion, please let me know. a!localVariables( local!principalPayment: 100000, local!interest: 15, local!loanTermYears: 30, local!periodicInterestRate: (local!interest/100)/12, local!periodicInterestRateModified: 1+local!periodicInterestRate, local!periodicInterestRateModifiedToPower: power(local!periodicInterestRateModified, local!loanTermYears*12), local!xx: local!periodicInterestRateModifiedT

Hi, I have link as below . To make it more noticeable to the user I would like to add a border to it and make it look like a button. I tried to use cardlayout but it is displaying like in 2nd image. Can someone help me how to display border just order the richtext link, not the entire row. a!cardLayout( contents: a!richTextDisplayField( value: a!richTextItem( text: "Add Meeting Minutes", link: { a!startProcessLink( processModel: cons!RGRACSLBL_PROCESS_LEAD_LAST_APPROVAL, processParameters: { requestId: ri!requestId, labelChangeCountryId: ri!labelChangeCountryId_int, fromHQ: if( local!requestDetails.workflowType_txt = cons!RGRACSLBL_LabelUpdate_WorkflowType[1], true(), false() ), labelChangeRequest: cast( typeof(

HII  i am getting this error - Expression evaluation error [evaluation ID = NYEY6] in rule 'gai_displaybatchrecordsummary' at function a!gridField [line 59]: Cannot update Map using null index (APNX-1-4522-005) How can i resolve this  i have added my code a!gridField( showWhen: a!isNotNullOrEmpty( ri!record['recordType!{43099841-b468-444e-97af-bc369b79a6fc}GAI Batch.fields.{c835857e-c9ec-40d4-a818-f2d8593b1100}batchNumber'] ), label: "Batch Details Grid", labelPosition: "COLLAPSED", data: a!recordData( recordType: 'recordType!{975fa1c0-6a6a-494c-bdf3-1b0d87ea07e0}GAI Batch Detail', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{975fa1c0-6a6a-494c-bdf3-1b0d87ea07e0}GAI Batch Detail.relationships.{3cd6a92f-954f-48e2-

I have a requirement where based on condition I need to fetch the table name so am storing it in Data Store Entity Type. Am able to fetch the value, but I need to convert this to table name. Can some one help how to convert it. Do help with code or if we have any function Eg: Am getting value in Process Model in Pv!table: 473c45d0-5c99-4665-a335-f772838ccb37@2232 but I need to display exact table name. Note: table is of type Data Store Entity

Hello, I have stored different values of a grid in my local variable local!DatosLineas (read-only fields which result on querying another record  + extra column which must be completed by the user).  I want to "write" some of the fields of my local variable in another record fields. For example, the id_pedido of my local variable (which has been created by querying another record, "CPF_Lineas_Pedido") would be the id_Pedido in my other record ("CPF_Lineas_Recepciones") In this case, I don´t know how to match the fields and write my new record with the data of my local variable. I have to point that the INFO SHOWN IN THE VALUE OF EACH FIELD CORRESPONDS TO THE PREVIOUS RECORD (CPF_Lineas_Pedido), but I want to save the values in a NEW RECORD (CPF_Lineas_Recepciones) My code is below: a!localVariables( /*mirar para incluir columna extra en variable local*/ local!DatosLineas: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-42

I'm trying what should be a very simple task ... and I can't get it working!  I've created a Related Action to update a record - just used the automatic creation tool that built me an interface and a process.  In my user interface, if I include the related actions dropdown on the record view, this update works perfectly. The interface shows all the fields and allows me to update and hit Save. Perfect. But now instead of using that interface from the related action dropdown, i'd like to place it in a view so that it shows as a toolbar menu item across the top toolbar. But now, when I hit Save on that interface, nothing happens. It's like it's not calling the process at all.  Here's my related action and my view - what am I missing?

I have record type that get its source from data store entity and it has default filter and other user filters how can i query the same data using expression rule ? for example we have fields in the data store entity      startedBy , status , location , department  , empId , addedOn and the rule inputs for the expression rule are searchText , selectedLocation and createdOn this is the default filter  a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field:"status", operator: "=", value: 2, applywhen: a!isUserMemberOfGroup(loggedInUser(), cons!SP_MANAGER_GROUP) ), a!queryFilter( field: "startedBy", operator: "=", value: loggedInUser() ) } ) and this is the user filters that i want to use (this for user search )  logicalExpressions:  a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: "empId", operator: "=", value:tointeger(ri!s

"An error occurred while retrieving the data. Details: The data source [jdbc/Appian] cannot be reached or its configuration is invalid. Details: could not extract ResultSet" I keep encountering this error while trying to add some filters to the data retrieved from a query entity. The query runs fine and retrieves all the data, however, when I go to add some dynamic filters to this data I keep encountering this error. I am reaching out to see if anyone from the community has come across the same error and what solution worked for them. Basically trying to add a few specific data filters to a search bar in the application. Any suggestions are welcome. Thank you

Hi, Does anyone know how to convert a document stored in appian to an url? to use it as a dynamic link in a json. Thanks!

Hi is there any way to input this type of sticky pad into appian interface and the save the written values to the database without the use of process model.

Is it possible to build a process report that shows me all processes (and id's) that are showing as error ? i can use the existing report that lives under Perf Monitor to view how many instances have errors - but I want to build a house keeping task that will go back and cancel these cases and for that I need to get the process id's for a named procedure. (date filtered) Alternatively how much impact is there when deleting process instances in bulk. 

Hello everyone I have a requirement to remove the decimal point in the value. For example 15.50 into 1550. Is it possible? 

Hello. I built some process flow logic that's checks if a value isn't null and then performs an action. The value is for a property of a CDT processVariable: Ex: if(  a!isNotNullOrEmpty(pv!requestItem.field),  do something, do nothing) I came across an issue where the flow was performing the action when the value is null (value is verified) I'm debugging in an expression rule and can replicate the issue when the query returns a Dictionary list, and I get the intended behavior when using data[1]. The issue makes sense here since the null checks were originally against the list. However, the process variable isn't a list, its a single entity ("Multiple? is No and verified). So I'm not sure why the behavior is happening. Has anyone experienced this and found a solution?

Anyone know how can I change from this format: "mm/dd/yyyy h:m PM" to this format: "dd/mm/yyyy h:m PM". I only want to switch the order for the day and month.  I have tried the following expression, however this way it doesn´t show PM/AM. a!gridColumn( label: "Fecha Recepción", sortField: 'recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion', value: if( isnull( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'] ), fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], datetext( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], "dd/mm/yyyy hh:mm" ) ), align:

Hi, is there an easy way to know how many times and where a component (for example a!hierarchyBrowserFieldTree) was used in an Application? Many Thanks

load( local!crAppComments_cdt: rule!CR_APP_QE_getCoventsAndConditionsCommentsBasedOnFilters( requestId_int: ri!requestId_int, cif_int: ri!cif_int, sourceName_txt: ri!sourceName_txt ), { a!boxLayout( label: ri!sourceName_txt & " " & cons!CR_APP_LAB_COLLATERAL_COMMENT[1], isInitiallyCollapsed: true(), isCollapsible: true(), contents: { a!sideBySideLayout( showWhen: not( contains( ri!buttonAction_txt, cons!CR_APP_TXT_READ_ONLY ) ), items: { a!sideBySideItem( width: "10X", item: a!richTextDisplayField( align: "RIGHT", value: a!richTextIcon( linkStyle: "STANDALONE", icon: cons!CR_APP_TXT_ACTION_ICONS[2], color: "ACCENT", size: "MEDIUM", caption: "Edit", link: a!dynamicLink(

load( local!crAppComments_cdt: rule!CR_APP_QE_getCoventsAndConditionsCommentsBasedOnFilters( requestId_int: ri!requestId_int, cif_int: ri!cif_int, sourceName_txt: ri!sourceName_txt ), { a!boxLayout( label: ri!sourceName_txt & " " & cons!CR_APP_LAB_COLLATERAL_COMMENT[1], isInitiallyCollapsed: true(), isCollapsible: true(), contents: { a!sideBySideLayout( showWhen: not( contains( ri!buttonAction_txt, cons!CR_APP_TXT_READ_ONLY ) ), items: { a!sideBySideItem( width: "10X", item: a!richTextDisplayField( align: "RIGHT", value: a!richTextIcon( linkStyle: "STANDALONE", icon: cons!CR_APP_TXT_ACTION_ICONS[2], color: "ACCENT", size: "MEDIUM", caption: "Edit", link: a!dynamicLink(

I have the following error, I am trying to display a card info on vehicles. Expression rule works properly. Please help me on how to understand this error. Thank you.