Form A change updates Form B field
Hi there, I don't have any experience with coding and I couldn't figure it out. So... I have a form called Materials_Catalogue which contains Description and Unit_Cost. The second form (Resource_Costings) contains Resource, lookup field to Materials_Catalogue pulling Description and Unit_Cost, Quantity and Materials_Cost (Unit Cost x Quantity executed on User Input) I need Materials_Cost in Resource_Costings to auto update itself when Unit_Cost in Materials_Catalogue is updated. To simplify, when
Zoho Creator: forms with decimal/currency fields: need "thousands" separator recognized
When I try to fill out a currency or decimal field on a form, if I fill in "5,950.30" it's an error. When I do "5950.30" it's accepted. I think your forms need to be intelligent enough to recognize that the "," is a thousands separator.
Alert on "On update"
Hi Zoho, I have a form that is being update every week. In the form the user enters a list of approved agents, and than in a subform lists the valuations he got from them. On input, the list the user entered is translated to a drop-down menu of all the approved agents from the user to choose from. But when the user is updating the list - I need to have an alert if an entry in the subform is from an agent that is no longer approved. Trying to script the following on the list entry field "On Update":
Trying to add record using REST API, but file gets downloaded
HI All, I'm having a bit of an issue, I have just started developing a portal and would like to add records, as I'm still testing the API I wanted to make sure that I can send and receive information, as most of the work will mean that information is recorded more than read I started trying the add record part of the REST API, but whenever I try it just downloads an xml or json file, with correct information, bit nothings updated in Zoho Creator. If anyones run into this before please let me know.
Total Multiple Subforms
Hi, I have a form with multiple subforms. Each subform has a field named Score. How can I get a total for all of these Score fields? Many thanks Antony
Conditional If Statement handling "null"
Hi, If I try to use a conditional if statement it will not let me use "null", like: input.Date_Field = if(input.Other_Date_Field != null, input.Other_Date_Field.addday(2),null); I get "Both the argument should be same type for 'IF' task. Expecting 'IF' expression found 'TIMESTAMP' expression" But I can write a normal if statement like: if input.Other_Date_Field != null { input.Date_Field = input.Other_Date_Field.addday(2); } else { input.Date_Field = null; } Please allow for "null" in
Custom field validation
Hi, Is there a way to implement custom validation, for example using a regex? I have a field which I want to restrict input to the following format [0-9][0-9]:[0-9][0-9]-[0-9][0-9]:[0-9][0-9] The users are being prompted to enter opening hours for their businesses in the format HH:mm-HH:mm. Thanks in advance!
Record Summary Template Format
Hi, I'm looking for some help in formatting a Record summary template to look similarity to the example on the following link. I would like to produce a simple invoice with two items based on a small data set. I'm not able to get the correct marine size and table to line up correctly. I've tried using a tow column and a single column layout but I stlll can't get the right look in feel to the invoice. https://www.zoho.com/creator/help/views/record-summary.html Thank you for any help.
Custom Filter Ignored In Report
I have a simple report that I'm trying to get to report (and summarize) only records where a number field <> 0 by creating a "Custom Filter". It seems from all the different things I've tried, ZoHo report generator wants to ignore the Custom Filter. It does also utilize an "Auto Filter" to select a month/yr at run time, and this aspect works, but it's still listing records that should not be included according to the Custom Filter that is saved with the report. I feel I must be missing something
Using different From when sending an email
How can I send an email to someone using a different email address than my zoho.adminuserid Thanks
Merge two applications
I have two creator applications that i would simply like to merge or combine into just one application - ie. can this be done? i was hoping you could just export one and then import into the preferred application but i can't see how to achieve this. thanks Tony
No template option in schedule.
Hi, I have a schedule that sends an email to all empleoyees. Normally in the send mail interface, in the attachment section there are 4 types, view, report, file and template, but, when I try to do it in the schedule, What to do section, there are only two, view and report. is it possible to send a template in this case, when one send mails with schedules?
marking fields in a form
Hi Zoho, I have a form that two users need to fill together. Each user has his own fields, but can fill in the other user's fields too. I give both users the link to the form - but I need to mark the fields in some way, so each user will know what fields are on his responsibility (to be filled or to be checked, if the other user filled them). How can I do this? any way to format the field's title? Thanks Ravid
Lookup using Fetch
Hi, I'mm trying to get a lookup field to populate a field from another form but I can't seen to get it to work... even after looking at your examples. This is the Members form and the field I need on the other form is Starting Weight (st & lbs). This is the Class Register form and I need the field Starting Weight (st & lbs) automatically populated when I select a member from the Members form using a lookup field. Any help would be greatly appreciated. Many Thanks Ian
Running Totals: Help
Hi, I'm struggling to get something to work: I have a report in Zoho Creator with the following Columns: Property Date Category Credit Debit Delta The first five columns are from data entered into the DB, the sixth column, "Delta" is from an aggregate formula where I effectively minus Debit from Credit: sum("Autoview_1445830633762_Morse_General_Ledger Table"."Debit")-Sum("Autoview_1445830633762_Morse_General_Ledger Table"."Credit") What I want is for the Balance Column
Google Translate API
Hi, I am writing a HTTP Get request to Google Translate API. The URL request follows the Google conventions and the answer from Google comes through JSON format. https://cloud.google.com/translate/v2/translating-text-with-rest void Google.Translate() { //transRes = getUrl("https://www.googleapis.com/language/translate/v2?key=AIzaSyBjYIY5pf9uyTDZq1jjB6FWdsb8bKyByOo &target=PT&source=EN&q=test translation"); transRes = getUrl("https://www.googleapis.com/language/translate/v2?q=This is a test for zoho&target=PT&source=EN&fields=translations%2FtranslatedText&key={API
Copy real image from image link
I have images stored in another application and use the link in an image field. Is there a way to use the link to copy the actual image and store it someplace in creator? The client would feel safer if the image is stored in two places.
Using filter in sub forms
We've extensively used a filter in the main form but when using the same filter in the sub form Creator states variable not defined. The filter we use is Site.ID equals "input.intake_form_2_question_01" which is a field in the main form.
Bug in subforms?
Hi Zoho, When I enter a form with subofroms, the "x" to delete a row is in a separate line than the line its reffering to, and is noe showing correctly - I'm attaching a photo. This wasn't here a week ago.... Please fix this Thanks Ravid
Set Lookup Values "==" some value via deluge script
Application: buscar Form: Colonia View: Colonia Form: Delegacion View: Delegacion Form Colonia holds 2005 Colonias for Mexico City, Only. Colonia in Mexico is like counties, in USA. Delegacion in Mexico is like cities, in USA. I am dinamically populating Colonia Field, every time I choose an option from Delegacion Field. IT WORKS FINE. I have a new need. I am a non-profit, I have 2500 properties, from 80 real estate companies. I made a zoho app, where they typed the Colonias names, so some of them
Wondering About Possibilities (No Programming Experience)
Hello, So I've been watching some tutorials and learned that the first step is to determine requirements. I have completed this step thoroughly and was wondering if what I'd like to accomplish is possible. I have no experience programming but I am willing to invest the time to learn what's required. 1. Can a form exist with a button called "Create Work Order" where if clicked, a PDF is created consisting of only certain fields? I'd like to the PDF to be formatted via HTML/CSS so it has the information
FORMDATA field for Custom Action
When developing a custom action like sending an email message for each row in a report, the Custom Action can't use the field FORMDATA which will include all fields in the form. please upgrade to have this feature included in your next release. Thanks.
twitter link from zoho creator report
Hi, I want to use a database to schedule my future tweets. The idea is to make tweet as a string to add to the following link http://twitter.com/home/?status= my first tweet URL will lead me to a separate window to tweet (click) Somehow function keep shorten OpenURL "http://twitter.com/home/?status=" line into "http://twitter.com/home?" any idea how i can tackle this? thanks Halit
Maximum published components limit?
I have been testing publishing databases and just received this message: Maximum number of components allowed to publish for your account has been exceeded. Although I have generated several test databases and published them, I have deleted all but one of them at the moment, and it is the only published component. As far as I can tell this means that I currently have just one published component. Is there something I am missing? Do I need to de-authorize or unselect published components somewhere?
Dropdown list based on day of week?
I am developing a class sign-in app, and would like to make a drop-down field showing classes available, which changes based on the day of week. Has anyone done anything similar? What is the best method to accomplish this?
Submit form data to google spreasheet
Is it possible to for a zoho creator form to submit information directly to a google spreadsheet?
ZC_Subject & ZC_Content but is there a way to capture FROM or TO or CC?
Hi there, I am using a form with the ZC_Subject & ZC_Content to capture the subject and body of the email. is there a way to capture any other parts of the email? Like TO or FROM, or better yet a unique header id? Thanks, David
Variable Not Defined
I copied the code exactly as it was stated in your help link: https://www.zoho.com/creator/help/script/fetch-records.html#Fetch_Related I updated it for the forms and fields in my application and I'm getting a Variable not defined error. What am I doing wrong if (Wanderist_Details[ID == input.Name].count() > 0) { x = Wanderist_Details [ID == input.Name]; //input. refers to fields in current form input.Wanderist_Number = x.Wanderist_Number; input.Passport_Issued_by_US = x.Passport_Issued_by_US;
Auto apply a formula to a table
Is it possible to bulk edit a table using a formula? The following formula is currently in the form actions on user input: if (input.devices_room != null) { roomid = Locations[ID = input.devices_room].locations_room_ref; input.device_ash_code = roomid + "/"; } I want to amend the bulk edit existing records and then delete the bulk edit formula rather than go in and edit each record
Retrieving screen width
Hi Zoho, I need to retrieve the user's screen width for my html page. jQuery solution did not work (not supported?) how can I get it? any Zoho internal script? Thanks Ravid
Problem with the function for each
I have this code and I need you "for each i in input.R" run Only with Certain records, but when i keep the record is saved as "R" is not input. Then when i select That box Belonging to a subform, I changed all the fields INSTEAD OF only of the subform Those That are inside. (Including the data That Already Been HAD registered Earlier) I have the same code and another field and in this if the input is saved. I do not get it. if (input.Clientes1 != null) { if (input.Correo_Electronico != null)
Zohologinuserid
I have a form "Employee" that contains their email and name. I have another form Test with the employees name field as lookup. (incase it does not fill in log on). I am trying to get that field (Test/Employee_Name) to auto populate when the user logs in. I am thinging I am going at it incorrectly, meaning Fetching email record from "Employee/CO_Email" and comparing it to the logonuserid. Then trying to input the logonuser name in the employee field of the test form; I wish I could also code it to
Record summary templates
It would be nice if we had the ability to save a record summary template and reuse it across the platform. Of course the fields will change in each form, but the general design and layout can save lots of time. Currently within one form you can copy templates, but what I'm suggesting is universal template design that can be used for any form. Maybe there is a possibility of doing this in Zoho to which I'm not aware?
Adding an edit button to a record summary
As the title suggests, I would like to add an 'edit' button to a record summary that would immediately put me in the edit page for that record, without having to close the record summary and find the record via the list view. Can this be done?
developing a timesheet application
I looking at creating a timesheet application for my business, i need to be able to record hours each day and then get the timesheet to add up the hours and days for the week. Then against days when people are sick or on training i want to record a code against that day, i also then want to print the timesheet out for signature by the client i need the timesheet to calculate the hours and days, for example hours less than 4 equal 1/2 a day and then over 4 equal 1 day Any helps would be greatly received
Mobile App IOS
Any trick to limit individual field width in a report when viewed on an Ipad,
Not Receiving Emails From Zoho (Invites, Password Resets etc.)
Hi We are not able to receive any Zoho originated emails to our ourdomain.com mailboxes. We have contacted our mail providers and they are not receiving any connection attempts from transmail.net hosts. Could you please trace the outgoing emails and check if there are any bounce-backs (Non Delivery Reports) coming back to Zoho. We are sending from accounts@ourdomain.com and have sent a few tests in the form of user invites and password resets. The emails were destined for tba@ourdomain.com and tba2@ourdomain.com.
Dynamic picklist works incorrectly for Multi-Select Field
The following is deluge script returns a list that is set as the picklist for field, My_Field_A: Dynamic_Choice_List = ( My_Lookup_Form [ My_Lookup_Field_1 == "ABC" ].My_Lookup_Field_2).getall() ; My_Field_A:ui.add ( Dynamic_Choice_List ) ; If My_Field_A is a Multi Select field then the value selected from the picklist is added to My_Field_A's Choices list in the Form Builder. This is WRONG. If My_Field_A is a Drop Down field then no value is added to the My_Field_A's Choices list in the Form Builder.
Pre-populating data to a form
I am building a data collection application and I have two forms, populate_data and abstraction. I have imported data to the populate_data form and have a unique column of data called form_number. On my abstraction form, I would like to create a lookup field on the form_number column of data in the populate_data form so that certain data fields in the same row as the form_number I select in the lookup field from the populate_data file will populate to respective fields on my abstraction form. I
Disabling a column in BulkEdit
I want to disable only 1 column from the list of BulkEdit. Perhaps it's a very simple to do but I don't find how! Is it possible to do? If yes, How can I do it?
Next Page