API/Deluge Limits Do you have hints and tips
So I am hitting limits (500 API calls and 5000 Deluge Statements) quite regularly, I just wondered if people had any suggestions. This is my position: I have a variable list of CRM Account ID's which has been built up in a previous step. My app needs to go and get Account Data and Related Case Data and Opportunity Data, when I have say 10 ID's it s not much of an issue. its just 30 API calls (10 for each module) and may be 300 statements to process for output etc. But with 200 I hit the API call
New app builder
Another bug. When using the script builder in the new app builder, for some reason using the list function 'tolong()' is not being recognized. I switch to the old builder and it works fine.
Duplicate App
I'm trying to duplicate one of my applications but only get the error message 12002. What to do?
Passing parameters to a function
I have a function that is called from two different Views. The function opens a stateless form. When it is closed I want to return to the calling view. Is there a way to tell where the the function is called from? I tried adding another parameter to the function but in the view the only option for parameters are fields in the view. Is there an option to type a string for the argument? Herb Wexler
Using dynamic authtoken or static authtoken
Hi, I have a website that integrates with Zohocreator using its API. There will be many situation where there will simultaneous use of the Zoho Creator Application through record additions or updates from the website. Is it sufficient to have a static authtoken or would it be better to have dynamic authtoken (an authtoken is generated everytime we want to add or update the record)? Hope to hear Regards
Pop-up Display
This seems like very basic question, but: I want to write a function which gets called as a Custom Action. In that function, I want to display a list of records in a pop-up window. I can't see any Deluge functions that allow this to happen. Is this possible? And if so, how? Thanks Alex
Account information related to contact
Hi there, I have two fields in my ZCreator form. ZCRM contact lookup. Link for account. When I select a contact from contact lookup field the corresponding ACCOUNT should be present as hyperlink (full details on link click). How can I achieve this in ZCreator? Thanks.
HTML page as email content
I need to send an html page (based on my app's data) as an email content. (the html page itself works great) I tried doing so as it says in this help page - https://www.zoho.com/creator/help/script/send-mail.html by copying all the html code from my zoho page, to the message content in the "deluge mode" (send mail task) It doesn't work. Anything I'm doing wrong here? Is there a limitation on the html code length when sending it as a mail? Is there any other way of sending an html page as an email
Default parameters for custom functions
I think it would be very useful for default parameter values for custom scripts functions. Can you please add this feature?
Multiselect
How can i use the value of a multiselect to display a subform? The subform is hiden and i want it to be shown if in the multiselect field i check one box
Why Has Zoho Been So Unreliable In Production
Over the last few months, we have experienced repeated serious production problems with Zoho - each of which Zoho admits was their fault. Why can't Zoho understand the importance of protecting their users who have applications in production. In mid-March, the link between Zoho and Paypal failed and Zoho was not being updated with Paypal transaction information. According to the problem resolution that I received from Zoho Support, the problem was traced to a new server that was put on-line at Zoho
I have a number of my records showing "0" in the record's ID
Hi, I have a number of records showing "0" in the record ID...why is this the case? Would it be possible to have a unique ID for those records? Records
NEW BUILDER ... terrible script debugger
So if you write buggy script, instead of telling you there is a bug, it says "script saved" but doesn't really save it. I lost about 20 minutes worth of work just now, because I assued script saved meant script was actually saved. But just as I was about to test it, I noticed my own error. l = Lesson[ID == input.thisLesson]; clear Student; for each s in l.Students{ if(s.status == null) { Student.add(s); } } Student is subform in Lesson it says "script saved on this"
Cannot duplicate application
Greetings, I am unable to duplicate my application. The name of the application is AdhocAds Sales Tracker. I have shared the application with support {at} zohocreator {dot} com any help you cna provide would be greatly appreciated .
Can you combined all your items together.
Its too confusing for the average business owner to go from CRM to campiagns to others. cant you just combined them and allow it easier use?
Field in CRM not updating
Hi, We are using a creator form to capture leads and send them to Zoho CRM. I have mapped several fields and it works just fine. Except for the one marked with red, that one does not update in CRM. { "First Name" : input.First_Name, "Last Name" : input.Last_Name, "Email" : input.Email_Id, "Leads Source" : "Blog", "Lead Owner" : "dk@2base.com", "Lead Status" : "Newsletter", "Country" : "Denmark", "Language" : "Scandinavian", "Description" : ("input.Want_to_receive_newsletter + \n\n") } The form is
Zoho creator slow for anyone today?
Loading pages forever ... on different computers, different locations. I'm so frustrated already looking for replacement to Zoho creator.
Combining Sub Form data with Main Form data
I am new to ZOHO creator and have a fairly simple requirement for collecting online Data. I collect the data from a form I have created which has a sub form to collect peoples names and details. On completion of data entry I need it to email the details entered. My form does this fine but the data from the subform does not come across, all I get is the subform "record ID" I think. Below is the date auto emailed. the bit in red is from the subform and doesn't give the names or details submitted.
Parameter Types in HTML View
Hello, I am creating an html view to get a nicely formatted, custom output view of my data. I have encountered an issue in trying to pass numeric or date fields to parameters in the html view. The template variable saleprice is of type STRING. But you are trying to update it with an expression of type BIGINT It seems that parameters default as string type. Is there a way in the script to set individual parameters as something other than string? Many thanks. Justin
Multiselect
Can i use a checkbox or a multiselect field to make a hiden subform appear?
Zoho Invoice Line Items are Creator subform lines
Hi There I'm developing an Invoicing app in Zoho Creator. It will take data from Zoho Creator forms and push it to Zoho Invoice for Invoice generation via Integration tasks of Zoho Creator with Zoho Invoice. My Invoice line items are entries of a subform named 'Food' in the main form Named "Food Inventory". I've declared a map variable that holds values for each line of subform. itemsList = List:Map(); itemsList.add({ "ItemName" : row.Food_Item, "ItemRate" : row.Rate, "Quantity" : row.Quantity
formulas loosing brackets
Hi, I have a formula like his one: ((coastweekquarters * 86304) + (coastweekeights * 66816) + (coastweek_online * 50 * 86) + (billboards_number * billboards_months * 30000) + (billboards_number * 15000) + (LinkedIn_Number_Of_Clicks * 2 * 86) + (kenyayetu_how_many * 100000) + (msafiri_How_Many * 1300 * 86) + (Nation_Thursday_Property_Section_1_4_Page * 90000) + (Nation_Classifieds_With_Image * 7500) + (XpatLink_How_Many_Issues_To_Advertise_In
Decimals showing on Number field???
I added some number fields to my form. In live mode they show with 2 decimal places. Curiously if I change them to Decimal fields with 0 decimal points they show as whole numbers.
Error occured while executing on user input script
I am inputting test data into the following form https://creator.zoho.com/essistmgmt/assets/#Form:AGREEMENT and it suddenly closed with the error message above. Can I get more information on the error details to understand the cause?
Just build a database from Google spreadsheet
When I try to edit a record - I get this error No rows found for the table CustomerDatabase in this DataObject
Field Placement
I have a two column form. I have dragged the fields to the desired positions on the form. When I view the form the fields have moved all by themselves. They change positions. They change columns. I end up with the First Name and Last Name fields nowhere near each other. I've moved them multiple times. They keep moving back. What's going on? What am I missing? --DJ
Link to EXCEL - Problem with multiple line fields
I was able to link a view to Excel by using both Excel's Web Data Query and Zoho html permalink . This is very handy because I can build a lot of reports in Excel and then just refresh the data. The issue that I have is with one text field in Zoho, which has multiple line. This field gets broken down into multiple rows in Excel. Any suggestion on how to fix this? thanks
Expert in Zoho Creator required!
I have a small project (10-20 hours) which requires some quick development, and ongoing developments as I no longer have time to do it myself! If interested please contact me via email: ashley@elprofesoringles.es or +34 633188512 Thank you, Ashley Williams
Display the position of the selected radio item
How can I return the position (0,1,2,3,4, etc) of the selected radio item?
Back ups suggestions
I have 3 main suggestions for back ups automatically delete oldest when you reach the limit of back ups have more than 3 back ups per application rename back ups I have an application which I want to back up regularly. When I go to back it up, I see the following message, "Already three backup's for this application assets is present. You are allowed to have only three copies" I always have to delete the older back up before I can click the back up button. Can you automatically delete the oldest
How do I change a number field to text field?
I've a field called student ID, which is mainly populated by numbers. One new ID contains a letter to cannot be entered. How do I change the field type? Thanks Mel
All fields do not show up on the screen in the Chrome browser when using new Creator Builder interface
Chrome browser does not appear to be compatible with the new builder in Zoho Creator. The screen ends on the icon File Upload field. There is no way to access icons below File Upload. No such problems existed in the old builder, which was a better product on many levels. I support opinions expressed by other Creators users that the best decision Zoho could make is to scrap the new builder and return to the drawing board.
Can't duplicate application
Hi, I am trying to duplicate an application. When I click on Duplicate it says 'Duplicating, please wait.' After a few seconds that disappears but the application has not duplicated. Please help- thank you!
Creating A SAS using Creator
I'm developing an application for a client Creator and it's going well. I'm now seeing opportunities for create specialised apps which could be sold as SASs (Software As a Service) - like Zoho itself does with its Business Apps. I may have missed the obvious, but I've not seen a way to do this. I know I can create an app and share it with people who have a Creator account, and I could do things such as using filters so that users could only see the records which they personally added - but that's
Schedule Delete Based on Date
I am building a property management app and need to run a scheduled script once a week to delete records. I need to delete records that are older the 14 days and status is set to "rented". I would appreciate any help. Thanks, Aaron
Just shows Processing on website - Please Help!?
I've created a form through Creator but on the website it just shows "Processing" and doesnt load my form unless i sign back into creator and "save". But again a day later it returns back to "Processing"? Can anyone help?
Merketo Form Submission Error
Merketo form validation not working with javascript function in submit button tag
ZoHo Creator is down for us--anyone else experiencing problems?
We can sort of see parts of forms, reports and views, but in a janky format, cross-browser. Clearly, something is down and has been down for over an hour. Anyone else having issues?
Portal site login issue
After I login, the header is repeated in the loign box area. I contacted tech support a couple of times, but no response. Is the portal feature still beta?
Check for conflicting dates
I am trying to create a form that will double check whether or not a person is already scheduled for a shift that is in conflict with another shift that I would attempt to assign the person to. I.E. PersonA is assigned to Shift1 from 7/1/2013 to 7/7/2013. If I tried to schedule PersonA for ShiftB that is from 7/3/2013 to 7/10/2013, the application will tell me that those dates are unavailable. on Validateif (Shift[ID == input.Shift && Shift_Start_Date <= input.Assign_End_Date && Shift_End_Date ==
Next Page