Relating tabs
how can i relate a custam object to a standard object using lookup
create list using toList() then use remove from list questions issue
Hi Still getting my head around this but here are some questions so far 1) toList() enter_string = "X</span>"; enter_string_as_list = enter_string.toList("</span>"); THE String List will contain a trailing , ie X, Q1) Is this meant to be like this by design, lets assume it is for whatever reason 2) remove the element takeout = enter_string_as_list.remove(0); takeout is now X which is correct BUT theemptyaize = enter_string_as_list.size(); returns 1 Q2) Should it now not return 0 ?? as the list
Alert or Pop up in html view
I want to check out the date field in query string is present /null/or invalid for that i want to use alert box
How i create autogenerated date
I want to generate date which is autogenerated and pass through query string andand show in also input field
Limiting subform multi-select based on selection in main form
I am developing a database with forms for corporate data, project data, and employee data. I have created another form to track activities data associated with a client/project by employee. In the activities form I can select a corporation, which updates a multi-select for projects associated with that corporation. I have a sub-form within the activities form that allows me to select an employee and record dates/times/activity for that employee, and associate them with the project selected in the
Subforms
I am new to to Zoho creator and have recently been using the trial version of Microsoft Access to set up a patient database for home visits. I have created a form and have included two subforms within the Master form. 1. I was hoping that they would just provide a link to the forms, by clicking on the images (see attached "overall patients form (editing view)") and not reproduce all the entries, as in the attached "overall patients form (actual view)". 2. I would like it look like the editing
Faster Data Entry... Need help with Lookup data type...
How can my lookup field "remember" their values from previous form submission? I'm trying to improve the speed of data entry by "remembering" the last value that was submitted using the form. I see where I can assign the value to a variable, but how can I then assign that value to the lookup fields when the form is loaded. Or is the right approach at all?
counting months in irregular fiscal year
If anyone out there knows of an elegant way to count the number of months since the beginning of an irregular fiscal year I would really appreciate send that gem my way. I had an app all ready to go for a client that assumed a regular year of Jan1--Dec31 and used the basic .getMonth( ) date function to generate a number count since the beginning of the year for a given date. Then, the client informs me that oops...their fiscal year is May1-Apr31. Now my app formulas must be changed to reflect this
take the percentage from one "form" and calculate it from a dollar amount on another "form"
take the percentage from one "form" and calculate it from a dollar amount on another "form" is it possible??
Combining Views
Hi, How do I combine three different forms to create a view that has all the fields from these forms? All these forms are part of same application. The first form contains a user entered reference field which is also a lookup field in the other two forms. Thanks! V
Creator Embed From not working in IE8 or Safari
Hello, I have an embedded form that works fine in Firefox and Chrome but does not load in IE8 or submit in Safari. Permalink works fine just not the embed code. http://www.sustainableprosperity.ca/RIO+20+Feedback Thanks, SP
Export Back-ups
Hi, I have 7 applications and I will be making more soon. I would like to back-up my data through exporting it all onto a excel speadsheet (each different application). I was wondering if there was a way to get them all to download at once with one click instead of going on all of them and doing it manually and if possibly there is a way to do a scheduled back-up some how? Thanks
Creator Font Change
Hi, I would like to change the font of a renewal deadline to red whenever it is within a month of that renewal deadline. How would I go about doing this in Zoho Creator? Thank you, Jon
issue with email login not in use...
Hi, last year i've played with creator doing a renowal domain system, as a main account i use an email not working now (domain expire). i shared this app with mine domain. can be possible be in contact with support for details? thanks in advance for kind reply Noris D.
I can't use public application on free account???
Hello. I can't find any information on this in the FAQ. Whenever I try to change a form to public the option is grayed out and it suggests upgrading my account. However in the business version faq it says that I should be able to create a public app accessed by unlimited users - inside of the free edition.
Conditionally Call Paypal
Is it possible to conditionally call the PayPal function? For example I'd like to have a radio button options to Pay online Pay at the Door If they choose Pay online it takes them to the PayPal screen otherwise the form saves normally. Herb Wexler
Formula
Hello, i was trying to edit this in free flow, The "username" and "userid" are field name right? and type is "formula" ..But you can't put formula if you don't enter "expression"? in the given example theres a two fields username and userid but their type is "formula" is it possible that you can convert a field to formula in free flow? username ( type = formula value = zoho.loginuser ) userid ( type = formula value = zoho.loginuserid )
ERROR ON AT SUCESS SCRIPT
Dear All, While filling online Form, I am getting Error Message as below : Error on at Sucess Script Note: We are working on giving more meaningful error messages on script failures. What is the solution for this message. I have given request to Zoho Team, but not received any reply. Please reply me at the earliest. Deepak
Can I set up a field that autofills with consecutive unique numbers.
I need each form entry in my database to have a unique consecutive number. So when a form is submitted the first field might be 0234. Then when the next form is submitted that field will automatically show 0235. Is this possible? Thanks in advance.
Need a Database Documentation Report
Any idea when there will be a database documentation report, similar to what you find in MS Access? It would need to report on each form and view, and all of the field properties associated with it.
HTML View Problem
I am evaluating creator for possible use by our company. I am having a problem grasping the concept of the HTML View format. I have my form created, and have created many working view with that. I would like to create an HTML view to report on a single unique record row from my table/form. I understand how to build the HTML portion, but how do i display data from the form in the view specifically. I have passed the variable that I need to set up the criteria to select the correct row, but how do
Zoho Reports Style Data Import Process
Hi, The Zoho Reports method of importing data is so much better than that of Creator. I would like to propose that you try and incorporate this into a future release. Thanks Shaheed
Opening View from list and passing record ID
I am new to custom programming within ZoHo creator and am having difficuties in creating a function that will open a custom view with the lists record ID. I have the custom view called Quote_Review_and_APQP_Tracking and here is the inital Free Flow Script htmlpage Quote_Review_and_APQP_Tracking(potential_idstr) displayname = "Quote Review and APQP Tracking" pdf = true content <%{ curPotential = Potential [ID == input.potential_idstr.toLong()];%> I have created a custom function called
Email Already exist
Hi, i tried to do this in free flow and works fine at first,when i try to submit the email again it shows" One or more fields were dynamically changed. Please resubmit the form. then after i resubmit the form it "Added Data Successfuly"? On User Input { if (count(Register[emailid == input.emailid]) > 0) { input.emailiderror = “This email id already exists”; show emailiderror; } }
Cant find the "count" built in function?
Cant find the "count" built in function?
How I iterate the loop without using form data
There is 'For Each Record' is iteration loop in Zoho creator But I want to iterate one html view in 7 times with incremented date. How I resolve this problem by using Zoho creator? Please Reply
Edit - Form View : Unable to scroll to right to edit
Hi, When I go on form view and try to edit a embedded subform, I am not able scroll to the right and make changes to the data. Please attached image for your reference. Thanks! Vishal
Unable to add or edit records
We are not able to add to any records in the database ("please wait" continues without proceeding") nor can we update any existing records. We have tested in the latest version of all browsers.
Email - Subform Data
Hi, I m unable to include subform data into the email message I am trying to set up. Is it possible to include subform date into email messages? Thanks! V
how i transfer value from one form to another?
I want to transfer one form value to another form and which is also display in view.
Import Data fails with set variable validation
Hi, In my app (app name PIM), I currently have a form called 'Categories', which has the following fields: Root Category Child Category Grandchild Category Website Category I want to be able to import this information and set the Website Category automatically based on the following formula: Website_Category=(((input.Root_Category + if(((input.Child_Category).length() = 0),"","/")) + input.Child_Category) + if(((input.Grandchild_Category).length() = 0),"","/")) + input.Grandchild_Category;
Unable to add or edit records
We are not able to add to any records in the database ("please wait" continues without proceeding") nor can we update any existing records. We have tested in the latest version of all browsers.
if and else if are they counted differently when it comes to number of Deluge statement executions
Hi, I think i read this somewhere need to verify maybe i understood wrong when counting number of deluge statements executed would this be different 1) if ( a==b) do b if (a ==c) do c 2) if (a==b) do b else if (a==c) do c thanks ...
Inserting Lookup Field information into HTML view.
Application has two form: - Project Form: containing Client name, Project number, Task required. - Purchase Order Form: containing PO information The PO Form has a Lookup Field that allows the user to associate the PO with the Project by the Project Number. Once the user click on the submit button, the PO form launches an HTML view for printing. I am able to auto insert all the PO form fields in the the HTML view, but I have no idea how to insert the associated Project field into the
Refresh a Show and Hide expression
Hello, I have the following script: if((input.Order_Type == "Diet")) { show Choose_Diet; show Diet_Description; } else if((input.Order_Type == "Medical Equipment")) { show Medical_Equipment_Type; } else if((input.Order_Type == "Medication")) { show Medication; show Dose; show Frequency; } else { hide Choose_Diet; hide Medical_Equipment_Type; hide Diet_Description; } This seems to work, but when I am in the form it only works one time. I think
How to Get Data From External Website?
How to Get Data From External Website? i already read this in Help Center,but i want a better explanation,thanks
List Add
Hi Here's my problem: I have a list LISTA { A,B,C } and I would like on edit/on success that all items on LIST that are not checked to be included on LISTB How can I do that??? Thanks
Zoho Creator - File upload with Google Docs
Team, The file upload field does not work for Google Docs. It displays the file name (sometimes) but nothing more. The Google Docs link is not importing. I see that you are working on this in CRM forum. Will it be corrected in Creator as well. Thanks
what is String Variable?
can you give me an example of string variable? String variable are "Zoho Variable"? zoho.adminuserid zoho.loginuserid zoho.adminuser zoho.loginuser zoho.appname zoho.appuri zoho.ipaddress ??
Importing Data and Code Execution
I know that On Load and On Change code is not executed when importing data. However I was under the impression that On Submit code would be executed. I'm not seeing this happen... Cheers, John Whitney
Next Page