Foundation

Hi , Can anyone please help me with this issue! Thanks for the help in advance. I have an interface , i have used a!gridfield(). In the grid of the column is the date received. The error says that at function a!gridfield cannot apply operator[LESS THAN] to field [Daterecieved] when comparing to value [TypedValue[it=7,v=2024-09 -27] a!gridColumn( label: "Average customer rating", backgroundColor: a!match( value: tointeger(today()-todate("9/11/2024 12:00 AM")) whenTrue: fv!row < 10, then: "NEGATIVE", whenTrue: fv!row > 20, then: "SUCCESS" default: "NONE"),Here in above value: I am calling fv!row[recordtype!abc,daterecieved] , above is just a single value. Thanks for your responses . But Sorry my bad , its actually fv!value which i have given. Below is the code: a!gridField(label:"Rating Grid",data:local!data,columns:{a!gridColumn( label: "Average customer rating",sortField: reco

is there any way to cast from record type to map for me it  didn't worked cast( type!Map,{'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field'('recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{f5fe89e3-be39-448f-b18d-61ab47caa97b}escalationFieldId': 14069, 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{cbe43a10-86dc-41f2-a4f9-4beea7e8fc4a}escalationPathwayId': 387, 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{3437a64f-dac3-407a-a089-7e9d64dca973}isRequired': true, 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{571d49da-e656-4d6e-b6d3-bcfe8392f1b1}visibilityStatusLookupRefId': fn!tointeger(null), 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{166243bd-ab58-4b6c-a50f-613b8c6e48c9}autofillSourceFieldName': "description", 'recordT

I have created an interface for Job On boarding application. I put cards as choices to record Candidate Status whether Selected/On-Hold/Rejected, what I want is after selecting anyone of the cards It throw Confirmation message like "Do you want to Continue?". Whether it is possible? If possible, means give me a solution for that.  ps: Due to server issue I have not get the exact cards. This is for reference

Hello all, want to compare all constants from one environment to other environment, we have more than 15K constants and want to add in one package, is there any way to add all constants in one package?  Thanks, Bhushan J

Hello, I am an APPIAN newbie and during my day to day activities get to query the backend data. Sometimes the app's request table in the SQL database shows a task assigned to a group and is displayed as follows: [Group:442658].Question is: how can I track the actual Group by this number, and lookup its name and members? What is this number, is it a UID? What permissions I need to have to query this information in the APPIAN designer? Thanks in advance.

Hi All, Currently I have an interface where we allow the user to upload documents, we wanted to see if it was possible after the user clicks upload they can see the actual document before the submit the form, that way they "make sure" it is the correct document. Is this possible in appian at all? thanks in advance

Hi, we are having a problem executing an expression rule, which contains an a!queryRecordType, where we have: - 1 grouping field - 1 measure field - 4 filters,  on a batchsize of 500 items. In detail, every time we try the rule from expression rule the result is correct but when we insert it in a script task from process model it randomly gives wrong results (correct measure corresponding to wrong group fields). A delay of 1 minute after last node has also been inserted in the process  activity. What could be the problem? Thanks,  Francesca

Hi Team , I am getting this error in the grid field Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 173]: A grid component [label="Search results"] has an invalid value for "columns". A grid column [label="Relationship Manager"] has encountered an error. Expression evaluation error at function 'like' [line 229]: A null parameter has been passed as parameter 1.

I have an integration that I save the output into a DataSubset object and want to use to update a table in the database with a Query Database task. The DataSubset is as followed: DataSubset startindex null ... data [List of Dictionary - 1,000 items] Dictionary EMPLOYEE_ID "1" PAY "Hourly" ... In my Integration task, which is the first task, I save the output to a Result variable (which is type of DataSubset). Now in the next task, I add a Query Database task that I want to use to update a table where the EMPLOYEE_IDs match Would it be: "Update users set pay = ac!Result.data.PAY where employee_id = ac!Result.data.EMPLOYEE_ID;"? This doesn't seem to work. What am I doing wrong or what's the right way?

Hi All, We have requirement  that when we configure URL in interface that should allow access to microphone and camera. Existing webContentField() doesn't support this. Code snippet for reference a!webContentField( source:"">whereby.com/XXX)  Any pointer regarding will be helpful Thanks

Hi all, I'm a beginner of Appian, and I am required to change the font size of header in read only and editable grid... Is there any way to change them? According to richtextdisplayfield, this seems to be only applied to value... not label in grid column... I need your help. Best regards,

Hi Appian Developers (and Community of course), I hope that somebody from the Apprian Dev Team could answer / provide info. I'm using the Styled Text Editor Component component (a!styledTextEditorField) to display content stored as HTML (display only, no edit required). I'm wondering that is the exact maximum allowable value for the Size limit parameter?  When I set 100K, it prompts "You reached the maximum character limit. Remove characters to continue." (it is an email conversation stored as html and it is expected to be large in size). When I reduce it to 99K (set value for Size limit parameter to 99K), the error is gone. Obviously, it lays somewhere between 99K and 100K but I would like to know what is the maximum allowed, to be able to display as much as possible of the text. Or does it maybe depend on the encoding - single-byte/multi-byte? However, the documentation states "... The parameter value is about equal to the number of charac

I have an interface with a link(Open URL ex. https://) that opens a new tab/window. The new tab/window initiates a process, and I would like this window to close automatically once the process is completed. Is there a way to achieve this in Appian? Any guidance or code examples would be appreciated.

Hi Everyone, I need to Implement one grid Structure that would be like  the grid would be dynamic grid, the request Ids may depend on cif number, For Example (CIf-117907 have 5 requests (123456,12456,13456,134566,1244555) like that. How Would I do that if someone can provide solution that would be more helpful, If more details required please let me know   Thanks.

I developed a process model with a form that collects employee details. If the "submit" button is clicked, it moves to a user input task with "Approve" button. Upon pressing this, the details are updated in the database. The issue is that when I run the process model in debug mode, it works perfectly, but when I run it through the site action button, the first page is displayed but doesn’t proceed to the user input task. Instead, it stayed on that page. Please provide a solution.

I’m using a webContentField in Appian to embed a webpage, but it doesn’t allow me to access the device camera. Is there a workaround or a different component I should be using to enable camera access within the Appian interface?

Hi all, I am Importing an excel file to database. It has two tables Deals and Loans. Deals to Loans have one to many relationship and deal id should be stored in loans table for the related loans. When I am uploading the file I am first storing the excel data in Datastore. And from data store I am saving the related data in the tables. while saving the loans the related deal Id is not storing properly. Loans data is being saved from datastore itself. We are applying index for deals table and then storing the related deal ID in loans. For example I have 10 deals of data in excel the first deal has one loan and the second deal has 3 loans and the third deal has one loan. For the first loan the dealId storing is 1 and for the next 3 loans the deal id is storing as 2 but for the 5th loan which belongs to 3rd deal the deal Id is storing as 5 instead of 3 in loans table.

I do have a process model with start form. All my buttons are set to "Submit: true" but for some reasons not always buttons not redirect user back to record view. I do have enable chaining between all the nodes.  None of the sub process is run as async process. Enable chaining is also enabled between all nodes in sub processes. I'm using Appian version 20.1

Hi All , Two days ago, one of our DEV environment went down. Upon checking the server status, we found that all services were stopped. We restarted the server, and it's been working fine since then. However, I'm keen to understand the root cause of the issue. I checked the Tomcat logs but couldn't find any relevant information. Could you please suggest how I can identify the cause of this? which log should i see ? Thanks in Advance

I have a requirement where I have a wizard form with 2 steps. In first step, I need to fill in some mandatory data fields and when I click on next to move to 2nd step, then on the basis of the data filled in for those mandatory fields in step 1, a dynamic email template is generated which user can freely edit.  The problem I'm facing here is because generated dynamic email template is displayed in an editable paragraph field and formed on the basis of data in mandatory fields. Now, user can also edit the words that came directly from mandatory fields in the email body or subject. This can cause data inconsistency issues, data which is saved for mandatory fields in DB and data sent in email. What can be best solution for this problem from UI design perspective - I thought of validations but it seems next to impossible to validate the data entered in free paragraph field with what is entered in previous step and then I thought of making the mandatory fields data as readonly

How Can I fetch the List of value as a text string from the given List

Hi all, I have a requirement of importing the excel file to database. When the user upload an excel file in import it should create new data in 3 different tables. For example, in the excel file the data present is based on deals and each deal can have one or more number of loans and the deal will be having some amount values. So when the user upload a file it should update deals table, loans table an other table which contains of amount data of the deal. Thank you.

Hi, i've this pm with the following error in interface I post the code of interface but not so precisely where the error may be a!localVariables( /*utente e lavorazione*/ local!utente: rule!TES_getUtenteWeb(utente: ri!utente), local!idUtente: index(local!utente, "id", null), local!lavorazioneFO: a!isNotNullOrEmpty(local!idUtente), local!tesseratoDB: rule!TES_getTesseratoByIdTesserato(id_tesserato: ri!richiesta.idTesserato), /*modifica anagrafica: nome, cognome, dt_nascita tesserato*/ local!anagraficaModificata: a!refreshVariable( value: rule!TES_checkModificaAnagraficaTesserato( tesseratoDB: local!tesseratoDB, tesseratoModificato: ri!tesserato ), refreshOnVarChange: { ri!tesserato } ), /*gestione omocodia per disabilitare controllo congruitÃ%A0 e calcolo automatico del codice fiscale*/ local!is_omocodia: false, /*variabili per selezionare il tesserato dalla grliglia omonimi/giÃ%A0 censiti*/ local!confermaAttivit

When we deploy a document from a lower environment to a higher environment, its ID is getting changed. Due to this, constant points to invalid/wrong a document.  We are using direct deployment (Compare & Deploy) Is it expected behavior?

Hi,I am using a gridField ... Now I want to highlight a row based on a value of a particular value .. say suppose I am displaying employee info (id, name, salary, location etc ) ... Now I want to highlight a row where the employee id = 10 with red color ...  Is it possible to do so ?