Insert Record
When I fetch records from a form and use script building to input records on another form does it input new records for all records fetched?
HELP need to export DB that has more than 30 Dropdowns--How do I do this without creating mulitiple views?
We are unable to load this view as it has more than 30 dropdown/radio/multiselect/checkbox fields. Please remove some of these fields from the view and try accessing it.
Export to PDF - not grouping
I have a view which I am trying to export to PDF. This view is set to group data by a certain field (room number), and also to sort data by date and time. When I export, the PDF file is only sorted by the date and time, room numbers are all over the place. I would like the PDF file to look exactly like the table - showing the propper groups. Admin: Name of the view is "Tomorrow Schedule" - already shared. Thank you.
MaxValue Assigning
Is there a way to have only "public added records" to be assigned a sequenced record number?
How to calculate sum of multiuple entries from one drop down field and order by specific employee chosen in a dropdown
How to calculate sum of multiuple entries from one drop down field and order by specific employee chosen in a dropdown. Example: Dropdown called Employee I choose Employee A Dropdown called Passport_Weight I choose 3 Submit and now 3 shows as passport_weight in the view for Employee A - I then renter again Drop down called Employee I choose Employee A Dropdown called Passport_Weight I choose 3 In the View I would like a column called Total_Weight = 6 for Employee A calculate sum of two entries from
Cosmize option for publishing form in pdf from my website
hi , i have recently migrated from ms access to zoho by migration tool , i have 13 14 block of form of a typical cv , how can i put a option for customize publish of cv in pdf by those forms .
Why isn't my code working?
I set up the following function: void SaveExistAgency(map mapAgency) { insert into tblAgency [ Added_User = zoho.loginuser intAgencyID = (input.mapAgency.get("intAgencyID")).toLong() strAddress = (input.mapAgency.get("strAddress")).toString() strAgencyName = (input.mapAgency.get("strAgencyName")).toString() strCity = (input.mapAgency.get("strCity")).toString() strCountry = (input.mapAgency.get("strCountry")).toString() strRegion = (input.mapAgency.get("strRegion")).toString()
Cannot share to users
I just removed a user from an app and now cannot add another. The "Share to User" button simply doesn't respond to clicks. Other apps are working properly, and I've tried both Firefox and Safari, but... nothing. If anyone has an idea for how to fix this, I'd be most grateful! Dusty
Persitent collections ?
Hello, Is there anyway to make a persistent collection along the same session so I don't have to query the database three times to fetch the same data in a single form? when working with same data in OnLoad, Validate and On Success ? Thanks
Drop down values per user needed to calculate sum in another field in a view?
Drop down values per user needed to calculate sum in another field in a view? example: User: A Dropdown value=1 Dropdown vlaue=2 Total Weight=3 I would like the total weight to only show in the view possible? Thanks
Update Time Script
I need to create a script that will automatically update the time field when a person's name is entered in the name field. How do I do this? I have created another script that automatically updates the date/time field when the screen is opened, but can't figure this one out. Thanks for any assistance.
Scheduled backups ?
Is there a way to schedule backups, instead of launching them by hand ? THX.
Pic resize & Summary display customization
Hello again! Four questions: 1. Is there a way to strict a "File upload" field for only .jpg files? And than set to automatically resize a picture to say 100x100px? 2. Is there a way to customize the look of "Summary display" in terms of column width etc? 3. Is there a way to automatically remove the user submitted entry after a certain period or send an email that will contain removal code? 4. How to add a search form to the top of the form that will search through entries? Thank you.
RESET button is inoperational in Zoho Creator new Application Popup/Feedback
Zoho Team, RESET button is inoperational in Zoho Creator new Application Popup/Feedback ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Unable to create a new application
Zoho Team, I am unable to create a new application. I am trying to create a new 'Job Applicant' one. After filling all the details when I submit it does not do anything and keeps blinking at me. FireFox console shows the following messages recorded: Error: not well-formed Source File: https://creator.zoho.com/api/json/messages/view/Admin_Unread_Mails/zc_ownername=zohospace&apikey=7be491b9e0c6b859f2932463d5388409&raw=true&ticket=e91a00d76de265c4fd4e84c7ca7f2b52 Line: 1, Column: 1 Source Code: {"Compose":[]}
Vulnerabilities in Zoho Creator Page
Zoho Team, Whilst creating an application with Zoho Creator and in FireFox I am seeing a lot of the following messages: creator.zoho.com : potentially vulnerable to CVE-2009-3555 ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Send email, If condition
Hi, I use ON SUCCESS condition to send email, but I think I put something wrong in it. Script may be saved but don-t run. Any suggestion? Thanks Michele if (input.Dropdown == "A") { sendmail ( To : "xxx@xxx.it" From : zoho.adminuserid CC : "xxxx@xxx.xx" + input.Email BCC : "xxxxx@xxxx.xxx" Subject : "XXXX" Message : (((((((((((((((((((("Dear,<br />\nno dia ") + input.Data_Hora) + " na postação ")
Problem with javascript and form behaviour
Hi, I have a form with very simple onLoad script: disable fieldname; I had a large script initially but stripped it just one line with no success. When it loads it throws out javascript error: Error: syntax error Source File: https://creator.zoho.com/generateJS.do Line: 1, Column: 1 Source Code: function doaction(recType) Also I have the exactly same problem with other scripts on page. Browsers tested: FF3.6.3, IE8, Opera 9.64 If I remove the script completely then the page loads fine, but any onUserInput
Ability to turn on/off specific forms and views for a user based on their answers to a setup questionnaire on first login
Is there a way to provide a setup questionnaire that a user completes in the database, and then have the database automatically turn on/off tabs, forms, and views depending on their answers? Thanks, Jim
"Text only" report: academic bibliography
Hi! I uploaded a MS Access database to Zoho Creator and will need to export records in a textual form: the database was created for managing a wide bibliography, fields are i.e. Author, Year, Title, Volume and so on, and my report should look like this: Reilly, Rahtz, 1992 Paul Reilly, Sebastian Rahtz (eds), Archaeology and the information age. A global perspective, London, Routledge, 1992 I need to create many of them because every publication requires a different layout for bibliography... in Access
Automatically add entries to website?
Hi! I am new to Zoho. Currently I am exploring ways to add submitted form entry to my website (hosted on blogger.com). I want to make a mini market, for people to sell their products. They just need to enter email, phone, short text and a picture. Is there a way to add this data automatically to website after they submit. Thank you in advance.
assign zoho.userlogin to a field? Use it as a "lookup: to connect forms?
Is it possible to set the value of "zoho.userlogin" to a field? Then, can I use this field to "connect" two forms (using a "lookup" field)?
Multiple Selected Bullet Points
Hi First posting, newbie. Is it possible to have a number of bullets (say 10) where the input could be none, or between 1 to 10? I want to create a check list that has say 10 items which if an x or bullet is populated then this would indicate that the item was defective and would require a text field with more details? Not sure if I have given enough information? Regards Steve
Set checkbox status On Load
Hi Folks, I have a Form with a checkbox for nine survival equipment options. I have been asked that when the Form loads, that some of these options are checked on by default. Seems a simple request, eh! So far, I have been unable to add a statement to the On Load script that can achieve this. I can usually find the answers to my problems searching the forum but no luck in this case. Can someone set me on the right track please? Many thanks.
Minimum Date Calculation (Formula)
I have three date fields in my form and would like to include a formula that calculates the minimum date of all of these fields. Is this possible? Some of these fields may have null values. e.g. Due Date #1: 05/01/10 Due Date #2: 06/01/10 Due Date #3: Null Formula = 05/01/10
Success Page after form submission not loading
Hello- currently after a user submits the form. It flashes a Success message very fast, closes the msg by itself, and goes back to the form-leaving users confused if the form actually was submitted properly. Here is what I have at the bottom of On Success After Sendmail I have: thisapp.calendar.updateAllDataField(input.ID, input.formdata); success message "Thank you! Your booking request has been sent!"; openUrl("http://www.xxxyyyzzz.ca/form/success.html", "popup window", "height=100,width=100");
Create event field
I would like to create a field and record the number of each session, the date and time that I added the comment; as if the event field.
Unable to display thumbnail to others in secure mode
I want to display a thumbnail from an image field. I've created a formula with the following value: "<img src='https://creator.zoho.com/DownloadFile.do?filepath=/" + Image1 + "&sharedBy=myUserName&appLinkName=myAppName&viewLinkName=viewName' alt='Display Uploaded Images in Zoho Creator' width='64' height='75'/>" However, since the app is in secure mode, only i can see the thumbnail, and only in one view. The rest of the users of the app cannot see the thumbnail. If i remove the secure mode, the users
Show Form (not fields or objects) when a field is seleced above. I can show a field and hide fields but not forms as a whole
Hello I have a multi - link object on my form. Based on the value chosen on the form, I would like another form (not objects) to appear below. Example: Multi-link name is Activity Multi-Select Values BDI,HAC If I choose BDI I want to show a form called BDI_Form If I choose HAC I want to show a form called HAC_Form I tried the On User Input feature on my Multi Link but it doesnt work if (input.Activity == "BDI") { show BDI_Form; hide HAC_Form; } else if (input.Activity ==
How to show another radio box??
Hi, How do I show another radio box if customer selects "yes" in yes or no radio box? Am very much not a coder so a reply in lay person speak would be appreciated.
Need help in designing an application
I would like to create an application to track the progess of my employees. Things like licensing progress, training progress, sales records, etc. Should all of these inputs be on one form or multiple forms? Such as: form 1: employee basic information form 2: training sessions attended form 3: sales records form 4: miscellanoous if yes, how do I "connect" these forms? Or, all in one long form? thanks
Field Limits
IS there a limited number of fields that a form can have? I am getting an error about BLOBs???
Report type in Zoho creator
Hi, I have created a report on Zoho creator that has several data points and therefore the tool does not allow me to use Stacked Bar type. It forces me to use Line or Scatter charts which in this case are not very useful for this data I am showing. Since I am using Color filtering, users will only see very little ammounts of data for specific countries and therefore I want to force the report to use Stacked Bar so the information is viewed correctly. Can I force the Report type somehow ? Once again
Creation of PDF Not Working, Again!
Once again, when i try to create a PDF of a html page, the document creates, but it is completely blank,????
Is deluge?
Is deluge written in a specific language? or close to a specific coding language?
Viewing Specific things
I have a question that I cannot find the answer to in the forms anywhere. What I was wondering is if there was any way that if I click a button from one form that links to another, when the second form opens it only shows some of the entries. For example: If I have a form called jobs with a column called job codes. I click a function I created that sends me to a new form that allows me to specify more details about the job on the previous page. This function also sends the job code variable from
How many people can access a Creator form in one go?
Assuming the form I create for my (school) website is safe when I make it and embed it using Creator, can anyone tell me the maximum number of people who can access the form and have their information saved at any one time? Many thanks,
Need help with Stateless Form
I am trying to use a Stateless Form to display a count of data based on two inputs. The first Field in the Stateless Form is a date range The second Field is an Employee Number The employee number is in a form called "Employee" which is linked to a second form called Set_Lead. I want to Display a count of Leads that have been set by that employee during the date range. Is this possible?
view permissions not working
I have created a view and when I choose accrss the application and or create a permalink the edit, add, delete options are available and work. How can I keep people from editing or deleting the data. The permissions for edit, add, delete are not checked in the view form properties. Rick
Stateless form and formulas
I am using two forms to add data to a table. The main form has a formula field that separates the Time from the Time/Date field. The second form is a stateless form that adds records to the same table above. The formula field calculates but is 2 hrs off when data is entered using the Stateless form. Is there a way to add the formula field in the Stateless form and have it added with the record? I'm using that formula field to populate a Calendar View That just needs to show the time on each record.
Next Page