Has anyone had any experience working with Creator and a domain registry API?
I have a custom module in our CRM for Domain management, I would now like to be able to dynamically keep these domain records expiration date accurate for each domain to be automatically checked for the expiration date and then update the records with the most current expiration date. Thomas
Validate Unique Form
I have a form which (Ppl-Sponsors - in the ERD below) and I need to validate it so that it is a unique entry. Not allowed: Same Person & Same Company & Different Sponsorship Same Person & Different Company & Same Sponsorship Same Person & Same Company & Same Sponsorship Same Person & More than 3 different sponsorships Same Person with no Main Sponsor Any thoughts? Thanks in advance Pete
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
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!
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
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
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
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.
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
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
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
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?
Mobile App IOS
Any trick to limit individual field width in a report when viewed on an Ipad,
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
Auto populate
I want to concatenate two fields into a third with a separator of "-" Field 1 - wiring_from_device (Look up field) Field 2 - wiring_to_device (Look up field) Field 3 - wiring_label (Single Line) Seems easy but struggling.
Extremely long latency time
Hi Zoho, When I open a new page in Zoho its takes VERY long time to load (about 30 seconds!). This won't happen when I open the same link as a popup. Why is that? How can this be fixed? This also affects the time is takes the system to save changes in script. Thanks Ravid
Record Summary not displaying linked filtered view
I have a form "Strategies" with a bi-directional lookup to "Programs". In the 'Column Properties' of the 'Strategies' report, I include the linked field to 'Programs' and selected the view 'Programs-Active', which is a filtered view (Active = 'Yes') since I only want to see the currently active Programs for each strategy: The filtered view on its own works fine. However when I look at a Strategies record summary (default or my custom summary), I see all the Programs that were ever selected, not
Transfer all fields from sub-form into parent form
Hello, I created a form with inputfields which I embedded as subform but I'm not happy with the current layout. I want to just "drag and drop" all the inputfields from the sub-form directly into the parent-form without recreating every singe field there. Is there a way to do so? Thank you in advance.
URL for universal search?
In a Deluge script, I'd like to fire off a search (using the master search at the top of the page) and pass it specific criteria. My hope was to add a custom action, to be shown in the menu for all rows on the report, so that selecting it will fire off the search and then let Zoho display the results as if someone had typed them at the top and hit enter. I know about the openURL() function. I just don't know what URL to pass it, and how to pass in the search criteria. Thanks! Bruce
Import data to form and subform
Hi Zoho, I have a form with multiple subforms. I need to be able to import data to the form including the subforms data. I've added a bi-directional lookup to the ID fields, so I can add the subform's fields to the main form report -but: 1. When exporting the main form report, and trying to import data based on the template - I get an error, the subfrom fields are not recognized by the Zoho system and in the drop-down list of the field options the subforms' fields are not showing. 2. When viewing
Update all records and keep them updated
Hi, I have a schedule that is triggered when two fields are equal. One is user´s day of birth and the other one is the current date. so I did this: DOBB = DOB.toString("dd-MM"); Current_Date = zoho.currentdate.toString("dd-MM"); But, the Current_Date do not update automaticaly, I have to edit each user data in order to update it and that is no practical option. How can I update all the users data and keep them updated? Any help will be appreciated
Help with custum schedule
Hi, I want to create a custom schedule, but, I don´t know how to write in Deluge what I need the schedule to do. I need to send a daily mail to all users in a report. The mail should have de names of all the users that are having their birthdays on this day. Does anybody know how can I do this? any help or hint will be appreciated
Report based on multiple criteria
Hi, I have no idea what I am doing wrong here, as I copied coding that I had from another (similar) page, and it worked there, but not here. My form has two fields - one that is a dropdown to choose Purchaser/Assistant, and one that is a number field to enter a Product SKU. I am trying to pull all records to be shown on a report, based on what is chosen. if((input.Purchaser_Assistant != "") && (input.Product_SKU != null)) { openUrl((“https://creator.zohopublic.com/zoho_jchan5/requests-for-purchasing/view-perma/Transfer_Requests_for_Purchasing_team/CZwJ0VjVyUvUHYyaKuwEgOUCX36DmEJFnqydeKV4KS8bOnaxPpSXnGwK91eQ1jKHakX4UA3bUZQ7KFWvCdNVYqa4yTr40eeVr5Ov?Purchaser_Assistant=input.Purchaser_Assistant&Product_SKU=input.Product_SKU
Image rendering in the forms
I am creating a clinic management system. In the patient forms, I need to show several images in the forms with patients old facial pictures (before treatment) and a new facial picture (after treatment). so while filling the form the user can see the image rather than image to be viewed in a view?? is there anyway, i can achieve that??? Any help will be appriciated
File Upload Shorten Field Name
After a user submits a form that includes a file upload, is there a way to use script to turn the original file link to show as something like "Download File" in the corresponding view? For example. I would like the following to be a link that says only "Download File", instead of the original file name of the uploaded file. Thanks
Add a check mark to symbols
Dear Zoho creator< Can you add a check mark symbols to symbols, I really need it for my project check list but have no check marks to check. So can you please add a check mark, I prefer feedback today or tomorrow. Thank you,David kenneth goicuria
Is there a place to discuss Beta features of Zoho Creator?
Hello, Is there a place to discuss the beta features of Zoho Creator? Thanks.
why is the parameter "pageSize" available in Report but not available in rest api view record ？
why is the parameter of pageSize available in report but not available in rest api view record ？ Here is example: 1. the parameter "pageSize=4"below is not available. the json return contain all records. https://creator.zoho.com.cn/api/json/productv3/view/ProductLook?authtoken=****&zc_ownername=<appownername>&scope=creatorapi&raw=true&pageSize=4 2. the parameter "pageSize=4" below is available. the view will only show 4 records. https://creator.zoho.com.cn/<appownername>/productv3/#View:ProductLook?pageSize=4
Next Page