General

Hi, I configured the sign-in Page with one link which was initially not showing on the sign-in page. But when I removed the link from the Sign In page it started showing in the login screen. Can anyone suggest how to remove the link? Screenshot of no links configured Screenshot of the link showing on the login screen

Hi All, We have given our client to add notes up to 10000 char. It is getting saved in DB as well, But when querying from Record it returns only 4000 char. I need help here to overcome this limitation. It's Urgent!!! Thanks in advance.

Hi Team,I have a constant which holds array of data store entities, In a interface I need names of those entities from constant.for example: cons!xyz is my constant, if I just simply use this in interface I'm getting something like this(internal representation) [Data Store Entity:"29c9c1bd-6809-486b-8da1-f993cd872bbc@867691"] [Data Store Entity:"95bb55be-5347-4ea3-9713-b78870bbf7e3@867691"]instead is there any way to get name of those entities like "employee","education" ,something like that.Thanks in advance [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] 

a!dropdownField( label: "Deposit Amount", labelPosition: "ABOVE", placeholder: "--- Select ---", choiceLabels: a!forEach( items: rule!CD_QE_Get_Amounts().data, expression: fv!item.amountFrom & " - " & fv!item.amountTo ), choiceValues:a!forEach( items: rule!CD_QE_Get_Amounts().data, expression: fv!item.amountFrom & " - " & fv!item.amountTo ), value: {local!DBben.Amount}, saveInto: {local!DBben.Amount}, searchDisplay: "AUTO", required: true, validations: {} ) Hello All,  I am facing this error "has an invalid value for "value". All selected values must be present in the choiceValues array, but value was -∞ and choiceValues was 100000 - 500000; 500001 - 1000000; 1000001 - 2000000;" any advice ?

We are experiencing an intermittent problem with Send Email node in a process. On the front end, the error is 'Failed to send email'.  On the stdout log, it is stated that the error is caused by: 'jakarta.mail.AuthenticationFailedException: 535 Incorrect authentication data - https://community.mimecast.com/docs/DOC-1369#535'.  According to the given Mimecast web-page, error 535 is due to 'Incorrect authentication data'.   The sender and receiver in this instance was the same as multiple other instances in the same day, which worked as expected, with email going out and being received successfully. Any ideas? Thanks for taking the time to consider this.

The Health Check for my application, for process sizing, has 3 process models that are all taking up about 16GB and 32,000 # of instances.If I reduce the archiving from 3 days to 1 days on each process, it should cut out 10GB and about 22,000 instances.  Would doing this have any positive impact on the applications performance as a whole? Would it free up resources or processing engines in any way where I could see improvements on process models?Right now, I'm seeing sometimes my write to data stores taking .90 ms in some cases and then in other cases, taking up to .300ms (which is too long)  For context, my prod environment has about 853,000 process a day (585,557 completed, 183,000 active)

Hi Team, I have requirement to run on scheduler to create case based on configuration and export some transactional data in the excel file, send an email. In the excel there is one column with datetime type is one of the columns and in the excel always it is exporting as the usertimezone. Example: This scheduler PM always run around 01:00 AM CST and last published designer time zone is GMT.As this user is administrator across platform level, so don't want to change user time zone to CST. Please find below items for reference. 1. I have run the PM in the CST timezone,Stil in the exported excel file taking the last published Administrator account time zone (GMT). 2. I can do it in data base, but i don't see any dynamic function to convert automatically handle daylight savings (Without hardcoding +06:00 hours..etc). Can you please help me out to export excel the column data datetime as CST timzone. Thanks and Regards Venkatesh Suram

Can anyone help me, Is there any option to delete document from SharePoint by using Appian.

Hello, Please let me know if we can generate the password protected excel using Appian? or make the generated document password protected? Thank You!!

Hi All, Its very urgent. I am facing an issue with removing <style>......</style> from the HTML text. I want to remove all the text/special character/all the property between style tag. <html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style> <!-- @font-face {font-family:"Cambria Math"} @font-face {font-family:Calibri} p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif} span.EmailStyle17 {font-family:"Calibri",sans-serif; color:windowtext} .MsoChpDefault {font-family:"Calibri",sans-serif} @page WordSection1 {margin:72.0pt 72.0pt 72.0pt 72.0pt} div.WordSection1 {} --> </style></head><body  style="word-wrap:break-word"><div class="WordSection1"><p class="

Hii, I am getting this error while clicking on record Action: An error occurred while applying the context for the GAI Grant related action [identifier=253]. Details: The record data does not exist, has been deleted, or you do not have sufficient privileges to access it. How can i resolve this ? ), a!gridColumn( value: a!recordActionField( actions: a!recordActionItem( action: 'recordType!{8b4ab8ba-4c5b-4a6e-bf36-23ee7bb475b3}GAI Grant.actions.{4e3745c4-618f-44fe-a3de-3c29fd228894}editProjectObjective', identifier: { appId: ri!appId, projectObjectivesId: fv!row['recordType!{0b254c54-d92c-4674-a733-f9a9e4e2b147}GAI Application Project Objective.fields.{bd9fc329-44b3-4179-bd65-a400aee6091c}projectObjectivesId'] }

Hii, I am unable to select NA option , for YES or NO Its  working fine , how can i resolve this,  i have to save a!radioButtonField( label: "", choiceLabels: { "Yes", "No", "N/A" }, choiceValues: { 1, 0, "NA" }, value: fv!item['recordType!{f42d5bd8-9c50-4910-b251-13ec6bf9fdb6}GAI App Review.fields.{899275d5-d9e3-4030-9291-883eaf45d2c6}reviewerAnswerBool'], saveInto: { local!a, a!save( fv!item['recordType!{f42d5bd8-9c50-4910-b251-13ec6bf9fdb6}GAI App Review.fields.{899275d5-d9e3-4030-9291-883eaf45d2c6}reviewerAnswerBool'], if(local!a = "NA", {}, local!a) ) }, this value in to boolean type column

Hi Champs, In one of the use case, we do need Case management and I see Appian comes up with it's Case Management framework ; but I am not sure how to use the same. Can anyone have use the same or any idea how to use it? Regards, Ghanashyam

Team, Do we have any cloud approved function which can provide constant using constant name ? Regards, Gaurav

Hi everyone, We had a summarized task list ( SOURCE : View ) in a grid , where we have rows coming from so many record types. We had a recordlink present for every id, once clicked it have to redirect it's concerned record type dynamically. So could you please help me retrieve the object type using its UUID.- Once provided it had to retrieve the recordtype, which i will pass dynamically to the recordtype input in a!recordlink(). If anybody worked on any type of this scenario, please help me on this. Thanks in Advance

Hi, I am confusing datetime value how to handle in appian? I read below of link :community.appian.com/.../handling-date-and-time Confirm in my cloud environment .Datetime value does not show correctly.What wrong is it?

Hi All, I am using Appian 23.2 version, using text field to validate percentage value for a float/number data type column but Appian not throwing error when I entered text value, instead, Appian automatically removing text and only defaulting numeric value if any in the entered text. Few scenarios: a1.25 - Should error message 10.s2 - Should error message  10 - Should allow to proceed 10.25 -  Should allow to proceed. I have tried with integer field also but no luck, seems I am missing something. Please help me on this validation. Thanks in advance. a!localVariables( local!percentagenum: 99.99, a!textField( label: "Percentage", value: ri!spx_Launch['recordType!{97e19909-9b98-4335-a811-7472bde63ac3}SPX Launch.fields.{39ad4217-f104-46d2-a63c-06b17a945271}flight_number'], saveInto: ri!spx_Launch['recordType!{97e19909-9b98-4335-a811-7472bde63ac3}SPX Launch.fields.{39ad4217-f104-46d2-a63c-06b17a945271}flight_number'], validations: if( len(

What should I persist in the db to identify a group? I may need to migrate this to another system IE: Dev to Test

how much time difference pp!timezone to IST  which timing =pp!timezone is following

What is the most common use case for an Appian application? A. A reporting tool that uses complex aggregation across different systems. B. A workflow that requires extensive database data extraction, transformation, and loading. C. A workflow for multiple groups that needs to be accelerated while reducing mistakes. D. A backend process that requires management and no user interaction.

Hi All, I have a requirement where I need to merge 2 selected rows in read-only grid and merge them into one row and the displayed name will be the first selected row. Where the whole data related to both selected records will be merged into one.

Hi All I am using getLastLoginDateTime function which is in the below plugin  [mention:f77937a217d845edaa4c53ff358f0f09:f7d226abd59f475c9d224a79e3f0ec07]  But facing weird issue.  below are the code snippet It is working fine without typecase but while typecast it is showing errorNote :- loginDateTime has date and time data type and it is not working for 2-3 users and for rest it is working fine even while typecast.

Hi Team, Currently am writing data to table from stored procedure. Can someone help that what is the best way to improve its performance, Since in Healthcheck its coming as High Risk.  Number of records added is around 4Lakh. 

how many times we can take exam for one registration.  if so how many times? how many days in gap we can take the exam. 

Hi, i'll give any date it has to subtract with today and give me number of days difference ex: inputdate -today= no of days difference, 04/07/2023- today = 7 days which functions i can use to achieve this? suggest me