Find any gaps in dates across 3 years
I'm building an application form for new employees, and I'd like them to input their previous employers and dates over the last 3 years. What would be the easiest way to validate that every day over the last 3 years is accounted for, and that there are no gaps of over 30 days? I imagine this can get cumbersome so if anyone's got any tips, I'm all ears. Thanks! Brian
add record with if then else
when updating data at form 1, a new record is created at form 2 some fields are directly transfered from form 1 to form 2 this is acomplished with "add record". but form 2 has a field "A" wich value depends on the value of field "B" at form 1. That value has only two possibilities and should be obtained by a "if then else" with the value of field "B" of form 1. how can this "if then else" work inside "add record"?
Open Report with cirteria for subform data
Hi, I have a report based on a form with 2 subforms. I trying to open the report with an url passing as criteria an ID of a subform record. The main form is called Kursanmeldung, the subform Kursplanung. I have tried following variants without success: openUrl("#View:Kursanmeldung_Report?Kursplanung.="+KursID, "open window"); openUrl("#View:Kursanmeldung_Report?Kursplanung.ID="+KursID, "open window"); openUrl("#View:Kursanmeldung_Report?Kursanmeldung.Kursplanung.ID="+KursID, "open window"); when
Create a report with form and sub form fields.
I need to generate a report with fields from form and its sub form. Use Case: I have a form 'Invoice' with invoice #, invoice date and customer. I have a sub form 'Products' with product, quantity and rate. I would like to show a report in this format. Invoice # Date Customer Product Quantity Rate 2 6/16/2017 Customer A Item A 1 12 2 6/16/2017 Customer A Item B 2 10 3
How to create a filter with stored dates
Hello, I have a Date field in my form with the name TransferDate. I would like to create a filter so I have enabled it from the 'Auto Filters' menu. The filter is working like the below image. It shows me 'month - year'. Is it possible to customize this filter to show me all the dates which are stored in the database? I mean the filter to be like: TransferDate: 10-05-2017 28-06-2017 20-07-2017 . . . and when I click the '28-06-2017' then to return me all the records with this TransferDate? Maybe
Group records
Hi guys, Is it possible to group records into one record? So lets say: Department : security / name: Me Department : security / name: you Is it possible to group them on department? so the report looks like this: Department : security , and if i click on it i will see, Name: me Name; you Maybe like a dropdown?
Auto fill field in subform from parent form field
I have a form called "Bed-Tillage" with a lookup field called Section_Setup This form has a subform called "Bed_Selection" with a lookup field called Section What I want to happen: as records are added to the subform "Bed_Selection" I wold like the field Section to be auto filled by the parent form field Section_Setup I tried this in the on load of the subform input.Section = input.Bed_Tillage.Section_Setup; but it creates this error - Error at line number : 1 'Bed_Tillage' is a lookup field
Edit CRM pick list menus
Is it possible to add to an existing pick list menu via Deluge?
Form Layout - Sections/ Horizontal space
Hi, I am trying to improve the layout/alignment of fields on my form and can not see how. Fields just automatically fill down from the top which I guess is OK when using single column but with double column related fields don't always line up. For example if I add a comment field Is it possible to add horizontal padding between fields? (I thought about adding some extra fields and then hiding them but they are still visible to me as an admin)
quickbooks connector
I have written a function to push new customer data to qb using the sample script that zoho gives. the issue is I get a success message upon execution... but it also gives me the following response: Executed Successfully Log messages: java.lang.Object@39c90431 the code: void qbooks.newCustomer(string customer_r_ID) { for each rec in Customers[ID == customer_r_ID.toLong()] { //Declare Map Variable to hold the customer details Customer_Details = Map(); //Add the customer details to the map variable
Help with custom Function
Hi zoho community, I am trying to create a custom function, but with no success so far. I would like the function to add elements to the inventory (stock) and update the status of the element too, having a button for each element row in the report (currently I am trying to use it in the Purchase order form report, but I also would like to have something similar in the purchase detail report). the related forms and reports are the following. Add product form: this form report = inventory product code
Multiselect based off another multiselect
I have a list of contractors, each of which has multiple employees. I also have projects assigned to the contractors, some projects have more than one contractor -- what I am hoping to accomplish is selecting multiple different contractors from a lookup in the project form, then filter another lookup of the contractor employees, based on the contractors selected. Is this possible? Or is there a better way to accomplish this goal? Thanks, Chris
Name field type causes unsupported type of form error
When I add a name field (the field with a built in first and last name field) to a form and then view the form I get the following message: Unsupported type of form. Please contact your application owner. Removing the Name field causes the form to load correctly again. Am I missing something?
Call function in page
Hello, I have a created a Page to print a letter an wanted to get the name of the person signing the letter. For this I call a function that I have previousl defined under Workflow. When I print the letter, the function returns no result. What am I doing wrong? here's en extract of the code in the page: <p>Unser Kursraum an der Chutzenstrasse in Bern ist zentral gelegen und vom Hauptbahnhof Bern mit den öffentlichen Verkehrsmitteln innerhalb von 10 Minuten erreichbar.</p> <p>Gerne bieten wir
Open Url - html page - hide headers
I have a html page to print invoice. I open this page using OpenURL through custom functions. When the page is open, it displays with application header and footer. openUrl("https://creator.zoho.com" + zoho.appuri + "#View:Generate_Invoice?invoiceId=" + invoice.ID + "&zc_Header=false", "Popup window"); I would like to see only the html page content without header and footer. Is this possible?
signatures
Hi guys! I have 2 signature fields and i have written on a Windows Microsoft surface pro. But when i go to my reports i don't see the signatures. But if i put write on a laptop or iOS device it works perfect? Can i get this checked please? Kind regards *** THE TEST WAS DONE ON A LAPTOP
'on user input' action not using updated field value
I have a form action which update three fields A, B and C; when C is updated it triggers its 'on user input' action and calculates a number based on A and B values, but C is actually using A and B old values, not the updated values. Need help!!
Copying data between entries
Hi Zoho, I'd like to give my users an option to copy data from similar entries on the same form. I've created an "Import request" form, where they choose the entry to copy the data from. I will appreciate help in planning the best way to do this. so far, since there is no "copy entry" command in deluge, only add or update, the script is fetching the desired entry to copy from, and one-by-one update the fields in the user's entry (meaning many many lines of Entry_to_Update.Field_Name = Import_From_Entry.Field_Name ; with
Fill field from other form
Hello, I have this situation on one of my application: Form 1 (Opportunity - see pic1) is for manage the IT opportunities we have; here we have a field "opp_id" which is a numeric field we use to autogenerate the opportunity number; we have other fields like Country(Pais), Prime contractor, etc. Form 2 (Proyectos - see pic2) this form is for manage all the projects once an opportunity is won. The fill-in is based the lookup field "Nro. de Oportunidad" on this form which list all the opportunities
How do you edit the parameters passed via a custom action?
when building a custom action, I built a function via the 'wizard' to pass 3 parameters. I need to change the type of the Argument from Int to String and it wont let me edit the types. I want to change the sub-rev type below. You cant change it by clicking edit, How do you do this?
sendmail - sending multiple attachments
Hi all, I am not receiving the data when I script to send multiple pdfs in sendmail attachments. see below. Also, how do I include multiple attachments in the Templates. When I include field; the result is the file name --- not the actual file attachment. Any suggestions? mail [ from:zoho.adminuserid to:receiver@mail.com subject:"subject - " + input.Client_File message:"<div style=\"text-align: left;\"><br></div>" content type:HTML attachments :template:First_Document as Inline, template:Second_Document
Problem calculating currency value
Hi all, I know it is a quite stupid question but I can't find any solution even if I tried everything! I have a form which represents an order. This has some records stored in another form. Each of these records has a quantity (decimal) field and a cost (currency type). I need to update the total of the order. ... total = 0.00; for each p in products { total = total + (p.cost * p.totalQty); ... } ... order = frmOrder [ID == orderID]; order.total = total; Instead having the cost multiplied
Help with a Deluge Script
Hi All, I have a group of members that are all paid clients of Zoho. We have a form that we use to enter data regarding the programs of real estate lenders. I want to publish that form to enable the lenders (non-members) to add data on their own. However, I want to exclude certain fields from the view of the lenders. Zoho support suggested that I use the following script" if(zoho.loginuserid==null||zoho.loginuserid=="") I am not experienced in writing scripts and I cannot figure out how to
Integrate Creator into Reports problems
Hello, I would like to create more complex reports in Zoho creator. But the option Query is not available in Creator, only in Reports. So I investigated and found option to integrate Creator and Reports. It goes that you have to Publish the report in Creator and then with that URL you can set a Scheduled import in Reports and then based on that create more complex Queries. OK, although not simplest option, I would prefer that Query option is in Creator (why is it not??!). But it works, big problem
Webhook POST from external service?
I have the requirement to integrate with multiple external services. It seems reasonable to have the ability to accept and manipulate a JSON or XML payload in the body of the webhook HTTP request, however, it seems that this capability doesn't exist in Creator. I've scoured the help facility as well as these forums for a definitive guide and have found nothing. I have contacted live chat support as well. They keep pointing me to the Creator API documentation which assumes that I can configure the
Accepting Raw Body POST
Using "Pages" how to accept POST from other services in Raw Body? Thanks, Damien Cregan Hire an Expert
Block edit
In my inventory management, I have a subform for inventory activity (added to stock and removed from stock) I have a number of examples of how to update the parent record but I'm still really shaky on how to do it. For the time being, I'll figure that out, but once the main record is updated (quantity on hand is correct) I need to prevent the record from the subform from being called back and edited. (I need to keep the records for tracking the traffic on a given item). How can I do that? Is there
New Schedule - Add Record
We have a Sales form with our sales records. And we have a Tasks form with things we must do. Tasks -Description -Date -Sales (lookup filed linked to Sales form) -Owner -Status After I add a record to Sales, I want to automatically add a new record to Tasks. I am using the Workflow Schedules feature to try to accomplish this. Everything is working except I can't figure out how to populate the Tasks.Sales field value so that the new Tasks record is linked to the Sales record. insert into Tasks [ Added_User
Access Admin Only Form Fields
Hello, I want to know that is there any way to access form fields using REST API which are labeled as Admin Only in permission section?
reports - Aggregate Formula - countif
I am creating a report and want it to count based on there being nothing and im using the following script: countif("Autoview_1496775088044_Row_Subform Table"."Scion"='') it always returns 0, am I using the right operator of ='' ? When I do the inverse !='' it works perfectly and counts only the cells with data.
Layout app on Windows platform
Hi guys, Is there something wrong with Zoho Creator app on Windows devices? The headlines "Prijzen and Opgehaald" schouldbe "Bedrijven and Maatkleding"
How to fetch a String (instead of ID) of Longlist in Page?
Please see the attached images below. How do I change the Suppliers ID into String? and Is there any way to limit the number of row displayed? Current settings: Add_New_Product - Product - Suppliers [Lookup - Longlist - One Product to Many Suppliers] - Quantity - etc.. Suppliers - Supplier_Name [String] I have tried adding s.Supplier_Name but got "Invalid collection object found" error. <tbody> <tr> <td colspan="5"
Record Summary
Hi all, I have 3 reports of 1 form: Report1 = All Report2 = criteria "Paid" Report3 = Criteria "Not Paid" Can i add the traditional "Paid" on report2 on record summary, maybe with a picture? or even a script? like this?
How to get CRM custom fields into creator?
Hi I am using "zoho.crm.getRecordById", "zoho.crm.searchRecords" and "zoho.crm.searchRecordsByPDC" in Zoho Creator to access crm entries in "Contacts". This works fine and gives me the standard response incl. contactid, Last Name, date-modified etc.. However I cannot extract my custom fields, which i have added in my custom crm layout. Can i change the standard response from crm? How can i access my custom crm fields in Creator? thanks in advance Andy
button to launch another page (newbe question)
In my service order form, I have a field for the customer work order number. field action is configured to create a link to the customer's web site which will display the current work order (murl = "first part of url" + input.ticket_number) This produces a string which is the url to the desired web page. Next, I need a button or a clickable link to access that web page in either a new window, new tab, or popup window. I've tried to create the code for a button, but I just can't seem to make it work.
image display in page
Hi, I am building an app which records the travel expenses of users . Now along with the details the users upload recipts in jpg /pdf format. I have built a page which has embedded the report of expenses filed. My next step in the process would be to display all the recipts one below the other . I want to know is there a way to accomplish this.I have created a sample doc with one receipt which I am attaching for your reference. presently I have attached only one recipt. Like this multiple receipts
Please help. I am trying to remove 00:00:00.0 from datetime field formula
This is the expression that I am using at the moment: input.Customer_approval_date.addBusinessDay(15) This is the result I get: 2017-06-21 16:00:00.0 But I don't want the time to appear. Please help :) If the suggestion is string to remove the time, please let me know where I enter the string formula as I have seen this suggested elsewhere but don't know where to enter the code. Thank you for your help :)
Update records within Subform
Hi Zoho, I want to populate Subform field with multiple rows from Main form field update. Main form is Customers. The field for updating is Customer_Company. I have add Field Actions in Subform On Add Row to populate the same field in Subform. So every time add new row in Subform automatically copy the value of Customer_Company to same field in Subform. What I want to ask is, when I update the Company field in Main form, I want all the field in every row in Subform also changed. Please help. Thank
Zoho creator user account create and login.
Hi, I need a order management app.Where customer can create an account. If admin approve customer account then customer get login this account. It is possible?
Problem with OnAdd-OnSuccess workflow
Dear Team, I'm developing an application to generate Quotation ID. First thing, the Auto Number does not accepting prefix zero (Ex.001). So I was surfing the blog and found below post. https://help.zoho.com/portal/en/community/topic/auto-generated-number-field-with-prefix I have added the code in the OnAdd-OnSuccess Form Action, but when saving the entry, the code is not generated. I've tried the same logic with a formula field, and it works, but could not use one formula field in another formula
Next Page