Options in Embedded Report (Export, Print)
Hi all, I am embedding a report of type list in an HTML page and I would like to have the option to export data (same feature than the one in the standard report not embedded). But I can't find how to display it. Also, I would like to remove the Print option next to each record but again, I can't find how to disable it. Any idea ? Many thanks! Guillaume
Tutorial: How to count booleans
Ok, I have rows of data, and each row has multiple decision booleans, which are progress criteria for a job completion. My goal is to total the "true" booleans, and use this total to represent "amount done". I struggled for three hours trying to figure out the correct syntax for this, searched the forum, nothing. I hit upon the solution quite by accident. So here is how you do it: Say my project names are in string column "Project Names", and I have columns for "step 1", "step 2", and "step 3",
Customer portal vs. Share in Creator
I've just updated my account to Enterprise, believing that the customer portal gives the flexibility to manage the users. I have an app where I have more and more users, so far I had to create an email address for the user in Zoho Mail, then creat the same user in Creator, and then do the programming (scripting) to get the login name from them. (I have some scripts where I need the individual user, since some data based on them) The Customer portal is something else, but how can I make this long
Show links from subform in main form's report via script
Hello, I have a form by which I upload files. Each record of the parent form needs to be associated with 1 or more uploaded files or URL links. The only way I know to associate a variable number of uploaded files or linked sites is to use a sub form. This part is OK. However: I want the end user to be able to click on a link to download the stored file or access a web-URL directly from the parent form's report without having to open a separate window corresponding to each of the sub-form entries.
Zoho Creator
Hi, I am trying to create a new app using zoho creator. I am trying to create an app called "compressors", I want to mimic the "products" app that is already available but with minor adjustments. Do you have any ideas on doing this? Thanks
Is it possible to have a conditional Payment form?
Hi there, my client has a requirement to allow direct deposit as well as PayPal payment. Is it possible to make the payment form conditional so that if the user chooses "Direct Deposit", they won't be directed through the PayPal gateway? cheers, Jeremy
Page
What is the use of Create page? I Saw that user guide but i dnt understand pls explain me
Does anyone know how to import Cognos reports into Zoho creator?
I'm new here and can't even get started. My excel files from Cognos don't integrate well into the Zoho. Is there a developer out there that would like to work on a project that could help change the performance management process for a category in the CPG industry? Would love to collaborate on this project to get it moving along.
Report Only see my records
Hello, I have a report and in this report I have a field called "Assigned To" which has an email address of the of the person that equipment is assigned to. When anyone accesses this report I want them to only see records where "Assigned To" equals the email address of the person logged into Zoho Creator. How can I do this?
View/Report help
Form1 has a look-up to a Team Team is connected to Teammembers How do I get a report that connects Form1 with all of the Teammembers? ie, if a record in Form1 is connected to TeamA, and TeamA has 5 teammembers, my report (unfiltered) would have 5 rows (ie, 1 row for each teammember) in MS-SQL, the view would be: select T1.* ,TM.* from Form1 as T1 inner join Team as T2 on T1.teamid = T2.teamid inner join Teammembers as TM on TM.teamID = T2.teamid
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
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???
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; }
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
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.
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
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?
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
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.
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/
Show checkbox in view, versus true/false
How do I change the view to show a checkbox instead of true/false for a decision box field? I have a test view that it will work with. But my main form view will only show true/ false.
Issues with Button in stateless Form
After recent changes in creator user interface & modification in application, I am finding that I am unable to pass any value to stateless form field through deluge code written under an action button. Example : I add a field named Message in a stateless form , I also add a button called say " Show message " and under this button i write code Message=" This is test message" When I press the action button, the field does not get the value and does not show on the screen. It use to work well in the
password field
i want to allow password field in my form. how to do it?
location search
I am looking for an app that will allow me to search my database for customers that are located within a 100 mile radius of a zip code that I enter. Please respond if you know of a way to do this using ZOHO.
Next Page