Iteration on Zoho Creator (not related to forms or fields)
Hello, I want to iterate character by character in an string. Which iteration structure (not related to fields or forms) could I use? Kind regards, Mari Plaza.
RTL in pages
Hi, I am trying to tweak CSS or Table tags in a page so as to render a table as RTL. I am using the Dashboard template for the page. Unfortunately, all my trials failed, any suggestions? Regards
Record Count for our application
Dear Sir, The following are the top most record consuming forms for our application. New order - 8150 Order Item 25903 Logistics 7704 Events 5735 Billing 8000 But our total records used was 49325, but the above alone comes to 54000. Pls let me know, what we are missing. Thanks, Anitha
Unable to update email content
Hi When I try to update the email in script builder format ...the following is shown No rows found for the table Form_To_SuperDO in this DataObject Does anyone who what the problem is? Regards Umar
Zoho Creator get records from SubForm error
Hello, I'm making an app in Zoho Creator. I have one problem with SubForms. The app is like this: I have one Main form, with SubForm in it. I have a html view where I load one record. rec = Main_Form [ID = input.ID.toLong()]; Now "rec" holds all the fields from the main form. What is the correct way to iterate though the fields in the SubForm. When I try this: subform = rec.Sub_form; I get this error: Form does not exist - ZC_SUBFORM_9 What I want to do is make a for each of the fields in the subform.
Unable to duplicate a form without data
I have a long, complex form with sub-forms. Attempts to duplicate the form according to the "How can I coppy/duplicate a Form?" knowledge base instruction lead to a "null" error (old builder or new). Suggestions? Thanks.
Fetch record using criteria based on a lookup field
I have two forms, one is report and a form called persons. Each report could be linked to more than a single person using a lookup multi-select in the form. Now I want to fetch all reports linked to a certain person provided that each person field int he report form most probably contains more than a single person (a list of persons). How to do this without iterating through the whole database of reports then iterate each list of persons?
Links
Am pretty new to this. Currently have a a jobs form and a wages form and report. The wages form has a lookup field to get the job ID from the jobs database and works fine. I want to create a link on the jobs form/report that links to the wages form and shows wages relating to that job. There maybe multiple wages relating to the one job. I currently have hard coded in a link using the Note field but want the link to populate with the job ID. I would like to do this from the jobs report and also edit
URGENT- Can't add records or upgrade subscription
Hello, I am trying to upgrade our subscription or purchase an add on pack of additional records. However once I select the option I am trying to purchase I am taken to blank page and I can't make payment. Please see the screenshot attached. Our team cannot currently add notes so this needs an urgent fix. Thank you
Connecting two forms through an alternate submit button
I have two forms that I want to "connect". For simplicity's sake, let's call them form_a and form_b. In form_a, I have a field that I want to retain in a field in form_b. Let's call these fields field_a1 and field_b1 respectively. They both contain the relevant Project ID for the same project. What I currently do is: Open form_a. Enter the Project ID into field_a1. Submit form_a. Open form_b. Paste the Project ID into field_b1. Submit form_b. However, I want to combine the steps 3, 4 and 5 into a
Zoho automatically generates single fields in on edit form action
Dear all, I have the following problem. As you can see in attached image 1 I have a form with some fields (I do not hide any field). Hotel Name and Year are two dropdown fields which fetch data from an another application. The problem is that when I click edit in the report it generates the attached image 2. As you can see there Zoho automatically generates two single fields below of Hotel Name and Year. Why this happens? Is there any way to hide these two fields because I do not need them? I wrote
Lookup field filter
Hello, I have a form called [Master Inventory] and among its fields there are a few in particular... Device ID Assigned To I have another form called [Work Order] which has a subform called [Work Order Subform]. In the subform I have a lookup field called Device ID In the subform when I click the Device ID drop down field I would like to only see Device IDs where the Assigned To equals a field in the [Work Order] parent form called "Installer". Is this possible? If so how would I do this?
Manage Users & Groups
is anyone else having trouble accessing the 2 pages for managing groups and users???
design form
i want to give background design for my form. how to do that?
move form button?
Is there a way to move an embedded form button? I need to change the styling / format of an embedded form. I am using an embed url on my webpage and need this form to be formatted slightly different. Here is the published url of my form: https://creator.zohopublic.com/precisionsailloft/prod/form-perma/Boat_Selection/Q95daGBSWbGHdWV0a7tJOZKeqOVGOY2vJmD9yMCpJkXp9Bab6RDhyGbR9nMufdHGRwmNxYmppaYEPquNpr2MOwtC915shJP62D0F Specifically what i need to do is move the Search button up to the right of the Manufacturer
Deluge Script - syntax needed for reaching to another application
In the script below, how do I indicate that the Companies form is in a different application? if (Companies[ID == input.Company_Code].count() >0) { temp = Companies [ID == input.Company_Code]; input.CoCodeFetch = temp.Code; }
Report Separator Export Broken
I am creating a report "Completed Orders" under the "Orders" view within ZoHo Creator account. When I choose to link a view, I add on the fields from that view that I want to included in the report. To the left of the newly added item, there is a blank field for the separator indicator. I fill these in with a single letter component and click save. Within Creator, the separator indicators look fine. Upon export, all the separator indicators are "Q" (which is the first separator I used on the first
Uploading to Zoho Docs from Zoho Creator application
I am working on a project management application to allow users to keep track of and collaborate on written projects with other users. To do this, I am looking for a way to automatically upload files to Zoho Docs using the file upload field in a Zoho Creator form. Is this possible?
How are child records related to parent records when using subforms?
I am new to Zoho Creator and I am having a problem understanding the link between child records and parent records when using a subform. I want to be able to initially import the child records (rather than have to enter them all in the interface) and still have them display in the subforms when editing a parent record. I can only get the ones I enter directly into Zoho to appear in the subform. I import the child records with the correct ID for the appropriate parent record and they load into the
Form Relationships
I am new to Zoho and it appears to be the perfect solution for my small business. We have a current database which we do not use the majority of the features but pay a lot of money, therefore looking for a simple cost effective solution. I have export the tables into 3 Excel documents; 1 contains company details, 1 contains the contact details and the other the machine details. I want to setup a database that contains 3 forms for each of the tables with a one to many relationship, for example 1 company
Remove all Non-alphanumeric in a String via Regular Expression
I had a need to remove all special characters in a string. Regular expressions saved the day: validation_string = string1.replaceAll("\W|_","",false); Ref: http://stackoverflow.com/questions/3114027/regex-expressions-for-all-non-alphanumeric-symbols Cheers, John Whitney
Relationship
Hi, I have created 2 forms 1 is Property Details another one is requirement details so i want to show property name in requirement details form
What does this mean and why am I getting this error?
Any help would be appreciated. I don't even know where to begin with this error on an Add Record script. See the screenshot please.
Data Type in Reports Incorrect
I have some formula fields in my table that when I try to use them in report show up as text so I only get the option to count them rather than sum, count, avg, etc. The formulas work fine and show up properly in the views, but not in the report of the view. I have made http://creator.zoho.com/kavery327/powered-parachute-log-book available to support. In the Report the field Total_Hours is numeric (or should be since it is a formula calculated from numeric data), but shows as text. Any insight would
Formula field result format not consistent
I have 3 formula fields. The formula is basically this:(((Date1 - Date2) / 86400000)).toLong() I had one field like that in my application for months. In report it is shown as number. Today I wanted to add now formula field: (((Date3 - Date2) / 86400000)).toLong() That shows up now in the report as text (the values are calculated correctly) What is misterious is that if I make another formula field (3rd) and copy the formula from the first one (((Date1 - Date2) / 86400000)).toLong() That too
Aggregate Records
I cant see the result of "Aggregate Records" on html page view I already see this link https://www.zoho.com/creator/help/script/aggregate-records.html#Sum_Function I folow the steps of the link I have a form SaidasRomaneio that have a field Valor Here is my code: htmlpage Flow_Page() displayname = "Flow Page" content <%{%> Fluxo de Caixa<%Valor = SaidasRomaneio.sum(Valor); }%> Do not show de result of "sum" on page What is wrong?
Hide fields if not equal to
Hello, The fields below are on a form and I only want three zoho IDs to see them, all other zoho IDs hide these fields. I want to hard code these zoho IDs into the script. How would I do this? Payroll Amount Deduction Total Iram
Using system variables in pivot charts
It would be useful to be able to report by system variables - like records' Added Time in pivot charts. For example, to graph how many new records are placed over time. How can I do this?
Viewing records in the parent form even if records in the sub form gets deleted
Hi, In our application, we have a parent form NewOrder, and a sub form in that parent form, order item. If i select 4 values in the order item, these 4 values are viewed as 1 field in the parent form. but if i delete the records in the sub form, the field values get deleted in the parent form. Pls advice on how to proceed with, even if i delete the records in the sub form, it should be visible in a field in the parent form. Detailed step on how to proceed is very much appreciated. Thanks, Anitha.
Sharing Data between Creator databases
Is there a way to dynamically reference data from another database within the same account?
Add Formula to Amount
Hello, this is my first post...so excuse me if I don't explain my problem good enough. I have a page where one can input an amount in a given field to a specific user. So I would type in a specific user and enter an amount that user has paid and the date the amount was paid. But on the report page, I would like to have a field that shows how much the user has paid in a specific amount of time (week, month, or year). Is this something that can be done?
help href in html Page
Hello, on one page, I should open another page passing a parameter which is not a value but is a variable, how can I do? So I'm not trying to pass as the value of zoho.loginuserid. <tr class="zc-viewrow zc-row-1"> <td><a class="zc-edit-a" href="#Form:NewAction?Account="+zoho.loginuserid> - New Action</a></td> </tr> Is it possible to do a refresh only a part of the page? Thank you in advance David
Return to Previous Form Code for Stateless Form button with mandatory fields.
Hi Zoho! I created a form and whenever I press the cancel button, it prompts me to enter the details. Please see image below: Note: I just put openUrl() in my DELUGE Script for the close button. Any help will be much appreciated! Thanks!! Joy :)
Why does this deluge script not work?
The script below hangs, and doesn't work. How do I fix this? I think the script is saying: show all rows from Groups where Group_Members.UserRecrodD contains (zoho.loginuserid) I want it to say: show all rows from Groups where Group_Members.UserRecordID contains (User.RecordID) list Copy_of_Groups_Report { displayname = "Groups I belong to" show all rows from Groups [Group_Members.User.contains(zoho.loginuserid)] ( Company CompanyViaFetch Group_Name as
Auto populate a form with data fetched from same form
I was working on this feature some time ago, never figured it out and moved on. Now I'm revisiting this idea of auto populating my form of customer information that has been previously entered. Additionally only pulling address that have been entered by the current logged in user. Using Auto populate a form with data fetched from another form I have tried to get this to work, however with no success. Any direction or examples anyone can offer? Thank you
How to automatically add another upload doc field after one has been uploaded
Within a form I am creating, I want to know how do I let the system automatically create another File upload field after a document has been uploaded. In addition, if the second doc also uploaded, system will create a third blank field for further uploading. Thanks for your assist.
Rest API delete not supported?
When calling an external API, Zoho Creator lets me do a Post and Get call. But for some reason Delete is not allowed. Is there any way to do a Delete call? (this is NOT RE: the Zoho Creator API - Delete is supported there, but RE calling an external service.)
data from form to pages
how to access data from form in pages?
user permission
i maintain a client database. i want to allow uers to edit thier data alone. not others. how to do it/
Input masking
Hi Zoho, I am trying to create an input mask for numbers. Currently, if I input a number like 12,583,720 Zoho displays it like this 12583720 This is not very reading friendly for humans. Is there a way of masking the number so that Zoho inserts commas and dots in the appropriate places. Not all numbers will have 8 digits. I still need to be able to perform numeric actions on the field. Thank you, Anne
Next Page