Simplest question of the day: vis Zoho Creator backups
Here's an easy one - just a yes or no. Can anyone out there tell me if the record limit (we have a Zoho Enterprise account) includes the number of records held in back up copies? Oddly, this doesn't seem to be spelled out anywhere. I would have assumed the answer is no, but we're trying to work out why we've used up so many records. Thanks a mill for anyone who has the answer.
creating a list
I would like to insert a list into a multiselect during submission of a stateless form. Is this possible. Example in my stateless form I am creating a list in a multiselect. when I submit that stateless form I am inserting a new record into another form and i want to insert that list into the form as well. make sense?
Integrate Zoho Creator With Dropbox
Hi, Anyone could you please tell me how to integrate Zoho Creator With Dropbox with step by step Regards, Lionelmartin
Multiple Documents
Is it possible to place multiple documents in a database, i have over 900 clients and i collect multiple documents for each clent, i want to know if there is a way to place these documents in the database wihtout placing multiple file upload buttons. This is the way i am currently doing it, but there must be an easier more simpler way of doing this, if you answer can you please also list the steps on how to do it.
Text size
In a RTF field, I keep adding text from various sources. Then I try to make all the text the same size, usually the smallest available. Sometimes it works, sometimes not. When it doesn't I end up with a messy looking record with different size texts. I have tried copying all the text to WORD and making all the same size with no problem, then pasting back in ZOHO. While it works, it's a time consuming solution. As far as I can tell all the text I bring is is the same, but I must be missing something?
Please Wait... submitting a public record-edit
I email a link to edit a form to my public users in the following format https://creator.zohopublic.com/<user>/<appname>/<formname/record-edit/<form_report>/<record ID>/<public key> The record is displayed correctly. But when they hit Submit the form is never saved. The Please Wait... stays on the screen. However if I am logged into my Zoho account on another tab the record saves properly. I have removed all the code in the On Validate and On Success sections and it still will not save for a public
Customer Portal -- customized to retrieve customer info?
Is there a way to to have an "open" customer portal (i.e. allows anyone to sign up) that requires/collects more information than just email address and password? For instance, when people log into my customer portal, I need to collect their names, emails, company names, etc. Is this possible?
Collapse all Namespaces on Function screen
Big applications can have dozens or hundreds of functions. Grouping them by Namespace is good but it can still take lots of scrolling to find a function. Can a single button be added just above the Default Namespace to collapse/expand all Namespace sections.
embedded form error - cookie disabled?
Hello Zoho, While entering data on an embedded form and clicking submit, instead of the refresh screen set-up to load after a successful submission, in some browsers our users are seeing this message: "Note : Cookie is disabled in your browser. Please enable the cookie to continue." This is causing some confusion among our users. Is this something we or you can address? Many thanks, Emerson
Search box activate pr user
Hi, The general "Search box" on the top of the page is only visible for the administrator. Where is the setting for box for activating pr user? I can see the options Application settings - Search where it is activated and one can choose forms. But no info on how to activate for users. Best regards, Brynjulv
report with data from related forms
Hello, 1) I'm able to generate a report with data from parent form. But is it also possible to add fields from grand parent forms or forms not directly linked by lookup field, but INDIRECTLY related by lookup fields? 2) Is it possible to use related fields in the pivot chart report? I only get a list of fields from the form that I select as base, not from linked ones. And also again, is the same logic as point 1 valid for pivot charts? Thank you
Error Message when Changing Field Name
I am trying to add a multi line field in my form. It adds the field, but when I try and change the name, I get this error when it tries to save. I tried modifying other forms and everything works fine, it just occurs on this form. All other fields prior to this one saved fine. I also tried to add different types of fields and got the same error for them.
Zoho Creator SQL query updates
How can I write direct SQL queries to update data in forms? Thanks
How do you create an auto responder registration confirmation
I'm new to creator but see it as a possible solution for the painting classes i hold and I'm looking to have my students when they register for the class be sent an automatic email confirming that they have registered. How do I do this?
Lookup field within same form?
I have a complicated problem I'm trying to solve with lookup forms. Let's say I have three forms: Concerts, Pieces, and Composers. Pieces is related to Concerts (there are pieces in concerts) and Composers is related to Pieces (composers write pieces). I want to create a lookup field within Pieces so that when I use a subform Pieces within the form Concerts I'm not accidentally re-entering pieces that already exist (I've checked off "no duplicate values" but since I'm entering pieces from all
Pivot Chart: compare actual value of 1 record with Avg, Min, Max of entire column
Hello - as the title suggests I would like to make a scatter plot (or any chart that will display what I want to visualize), which plots the Avg, Min, and Max of values in a column, and then plot 1 value from a particular record from the same column. For instance there are 20 test scores - the Avg, Min, and Max of all test scores are plotted - also little Johnnys particular scores is plotted on the same chart so he can see how he compares to the Avg, Min, Max. Thank you!
Convert Number to String (Alpha)
Is there a way to convert a number (long) to its alpha correspondent (e.g 4 to four, 5 to five, etc)
Filter across the applications.
Hi, I have created application App1 with a lookup filed Supervisor from App2. In App1 I have lookup filed Country from same app. When I choose a Country, in Supervisor name from App2 should be visible for only selected Country. Can anyone let me know how we can do it. Thanks.
Dynamic picklist based on values of other records (same form)
Hello, I am a new user and looking for some input on how to accomplish a task. I am running a membership database. After being a member for a year, you are now authorized to sponsor other new members. On a user record, I typically enter who their sponsor is. My goal would be to have this be a dropdown, or lookup. However, I only want to show other members that are eligible to sponsor. So, the criteria when someone clicks on the dropdown would be to look at all of the other records and only show
How can you relate two Accounts together
On the Account form I wanted to place a Look Up field to select another Account "Parent Account". This will establish a Parent/Child link between accounts. When I place the Look Up field into the Account form, I don't have the option of selecting another Account form. Is there a workaround for this kind of simple Form A to Form A relationship? Thanks, Kurt
All reports involving this field will be lost!
When looking to delete a field in a form I created, I receive the following message: "Data corresponding to this field and all reports involving this field will be lost. Do you really want to delete this field?" Is there any way to delete a field from a form without losing all the reports I've spent so much time creating?! Whilst I understand any data captured by a field in a form will be lost, I don't understand why all reports created are also deleted. Why can't the field just also be removed
Limit on filter values?
Hello We have designed an application for a client and they need to be able to filter the data by month. Unfortunately, they have now been using the app for more than 50 months, which means that the most recent month (ie January 2016) is no longer turning up as an option in their filter menu. (There is a limit of 50 with date-time filter values -- see https://www.zoho.com/creator/help/views/set-filters.html). I can't create custom filters because the sheer number of views involved (ie hundreds),
Invalid Entry keeps popping up
Suddenly, after using ZOHO Creator for several years on 10 databases, I am beginning to get "Invalid Entry. Please correct and submit again". This occurs in a RTF field. I noticed in one instance, I can save a record that has 3 entries in that field, but if I add a 4th, I get the error message. Not just this record but several similar records. IX-B Captured 1944 After the war, attended Northwestern U. and started a governmental affairs/lobbying firm. Working there at age 80. THIS WORKS 4. After
How do I extract the file name of an uploaded file in Deluge script?
If I just do the following sampleForm.UploadField I get the a long number followed by the file name (eg. 12123243434_ThisIsTheFileName.pdf) But I just want to get: ThisIsTheFileName.pdf I could cut off the number part in script. But the next time the behavior of the Upload Field in Zoho Creator is changed (like it recently has) I would have to adjust it again... Thanks, Filip
Hide a form with control statement
Hi, I would like to hide a whole form depending on who is logged in. I know that a form can be hiden or shown but for all situations. I have noticed that while exporting the code the way zoho hides the form is by putting hide=true before the form definition but it is not possible to define the control statement there directly. I would appreciate any help here, Thanks in advance SerGo
Menu layout
Hi, In ZC, on the pane layout customisation has menus that are expanded by default. Is there any way, even via custom scrips in other programming languages, to get this collapsed by default. Thanks
hiding -select- from drop down fields on Sites Form creator
good morning id just like to ask for a tip on how to hide -Select from a drop down field please and thankyou
How to set a date field to default to today's date?
I would like today's date to be the default and automatically populate the date field. I need baby steps, please. Thank you
If I delete a user, will the records they added also be deleted?
Just want to double check before I delete a user that the 100 records that they added to the application won't be deleted as well. Can anyone clarify for me please?
Could not copy sample apps
I am testing some examples from the Zoho sample applications. I tried to copy the sample app to my own Zoho Creator account but the option is not there. For example this sample app: https://creator.zoho.com/sampleapps/collectionvariable/#View:FormB_View Can someone help
counter number row in child form
Hello everyone , I need your help: I would like to enter into a numeric field a row count of a child form that start at zero for each record inserted had tried with some scripts found in the forum but the count is not reset and continues for all the rows inserted for each record . suggestions ? ideas ? thanks a lot
How to make data field unchangable for user?
Some data fields I have scripted to calculate themselves automatically(using different dates), using different date. I am using script like this: if input.main_date != null { input.purchase_date = input.main_date.subweek(2); } What I would like to achieve is to disable those data fields from being edited by the user. So for data fields that are calculated automatically using the script above, I would like to make them non-editable by user (so only automation affects them). Is this possible?
Order Id
Hi, Im trying to create an order management system. Each order should have a number but this number is consecutive for the department, where the order belongs to. For example, if the latest order from Human Resources is #8, the new order will be #9. But if the latest order from Production is #20, the new order will be #21. The idea is that the order number is automatically generated after you select the department. I appreciate your help so I can achieve this.
How to test if input.Lookupfield is blank / null?
I am trying to understand how to best determine whether the current user input value for a dropdown lookup field is currently null through deluge i.e. displayed or selected as default "-Select-" on web app or "Select option" on mobile app. Currently I have the following code which works on the web site where the if formula is presenting code from calculating a Due_Date if all of the necessary input variables are not yet selected by the user: if ((input.Service != "-Select-") && (input.Priority
Show edits on form update
When a form is updated, is there any way for the sendmail function to identify what changes are made? For example, for a task list if the user changes a deadline, the automated email would identify which field was modified and how.
Add Freeze Column Option for Views Like Zoho Reports
Zoho Reports allows you to freeze columns like you can in Excel. This would be very useful in Zoho Creator as well. Sincerely, Russell S. Brown
For each row not working
Hi, Probably doing a misstake, but needed to check. I have a form that has two states. Either its billable or nonbillable. There is a subform that has products dropdown that has some product and one of them is "Non billable product" If its NONBILLABLE (Main form) then all the products dropdown in each row should say "Non billable product". The rule works for the FIRST entry, but not for the following rows. Cant seem to make it work. This works for the first entry: if ((input.Typ_av_faktura = "Ingår
Do API Data Posts count towards API usage limit?
I want to post to data from my HTML/PHP form to my Zoho database forms, does this count against my API usage limit?
Report with multi-select criteria and related forms
I have a form created for individual freelance employees with a related form tracking their availabilities. For example, the employee might not be available for a certain date range, and then be available for another date range. In addition, the employee has certain software skills that I've got in a Multi-select field. What I'm trying to do is to create a simpler way to get employees matching certain criteria including the software multi-select and the availability. I have another form that allows
Pass Value to the Next Form
I have Form 'Students Information'. In that form, I have field 'Name' and 'Batch Number'. In the next form - Form Training Information', instead of using lookup, I still have the 'Name' and 'Batch Number' fields, but I want the value from Form 'Students Information' to be retained in this form. How to do this?
Next Page