Function, dynamic input record
Hello, We have an educational center. We have a form to add presences of our students. We have a form to add ABSENCEs of our students. We always like to replenish the absences. So, we have a function called "Replenish" and it is a button next to each row in the Absences view. I would like when I push the Replenish button, a popup to appear to ask me to input the date that the specific Absence will be replenished. Is this possible??? Thank you.
How to revert back to GUI on criteria dialog?
After clicking 'advance' on the criteria builder for views, how to I get back to the GUI mode? There doesn't seem to be an option.
Duplicate entry
I'm trying to change a single-line field to a Dropdown field and I get the following error. (with many of my categories) [t_1368016000000063427] Duplicate entry 'Centre pour l'�galit� des chances et la lutte contre le racisme' is not allowed as duplicate entries already exist. How can I solve it?
Recurring Tasks
Is there a way to format a date field to recur? For instance, I would like to add tasks that recur weekly to my calendar view. The scheduling feature does not look like what I am looking for and involves scripting which I cannot do.
Need to add rows in an entry form
i want to create a form that askes for previous experience in jobs. I want to capture about 3 column headers and have a row for each one, how can i create "rows" in the form builder. All my questions have to come one after another in a vertical manor any help will be great. i have created a similar form in XLS but want to put it online in a form. any help? Thanks
Can't remove shared app??
One of my shared users wants to remove/delete an old app that someone shared with him over a year ago and he never uses. There is no clear way of how to do this?? How can you delete old shared apps you no longer want? Thank you!
Form Schedule Frequency
I have a form schedule below. My intention is to have it run constantly, identifying records to delete based on the criteria. Since the Modified_Time is only a date record, the frequency = Once. Does this mean the schedule will only one Once and then quit forever? When? Identify_Recs_to_Delete { Execute on 28 days after of REQUEST.Modified_Time } What? rec_ID = (REQUEST[(STATUS == "Complete")].ID).getall(); for each element in rec_ID { delete from REQUEST[ ID == element.toLong() ]; } Cheers,
Adding Criteria failed
try to add search criteria in app's view "Adding Criteria failed. Please try after some time or refresh the page and try again." how to resolve it? app https://creator.zoho.com/vsavonkin/view/40/edit/
Overview of data from different forms (But from same application)
Hi, If i create a single application with several forms, will i then be able to create a view/ report where i can see all data from all forms in just one view? Or can i only see the data form by form? Kind regards, Bo Thygesen
Grabbing the field names for a form
Hi, I want to grab all the field names for a particular form fieldslist = getFieldNames(); // would be from the form itself in the onSuccess action But what if I'm working in a function. Thank you Guy
Edit form fails to load if Zoho CRM User look-up field has value
Hi, One of the forms I have been building for a client has a look-up to Zoho CRM's Users module and this Zoho Creator form fails to load in edit mode, when some user record is already selected for this field. When I make this field empty, by using the Bulk Edit option, the edit form opens up without any issue. I have provided below relevant images.. Error scenario : Same form loading with the field is empty : I also have another such Zoho CRM look-up field (referring to Accounts) in another Zoho
build a report based on form and sub from
Hi all, I have built and form and then a sub form with in it so that a person registers their details in form 1 and then in the sub form enters there interests one at a time "submitting" each one as they go. Now that i want to report the details i cant seem to join the two forms to produce one output. Any ideas? Regards Duncan
Site visitor statistics
Can anyone let me know how I can get site visitor statistics out of zoho creator? I have setup a public viewable database and i want to see how many people are viewing it. I use wordpress and they have an awesome site stats report. Thanks
Formula Help
Here is what I have: ((Weight * 0.417 + Weight1 * 0.585 + Weight2 * 0.75 + Weight3 * 0.9 + Weight4 * 0.916 + Weight5 * 0.999) / 20) It works great in calculating the value I am looking for. For fields Weight, Weight1, Weight2, Weight3, Weight4, and Weight5 I am multiplying by a known number. I want to add field Weight6 but the number that it is to be mutiplied in order to give me the value I am looking for changes. I added an additional field Fineness to enter the proper number
too wide page in edit mode
With free flow scripting active in functions section but not only in that place (in scripting part of the forms forms and in html views the same happens ), when I use Chrome whenever I activate Refer Fields section from the left and I change the function (in functions sections) or I save the script, the page becomes very wide and I the horizontal scroll is activated. The following short screencast contains an example http://screencast.com/t/BeZbkfmc Regards, George Baltatescu Zoho Creator Developer
Do Zoho Creator Forms work on a Tablet?
I see some related questions from years ago that went unanswered. I have to evaluate this very quickly for a potential contract. I don't need advanced native abilities on the tablet. But I do need basic forms to run well on a tablet, with some way to enter comments, even if it means I custom build alphabet buttons inside the form. Can these forms run on a tablet? If not all tablets, can they run on a Windows 8 / Surface Pro tablet?
exporting the PDF of an html view
Hi, Is it possible to: 1. Export a pdf of a html view to the system ( rather than downloading it ) and 2. Attach it to an email Thanks, Guy
Image reducing in view list.
I would like to have the images in a list reduced and I found this formula but I couldn't get it to work. There wasn't any descriptions on what to change so I am not sure I making the correct changes in the formula. Is there an easier way to change the image size? Please Help. (((((Image_1).replaceAll("border","height='200px' widht='200px' border")).replaceAll("sharedBy","zohologinuserid")).replaceAll("appLinkName",("image-workaround"))).replaceAll("viewLinkName","image_View")).replaceAll("fieldName","Image_1")
Populating drop down box selections
im creating a surgical case log. I want to create a procedure entry drop down box. I have an excel spreadshett with the 100 or so different operations I do. Is there a more efficient way to get this set up than manual entry as I'm afraid this will not be feasible from a time standpoint. Thanks for any suggestions
Edit Mode changes the view
So using Deluge script I was able to hide parts of a form but when I got to edit mode the entire form shows up is there a way to make the script work even when juist viewing it in edit mode?
Email Log
If you exceed your daily email quota of 500 emails per day the balance of emails are logged. Is it possible to access the log to see the initial 500 emails?
Pagination Code
Hello friends, Today, I am sharing a pagination snippet with you. ( http://www.webnersolutions.com/ ) ============================================================================= Function name : calculateTotalPageNumber ----------------------------------------------------------------------------------------------------------------------------------------------- list calculateTotalPageNumber(int total_record, int display_per_record) { if (input.total_record <= input.display_per_record)
[HELP] Post data with php CURL
Currently I am trying to post data with cURL and PHP to populate my custom built app. However I can't seem to get anything to work. I can easily post data the same way to the CRM but not to the creator. This is my code: public function serializeModelling($object) { // Set the curl address $this->curlAddress = 'https://creator.zoho.com/api/xml/write?'; $this->scope = 'creatorapi'; $this->token = '***'; $this->extraParameters = ''; $xmlData = '<?xml
Successfully display 1 to 10 number without using for ,while , do while loop .
Hello frnds , I am a newbie in zoho creator.yesterday was my tough time in office when i saw we cant use for,while,do while looping statement then how to display 1 to 10 or more number in successor. My friend Nitin ,who works in webners ( http://www.webnersolutions.com/ ) help me in this.I am sharing a code of snippet with all of you. Function Name : makePageNumberList ------------------------------------------------------------------------------------------------------------------------------------------------------------------
'Merging' the records of two forms for display
Hi, I wish to combine the selected records of two forms: BalanceSheet, Invoices where they have similar fields: Date, Description, Amount I am then displaying a list of the combined results in a html view called Books. What is the best method to 'merge' and sort these records for display or is this the wrong approach? Thank you, Guy
Access workspace apps via mobile?
Hi, is it possible to access workspace apps via the javascript enabled Mobile site (https://mobile.zoho.com/creator/)? I can only access my personal and shared apps but not workspace apps. I can access them via creator.zoho.com/mobile, but apparently this version is limited. cheers, Jeremy
creating a 'wizard' in Creator
Greetings I would like to create a wizard that allows my users to complete a series of forms to complete one 'profile'. Putting all of the data needed into one form would be clumsy and very large so I would like to give my users a page 1 then page 2 then page 3 etc. environment... something that they can save and finish later. A common profile would be like an application for a university or complete employee application with history of education and jobs or a form to gather up all information connected
XLS attachment in Report Schedules
How do I attach .xls attachments of my views in the report schedule? Currently the data is in PDF format, which isn't helpful. Thanks, Sudeepta
Downgraded to Personal Free Edition?
Hi support, Why was account sigroup downgraded to the personal free plan? Thanks, John M. Whitney aka buzzap and sigroup
Zoho Not Being Updated From Paypal
I have an application in which users are registering for events (a bicycle club). Starting March 7th, we have had multiple instances of people successfully paying for their registrations in Paypal, but Zoho never seeing the completion data from Paypal. As a result, we don't have a record that the transaction is paid. It's happened in about 20% of the transactions. There's no pattern that we can see as to the type of registration, the event, or the type of Paypal payment. All transactions run
When a Fields' Choices are Updated - Will the Deluge Change Automatically?
When a Fields' Choices are Updated - Will the Deluge Change Automatically? For example, I have a radio button list of 5 choices: Favorite Fruit: - Apple - Banana - Television - Kiwi - Persimmon Now in my deluge script I have: if (Favorite == "Television") { do something; } My question is, if I update "Television" when editing the field to "Orange", will the deluge script automatically change to: if (Favorite == "Orange") { do something; } Now, my specific situation is a LOT more complex. As I have
Multiple Forms with a single table
I have a single table which contains all my data but I want to use 2 or 3 different Forms to populate it. The trouble is as soon as I set up a new Form it effectively sets up a new Table. I want to be able to enter Fields like Name and Address in all the Forms but then add in specific data in just one of the forms. For example, I would like to enter a customers Name Address and Contact info in all the Forms but some forms may require additional information such as Delivery Info and another form Collection
What are the built in features in Creator to create a Calendar view like this?
Is there a way to create color coded events? Is there a way to append a check box for which events to display?
Formula field not updated in Child form (Subform)
Hi, I have a Parent form (myParentForm) with the subform : myChildForm. In myChildForm I have a Formula field using the Lookup field related to myParentForm (this formula is to display a directlink to myParentForm record : href="http://....../" + input.<LookupField_to_myParentField> When I add rows in the subform, Formula field in myChildForm is not recalculated : href above stays with http://....../null instead of http://....../0123456. Can you make those formula fields update ? I know some workarround
Could not find Insert Html
Hello zoho-users, I search a lot but could not find Insert Html. Please help me..
Embed Zoho Calendar with week filter in a Zoho Creator html view
Hello. I'm making a view. This html view has multiple views embedded. The basic filter of the view are a range of dates (a week). I know how can I embed a Zoho Calendar and how to put it in week view, but, how can i select the week to display? Is this possible? Regards.
Syntax highlighting bug - parentheses
Until a few weeks ago the syntax highlighting feature was working for each set of opening and closing parentheses. I.e. "( ... )", "{ ... }" or "[ ... ]" for closed parentheses and "{" for an opening parenthesis that has not been closed. However, a platform update broke this feature. Can you please reinstate it ASAP as it makes it hard to spot where missing parentheses should be added.
unable to save script in edit view / free-flow script mode
The "updating script" message is displayed but the script is never saved. This applies even if no changes are made to the script. The same applies to all views in my app.
URGENT ... CANT ADD NEW DATA *PLEASE HELP*
Hello, When i start any form and fill it and click on submit this message comes up. "Invalid entries found. Please correct and submit again." and when i go to Error Details i find nothing. Please help. View Error Details Error details: Error occured while on Success script. We are working on giving more meaningful error messages on script failures
Displaying Data on a Form
I have data imported from a spreadsheet that I would like to display at the top of a form. It is to be referenced prior to the person filling out the form. Is there a way for me to import data into the form and then have them add the content and save the form with the data being added to that record??? Example: We are doing a round of phone calls. I would like the caller to be able to reference the person's name and information before making the call. Then when they make the call they will be able
Next Page