create list of form names
Is it possible to generate a list of the names of the forms and views in an application? What I want to do is create a software request form for an application with about 50 forms and views. When the user wants a change to the software they go to the form and specify if the change is to a form or a view. Depending on the response they are then presented with a list of the Forms or Views in the application. I can manually create the list but it would be nicer if there was a way to do this in a script.
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
Maximum Fields
Hi, Here, https://help.creator.zoho.com/Known-Issues-or-Limitations.html, it says that for single line fields "Form can have maximum of 80 text fields with max length of 255(SingleLine and Email). This can be increased by reducing the max length value. " I have already reduced most of the fields' (80% of it) max length of characters from 255 to 55 and some to 10 and 5. However, I am only able to use 81 fields. Is there a way to know how much should I reduce the max length of characters and how much
Problem HTML website form
I am trying Creator to decide to buy. I created a nice input form to be used on my website. tried to embed it, and all I get is a large black box that is empty. The email link works perfectly. I used the website link in the CRM web to lead form and that works perfctly. What do I need to do to get my survey form to show up properly on my site. Is there a setting or formatting thing in creator that needs to be changed? Many thanks
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!
Using form fields in lookup criteria
Now it is possible to use form field in the criteria of lookup fields. This will help creating dynamic drop down fields whose values depends on the value given for the other fields in the same form. Refer this sample application implemented using this feature. It contains three forms Country, State and Registration. Registration form contains two lookup fields Country and State. The criteria "Country == input.Country" for the lookup State in the Registration form will update the States based on
Merge Fields from Sub form Data
Can't seem to work out the code for emailing sub-form data from a parent form I use the insert expression on the email tool,but as its variable data, its asking to define the variable (Cant seem to find a help documentation regarding this, is there way to create a email template based on all of the rows or just the latest added or as you add them Subform: Bill Status Parent form: https://creator.zoho.com/kingstonscardiff/kingstons-inspection-booking-system/#Form:Bond_Status Regards Omar
Navigation URL
Can someone please tell me how to use #Script:page.parent.close I want to close a window on the click of a button using this script but it is not working. Can someone give me the exact syntax. Thanks. Jayadev.
If statement and multiselect/Checkbox
Hi, Can you apply an if statement to multiselect/checkbox fields? It doesn't give the option to apply any scripting to the field? Is there a work around for this. I want to be able to apply a condition (e.g. hide field) on the basis of a multiselect selcetion? Any ideas please? John
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
Best way to Control (delay) selected Scripts On Load
UPDATE: I had posted the topic below the stars earlier and now found a better solution. It was simple, really: For the key fields that need to load "first", create a "partner" field that is filled upon load with the same value as the key fields. Then use key field On Update script conditional on key=partner to trigger the filling of the other lesser fields that needed to be filled "later" . Then add partner="" to the On Update scripts for the lesser fields. ********************************************************************
Zoho Creator Helpdesk: automatically create request via email
Hello, Can you please let me know how I can have a new request automatically created via email to specific accounts (e.g. info@agroenos.com, help@agroenos.com, support@agroenos.com) ? Also, is it possible to answer a request submitted via email from within Zoho Helpdesk and have the requester receive the answer via email? I have already provided edit access to support, via the following URL:https://creator.zoho.com/admin.agroenos/help-desk/settings/edit/ Finally, can you please let me know what
Add Aggregate Formula/Field in Creator
Hi Does anyone know how to use this function in Zoho Creator? It has recently appeared in the Reports module (Edit mode) and I cannot figure out how to use it.
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.
Functional URL: Group By Option
There's not a functionality url to generate a view with the Grouped By option, correct? Cheers, John Whitney
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
Custom filter display sorting...
Filters definitions as I typed them in my view definition script : filters ( "Hier" : (Added_Time >= (zoho.currentdate - '0W:1D:0H:0M:0S') && Added_Time <= ((zoho.currentdate - '0W:1D:0H:0M:0S') + '0W:0D:23H:59M:59S')) "S17" : Semaine == 17 "S18" : Semaine == 18 "S19" : Semaine == 19 "S20" : Semaine == 20 "S21" : Semaine == 21 "S22" : Semaine == 22 "S23" : Semaine == 23 "S24" : Semaine == 24
Creating Zoho accounts for users
Hello, As an Admin, Is it possible to create a Zoho account for other users? We are currently integrating the Zoho Creator Help Desk into Google Apps and we need to have no interaction from our users during the account setup process. A silent deployment is what we are going for. If we can create Zoho accounts for our users as an Admin, with no end-user interaction, this would be great. Thank you
auto_increment a Zoho Creator Field?
Hi, Is there any way to create an autoincrement field? I'm making an Access Database editable online using Creator, and one of the columns was an auto_increment PersonID. Is there any way to replicate this? Thanks!
Allowing Users to add requester details
Hi All, I have recently installed Zoho creator helpdesk in my Google apps cloud and I'm still running trial mode. The only issue I encountered has to do with the addition of requesters (customer details). I have added multiple technicians, but they have not been able to add any new requesters thus far. By default, this feature is placed under the 'ADMIN' tab. Is there anyway to delegate some of the 'ADMIN' tab functionalities to my users (technicians)? I have tried the search in this forum but no
Collating data from a paper based survey
Hi, I'm conducting a survey. Around 200 respondents. This is an offline survey, where people are asked to complete a paper questionnaire. So at the end of it, I've 200 sheets of paper. I'm looking for something that'll help me organise, collate and analyse this data.. My questionnaire has several types of questions - some have likert scale type responses..(completely agree - completely disagree.. Could someone please help me with this? Is Zoho creator the right tool for this purpose or
Creator Helpdesk documentation
Is there some documentation available for the Creator Helpdesk application? When I click Help in the application, it presents the developer documentation for Creator.
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
ALL VIEWS LOTS OF TROUBLE TO USE .... Filtering and Sorting lost after custom action, or delete
AGAIN my users are ELDERLY people, I HAVE MONTHS encouraging them to use a webpage..... Now, every time they DELETE a record or use CUSTOM ACTION of the view, all the work they did filtering, and soring and searching, is lost and they get ANGRY, and loose motivation to keep using the site. Please after any UPDATE, DELETING, OR CUSTOM ACTION, preserve the work already done by my users.
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="
Share with a Developer
Hi, How do I share my application with a collaborator. I've activate the user as developer in the Home section and then I share the application with the same. Unfortunately this user still accessing at the application only as a user (cannot really develop it because can't acess at "Edit this application" mode. Thanks Mic
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?
Linking subform data
I would like to create a subform that displays data linked to a field on the main form. For example, let's say I want to create a form that lets me select an author's name from a dropdown that pulls names from a names table. I would like the subform to display all of their books. The same with a form for music artists that would list all of their songs in the subform. When I create the form and subform, I link the fields via the column properties as instructed in a knowledgebase article but nothing
Form extended when I use a checkbox
Ho All, sorry for my poor English but I do my best. I'm a new user of zoho creator. I would like to "extend" my form when a user click on a check box. Check Box "Brother" if check then ask Name & Surname Does anyone have a solution ? Thanks benoit
Home-page Functions
This page https://creator.zoho.com/home/functions#functions in my sigroup works, but in my niskypto account redirects to https://creator.zoho.com/home#myapps John M. Whitney
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
Reset forms to default
Hello, I have broken the Request - Embed form when I was modifying it n Creator Help Desk. How can I retrieve the original copies of the form? I have tried copying the code from a previous version of the form, but I am still receiving an error when I press the "submit" button on the form. Thank you
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!
Unable to log in using GoogleApps ID
Under the application settings I have selected 'Sign in using GoogleApps', and I've entered my domain name. When I try to open Zoho Creator Helpdesk from a test account, it still prompts for login credentials. Ideally we do not want our users to have to enter any additional information just to access the ticketing system. How can I fix this? Thank you
Next Page