how to make a field that is required to not to be necessary
I have a form with a radio button field that have two option , after that field i have two fileds with several option each on. What i want to do is : if the first option a the first field is selected then the first field after this field to appear and to be required, if the second option is selected then the next field to appear and to be required and the previous to dissapear and not to be required. If i put the both filed to be required from start, the form can not be completed because one of the
Help! How to import and link Zoho Form and Database to your website
Hi Guys, I'm new to Zoho, and need a little help here. I was thinking if there's any way if the form that i created (Built from Scratch) could be imported to my website, but the inputs to this form could still be viewed in Zoho database? If its possible, could anyone just teach me how, in simplified steps? Would appreciate any help, thanks!
Display null as " 0 "
Good day Zoho Gurus, I have this in an html filter: <%for each x in VAR_Staff { Person = x.Short_Name; HoursTotal_0_7 = Packaging_Process_Person_Workload[(Staff_Name == Person && (Due_Date <= (zoho.currentdate + '1W:0D:0H:0M:0S') && Due_Date >= zoho.currentdate))].sum(Estimated_Hours); HoursTotal_7_14 = Packaging_Process_Person_Workload[(Staff_Name == Person && (Due_Date <= (zoho.currentdate + '2W:0D:0H:0M:0S') && Due_Date >= zoho.currentdate))].sum(Estimated_Hours);
Setting up Logic for a Date based on today
Hi - I am hoping to use filters (although filters don't seem to accept manually written logic) or I can just set up a different view. But basically I need to set up a rule that says "If 'Date Emailed' is more than seven days ago from today, then show this record". I can't figure out the logical expression for this. Thanks for your help. Jon
Inconsistent behaviour of null values
ZC Team: it is a really good things that recently you made possible to update fields with null values. But I think that there is an inconsistency in handing null values 1. If I have for example a field, it is allowed to allow null values there Numeric_Field = 1; Numeric_Field = null; But if I have a numeric varialble, the following statements Numeric_Var = 1; Numeric_Var = null; will generate error: The template variable Numeric_Var is of type BIGINT. But you are trying to update it with an expression
How to create an invoice in CRM with multiple items ?
Hi, I'd like to create an invoice in CRM with multiple items. Here's my code. void CreerFactureZohoCRM(string NoFacture) { f = Facture1 [Numero_de_facture == input.NoFacture]; c = Commande [Num_ro_de_commande == f.Numero_de_commande]; itemsList = List:Map(); for each i in Axis_Lignes_Commandes [No_Facture == input.NoFacture] sort by Produit1 { itemsList.add({ "Product Name" : i.Produit1, "Quantity" : i.Quantite, "Unit Price" : i.Prix_selon_format, "List Price"
Set criteria for import picklist to limit choices by date
I need to set the criteria for the import picklist to limit my available choices to today or dates in the future. In the example below (episode), I succeeded in limiting the choices to dates equal to or greater than a specific date - January 1st. However, I could not limited the choices to dates equal to or greater than "today's date".
Generation of one Record Thru many Stateless Form
Dear Sir / Madam Could any body tell me how data input by a single user thru various stateless form (Which are the parts of a single Application) stored as a single record. Eg. If I input data thru a single large form, then only one record will be created. Please help.
Rich-text used in Subform
Hi, I need a rich-text field in a Subform. I can customize the toolbar of a normal rich-text field, but it's fully ignored when used in Subform (Toolbar is complete). Is there a way to fix this please ?
Change Default Date format on Excel Text Import
I used the "paste code" from Excel to get data into my Zoho database. However it defaults to DD-MM-YY. I manually change it, but sometimes I don't remember it. How can I make it so I don't have to worry about remembering? Thanks Jon
Creating a Pricing/Sales Form
How can I create a simple pricing form using drop down menus to generate a total once items are selected? I'm not looking to create a invoice form, but more like something a sales agent can use to generate totals for a product efficiently? Here is an example: Products: - Test A - Test B - Test C User selected "Test B" Quantity: - 1 - 2 - 3 User selected "3" Shipping Method: - Ground - Overnight User selected "ground"
Scheduler
I Have a 2 forms, one is parents and one is children. I want to have a automated email when a parent registration expires. I want it to take each of the children belonging to that parent and mention them in the email. How do I pull those records of all the children belonging to that parent? I've tried to use the fetch but can't get it to work?
Image / Logo in the Form
I tried to Insert "Logo / Image" thru Add Notes by I am unable to add. Could some explain me how i can load the logo or image in the form
One Record Thru multiple stateless form
Dear Sir / Madam Could any body tell me how data input by a single user thru various stateless form (Which are the parts of a single Application) stored as a single record. Eg. If I input data thru a single large form, then only one record will be created. Please help.
Options for actions besides "cancel submit" on validate?
I would like to add an extra step before my users save a form, asking them to confirm that the data they've entered matches our real-world data. For example, when they click submit, I would like a window to pop up with a yes/no question, at which point they can click "yes" or "no", which will save the form data - NOT cancel submit. I would then implement a script in the "on submit" action that saves different data based on their answer. I can think of workarounds within the form - decision boxes,
IE9 Security warning
I have a webview embedded on a website. It is working exactly as expected in Chrome and FF. Unfortunately, in IE9, it is prompting a security warning. It is also refusing to download all content without the user agreeing to download "unsecure" information. This is a huge issue! It is imperative that the use of Zoho is transparent to the user. If they get prompted about a security issue, a lot of users are likely to go away. How do I prevent this from happening? Please don't tell me to change my
Ticket Zoho Creator
Hi, Where I can found the value to Ticket? Is a same value that the SecretKey? Tks
Summary view show only 1 record on website
How do I get Creator to show only one summary record pasted and shown on my web page ( I can only get 10 per page at the moment) and for it to delete the previous data every time you put new data into the form. (So that it only shows the last record). is this possible?
Upload & Download a File
Dear Sir / Madam I am creating an application form in zoho creator, in which i would like to attached/upload a file which eventually applicants download and after filling required data again upload in the form. Please help me how i upload and download the file
Can't create Applications on Workspaces
I would like to report this problem, the strange thing is that with one workspace I can keep creating Apps, but not with some other, account admins said nothing is changed...
freeze panes
dear Zoho team, it could be very useful had the viewers been able to freeze panes in a view just like in an Excel file. thanks, peleg.i@playfect.com
views, hidden columns and Marketplace demo
Hi Forum, Recently I tried to upload an application that I developed to Marketplace. One of the problems I discovered is that views are not displayed as configured in my application originally. For example, many of my views have images displayed. In order to display an image properly in a view it is necessary to have both the field that contains the image name and location as well as the formula field that renders and displays the image. Of course I don't want the image name and location field
Selecting Last Entered Value as Lookup
Sorry if this is a basic question, I'm a noobie to Zoho. To simplify- I have a Form1 that has the fields, Date and Weight On My Mainform, I want to populate a "Current Weight" field with the last Weight that was entered on Form1 (Which should correspond to the record with the most recent Date,) How can I do this? I can have a dropdown box appear with Date and Weight displayed for the user to manually select the last one, but how to automatically populate the "Current Weight" field ? What is the
Enhancements to view actions.
I really don't like how view actions buttons are currently implemented. Here's the way I've been building them lately. and here's why! 1. They are located next to the other actions rather than Alllll they way to the right of a view.... The buttons become tedious to use when you have many columns in a view. Sometimes they remain completely off the page on the x axis so you have to scroll to the right. Let's get some Fitt's Law love and have you guys give us the option to move the actions to the
Help Please
I need a very simple function that I need to be added to my view and I can not find a way to do it. I have a column that has the 0 value in every field. I need a function that changes that value to 1 from 0. I am talking about the functions that you add at the right of the view table. The idea is that when you click the button that that function generates near the view's table to automaticly change 0 into 1 at the coresponding item.
Can I give edit/delete access to specific users only, not all users?
I would like to give edit/delete access in a view to specific users in my application. Lets say I have, two users A and B and the view 'Employee List'. I would like to give edit access to this view to user A only. Is this possible? If I go to 'Set Permissions' and select option to allow users to 'Edit Records', it does not let me specify which users should be granted this access and it is given to ALL users (A and B). Thanks for your help! Jose
Possible to have multiple admins and/or transfer admin role to a different user?
Is it possible to have multiple admin users and or transfer the admin role to another user? If not, please add this as a feature suggestion.
Duplicate Error
I cant get one of my applications to duplicate. There are no error messages to show you.. Can anyone help me to sort this out ??
Views Enhancements
1. Change the email field to a Icon instead of the entire email address 2. Relocation option for the Custom Action Columns 3. Make Lookup field a link to view the respected form 4. Change the file attachment field to an Icon instead of the entire file name 5. Add an option that the view link will always show all fields. (or add a column in "Column Properties" to show or hide the field in View)
Unlimited users plans pricing question
I am a bit confused. At this page http://www.zoho.com/creator/pricing.html there is 5000 records add on for $10. On the other side, I saw that in my account at https://creator.zoho.com/home#yourplan (Unlimited users plans) the records addons are $5 and $10 (depending on the Express edition) for $1000 records add on, so the price/record is 2.5 to 5 times bigger than the price for non-Express editions. Which variant is real? The one from here http://www.zoho.com/creator/pricing.html - where is not
iframe snippet embed issue
Hi We have 4 separate applications which have worked perfectly for several months. The applications are exposed within an iframe with form and view snippets. Suddenly all 4 applications come up with the following error message. Error details: Error occured while executing on user input script. Unable to update variable Error occured. An email has been sent to support with snippet details and access to one of the applications concerned. The applications are currently unusable. The coding has not
Create an RSS feed that will display in Google Calendar?
Does anybody know if it is possible to create an RSS feed based on the date field that will show as a google calendar? I have tried taking a copy of the URL for the RSS permalink using the export feature but have had no luck :-(. Anyone know a trick to get this working?
Enable Height and Width for Zoho Creator Form Fields
Hi all, Height and Width attributes can now be set for individual fields(if applicable) in a form from the 'Edit this Field' option. This feature is not yet open to all. If you would like to avail access to the feature, click on the following link and submit the form to request for enabling the feature for your account. http://creator.zoho.com/creatorteam/creator-feature-enable-request-form/form-perma/HeightandWidth_Enable_Form/ Regards, Mukesh
Logial way to check each colum in a row
I may have asked this before, not sure if anyone has found a better way. Lets say I fetch a row into a collection called "therow" I need to now check each column in that row, so I make make my way left to right if "therow.C1"........ if "therow.C2".... if therow.C2" I have 50 columns what i need is a "therow.C1+ 1 next column statement or to have therow.C1 replaced as a variable which i can build Any ideas from anyone ? thanks
Need help defining function for referencing fields from other apps
What I am trying to do: I need a form in my remote app to filter a lookup dropdown field based on the records from another master app. Ideally, it would work exactly as my on add and on edit scripts work in the master app. The current script used for that is: if (count(Tour_League_Division_Conference[Series == input.Series]) == 0) { clear Tour_League_Division_Conference_Name; } else { rec_TLDC = Tour_League_Division_Conference [Series == input.Series] sort by Name ; Tour_League_Division_Conference_Name:ui.add(rec_TLDC.Name.getall());
Update Record clear check box values
hi In a function i have retrieved a record, now i want to update the record and clear some check boxes which are checked cant seem to figure out what value to write to the record.. do i have to build a blank list first maybe ? Thanks
Issue with zoho.loginuserid == null in Formula field ?
Hi, I need to use zoho.loginuserid in a formula field, but <Expression 2> is not used at all. For example : if((zoho.loginuserid == null),"not logged","<a href='MyLink'>logged</a>") This is used in a public view, when we "sign in" the value doesn't switch to "logged"). Any ideas please ? Thanks.
excel formula to deluge ..base-10 logarithm of a number
my formula in excel reads =5.8-(1710/(273+$C4))+0.67*LOG($H4) $C4 =Operating_Temp_C, $H4 = Fugacity_CO2_(kPa) which becomes 5.8-(1710/(273+Operating_Temp_C))+0.67*LOG(Fugacity_CO2_(kPa))but I can not get the LOG function to work I have tried log() …….Format:<numeric>.log()……. Returns the logarithmic value (LogeN) of the specified number. 5.8-(1710/(273+Operating_Temp_C))+0.67*log(Fugacity_CO2_(kPa)) but with no luck and LOG10 …Returns the base-10 logarithm of a number…..LOG10(number) ……Returns the
Bug Tracker feature requets - filtering by, and reporting on custom fields
Zoho Bug Tracker currently supports filtering bugs by custom fields. The out-of-the-box bug form doesn't meet our need, so we ended up adding a number of custom fields. However, we cannot filter bugs based on these custom fields. It would be useful to be able to filter bugs based on custom fields. Also, Zoho Bug Tracker only has a limited set of canned reports, based on the predefined values of only the out-of-the-box fields. It would be useful to be able to define custom reports. A custom report
More Fun with Lists
This is a continuation on topic https://help.zoho.com/portal/en/community/topic/proposing-a-new-function-for-lists-remove-duplicates In this case, I'm attempting to find the intersection of two lists. For example, List_A = (a, b, c, d. e) and List_B = (c, e, f). The intersection of List_A and List_B is List_C = (c, e). In PHP, one can do this: $List_C = array_intersect($List_A, $List_B) But we do not have such functions in Creator. Now imagine a database where we have 100's of "List_A" records that
Next Page