Foundation

Using a grid I display several rows of comments on a form. The requirement is that users should be able to see only their comments or final approval/rejection comments. They should not have visibility to the comments for the different approval flows. The current solution is showing every comment in a grid. Is there any way I can restrict the visibility of approval flow comments? Any recommendations? TIA

Hi All Im having an issue regarding accessing my Community Edition Site Environment. Whenever I access the site envi, it has an error issue of "HTTP 403 Forbidden" I have already clear cache, tried access it on different browser but still the same. Any ideas why its happening?  I have attached some evidence for the issue: Than You!

Hi All, I am trying to use indexing for type " List of Text String " but the output i am getting not the expected output i am adding the screenshots here for reference. Thanks In advance, SSP

Hello all, Newish to Appian. I am trying to pass inputs to the Process Post Request API and am getting "null" as a return and the process does not start correctly. I am assuming this is due to my process containing a pv of a CDT rather than separate fields.  My question is: does the request body change per api, what should I pass, and is it possible to merge both get and pull requests into one api?

Hi all, I want to get fields in a CDT based on their numerical index, i.e. if I have a CDT like: {'type!{urn:com:appian:types:TEST}TEST_Employee'('firstName': "Frank", 'secondName': "Smith", 'age': 29)} To get the first field, is there a way to index it by number? Something like index(local!testCdt, 1, null) would return "Frank".  Thanks for your help!

Hello, I address you because I’m trying to get the lvl2 Appian certification. So, I would like to know if you would have any guides, tips, tricks, notes which could help me please ? (I’ve already took in consideration the Online Appian help, the Appian playbook, and advanced online training subjects, and of course the practice test) Maybe do you know some other pratice tests which could i try ? some Appian performance exercises for example... Regards

For accessing the next and previous records from the summary page view i have been applying the following logic on primary key and its giving me the required result of giving the previous and last records correctly. a!queryEntity( entity: cons!TT_TimesheetLog_Cons, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1, sort: a!sortInfo( field: "id", ascending: if(ri!fetchingPrevious, false(), true()) ) ), filter: a!queryFilter( field: "id", operator: if(ri!fetchingPrevious, "<", ">"), value: ri!currentPrimaryKey ) )).data.id now the situation is following: -like the next and previous buttons, I also want the last and first buttons which should take me to the first and last records in the grid, e.g. if i have 100 records the first button should open the first record summary view tab and the last button should open the 100th record. Currently I am not able to do that. -also if i am on the last record lets say 1

Appian covers many of the beginner questions on their new Youtube channel. Check it out! www.youtube.com/.../UC_3XbhXKEEs1_mi3S-DVD9Q

how to validate phonenumber with out using localvariable?

Hello,            Can anyone point out exactly what is happening? Our recent planned upgrade to newer versions of appian went as planned, but we started noticing missing tasks and also sudden alerts that are hard to trace where the root issue lies? Here's the stack trace, particularly unable to pinpoint exactly is the problem related to server upgrade or some missing precedent on a CDT! com.appiancorp.security.auth.activity.UserActivityFilter - Could not record user activity: secCtx=internalUser, authDetails=null -- java.lang.NullPointerException2022-07-12 13:53:02,275 [Appian Work Item - 2777 - execution00 : ExpressionRequest] ERROR com.appiancorp.process.engine.ExpressionRequest - An error occurred while evaluating function request: queryruleexec("483ddfd5-4250-4320-9a80-3ebbe68804ce",null,null) [id 794 from Unknown]com.appiancorp.process.expression.ExpressionEvaluationException: The expression function 'queryruleexec("483ddfd5-42

Hello All, I'm currently creating an editable grid for school records with a field called year graduated. I want the following entries for this field to be compared with previous row to check if the year is greater than the previous row and output an error message. However, I can't seem to find a way to access the previous item. I tried using index function but I'm having a cannot index type error. a!integerField( label: "Graduation Year/Expected Year", labelPosition: "ABOVE", value: fv!item.yearGraduated, saveInto: fv!item.yearGraduated, required: true, validations: { if( fv!index >= 2, if( fv!item.yearGraduated > index(fv!item.yearGraduated, fv!index - 1), "Please enter a valid year", "" ), "" ) } ) Any help would be appreciated. 

Under the form, I have a save button that will be disabled after the form submission. The button should be enabled if any changes are made to the data or a comment is added.Any help will be appreciated.

What do timer started processes do when the system is restarted?

Hi, Is there an option / workaround to capture the below Highlighted part for a group? Scenario: Based on the Group, I would like to create a safe link and navigate the Admin user to respective Group page. Thanks in Advance.

Requirement : Inserting customer and transaction records to database using Process Model. one to many relationship between cutomer and transaction table. ( one customer can have multiple transaction ) My Scenario I have one customer and 2 ttransacion records which has to be added to the database. Write to Datastore entty :Inserted  customer data in to  database and received  inserted id  for the customer data. Script task :Used script task to assign the  customer id ( received from previous step) to  transaction table foregin key . ( multiple  checkbox is checked in script task) Write to Datastore entty : 2  transaction records are added to db but first record has the foreign key but not the second one.   May I know why script task is assigning foreign key to the first record but not second record ? Did I miss anything ?  Is there any other method to resolve this  ? ------------------------------------------------------------

From where i can download my certificate for Appian Associate Developer exam?

Hi Team, I have opened the project of th Appian Slelenium API in Eclipse and getting below error in HelloAppian.java file. Exception in thread "main" java.lang.Error: Unresolved compilation problem: Logger cannot be resolved to a type at com.appiancorp.example.HelloAppian.main(HelloAppian.java:20) Could anyone help me on this issue.

Hi All, We have a use case, where we are trying to generate a word document using a process model with the data present in Appian DB, also, we have related documents which we what to attach in the generated word document. Is this Possible. Thanks in advance. Warm Regards Vineeth

I have parent process where it is saving data,I have sub process where it is updating same data , getting error at write to data store node “ An error occurred in executing an activity class “ Any suggestions please

Good Day Experts, I'm trying to generate the dynamic table using DOCX From Dynamic Template smart service. Please find the below configurations.  Xml Data Model : <devs><dev><name>Kalai</name></dev><dev><name>vanan</name></dev></devs> Sample template attached below. I'm getting below error, I've tried all possible ways to modify the merge field tags but still no luck. Can anyone please guide me what am I missing ? Error : freemarker.core.InvalidReferenceException: The following has evaluated to null or missing:==> devs  [in template "fr.opensagres.xdocreport.document.docx.DocxReport@6419bd1f!word/document.xml" at line 4, column 1455]----Tip: If the failing expression is known to legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use [#if myOptionalVar??]when-present[#else]when-missing[/#if]. (These only cover

Hi Champs, I have an requirement that in editable grid i want two fields in a single column and also  make all rows selectable by default .please, let me help for this issue.  As in figure i want the result. Thanks in advance..

Hello,  So I have a business requirement to create an xlsx file report with multiple pages.  I looked into the Excel plug-in and didn't find anything regarding that or similar. Does anyone know of a way to do it?  Thanks in advance.

Hello,  I am new to Appian. We currently have a process model that generates a completed PDF contract based on Data Inputs mapped from an interface.  We would now like that generated PDF to automatically be read only so a user can't change values in the form after the fact. Can I please get your thoughts on how to get the PDF to be generated as a read only instead of fillable form? Thanks!

Hi all, I have the following code:  it runs up until  fixture = new SitesFixture(); than i get this error: it says something about log4j manager missing but i didn't implement that. also i tried adding the log4j jar files from apache but still got the same error.  any help is greatly appreciated. Thank You! package sampleProject; import java.awt.AWTException; import java.awt.Robot; import org.openqa.selenium.By; import org.openqa.selenium.Keys; import org.openqa.selenium.WebDriver; import org.openqa.selenium.WebElement; import org.openqa.selenium.chrome.ChromeDriver; import com.appiancorp.ps.automatedtest.fixture.SitesFixture; public class helloWorld { public static SitesFixture fixture; public static void main(String[] args) throws AWTException { // TODO Auto-generated method stub System.setProperty("webdriver.chrome.driver", "removed path name"); WebDriver driver = new ChromeDriver(); Robot robot = new Robot(); int three = 3000; driver.get("s

I am trying to keep the submit button disabled if they have not selected a file and if the file is not a CSV extension. The button disable works fine for check for no file but the file extension checking is not working and can not figure out why. In the below code the first if is working fine but the second one it gets this error    Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function 'document' [line 45]: The passed parameter(s) are of the wrong type. Received the type Text.   and can not figure out why.  Is there a better way to check this?  Thank you for any help on this, also the ri!csvFile_txt it saves into show this     [Document: 383603]   as the value for it.  The upload also works fine with the csv file as well, just having the issue on the disabled validation part. primaryButtons: { a!buttonWidge