Too many bugs in your creator - is not reliable.
Too many bugs in your creator. is not reliable. - Often gets lost ralations of lookups; - Lookups are not shown in the subform; - If the lookups in the subform are "required field" can not be inserted into and block the registration form; - In edit mode, the lookups in the subform, the existing records are not loaded, remainnull and lose the connection; ---- in my application "Italy" - Form Regions is no longer accessible for editing, the script is there, but only those events, "Form definition" crashes.
bug in related subform
related bug in subform, If I insert a "related lookup" with the subform in other mask, the system goes in crash.
All I want is a No Results Found message when no data is found.
When no data is found in my HTML view, I want my own message that says so and explains what to do next. I know how to do this if a view is simple, but mine is not. I will explain my problem, and here is the page in question, http://www.slaafws.org/meetings : 1. My database has TWO forms for two different types of groups with BOTH form views displayed on the same HTML page. 2. The two types of groups are searched simultaneously by dropdown by country and state for US and Canada, BUT only country
Arkansas comes up in a search for Kansas, I need exact terms please
Isn't there a way to ignore all terms except the exact term being searched for? Arkansas comes up when I search for Kansas, others have said Female comes up in a search for Male. This is a big problem for me. Thanks
Support have screwed up my lookup field
I requested help with sorting values alphabetically in a lookup field. Then on the 19th Bhaskar from support informed me that he had made changes to the script. Now only one value appears in the lookup field. Can anyone from Zoho get in touch with me and tell me what is going on there?
Select multiple records to send email
Would like to know if there is any possibility to select multiple records from the address diary application that I have created using ZOHO? There are 100's of records in the address diary application along with email ID as a field. Is there any possibility that users can select multiple records and click one button to send email to the selected contacts? appreciate any idea to solve this requirement. Thanks in advance!
Upload & Download File
Dear Sir / Madam I am creating a Application form in zoho creator, in which i would like to attached / Upload a file which eventually applicant will download and again upload after required data filling. Please help me at the earlist
Paypal integration?
Is there a way to integrate a Paypal payment gateway within a form? I'd love to be able to create an event registration form and allow users to pay their registration fees via Paypal as they submit the form. Any help is appraciated! sitemanager
Error message in my deluge scripting. What am I doing wrong?
I am trying to add an update script to a field, so that when the field called "Complete" is set to "YES" I will get an email saying "Send Thank You Card to <here the name from the "Contact" field should be inserted> on <here I'd like it to insert the date 5 days from now>. Thank you for choosing Atomic Disc to duplicate <here the name from the "Job_Title" field should be inserted>. Here is the script I've used: "Send Thank You Card to " + input.Contact + .addDay(5) + "Thank you for choosing Atomic
Multiple Languages
Does Zoho Creator support mult-lingual forms? I need to build ONE event registration form in English and French. I want to link both English and French forms into one Database. Example English Form First Name (fname) Last Name (lname) French Form Prenom (fname) Nom (lname)
Fetch values in a Subform what is the format or is it supported
Hi Wanted to count the rows in a subform using count function but could not get that to work Then i wanted to Fetch all the rows for a subform to obtain the count Which leads me to the problem i cant see how to fetch the rows in a Subform (or at least it is not obvious using script builder) Help Thanks
How to add the duplicateCheck parameter when inserting data to CRM from Creator
This example: https://help.creator.zoho.com/Creating-a-record-in-CRM.html claims that the following: zoho.crm.create("Leads", leadinfo); is a wrapper for this: https://zohocrmapi.wiki.zoho.com/insertRecords-Method.html The insertRecords method has a request parameter: duplicateCheck=2 which allows me to update a record if it finds a duplicate. How can I use that duplicateCheck parameter when using the "wrapper" zoho.crm.create provided in Creator? Thanks, David
Openurl - problem with date format in url needing to be different to default application date format
Hi, I am embedding date ranges that come from form entry data fields (date format) to be used in an OPENURL command to select records for a view based on the record date being between the specified range of the dates passed via the OPENURL command. I couldn't get any recofrds selected so I tinkered with the URL and changed the date in the actual URL in the browser (as input from the form in the URL) from dd-mm-yy to dd-mmm-yy and to my surprise, it worked. And after much changing of date format
searchRecords & updateRecords of SalesOrdes in CRM
Hi, I want to search records and & update this Records of CRM's Sales Ordes from my Zoho creator, But the searchRecords("SalesOrders") don't supported. And also for updateRecords("SalesOrders") don't supported. How can I do my task? Can anyone help me?
Gantt Chart in Zoho Creator
Hi Guys, Is there any way to make gantt charts from Zoho Creator data ? I'd like to make simple chart with multiple StartDate and EndDate for each task. See the picture. Maybe with Zoho Project ? Or other web service ? Any tips will be appreciated. Thanks. Pascal
Downtime :(
And my Creator app: John M. Whitney
conditional information in Email
Hi, I use CREATOR forms and its Set E-Mail Notification (under More Actions Menu). I can insert any form fields in the e-mail. I want to replace the information from the field depending on the value of the field in the mail message Here is the example If the value of input.field1 equals/includes etc "Yes" then I want to place the text "You are joining to the party" else I want to place the text "You are njoining to the party" into the mail message Is this possible? Regards, Aydogan
Reports interaction for users
Hello, I have created a chart report and I have shared it with a user. The user could access the report but could not interact with it. I'll explain what I mean. When I put the mouse over a bar a tooltip appears that says "Click to see the data". If a click it I get the records related to that bar. The problem is that the user doesn't get the tooltip and could not get the records although I have shared the report with him. Thanks, FMN
Creator API add to form with Dropdown or Lookup wont accept Blank or -Select-
Need an answer please, i am paying a programmer to wait ==== From testing it seems you have to pass a value, blank or -Select- both return fail I would expect -Select- to work.. maybe i am missing something is there a trick to this ?
Filter across tables
I have a number of assets (automobiles) The automobiles have a number of tyres fitted. plus an exhaust to reduce emissions. With a number of automobiles comes lots of tyres and exhausts. I have created 3 tables. The first one is for the “Automobile” with a unique ID. I linked the other two tables (“tyres” and “exhausts”) using the unique ID. How do I choose an automobile (ID) and filter and show in the other 2 tables so as to show just the attached tyres and exhaust for that unique ID. is
Urgent pleae! Formula fields in a form don't work, please help!
I changed the name of my form and the links asociated to it in my whole application. After this, the functionality of formula fields appear not to be working in this fomr. Please help me out. This is the form. The application is shared for support. https://creator.zoho.com/yaxche/form/220/edit/ Thanks in advance. I would appreciate to look at it rather soon as I use this for business operation.
Subform: Quantity of Add Rows...
I have a subform, right now it seems to be like I can´t add more rows, I have 16 Rows. I put on the edit field of the Subform max rows = 30, but it seems to be that its not working. How can add more Rows for the Subform?. I will appreacite any help on this. Victor Miranda
Report limitation
When I was in free account, I did 1 report and erase it. Then a message says " You can only have a maximum of 2 reports under this account. Kindly upgrade to a suitable plan to create more " Well, it was free. No complains. Now I have upgrade it to basic plan, I have not created any report but today I got: You can only have a maximum of 5 reports under this account. Kindly upgrade to a suitable plan to create more Now I cannot create even one report. Could you please help me here?
Report Limitation (user or application based)
Sorry for the newbie question, but I'm a newbie. :-) Is the report limitation of 2 based on the Zoho user or the specific application being generated? I.E. Can I have 2 reports per each of my 3 apps; or am I limited to 2 reports total for all 3 apps combined? I am using the Free Edition right now, as I determine what level is best for each of the two non-profits I work with. Thank you, and keep up the great work on a great product. George
Formula on a value in a related table?
Hi: In a formula field, can I use the value from a column in a related table? If so, how? Regards, Tom
Hit Counter in Zoho Creator
Is there a way to insert a hit counter for my Creator application. I have it open for public viewing and want to know how much it is being used. Thank you
Changing a file description to "Download" link in view - Problem with files not uploaded
Hi, I have an "Attachment" file upload field in one of my forms where users can upload a file. In the relevant view, it was displaying the filename, which was not what I wanted, preferring a simple "Download" link. To do this, I created a "Document" formula field with the following formula: "<a href='/DownloadFile.do?filepath=/" + Attachments + "&sharedBy=" + zoho.adminuser + "&appLinkName=" + zoho.appname + "&viewLinkName=Open_Disputes'>Download</a>" I then display this "Document" field in the
Update Zoho Campaign member status from Creator
Hi, Is there a way to update Zoho Campaign member status from Creator ? How can we get this variable ? Thanks. Pascal Veilleux
Check Value indipendent from capital or accent
Hi, I have a script that in a formB allow user to find data if FieldA && FieldB are matching in another FieldA && FieldB from FormA. Exist a command to ignore Capital letter and Accent letter matching data? Any suggestion? Thanks Mic
Help with "Average" Aggregate Function
Hi all: I'm new to scripting in Deluge and have a question: How do I fetch only related records located in a sub-form (a.k.a. a related form) and then calculate the average of a specific field in that sub-form? Specifically, I need to know how to write the "criteria expression" part so it only finds those fields related to the parent form (not all records). I'm using the Fetch Records drag-n-drop function wizard. The pure Deluge Script syntax is... //to find the average of a numeric field for specific
Set Criteria Changed
Hi, The Set Criteria in the Form View has changed. I used to be able to just select my fields and it would bring up options for me to choose. Now it is just a blank box where I have to write in the code myself and I don't know what to put? I have a database with people and I would like to have multiple options when searching. I have people with PS3 and Xbox and would like to run a search for all people who own one or the other. I can't do this with the normal search as they would have to have both
Auto fill a subform based on a common field
In my current database I have all of our customer information and the order information in one table. Every time a customer reorders we create a new record with all of the customer info and the new order info. In my trial with Creator I see that you have a "subform" option which seems like a much better way to handle the information. I split the information and imported it in two different Forms, one for the customers and one for the orders. In the main "Customer" form I added a subform so that
Open URL - using date parameters in URL to present records in a view that have a date between the two limit dates
HAs anyone ever implemented this feature? Is it working correctly - are you able to use the same format for the limit date fields in the URL (say dd-mm-yy) as the specified date format for the application?
Calender view change
How do I change my calendar view to only display business days (Monday-Friday)?
Pass parameters to ZC form or view through the ZC html view page？
Hi In the html view page, when click on a link or an image, can I pass a parameter to the ZC and then open an existing record？ or have any suggestions? Thanks Stanley Guo 2012-1-12
problem in view for string with spaces
if in form there is a string with a lot of spaces results is trim the spaces ... example (field lormula in form that format string to fix length): "Name: " + Name + " age" + age ; result: Name: Peter age 30 Name: Augusto age 35 ---------- i like: Name: Peter age 30 Name: Augusto age 35 Ruggine from Italy
Timestamp when field has certain value
I would like my form to show current date and time when the field called "Master" (which is a drop-down field) has the value "Received" or "Reorder (on file)". How do I do this? Would this be a field action within the "Master" field or a formula field? What would the code be? Thanks for any help. -silver
Unable to create second report in Zoho Creater
I only have 1 report in my application, which I created yesterday. There is no button to be able to create a second report. The banner at the top states " You can only have a maximum of 2 reports under this account. Kindly upgrade to a suitable plan to create more" I only have 1 and am allowed 2. I am already a PAID $25.00/month account. I wish to create a second report that I am allowed. Also, how can you allow only 2 reports to a PAID subscriber which is the same as to a FREE subscriber!!!!! You
How to call custom validation method in custom validation and set the validation message according to the inner custom validation result.
$.validator.addMethod("MyWebserviceValidation", function (value, element, params) { var otherStatus = $.validator.methods["childWebserviceValidation"].call(this, value, element, "true"); //Ajax synch call if (!otherStatus) {$.validator.messages["childWebserviceValidation"] = this.customMessage(element.name, "childWebserviceValidation"); return false; } else { //process for this validation and return as per the output } }, jQuery.format("The fields must be valid "));
How to embede a report in a HTML view
Hi I have tried to embed a report in a HTML view like a have done it with forms and views but it didn't work. Please could you tell me how can I do it? Thanks, FMN
Next Page