Discussion Categories

Hi,  I am using a Record Type, and it has years of existing data. Unfortunately, the active data is identified by the length of the column name "uniqueFieldId", which is a text value so there is no consistency. Note, this is not a primary key in the table. The active field length must be 5 characters long. Anything greater or less is not considered active. Since it has years of existing data, we do not want to insert a new column, as I was thinking the easiest solution would be run a sql inserting an isActive column and then running the filter on it.  Now, my requirement is to use a record type, and filter the data. I am unsure how I can use record filters to ignore data by the length of the characters in the uniqueFieldId. The record type is then being used in a readonly grid. A gist of the code below, the aggregation below is necessary as there are other fields and calculations I am doing using relationships to this record type.  In a gist, is

Hello people, do you know web or agencies for work as a freelance in Appian projects this summer?Most common

Hi all,  I have a dropdown field and have a condition for disbaled, based on that it will be disabled or not.--> if it's not null or empty it's working fine --> if it's null or empty, the dropdown is not disabled and I'm able to select a value for first time. Once I select the value, the dropdown gets disabled. ( since it considers that the field is not null and it's disabled. But I want the field to be editable) Can someone please help here.   disabled: { if(a!isnullormepty(ri!record[my dropdown field])false, true ), },

Hi ,  When I have a rule input for the record in the interface , the values will get updated in the rule input as I update the values in the interface. In interface test, If I am have the record A and pull all the data from the DB, initially it has the values from the DB. But later when I edit the fields, the values will keep on changing (in interface level)How can I store the value when it's initially being pulled from the DB.  Can someone pls guide me here?

Hi, I am parcticing with the a!queryRecordType() function and I realized in return one field called identifiers where the primiary key is returned and I would like to know if I could transform it together with the data field into a map where the identifiers values are the keys and the data values are the values. For example: Having: identifiers : {12,20}  data : {"first value", "second value"} Transform it into {12: "first value", 20: "second value}

requirement is to get all documents from particular folder and then send those document one by one to third party API, but problem is, this API accepts document as base64 URL, not Appian document id, so can someone suggest , how can we get base64 URL for Appian document such that, we can send the same to the third party API 

ID refId Title Status 1 10 Test1 Approved 2 10 Test2 In-Review 3 10 Test3 Approved 4 10 Test4 Approved How to write query filter to fetch refId=10 when status all rows should be Approved

Hi All, Can we send mail to DL(distribution list)in appian with email smart service in appian? Please let me know if that option is available in appian

Hi Team,  I created an Appian account on June 26th, I requested for Community edition site. when can I expect the Site? Regards, Chandra

Hi,  In the date field, for the calender I want to make the weekends as disbaled (non selectable) whereas the week days should be selectable. is it possible to do this in a!datefield?

When I click on the performance tab of the interface  it says - not a valid component. Has anyone faced this issue? Please see the screenshot for reference

In my interface, I have many read-only field. I need to display them only when a field in the table ( isshow is set to true).For this, I included a showwhen : abcsample.isshow = true. But this is throwing me the below error: Interface Definition: Expression evaluation error at function a!headerContentLayout: Cannot compare incompatible operands of type Record Field and type Boolean.In this case, how can I give this condition. Can someone help me here?

Is it possible to delete versions of record type? I see in documentation version 21.3 that only web API versions can be deleted but in 22.2 release It include record type as well to not to delete versions. So, Also tell when 22.2 release applied ?

I am facing issue for refreshing the page after Completion of Record Action though Activity chaining there. could any please help on this.   Issue: When we delete the document from Record action, document is getting deleted but in interface still it is showing. 

When CSV is generated from Excel, first row is being skipped. And a blank row is added at the end. Any suggestions?

Hi, is there any function which convert USD OR POUND into  INR I have to convert  USD 30,872.11 and  €30,089.46  into INR how can i convert ?

Hi,Is Maintenance window in Admin console activation and deactivation records any logs?if so can anyone let me know the location to find the maintenance window logs? We would like to know who and when made this maintenance window changes.  Thanks,Venu. 

Hello Everyone, Can anyone help me with the Purpose of process reports?

Q1. a!dashboardLayout() is deprecated what layout should I use in place of it.. Q2. what was the role of a!dashboardLayout()

Hello, I am getting this error Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = EO1CO] : An error occurred while executing a save: Expression evaluation error: Cannot update Map; invalid index provided of type: Record Field (must be String or List of String) What does it mean?

Hi! I used to work with records, uploading the data based on a manual task in an interface (user introduces parameters and the record updates the info). However, I had to use a data store entity for an editable grid programmation, and I dont know if there is a chance to upload the record based on the data store entity. Thanks!

We have used MS Graph email poll plugin to read the emails and store relevant data. Once email is received and read, Emails are moving to junk folder. How can we create folder and apply rules to move emails for different folders.

Sir any guidance for level 1 interview

Hi EveryOne,  I am doing poc, My requirment is to show the Toggle, depends on the User selection, it has to display the respective pages   Thanks in Advance 

Table I want to query's structureDOCUMENT { docName docDesc color size priority } I have a list of {{ pickle.doc, blue}, { habenaro.doc, green}} I want to use to query the table with. Is there a way to do this in a single query? My list is of the form {docName, color}, none of these combos are unique.  I could get back 20 entries and still be fine with that solution.