New to Appian

Hello All, I have a requirement that status need to be updated until following Monday. We will upload spread sheet on Every Monday or Tuesday or Wednesday. While uploading it will check the date(it is a column in spread sheet) current date and previous date records will be updated to New Status. Now the requirement is it should be validated previous dates, current date and until following Monday records. We are able to achieve previous dates and current date. How to get following Monday date as we are not sure about the file upload week date. For example: On 08.12.2021 If I upload the file it should be validated on or before 08.12.2021 and until following Monday(08.16.2021).   On 08.11.2021 If I upload the file it should be validated on or before 08.11.2021 and until following Monday(08.16.2021) Please Suggest. Thank you

Hello Appian, From the appian cerification FAQ link, https://community.appian.com/learn/certifications/p/faqs  It says that "To maintain your certification, we require that you consume the quarterly release training and complete a short assessment." Where can I find the Quarterly release training? Is the "Release Showcase training" the right one? https://academy.appian.com/#/catalog/e17ac3d6-142b-418a-a4d6-1a23386be533  Also, do I get a message or alert before my certification gets expired? 

Hi, I am using the send email smart service. I let the user write the body of the email in a paragraph field, save body text in a text variable, and in setup>Message Body field, I use an expression to fill the body with the text variable.  However, the email gets sent with no formatting. At least, I want to capture the "new line" breaks that the user enters in the paragraph field. I would appreciate your help.

My use case: "Implement a related action. The related action will send an email. The list of recipients is inputted by the user. The subject line is inputted by the user. The body text is inputted by the user. These user inputs are captured after submitting a form interface"  I am using the "Send E-Mail" smart service. I am passing recipientsList, emailBody, and subjectLine text values as inputs to the process model.  How can I use these process variables in the Send E-Mail smart service node? I can't seem to figure this out!

Is there a way we can use xpath expressions on Appian Selenium api without initializing webdriver class?

I have a table called reference amenity in which I have manually mapped amenityId and amenity types, I want to call this table using the foreign key field of another table called amenity table and want to store the amenity Type.By using the expression rule I have called the reference table but I want to store the amenity types  using the foreign key  can anyone suggest to me how to do this. Reference table: ammenity table:from this table I want to call the ammenity type  ...

Hi My use case is as follows.  I have a button that initiates a process that creates an excel follow.  After pressing the button, and upon successful creation of the excel file, I want to display to the user a document download link. As for the label of this link, I want it to say "Download + FileName", where the file name is a Local Variable  for example, I want the label of the link to say "Download Excel File Number 5" for example Is there a way to make the label field dynamically displayed based on the value of a local variable. 

Hello All, We have an Angular Page(Dashboard) where all the Appian's tasks related to logged in user will display. There is a run task link which will open Appian task in new window and user can complete the task. Once the Appian task is completed the task window will get closed automatically and dashboard will display the updated task. We want to show a success message at Angular page(Dashboard) something like “ Task : [name] has been completed”. Please can someone share any idea to achieve this. Thanks, Gaurav

I have a process model that is calling an excel sheet that no longer is tied to the constant that is being used for a process variable.  We are working with an existing code base and there has been some deprecation since taking over the project.  When running the process, the error is "Invalid Content ID".  In the constant used for that data input has a value that says "Not Visible".  Is there a way to determine what document that constant was tied to, even with it saying "Not Visible" as a value?

Can any one provide proper answer and justify the answer with brief explanation with examples.

Hello Appian, How do I make a link to return to the previous grid, after having drill-down to a summary view? 1. drill-down to summary view through read-only grid(record grid) 2. from within a summary view --> want to go back to the grid using a link Thank you!!

I have one login form, I want to add one link from where i can redirect user to next interface or register page if not register, can i do that using interface component . I was trying to do that but not able to give the uri for next interface, please check below code: a!linkField( /*label: "New User? Register Here!",*/ labelPosition: "ABOVE", links: { a!safeLink( label: "New User? Register Here!", uri:" ", openLinkIn : "NEW_TAB" ) }

Hi, How to create a horizontally scrollable card list similar to what is shown in the image below.

Hi, I am unable to add " all users " group as parent group to " admin group " in my application. While I was creating the Admin group and tried o find " All users group " in  the parent group column, but it was not visible. Can anyone help me. Thanks, Praveen 

I have workbench installed in my system how do I connect it with my cloud appian??

Hi, I have a basic question Suppose I am working on ExcelDataProvider template, and I want to change content of the file as well as name of the input file and some logic of mine to process the rows. What is the process to build/deploy the java code using IDE. and do we need to import deployed code again in Appian ? Thanks, Mohini

if(ri!vfm_lastupdate<today()+730,"new",if(or((ri!vfm_lastupdate > today()+731),(ri!vfm_lastupdate>=today()+1440)), "refurbished",if(ri!vfm_lastupdate>today()+1828,"Testing Required","Null"))) here i need to check if the given date is less than 2 years compared to present date then show new, else between 2-5 display refurbished else more than 5 years display testing required 

Hi, I have a requirement to read uploaded DOCX file from appian uploads folder convert it to PDF and show in document viewer on richtext icon click on the fly. I have been able to convert DOCX file to PDF but not able to show it in document viewer. Please help.

Hi, Im new to Appian. Id like to add to my cloud database from an interface! However, I have a primary key thats auto incremented in the table and cant be null. So how do I add from my interface? Should I use an expression rule? query it? I dont know how to make sure the IDs arent the same each time the user adds something. Thanks 

Hi, In the Edit Record list  as per the requirement lastname,Firstname should be display in the grid but while sorting by last name  it is throwing the error, Error Evaluating UI Expression The alias [[field=STUDENT_L_NM, ascending=true]] cannot be used because it contains illegal characters. The alias must contain only letters, numbers, and underscores, and must start with a letter. Thank you

Hello Appian, I want to end the process automatically, if no work is going on for an hour after the process start. I thought "deadline" would play such role in the process model, but the process continues even after I set the one hour deadline. Please let me know if there is a way to end the process automatically, after no work is going on for an hour after the process start. Or if the deadline is the right way, I may have done something wrong with the setting, so please give example to follow. Thank you in advance.

Hi , I am Using SharePoint Connected system to Upload a PDF document from Appian to sharepoint . As a response i am supposed to get a Linking URL for further set of actions but i am getting a null value. PFB screenshot. Any solution to this issue? plz help Thanks

Can anyone help me understand which topics to read thoroughly for Appian L1 Certification?

Hi All, On my cloud instance, while accessing Properties I am just getting different language is the tab without any option to define properties. 

Hi , When you hit cancel button ,it should juss close the form .So that the task will be able to accept by others in the group rather than cancelling the entire Workflow How to Implement this? Thanks