Need help in designing a solution for Classes/Students/Tutors application - including time
Hi, I need help in designing (zoho style) an application that will enable an organization to organize it's calsses. The appliaction will have : Students, Tutors and Classes (physical classes) that needs to be pre booked. the main question I have is how do I make the logic that an instructor can NOT be in 2 classes at the same time, etc... (I don't need/want to lay to you all the criterias, as I don't think it matters). i have a problem in the design (if possible) and also on an easy "Make a new
Timed / Period classes
I need to have some kind of journal entries, where the classes can be either 30,45 or 60 minutes length. I have a reference table that holds these values (lesson_length). I need an interface on to create a new entry for a lesson. Each lesson consists of: Tutor Student Class (a physical location) Start Time Lesson_length I will appreciate any help in designing this, as well as a SUPER way to display the information. Thanks
No requester password?
When I create a requester, they receive an invitation. When they click on the link, they are asked to provide a password. There is no password created when the requester is created, nor is there a means to do so. If requesters cannot log in, the app has no use at all.
Question about embedding into site
Hello, I've made a small library of all our music pieces (we're a concertband). When I embed this into our site, how can I make sure the users can only consult and search in the DB, without changing or adding entries? JJo
Today isn't Today
I have a Zoho application that uses a couple date/time fields, and have the settings of the application set up as New Zealand Standard time, but the "Today" button on the calendar control shows tomorrow's date. This is affecting my application as one of my views was configured to show data from Today. I would appreciate this being looked into. Thanks, Leo Saumure
Dublicate enteres in temp table
Hello, Please, help me. I wrote view https://creator.zoho.com/aerosib/testapp/#View:carTrans It generate temp table carTransTemp with function cargo.fillCarTransTemp(date dt). Formally it is select from autoTrans group by manager, fromFrgt etc Sometimes in temp table i have dublicated enteres, some times all ok. And i cant find some depend between my actions and result.
Advanced techniques for form layouts?
While Zoho is most certainly an excellent product, I am not entirely satisfied with the look of the forms that Zoho helps me generate. I would like to group sets of fields and maybe put a header over them or a border surrounding them, whereas right now all of my fields run together. From reading the documentation, it seems like there is real limited functionality. However I read the code for my form and saw that there is a keyword 'column' that is used to create the two columns. I was wondering if
Count No. of occurance for a listitem
Hi all. Would it be possible to know the no. of occurrences for list items? Eg:- Fruits ={ Apple, Grapes, Apple, Oranges, Grapes, Apple, Pineapple, Guava } I am expectng a result something likethis Apple - 3 Grapes - 2 Oranges - 1 Pineapple - 1 Guava - 1 Any help is great help Thanks in advance. -Deepa Govind
Creator very slow at work, but fine at home
I have a Zoho application that is virtually unusable at work, but seems to work wonderfully when I work from home, and I'm wondering why this would be. Every other webpage that we access from work seems to have no issues, regardless of the fact that they are straight html, asp, or heavy with javascript as Creator is. As I am not a network administrator, are there any Zoho techs who would be able to offer a solution as to why this would be? I don't think it has to do with bandwidth as every other
UPLOAD URLs
I cannot get URLs to upload successfully. I would like to upload URLs with a Title. I have tried from Access, Excel and by pasting, all without success. I can get the URL path to upload so that it works as a functioning URL link, but the "Text to Display" gets lost. Have you any thoughts, tips or suggestions, please?
ZOHO Creator is extremely slow in the last hour !!!
In the last hour, response from ZOHO Creator is extremely slow ... what normally takes 3 to 5 seconds is now taking one to two MINUTES !!! Initially, only Edit Mode was slow ... now both Edit and Run Mode e.g. add a record with two fields (no scripting involved) takes over a minute. Other ZOHO Services (like this Forum) are responding just fine !!! Gaev
Views from multiple forms
Is there a way to make a view that shows data from multiple forms without having to add that data to a form through the use of a lookup field? So if I have forms that have data like this: form 1 ID, Name "1","Jim" form 2 ID, Address "1","123 Main St" I want a view that shows the below without having to add a name lookup field to form 2: ID, Name, Address "1","Jim","123 Main St"
One view that is conditional by user
I have a view I've created of a form. I want to set up the view so it only shows information that has been assigned to the user that is viewing it. I could make a new view for each user, but I have many users. Is there a way to make one view that shows only the information assigned to a user that is conditional upon which user is viewing it?
Form is missing/dissappeared
Need immediate answer: One of my forms has dissappeared from the Forms view. I can still see it in the Live application, but can't edit it. HELP
Find where a 'lookup value' was used
Hello, I am creating a meeting attendance application with a members 'table' and a meetings 'table'. I have my meetings forum using a lookup field for the members 'name' field. It's working great and it makes it very easy to record attendance. However, I am trying to view an individual member's attendance. I know that in the meetings view I can filter by particular members in the 'Attended' lookup field, but I want to be able to print off a sheet that lists all the members and their recent attendance.
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
Help with student attendance database
Hi, I'm trying to create a database to input and manage student attendance at my lectures and labs. I have created a form with: Date Class Type (Lecture/Lab) - dropdown menu Student Names - all student names as a checkbox list I want to use this with my iPhone so I can input student attendance at the start of class. The data entry works well, however, when i 'view' the data, all students in attendance are lumped into one cell. So, how can i modify what i have so that when i view the inputted data,
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 ==
Can't save search for view.
In my application "School Group Registration 2009-2010", I cannot save a search for the view "Available Dates View 2010-2011". The search works, but when I save changes I get an error. I tried to insert the criteria from the edit view also, but it would not save. I tried saving another criteria for text and it saved. This is a simple change and I need it immediately for this application that is going live. The application and is shared with edit access to support.
Issues with Hiding a lookup field
When I hide a lookup field in the form of a radio button and than access the form, all of the fields are hidden and the form is unusable. When I go back to the script and unhide it all of the fields are made available again. Can you fix this issue Thanks!
Limiting Accessiblity
For a Consumer Satisfaction Survey, we want our clients to be able to complete the form without being able to see all of the results from everyone. Is there a way to take the view option off of the screen where they would complete the form? Is there a way to just have the results emailed to us? Thanks.
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
User Limits
At some point, I'll elaborate on where this topic came from. Suffice to say that there are discussions going on about user limits in Creator. I'd like for this to be a casual discussion on the topic. Maybe something will come out for a Cycle 4 Suggestion... Is the current ZOHO business model of X users per subscription package the best value for the application developers? Is the requirement for users to only sign-in via ZOHO Accounts (or Google, FB, etc federated accounts) the best solution for
Need a Time Field
Need a separate time field. Right now there is only a Date/Time field.
Filter a lookup table
I have created a LookupValue table that contains variables that would be accessed by several other tables. A sample of the LookupValue table is shown below: Lookup Type Lookup Value Agency Type Health PHO Agency Type Commercial Agency Type Misc Gender Male Gender Female Salutation Mr. Salutation Mrs. Salutation Ms. I would then put a zoho lookup field in a table that needed to access the values, and filter the value displayed by
Field Limits
IS there a limited number of fields that a form can have? I am getting an error about BLOBs???
Application Sharing not working
Dear Admin, I have created an application and shared it with other zoho user. It become available to the other user. After some time I deleted that application and shared some new app with the user. but user is unable to get the NEW app. There is a link for the deleted app under shared apps. When user clicks on that link, then user receive the message " NO such application on ZOHO" Kindly resolve the issue
I couldn't make my application to public!! :(
I couldn't make my application to public!! :( Help me
Custom Schedules
On Zoho Creator Schedules how do I bring/show the input fields from my data base into the What to do tab?
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
Unable to REMOVE prompt for login details on Creator report embedded in website
I have a report that I wish to display in a website. Unfortunately, it Creator will not permit a permalink that is free of sign-in requirements. It only provides a permalink that requires sign-in. When I click the "Click Here" link as noted in the message below, it does not display the link that is free of sign-in requirements. * This report is private * When you use this code, it will prompt for login details. * To access the report without login, Click Here
Email using a user-selectable field.
Hello everyone, I'm writing a form application that will need to send an email to an address that is associated with a name that a user selects via a drop down. The issue I'm having is a bit hard to describe, so please see below: 1.) User selects Name of person they want to contact from a drop down. 2.) App should then look up the entry for the name to find the email address. 3.) Form should be sent to that email address. The problem is that in the drop down, you have to define values straight
Backup Failure
Support team please help. I have not been able to make a backup for over 2 weeks no matter how many tines I have tried. The meesage recieved is always FAILED. Regards Mark
Insert Value to another Form
Hi .. I make one script to add data from one form (a) to another form (b), in which all works well but one field in form b is stringlist where i can't add the value. is there any option to do so ???? Thanks .
input.Added_User_IP_Address is it really null or is it a bug?
Hello, I need to check on Validation if a form has been submited twice from the same IP address , how do I do this if input.Added_User_IP_Address is always null ? Regards
Cycle 3: Results of the Community Vote
The Voting Phase for the Third Cycle of the Community Driven Feature (to be developed by the ZOHO Creator Team) has ended. Once again*, Deepa Govind has the winning proposal! Congratulations! With 43% of the vote, her "Open URL in header Custom Action" is the clear winner. CYCLE-3-15581553 Runners-up were NiskyPTO's "Rich-text editor for input fields" at 23%: CYCLE-3-34411595 Fcpsppe's "Custom Buttons in Forms" at 22%: CYCLE-3-42494958 * Deepa also won the Cycle 2 round, which you can read about
Email data not working
Email data is not populating my form. I used the template and I am sending from a valid email. What is the format that it should be?
Multi-day events
Good day! I need to built app which has competion records (multiday events). How can I represent it in calendar view? There is only one day events I can find now.
search/results?
I'm weighing my options between a few problems right now, and was wondering if Zoho would be a good fit. I'd like to be able to have a search page and a results page, separately. The first page might involve picklists and text strings, the results page would simply return results from the prior criteria. Is this something Zoho can do? I apologize if I'm retreading a question posted before...
Next Page