Foundation

how to write validation in date field so user cant select any date from past?

Hello!Apologies if this has already been answered but i am attempting to capture the current user name, date and time when they open an interface and then record this for later.So i have:loggedInUser()  - which with no other details gives me the current user(great) now() - which gives me the current time and dateI am unsure of how to tie this all together I am guessing if I use a process model I can call a rule to get this information but then I need to add this to a record type and this process would need to be fired on open of the interface?? I'm just lost right now! Sorry i'm a bit lost any help would be greatly apricated.Thank you! 

So I have a CDT with a bunch of fields in it. One of the fields is a category, while the other is string. That string field will be identical throughout a particular category, but may or may not be different in different categories. So for example: local!data: {{category:"round things", string:"bubbles, <otherdata>}, {category:"round things", string:"bubbles, <otherdata>}, {category:"soapy things", string:"bubbles, <otherdata>}, {category:"hard things", string:"rocks, <otherdata>}} I'd like to get the union of categories for that set, but instead of the output being the categories, it is the strings.  so something like union(local!data.category, local!data.category) and have the output be: {"bubbles, "bubbles", "rocks"} instead of {"round things", "soapy things", "hard things"} I hope the idea is clear?

Hi All, I have a use case where I need to convert Date and time based on user time zone. I have a date and time component, and if user of timezone CDT selects date and time as "4/1/2022 11:46 AM CDT" and submits the case. If another user of time zone IST logs in then they should be able to see the date and time value as "4/1/2022 10:16 PM IST" (whatever the usertime zone is). Based on user time zone date and time value needs to be changed in UI. I have tried with todatetime(), gmt() and usertimezone() functions but none of them works. Please provide your suggestions. Thanks

Hi, the issue is batch size in the paging.. count[no of rows] is miss matching.. when i give the batch size =-1 then count[no of rows] will match to db data  when i give the batch size =10 or 1 or 20 or 50 whatever it will miss match the count[no of rows] from db to UI  why this will happen! what is the exact issue? why batch size is giving issue? can anyone help me with this 

Hi all - I'm having trouble with the User Picker field to populate a rule input with a specific user.  I'm able to search and select a user. it shows for a split second then goes blank again.  When run in Design Mode, it does populate my rI! field, but at runtime, just shows then goes away. What am I missing?

Hi Team I have a requirement where I need to generate different update query statements for different tables depending on some conditions in a  process model.Do we have any feature to implement this? I do not want to use a XOR gate and create different nodes from XOR condition as the query statements may be huge.Or if we can generate the query statement in a Script Task and directly call the query to update the tables in the process model.We use Appian version 21.1 Thank you!!

Hi Appian Team, We have a use case where Appian API integrated with SAP , and  the SAP system will input base 64 encoded strings for pdf, we have to read the same from the input variables and convert the same to PDF. Can anyone help us to implement the  same if we anyone have already implemented or have knowledge about this? thanks Sunu Sam

in a simple process that consists of two steps first : student upload image or pdf of his certification second : secretary review document  My Question : how to connect the image component in the secretary  interface to the uploaded document by student ? p.s in the student form the uploaed document is saved a table of Document Type

i debugged a process but it keep running for infinity and filling the database with the same row

I am trying to add an existing attachment dynamically to the "Send Email" task. These attachments were previously uploaded to the application and the attachment name and document are stored in a table. I have added documents previously that were static and had a constant name. Thank you for the comments.

Hi Champ, I need to have a checkbox where I need to show the hyperlink like below. Can it be possible? Regards, Ghanshyam

Hi, I have below kind of interface (editable grid) to upload multiple documents. By default, I am providing 1 row and when user click on "Add Document" I am adding additional.  I have a rule input which is of CDT like below I was able to insert "Document Type" value to DoCTypeCode and "UPLOAD" to DocumentID. But, I was unable to inert values to "DateAdded" and "AddedBy". I have to store "DateAdded" as loggedinuser() and "AddedBy" as now(). Is there away I can load default values into these columns in the page load or when the user selected "Document Type" dropdown. Thanks.

a!localVariables( local!additionalInfoRequired, local!cancelled, a!formLayout( contents:{ a!checkboxField( labelPosition: "ABOVE", choiceLabels: {"additional Info Required"}, choiceValues: {true}, value: if(local!additionalInfoRequired, true, null), saveInto: a!save( local!additionalInfoRequired, if(isnull(save!value), false, true), a!save(local!cancelled,false) ), ), a!checkboxField( labelPosition: "ABOVE", choiceLabels: {"additional Info Required"}, choiceValues: {true}, value: if(local!cancelled, true, null), saveInto: a!save( local!cancelled, if(isnull(save!value), false, true) ), ) }, buttons:a!buttonLayout( primaryButtons:{ a!buttonWidget( label:"Submit", submit: true ) } ) ) ) Hi, My requirement is when I check one checkbox, another checkbox

Hi Appian Devs,I have long length dropdowns in the interface belowPlease let me know what is the probable reason of this error on the interface.Thanks in advance

Hi!, I´m having this error: The save target must be a local variable that does not refresh on every evaluation or on an interval, a process variable, or a node input (or a rule input passed one of those three) I´m trying to start a process with start form interface in a  a!startprocesslink inside a button. Any posible answers? Thanks

Hi, is their any other alternative to between operator? bcz am querying data from db.. giving different o/p in UI same query i have used to query the data from UI so  a!queryFilter( field: "expiredDays_int", operator:"between", value: {rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 1 ).startIndex_int, rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 31 ).endIndex_int

Hi all, My question is: What kind of field would you use in an Appian interface to display [but not allow editing] of a field like "created by" and "created date" that you want to display but not allow user editing - such that the data from these fields is actually stored into the database. Details of issue: My colleague and I are fairly new to appian development and are working on a problem. She created an interface that that allows us to add and edit the rows in a particular reference table. The interfae [mostly] works - in that it allows you to add and edit rows in the database table. The problem we have however is that there are some fields, which are not supposed to be directly edited by users. For example: "Created by""Created date" Rather than the users adding values for these fields, we want them to be automatically set by the system by retrieving the currently logged in user and the system date. My colleague has been able to set the fiel

Hi, I am working on a process model which has a Create New User smart service and in that smart service, there is an option to send Account creation email which when turned on sends the user an email with Temporary credentials with predefined content. My current requirement is to change the content of the email. Is there a way to change the content present in Body of the auto generated Temporary Credentials email sent from Appian?

So I am working on filling up my information in an interface that later will be saved and it will turn that interface into a read-only interface so I can see all my user information. The issue is that once I press submit, the interface doesn't update the fields from each section of the interface until I press refresh on my browser, is there a way to update those fields when I change it into read-only or make the site or page refresh?

Im new to Appian, first step i want to create in my app is a login page, can anyone help me on this Help me to create a simple login page with user authorisation, error message if wrong user id and password or if user id is not created in the app.

Hi Appian DevsI have a situation here to explain, please look at the two interfaces below:Interface 1: Add new templateWe can add new template here,I have to validate my text field which is "Template Name". In this, I have called a expression rule where the name of all templates is being fetched from the database. And then, I am able to validate it by checking if the text filed value input by the user does not already exists in the database or not. Case 1: Add New Template: The validation is working fine for the new addition of template.Case 2: Edit Template from template dashboard: In case of edit, the value of the text field is coming pre filled from the rule input. So, even if I change it to a new value, I am not able to validate it for already existing templates using the expression rule.Can you please suggest me a method to streamline the edit case.

I have a document with 10 pages and I was able to extract pages 1 to 4 using Extract PDF Pages smart service (Start Page = 1 and End Page = 4). The new PDF which got generated has 4 pages. I would like to know whether there is any functionality / service available which would allow me to extract only pages 1 and 4. The new document generated should be having only 2 pages.

Can someone explain what's going on here?  If I try to get the output for the following string:  fn!char(65020) & " 21,245.00" the result I get is:  ﷼ 21,245.00 however if I try to get the output for the following: fn!char(65020) & "ABCD" the result I get is:  ﷼ABCD Can someone explain to me why it's essentially the same expression, but the symbol is on the right with the number and on the left with the letters?

Can we assign a task to a group or to a particular member through interface without using the process model??