Invite users email
Just now starting to get into the 'Invite users' cycle. I'm finding it really annoying that that the Invite email on the Invite/Sharing page is not stored. Surely this makes sense as I do not want to cut and paste the email each time I invite a new user? Am I missing something. Chris
Daily Calendar View
Zoho has a Monthly Calendar View format. Does it (or will it) have a Daily Calendar View format?
Can openUrl in a Function open a Stateless form?
If yes, what is wrong with this function code? (The code sets the Invoice Number (as string) field for records whose current string is "0 (un-paid)". After that I want the Form named Add_Invoice to open as a popup. It is not opening. Please help me figure out why not. Thank you. void SetPayCode() { NewInvNum = InvoiceNumberList [FilterAid == "Next"]; rec = Session [InvoiceNumber == "0 (un-paid)"]; rec.InvoiceNumber = NewInvNum.Code; openUrl("#Form:Add_Invoice", "Popup window",
Can variables be declared in a conditional formula?
For example, how would I get something like this to work? InvoiceNumbers = (Payment[ID > 0].InvoiceNum).getall(); if( InvoiceNumbers .contains(ThisFormInvoiceNumber) == true, ThisFormInvoiceNumber , ThisFormInvoiceNumber + "<font color=#FF0000>An Invoice Needs to be Made for This Group of Records</font>")
Edit ''Added_User' fields
My Zoho database has been public to date but I'm adding a private view of data that was entered via public pages. The Added_User fields that I use to restrict users to seeing only their own data, is therefore set to 'Public'. I'd like to edit this field so that it shows the user e.g.firstlast, otherwise users will not be able to view or edit data they have already entered via the public page. Although I can see the Added_User field in the view, I am unable to edit it in the record view. As Administrator
Failed to retrieve stored file
I am failing to retrieve the files stored at Zoho Creator. The effect is intermittent: sometimes I can retrieve them, while other times I can't. If you wanted to replicate my results, please look in my apps, whose access has been grated to Zoho Support. Thanks!
Need help for Character conversion
Hi When through the deluge to the SQL server insert into the Chinese data(English is ok), add data garbled, so how to convert the utf-8 to GB2312 or GBO ? Thanks Stanley
Single Record Duplication
I would like to duplicate a single record from a view. I do not want to enable the ability to create multiple duplicates, as setting the permission to duplicate would allow. I imagine this would take the form of a custom action button (on each row), that would simply duplicate that record and open that in edit mode so that I can run some validating script before submission. Anybody have any thoughts? So far I'm terrible at understanding how to write custom functions.
current month record restriction
how can i restrict adding a record with a date field only if the date field is within the current month? please let me know.
Script stopped working
Hello, A script has stopped working on one of my forms, all I get is the arrows going round and round. I haven't changed the script but its now, not working. What can I do? Many thanks Ben
Can in-row Custom Functions pre-load Stateless Forms with data specific to the record in that row?
Can in-row Custom Functions pre-load Stateless Forms with data specific to the record in that row? If the answer is yes, please send some script my way. Thanks.
Re Sort in Drop-down box of Deluge Builder
Hi Form a lot of no sort is difficult to find so suggested bellow Drop-down box can be sorted in Deluge. Thanks Stanley
Edit record in full window
Is there a way to force the edit view into a full window like a new record? Navigation for large records gets a little tricky, particularly when record contains large subforms.
Suggestion
Hi In the execution of a Deluge function can have a similar to the alert box is even more convenient,OR release info function for all users. Thanks Stanley
cannot retrieve data by internal ID in view
I have a lookup field by ID with display "Name" on the form then I have view with This lookup filed ( it displays name) from that form. I do not want to display internal ID on the view!! I need to opne this view from another screen and display all the records with specific internal ID. The only way I know of is to use openUrl function however, it does not work by ID field. only if I search by Name it works: openUrl("https://creator.zoho.com/ito_mu/ep-tracker/view-perma/All_EP_Registrations/EP_Name="
Need developer to integrate shopify and email feeds with zoho creator.
Hi, I'm looking for a developer to help me with some (to me, rather complex) API issues. I would like to make my shopify.com site automatically feed all orders to my zoho cretor app and also be able to update records automatically via emails from transferbigfiles.com... I don't even know if this is possible... If you are interested in the gig, or have further questions, please contact me by email: silver@atomicdisc.com. Hoping to get some help soon! -silver www.atomicdisc.com
Export Data PDF
I know the known limitation of zoho to export grouping, number formats etc to pdf. Is there any alternative to print views in a nice format (ie repeating column headers, page numbers) without exporting to another program?
List View store additional hidden information in a unique column and row
Hi, Maybe more of a html question looking for ideas I have a view which represents rooms (booked, free etc) Each column is a separate unique room and the rows are dates, for each room i use HTML in the list view to show <strong><span style="color: rgb(51, 153, 102);">Rm01</span> GREEN BOLD <strong><span style="color: rgb(255, 0, 0);">Rm02</span> RED BOLD Along with this i now need to store the Zoho ID of who made a booking for that room i have no more fields left on the form (hit the limit) So i
On Load value for URL field?
I think I've figured out how to populate Link Name in the URL field using On Load as follows: input.project_docs = "<a href=''>Project Docs</a>"; However, is it possible to disable *only* the Link Name field On Load, so that the user can put whatever URL they want in but the Link Name will always be "Project Docs"? Thanks!
Sign in and Sign out
hello im new here, would like to ask a question i have a website wanted to create my sign in & sign out for visitor or members what is the code?
Zoho Creator
I know I've asked before, but I'm really perplexed and swamped. Maybe I'm too dumb to figure this out? Sheesh. I need to do date calculations in Zoho Creator. Can someone help with this? Here are the various calculations I need to do. I'm a volunteer book review editor, and need to keep track of books I've assigned to reviewers. I need to log in the date a book is received by a reviewer, add 30 days to it, and generate a date the review is received. I also need to take today's date and subtract
Sharing an App that uses the Shared user's form.
BACKGROUND: I'm considering upgrading to professional express in order to market an app. The scheme is to sell the right to have the app shared by the buyer for a specific length of time. The problem is that if I have 1000 users who generate 1000 records I will quickly have a 1,000,000 record count and at $5/mon/1000 records a $5000/mon ongoing Zoho record charge which would make the scheme un-profitable. One solution I have imagined is to share my app, but then have the user/client install a second
Linking to a document (pdf)
Hello, How could I create a link to a PDF file on my HTML view? My app lets the user upload a drawing for each drawing number (via. Google Docs or local upload) but how can I create a link from my HTML view to the drawing so they can view it? The Drawing is in PDF format and ideally would be "downloaded" or "opened" via the PC or tablet software. I'm not really sure what my options are so if someone could point me in the right direction that would be great! Many thanks in advance Ben
total of a sub-form in a form
Hi i´m trying to do this and can´t seem to figure out how it´s done the "Total = 1379", how can my form give me this total regarding the values come from the sub-form? https://help.creator.zoho.com/Creating-SubForms.html#Deluge_Script Thank you.
Issue with Client's Application
I am assisting user viviennepbe with her pbe-ergonomic-evaluation-form. The form Ergonomic_Evaluation is stateless, but experiences this error for some submit types Error details: Error occured while executing on click script. Error occured. Also, I cannot delete records in Chrome, only IE 9. I think there's an issue on your side with this account. Enabled support edit access John M. Whitney
New User - Advice Needed
Hi there. I'm a brand new user to ZOHO and I'm excited by what I have read. I wanted to see if I could post my question for some input from all of the experts here to make sure I'm going in the right direction prior to getting too lost in the details. Here's the scenario. I manage a number of websites for our local high school. All volunteer work. Example is http://www.MarcusDrillTeam.com. I work (limited) with SQL databases where we collect data through forms. I have even posted to the SQL DBs
HTML View with Iframe and a form record opened for editing
Hi Need a HTML view which works as follows Top half has an iframe which contains a view I decided on an iframe for 2 reasons 1) The view is very wide with an iframe you can scroll left / right 2) below the iframe i want a from which needs to stay in a fixed position, with the iframe above i think this can be achieved Ok... now where i am stuck Bottom half of the screen i want a form opened with the record i want to edit So far i have tried to 1) Embed my form but that only seems to allow for a form
Re Add record to Creator from web html page through creator api
Hi Yoge I try to many times for add record to Creator from a web html page by Creator api,but failed to achieve,my html page code as bellow (in accordance with the help of Zoho), Steps, the first code saved as a the test.html and then use the browser to open <form method="POST" action="http://creator.zoho.com/api/xml/usana/apitest/add/ "> <input type="text" name="name" value=" Column Value "> <input type="text" name="age" value=" Column Value "> <input type="hidden" name ="apikey" id="apikey" value="3d8a1cea7b8efc6141c4f0233a155eed">
How to tell if Print button pressed
I have an HTML form and have enabled the Print and PDF buttons on it. When someone chooses print, I want to set a field with the date that the form was printed. How do I capture the event when someone presses the button? Thanks, Michele
And new field upon user input
Hi, We've been using Zoho Creator for 4 months now and love it. In addition to tracking data for our projects in Zoho we use a simple word doc with an embedded table to record activity. The data here includes user, date, time, activity description, expenses incurred, mileage incurred, and time incurred. With each new entry a blank row is formed for the next activity. I would like to quit using the word doc and simply do all of this within our application. Can anyone suggest ideas for creating
How to limit picklist in a Subform record when editing
The following code restricts picklist entries while adding a new record to a Subform, but when editing a record in a subform, how do I restrict picklist entries to the relevant ones? Denominations ( displayname = "12. Denominations Represented (Dénominations)" type = grid values = Denomination_Sub.ID width = 200px on add row { row.Country = input.Country; denomlist = Denominations [Country == input.Country] sort
Embedding Soundcloud Widgets
Hi Forum, I have created a database for our radio network of voice over talent. Was curious how to embed widget code from sound cloud. Right now I am using URL - but this has a funny effect of the code. Any help would be awesome. Please see the working side via the following link (sort on station 2DU) to see the two I have currently coded. http://www.zoofm.net.au/vodb/index.htm Thanks in advance for your help. Bret Murray
Re-arrange Application Order
Under Personal Applications is there anyway to change the order of your apps? I have 5 apps and of course the one I use the most is 2nd to last but I would like to move it so that it's the first application. Thank you, Valerie
Translating Google Apps UrlFetchApp.fetch to zoho creator
I am struggling with the syntax of converting the following piece of code taken from google apps into Zoho var resp = UrlFetchApp.fetch('http://xmlgw.companieshouse.gov.uk/v1-0/xmlgw/Gateway', {'Content-Type':'text/xml', 'method':'post', 'payload':xml}); where xml is a variable containing xml information. Can someone please help with the conversion. Thanks, Mike
Zoho Creator - Sites - Registered Public Access/CMS Integration
Good Evening I'm looking at Zoho Creator but would like to allow external users to register and provide access to elements of the application. Is this possible within Zoho Creator? if not is it possible to integrate creator with and an external CMS? Any advice or examples would be great. Thanks Ben
Error in summing and counting a subform data
Hi there I made a form with a subform, where I want to add products names and quantities by adding a line for each new product, I then made another two boxes, where i want to count(product names) and sum (quantities), i did: input.Refer_ncias_com_erro = clientes.count(referencias); input.Quantidade_Total = clientes.sum(qtd); but it doesn´t seem to be counting and summing, can anybody give a hand? thank you in advance
View Data in Google Earth
My data is all based off of addresses. Is there a way to load this into a Google Earth view through Zoho Creator? Ideally, I'd like to be able to select the records I'm interested in, click a button, and have them appear as Placemarks in Google Earth.
Starting a function by clicking on a button / link in an HTML view - is it possible?
Does anyone know if this can be done? Suppose in an HTML view I have a link or a button that says 'execute function x', is there a way to get this to run function x when it is clicked without making it into a link to another HTML page with the function call embedded in it? Thanks, Chris
Update formula field from custom action
I have a form that contains (2) fields called Reg_Users (lookup multi-select) and Reg_User_List (formula). The reason for the formula is due to the View criteria not working correctly. Example: If you were to set the criteria as Reg_Users == zoho.loginuser it will not work correctly, but if you use Reg_User_List (Formula: "" + Reg_Users) it works. My issue is the formula field only updating if you edit/update the form. The application uses custom actions to update the Reg_Users field, which does
Little issue with View params zc_SecHeader=false
Hi, When we use zc_SecHeader=false, the paging management is hidden too, even with zc_Paging=true. As a workarround, I set to false all the SecHeader params (add/Search...), but "export Data" and "Total count" params are missing (I didn't find it). Cyril
Next Page