i need to make a form to be unavaileble for submit after a certain number of records
how to restrict( make unavailable to be completed by user) a form after 10 records have been completed, that mean only 10 user can submit the form .
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
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
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.
help with case conversion and contains string functions
Hi, Is it possible to do a case conversion and search a string for a substring in one step? For example, I have tested: for each title in Books [Title.contains(input.Title_search)] - works but is case sensitive. for each title in Books [Title.contains(input.Title_search.toLowerCase())] - substring is converted to lower case successfully but obviously I need to convert the Title string as well. for each title in Books [Title.toLowerCase().contains(input.Title_search.toLowerCase()] - problem with
Customizing look and feel for multiple page forms
Hi there! We are in the process of creating a multipage form. The first form we embed - which is the lead form - looks fine when we embed it in a website. But all subsequent forms result in the default look and feel. See this example: http://www.jessweiss.com/testing/brandeisinfo/index2.html How can I keep this from happening? Thanks!
Can create a form that would allow web users to search my spreadsheets?
I would like to create a form that would allow team captains to search my database of players looking for a team and see a list of players that meet their criteria. Is this possible? How would I start this process?
How to put number counter?
I want to create a form for registration. I have to create a student ID which can not be duplicate. How do I create an ID that is a number and is in counter. The new form should just add up 1 to give a new ID.
How to remove "Powered by..." from internally embedded form?
I have a formed embedded by iframe into an HTML view, but it dows the "Powered by ZOHO Creator" graphic, which is a bit silly. How can I remove it? This is on free plan. Thanks.
Summary view labels
Hi, I am curious if there is any way to turn off the field labels that appear in a Summary View. It is the only View where field labels are used and I have tried using the zcLblWidth parameter set to 0 with no success (I know that zcLblWidth is a parameter for Forms but I was hoping that it might work for the Summary View). If I could just switch off the field labels I could achieve my design goal without creating a more complex HTML view. Thanks in advance for any tips. John
Some help with criteria in a view please
Hi, I have a field in a form that I am trying to use in the criteria on a view but zoho wont let me. Can someone please tell me what I am doing wrong. Field 1 Date_Completed where we enter the hate when a job is completed. Now in my view, I want the criteria to say, if (zoho.currentdate is > Date_Completed + 14 days) Can anyone please help. Thanks Nigel
Within a function send a user message best way
Hi, Inside a function i want to send the user a visual message No Alert in functions so cant use that Info is only seen if you are admin So .. what are my choices to inform the user of something occurring within a function ? Any ideas Thanks
manage drop down box
I'm not a expierienced in script language, and what i want do requiers knowledge about script language. i want to make a form for my site where user can select a team from a drop-down box (eg i want to put 20 team or more) and after submit, the chosen team to be automatically deleted(disappear) from the drop-down box and can no longer be select by another user . The next user will see only 19 team, and so for the next and next....
SPF record for outbound mail from ZOHO
In order to help keep 3rd party mail servers from marking messages from the application as spam I would like to update my SPF record to reflect that ZOHO can send email on my behalf. I added "include:zoho.com" to the record. Do you have a better recommendation for this? Thank you, Parker Byron Network Administrator Kansas City Regional Homes, Inc.
Select CRM Contact, then fetch to get email and address
Hi, Is there an easy way now in Creator to select a contact in CRM and get email and address ? I really need an easy way to do that. Thanks. Pascal Veilleux
subforms gone funny
Hi, Have any changes been made to the sub-form feature as they are displaying rather strangely in my form. https://creator.zoho.com/mrcomputer/mrcomputer/#Form:Job Regards Nigel
Creating Ticket from email
Trying to figure out how exactly a ticket can be created by just an email sent from the user? Looking for better set of instructions. Thanks Bill
Help with code please
Hi, could someone please tell me what is wrong with this code... if (input.Inspection_Fee != input.Inspection_Fee.round(2)) { input.Inspection_Fee = input.Inspection_Fee.round(2); } Thanks Nigel
Mass-update lookup fields values with regular dropdown fields values.
I want to set for a record a lookup field (let's say country lookup field) with country regular dropdown fields of the same record. I've tryed .select function, and nothing.
Help my form has gone lobsided
Hi, My form https://creator.zoho.com/mrcomputer/mrcomputer/#Form:Job has some how changed the column widths so the right hand column is wider than the left. Not sure what I did to make this happen but it has worked fine with all the current fields. Please help. Cheers Nigel
Importing to two tables.
Good Morning, I wonder if someone could give me some advice on something I am looking at. I am starting to build an application in Zoho Creator that will import data via csv files from other applications. The 'live application' will only be interested in looking at the data from the last import but I want to keep an archive off all data uploaded so importing and deleting current items wouldn't be suitable. So is it possible to import to two different tables at the same time with the first adding
Help my form has gone lobsided
Hi, My form https://creator.zoho.com/mrcomputer/mrcomputer/#Form:Job has some how changed the column widths so the right hand column is wider than the left. Not sure what I did to make this happen but it has worked fine with all the current fields. Please help. Cheers Nigel
Help with code please
In the following code, Why wont null stay as Null with a capital N when I change it and why wont nacm hide itself when I delete the Mobile field. The url if you want to see in action is https://creator.zoho.com/mrcomputer/mrcomputer/#Form:Job if (input.Mobile != input.Mobile.getAlphaNumeric()) { input.Mobile = input.Mobile.getAlphaNumeric(); } if ((input.Mobile).length() = 11) { show Type_of_text; show RFC_text; show Send_RFC_email; show Customer_contact; show Time_of_contact;
Files hosting overpriced... Files hosting should be free.
One should be able to have one's business in the same place. I need a way to have all of my files (like free email services have) in the same place. Right know you'll charge me for every byte of data. It's not affordable, is a mess! Files in my PC and files in ZOHO. I can't afford your file hosting pricing. Is too expensive. A small business can have huge amounts of data, like real estate business, pictures, contracts, legal documents. I need to get organized and zoho is not woking for I cant afford
Please help with variable please and show how clever you are.
Hi, Simple scenario... Form A Form B If you run form A an alert comes up saying "You have run form A" If you open form A from form B, I want the alert to say "You run form A from form B" In simple terms the code should be When in form A make a variable called, lets say, xxa=1 and carry it over to form B when in form B say (if xxa=1 then alert "You run form A from form B" else alert "You have run form A") Could one of you clever people show me the correct script for this problem Thanks in advance
Dark PDF Background
When I export a nested HTML view the background of the PDF is dark like the one below. The HTML view has a white background.
Is it possible to "wrap text" and center row values in pivot tables?
I would like for the header data in pivot table columns to "wrap" with the size of the column like in excel spreadsheets and for the data to be centered. That way horizontal scrolling is at a minimum. Is it possible? Thanks.
Help with sub-form please
Hi, I have a sub-form called Status_Board which I insert into my main job form. I have 1 question and 1 problem I could do with some help with 1. Is this the best way to achieve a job status board? 2. In the On Add Row for the sub-form, I have the code 'Status_Board.Report_time = zoho.currenttime;' which always works fine the first time, however, when you add the 2nd, 3rd, 4th, 5th etc row the 'Status_Board.Report_time = zoho.currenttime;' code does strange things. Sometimes it leaves the time field
I can't install any application in Zoho creator from marketplace
I can't install any application in Zoho creator from marketplace. I logged in as :integration1@oscillosoft.com.au, which is a free user. When I want to install an application from Zoho Creator Marketplace, it showed an error message. the message is : Stack overflow at line:10130 Help me if have any solution.
Please Provide time duration for Success Message or provide Success Message with a OK button.
hello Zoho, Zoho is Popular in the USERS and Now USERS wants more expectation from Zoho. I want to give an attention to ZOHO Administration that Please Provide a Time Duration with a Success Message or provide a OK Button with it, because The time period for displaying the Success message is too short, And if we want to give a special information to our USERS in success message, then it is much less time to reading the message. So please provide any way by which we change the time duration to displayed
More Actions -> Export Data missing !
https://help.creator.zoho.com/Import-and-Export-Data.html#Export_Data says Export Data The Export Data feature in Zoho Creator enables you to export your data anytime in the format of Grid (excel format), PDF, HTML, RSS, JSON, CSV and TSV. You can export data as spreadsheet and take it to Zoho Sheet if you want to do some analysis, export it as PDF if you want to print/email the data, export as HTML to view data in your browser, use RSS feed to subscribe to changes in the data or javascript based
Add new leads in CRM with campaign association by zoho creator
Hi, I am trying to add new leads into CRM with associate a campaign by my zoho creator application. I can insert new leads into CRM but not with campaign association. Can any one help me. How to add new leads into CRM with associate a campaign by zoho creator application?
Is this correct
Hi, I have a field that I want to be all capital letters and numbers, input.Serial = input.Serial.toUpperCase(); When I use this on 'on user input' it does the job I want but the circle that appears when a field is updating stays. Also you can then no longer change or delete the field. If it helps, take a look. It is the field Serial in the following form. https://creator.zoho.com/mrcomputer/mrcomputer-biz/#Form:Job
Help please with an error
Hi, In my form https://creator.zoho.com/mrcomputer/form/118/edit/# In the field Date_Booked_In I created an Actions on user input script The script saved but when run it created an error Now I can not vies either the Actions on user input script to change it nor can I view the form definitions. I am in desperate trouble I I need the form for my business that opens at 9.am UK which is in 1/2 hour Please can someone help Thanks Nigel
Error log in Zoho creator
Hello all, I can't find a error log in zoho creator. Is there a way to see a list a past error messages? Thanks!
Record limits
Hi, Could someone please tell me how to limit a form to only 1 record. The reason I want this is for a form I am using for settings through the application so I only need 1 record. Thanks Nigel
Catalogue feature
Hi all, I badly need a catalogue feature: have a database of colleges , which I want to embed into web site. When select a town, the relevant colleges shown from the spreadsheet. Can anyone let me know if it s possible? Thank you Maria
Transfer data from form to form
Could someone please help with the following... I have a form https://creator.zoho.com/mrcomputer/form/118/edit/ When the form starts we use the drop-down box to see if the customer is already in the database. If they are not then we click the + next to address to add a new customer. On rare occasions we miss that the customer is already in the database and we click + anyway. I have set the action on user input to read.... if (count(Customers[Address == input.Address]) > 0) { alert("This address
Add new Leads with association Campaign by Zoho Creator
Hi, I am trying to add a new leads with Campaign association from my creator application. But can't. Can any one help me that, How to add a lead with Campaign association.
Help with adding something to a script
If this is my script, if (input.Collected_By != null) { openUrl("#Form:Print_Control?Customer_to_print=" + input.Job_Code, "same window"); } How do I also add that I want the field 'Print' in print_control to == 'Invoice' Thanks Nigel
Next Page