-
Recently active
When applying an edit action to a dropdown field. Due to the lack of an enumeration data type, the dropdown field may inadvertently transform into a text field when an edit action is applied.
a!gridField( data:local!data, columns: { a!gridColumn( label: index(local!labels, "id", null), sortField: "id", value: fv!row.id ), a!gridColumn( label: index(local!labels, "createdBy", null), sortField: "createdBy", value: fv!row.createdBy ), }, pagingSaveInto: local!pagingInfo, selectable: true, selectionValue: ri!idDoc, selectionSaveInto: ri!idDoc )
if(a!isNullOrEmpty(fv!row['recordType!AX Vehicle.fields.image']) ,a!EXAMPLE_DOCUMENT_IMAGE(), fv!row['recordType!AX Vehicle.fields.image']) Hello AppiansI am new to Appian and following the Appian developer learning path I faced an error in "write a maintenance record" of the process model, tried to solve it but in the end, I deleted the project and started a new one and now I am facing this error "Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 51]: Invalid Content ID" this error shows up once I add a new Document Image column in the list of the vehicle record type and for some reason, the Acme Auto Solution Application already built has the same error So I guess the problem is not from the expression or the record
Hello everyone I have a requirement to remove the decimal point in the value. For example 15.50 into 1550. Is it possible?
Having an issue while creating a Robot for windows, what will be the JRE Path (%JAVA_HOME%).
Hi All, I am getting this error while adding new column record the table. #1452 - Cannot add or update a child row: a foreign key constraint fails (`Appian`.`ISR_j_Product_TherapeuticArea`, CONSTRAINT `j_taProduct_fk` FOREIGN KEY (`therapeuticAreaId`) REFERENCES `ISR_TherapeuticArea` (`therapeuticAreaId`) ON DELETE NO ACTION ON UPDATE NO ) Could you please let me know how can we resolve this,
Hi all, I'm trying to see what is the best way to check if a record already exists in the DB, specifically in a relationship table. I have 3 tables: manager, employess, managers_employess_relationship each manager can have multiple employees. Manager table : ID Name 1 Juan Employees Table ID Name 4 Liza 5 Emily managers_employess_relationship table ( has the foreign keys from both tables) ID Manager_Id Employee_Id 1 1 4 2 1 5 when a manager is adding its employees in a form what is the best way to check if its adding an already assigned employee, for example if manager juan tried to add Liza again, I want to make sure it gives him some type of validation saying that liza is already assigned to hi
Hello. I built some process flow logic that's checks if a value isn't null and then performs an action. The value is for a property of a CDT processVariable: Ex: if( a!isNotNullOrEmpty(pv!requestItem.field), do something, do nothing) I came across an issue where the flow was performing the action when the value is null (value is verified) I'm debugging in an expression rule and can replicate the issue when the query returns a Dictionary list, and I get the intended behavior when using data[1]. The issue makes sense here since the null checks were originally against the list. However, the process variable isn't a list, its a single entity ("Multiple? is No and verified). So I'm not sure why the behavior is happening. Has anyone experienced this and found a solution?
Hi Readers, I have two tables Table-A with columns:- ID_A, Job_Role, Company_NameTable-B with columns:- Member_ID, Name, PhoneNumber, ID_A which are related as one to many relations I have created record type for different these tables and added relation ships in the record type as well, Would like to know can we consolidate them as below requirement rows which i want to display are Member_ID Job_Role Company_Name Name Phone_Number 1 DBA ABC.ltd SSR 1234567890 2 DBA ABC.ltd RC 0987654321 3 SysAdmin ABC.ltd NTR 6789054321 4 SysAdmin ABC.ltd RRR 1234567098 5 HR ABC.ltd MB 0984562348 Below are the tables structure Table-A is as below ID_A(PK) Job_Role Company_Name 1 DBA ABC.ltd 2 SysAdmin ABC.ltd 3 HR ABC.ltd Table - B is as below Member_ID Name Phone_Number ID_A(FK) 1 SSR 1234567890 1 2 RC 0987654321 1 3 NTR 6789054321 2 4 RRR 1234567098 2 5 MB 0984562348 3
Hi, I am receiving date in the format like : 25SEP I want to format it in this format : 25th September Is there a way to do it ?
In the Appian Designer, we can see the NEW tab which shows all the design objects like process model, record type, Data type, interface, etc. Can we customize that view i.e. can we restrict the limited objects to a specific group of users? Please let me know that will be most helpful.
can we calculate batchsize based on datalength(Bytes) from table and amount of data we retrive from Appian query ? because i have a requirement to send data from multiple tables to API Ex: For one table i have table with 235417 of data in that and datalength is (18366464 Bytes) . As we know we can retrieve only 1MB(1000000Bytes) of data at a time from query entity , So i am expecting my batch size should be dynamically decided based on datalength(18366464) and amount of data retrived at a time (1000000bytes) to send whole data in chunks . If i give hardcore value as 10k or 5k this may again cause issue for some other table with large data or large column . So my thought is it's better to decide batchsize dynamically based on tablelength
Anyone know how can I change from this format: "mm/dd/yyyy h:m PM" to this format: "dd/mm/yyyy h:m PM". I only want to switch the order for the day and month. I have tried the following expression, however this way it doesn´t show PM/AM. a!gridColumn( label: "Fecha Recepción", sortField: 'recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion', value: if( isnull( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'] ), fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], datetext( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], "dd/mm/yyyy hh:mm" ) ), align:
Hi! I´m using an enviroment from a partner to practise. When I want to start with the exercise of chapter "Design appian Records, part 1" ask me to look for "AS_Vehicle" in the application (topic 4). I don´t know why in my environment I don´t have it. Could you tell me how fix this? or can I import this from some place? Thanks!
Hi, is there an easy way to know how many times and where a component (for example a!hierarchyBrowserFieldTree) was used in an Application? Many Thanks
load( local!crAppComments_cdt: rule!CR_APP_QE_getCoventsAndConditionsCommentsBasedOnFilters( requestId_int: ri!requestId_int, cif_int: ri!cif_int, sourceName_txt: ri!sourceName_txt ), { a!boxLayout( label: ri!sourceName_txt & " " & cons!CR_APP_LAB_COLLATERAL_COMMENT[1], isInitiallyCollapsed: true(), isCollapsible: true(), contents: { a!sideBySideLayout( showWhen: not( contains( ri!buttonAction_txt, cons!CR_APP_TXT_READ_ONLY ) ), items: { a!sideBySideItem( width: "10X", item: a!richTextDisplayField( align: "RIGHT", value: a!richTextIcon( linkStyle: "STANDALONE", icon: cons!CR_APP_TXT_ACTION_ICONS[2], color: "ACCENT", size: "MEDIUM", caption: "Edit", link: a!dynamicLink(
hello, im trying to implement a rule that takes as an input (number:decimale) and return and italian readout of that number for example(21762161120,58)the result will be this way (ventunomiliardisettecentosessantaduemilionicentosessantunomilacentoventi/58)
I have the following error, I am trying to display a card info on vehicles. Expression rule works properly. Please help me on how to understand this error. Thank you.
<html> <head> <title>Appian Embedded Interfaces</title> <script src="">example.appiancloud.com/.../embeddedBootstrap.nocache.js" id="appianEmbedded"></script> </head> <body> <h1>Appian Embedded Interfaces</h1> <appian-action processModelUuid="example uuid" ></appian-action> In the above code I replaced src and Uuid with my cloud server url and uuid of my process model I have followed the embedded interface document provided by appian to configure this. i have also added cors in admin console as chrome.google.com ERRORS : 1."from origin 'null' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource." 2."Failed to query server. Status Code: 0"
Hi all I need one suggestion please let me know if anyone have an idea Question: I had data in array ex: a!map{ (id:1,idTwo:1,value:text), (id:1,idTwo:2,value:exam), (id:1,idTwo:1,value:yes) }, I need to combine the value when id and idTwo are same Expected Output: { (id:1,idTwo:1,value:textyes), (id:1,idTwo:2,value:exam) } Thanks In Advance
I am getting this error while debugging PM How to resolve this ? 2019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/2023
I am querying data and getting all the desired data from DB. And Ids are one of them.Now I need to move these data from expression rule to process model after doing required changes in the rule. These Ids are like {123456, 345789, 567890, 120078}. I stored them in map like map(id: {123456, 345789, 567890,120078}). But when I am trying to extract these Ids from the map using indexing and use with a process varible, which is an integer type with multiple checked, to store data, it is storing like {123,456; 345,789; 567,890; 120,078}. Kindly help me to get my Ids as they are without these unnecessary commas
Hi does anyone know how can we perform AnalyzeId operation in appian using textract connected system? I cannot see this operation while configuring integration
I am getting error like Premature End of file while generating Pdf how can i resolve this ? a!localVariables( local!voucherDetails: if( a!isNullOrEmpty(ri!batchNum), null, rule!GAI_getVoucherDetails(batchNum: ri!batchNum).data ), local!batchDetails: if( a!isNullOrEmpty(ri!batchNum), null, rule!GAI_getBatchDetail(batchNumber: ri!batchNum).data ), local!date: today(), local!xmlData: if( a!isNullOrEmpty(ri!batchNum), null, concat( "", "", ri!batchNum, "", "", local!date, "", "", index(local!voucherDetails, "description", {}), "", "", index(local!voucherDetails, "claimname", {}), "", "", index(local!voucherDetails, "fundsource", {}), "", "", index(local!voucherDetails, "fundamt", {}), "", "", index(local!voucherDetails, "invoicedate", {}), "", "", index( local!voucherDetails, "invoicen
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
