Create a custom field in a view?
I have a view that shows records in a summary view. These records contain client names, in the format saluation, first name, last name. Can I change the view definition to show these three fields as one and if so, what is the correct syntax? Many thanks Mark
Invalid email address when updating form and sending mail
I have an app that sends an email when a form is submitted and edited. The email address is provided by the user when they submit their info. When they submit their info, no error is given and the email is sent just fine. However, when they edit the form and re-submit, an error is given about an "Invalid email address". The specific email address is in the form: fname.lname@gmail.com It seems to be the . (dot) that is causing the problems.
Missing or Don't Find?
I am looking for some common functions and SQL like command but failed after serching help, blogs and formus. Are those not included yet OR I am not finding as a newbie to Zoho? a. Absolute Number, e.g Abs() b. Convert a date string('e.g "01-May-2003") to date. I resolved by writing a function myself c. Convert decimal to integer & vice versa d. Date difference between dates ( solved alternatively) e. SQL command like MAX(.eg Salary), MIN(eg Marks), AVG (Salary) and many like these. But many
Syntax for email data address?
userx-449@forms.zohocreator.com Every form in an app has a unique email address to add a new record, right? How does this work for an app that is sold in the Marketplace? For instance what is the syntax of the email address then? zoho-loginusername-formnumber@forms... Does the form number change with each instance or does it remain the same?
Likert Scale Field Type in Creator?
A Likert scale would be an excellent field type for Zoho Creator. It's my #1 feature choice for Creator. An example:
Can you edit form data via email or only add new records?
If I have a record created already via a form. Can I email an update to that record to change a field? Or can the email form data capability only be used to create a new record?
Connect to Zoho CRM
I am a new developer creating my first database. I have not found any step-by-step tutorials on Creator so I'm glad to find this forum. I am a big fan of the CRM app. It meets almost all my needs. There are a few things missing for me which is why I am trying to create my own database. My question is, is it possible to relate a custom database to Zoho CRM? I can create a database to manage client and contractors and the services that bring them together, but I don't want to reinvent the invoicing
Can you upload files/ photos via the API?
Can you use the API to upload a photo or file to a form?
Can I add a photo to a record by emailing it?
I need to attach a photo to a record/ form sent from an iPhone. Is it possible to email the attachment somewhere to attach it to the record? I am struggling to figure out how to attach an iPhone photo to a Creator record/ form. Please help. Will anything work? This should also work for a Blackberry and Android. You can do this with many photo sites by emailing a certain address with your user email for validation. Thoughts on an easy way to attach photos to a record? I do not want to make a user
number of lookups depending on another dropbox
I have a max number of students in a class, and it all depends on how it is set by the tutor. The number can range from 1 - 10, however, because if the number is only 4, then i want only 4 lookups to be added(or enabled, if not possible to make the rest disappear) The lookups are used to look for student names and add it to the class. Thanks for the time!
Empty upload field is no longer empty after record duplication
I check whether or not an upload field in my form is empty with the following code: if ((searchProfile.File_Upload != null) && (searchProfile.File_Upload != "")) This works fine if I created the record from scratch. If I duplicate a record with an empty upload field in it, the code above no longer works. Checking if the field is empty with searchProfile.File_Upload.isEmpty() is not supported. Adding the code input.File_Upload = "" in the On Add / On Load event does not work either. Please advise.
My app is non-responsive to edits
I'm trying to edit one of my forms, and I can't add or delete some of the field types. When I try to add a field it hangs at "Please wait" and doesn't do anything. If I try to delete a field, it vanishes, but if I reload the form it is still there. This is the case with several of the field types. I also cannot add views for the form, or change the columns that are viewable in any of the views connected to the form. It seems that something is "stuck" with that particular form in my app. I've
Reports- User Filter by Weekday
I am trying to create a report to show Usage trends. The Form I have allows the User to input the Date and Shift, and then the Quantity for each Product. (There is also a field on the form that calculates the day of the week on Date_Field.getday()) The User needs to be able to select the Day of the Week and select how many weeks to return, and then the report needs to output the usage for each day, with the averages. Example: User could Input Weekday = 1 (for Monday) User could request the last
Can a public app use another app's records for lookup fields?
If I sell an app in the Marketplace, is it a good design to have it use another database app to manage the lookup fields that is not purchased? Can this be done? For instance, I have an app with lookup fields. The user cannot add to or access these records directly- only through the lookup field. I would like to add to these records without needing to republish the app for a user to upgrade. Can I have the lookups get their lookup data from another separate database that I maintain in Creator?
Multiline appointment in calendar view?
Hi there, I was wondering how I would be able to have a multi-line item show up in the calendar view? Right now in the Calendar view, it only shows one line item per appointment. For example, if I create a new item in the calendar view, it'll show my name on a single line. I want to concat my name with other important info such as 'venue', 'time', and I want those to show on lines below my name. How would I be able to do this? I've tried using the formula field and adding <br> to the script, but
Best way to include record edit popup in HTML view?
Hi folks, I have a query about using record edit functionality in the HTML view type. I have read this interesting post in the forum: http://help.zoho.com/portal/en/community/topic/edit-link-in-html-view-dialog-problems but unfortunately I have not got as far as the original poster. I think this is because I am building the link in a different way. Background: I have a list of tunes (musical pieces) and would like to be able to edit these directly from the HTML view. At the moment, my view is extremely
Allowing edit of a record without login?
Is there a way to allow someone to edit a record without logging into ZOHO Creator? I have a form that emails users in a list when a record is added. Once they get the email, there is a link where they can respond Yes or No. If they choose Yes, then a hidden field is supposed to change to Yes as well. If they choose No, then nothing happens and the record remains unchanged. If I am logged in, this works fine and there are no issues. If I am not logged in, it takes me to the form from the
Public Access vs Private Access
If I begin my form with public access and my visitors do not create an account, can I go back after the fact and make the form private and force my visitors to create an account to have access to the information? If I make them create an account, can they access information that they have entered previously when the form was public? Thank you.
Time picker?
On the forms page, there is a drag and drop element for Date-Time. However, if I only need and want the user to be able to select a time, how would I be able to do this? The Date-Time picker seems to have such a large focus on the date controls and doesn't have large enough controls for the time picker. In terms of UI, it makes it more difficult for users to simply just select the time. Thanks in advance,
An Issue with Unshare
Share/Unshare is confusing me (ref http://help.creator.zoho.com/Sharing.html) I have added a public HTML "start page" in a private application with multiple views and forms. The start page has logic to share certain views and forms based on the ZOHO account email of a signed-in user (the logic criteria references emails in a "roll list"). I have verified that the share operation not only places a user on the application's share context (for views/forms/etc) but also places the user into the "Account
Generation of more than one records in a single form entry
We are trying to generate e-commerce application for bill collection. Table-1 contains customer detail in 06 fields. Table-2 contains bill detail in fields. Now we want to generate one form having all these fields. It is simple. But we want that customer data will remain as header data i.e. should be entered once and bill detail data can be entered more than once on a same form with total amount showing in the form at the bottom. i.e. if one customer wants to enter his three phone bill detail at
Corrupt Script Hanging - Will Not Load
In my "Admin System" application, my form "Task_Attachments" on-edit:on-success script has become corrupt and will not load. I am unable to load the script builder OR the free-flow script in order to correct the issue. 1) can you please go into my application and delete the "on-edit:on-success" action script for the "Task_Attachments" form. I have a backup of the script and will place this back once I can get back in. 2) Zoho needs to implement a feature where we can edit scripts in a "safe mode"
Need help with Lookup Criteria
I have 2 forms: Project and Workarea The Project form has a field- NAME; the Workarea form has a field- AREA and a field STATUS I have a 3rd form, Workflow. On it I want a user to associate a workflow with a workarea. To do this they must choose a project name from the dropdown lookup. This works fine. They then need to choose a workarea name (aka AREA) from the dropdown lookup. Here's where I can't get the criteria right to choose only the workareas associated with that project. Also- this has
Can a Dashboard (HTML View) be used on a mobile device?
I have created an 'Instructions' page as a HTML View. I see it on the PC version of my app, but it doesnt show up in the iPhone via http://mobile.zoho.com/creator. Is it not supported? also- in the mobile version it shows headings of FORMS and VIEWS in the interface. Can these heading titles be changed in the mobile? On the PC side, I renamed them ADD and VIEW/EDIT.
Using Creator script can I control files on my local hard drive
Hi. First, I love your program Creator. We have been working with it for only a few days and have found it easy to use, flexible and scalable. We have a need for an online asset management system as our warehouse is remotely located from our sales office. I have started to create an asset management database using Creator. I have the asset data collection form completed. Each asset has a unique SKU number, auto generated from creator using a maxvalueholder form. During processing of our assets we
Need to print job tickets.
I'm completely new to Zoho creator and trying to create a job tracking software. We run a small sign printing business. I want to print a job ticket to physically follow each job through our system as we print it. I have a form build that we'll fill in all the fields, I just need a way to print a ticket that includes data from one record. I realize I can go into the form view, and with a right click>view>open in new tab I can view and print one record at a time, but I would like to be able to edit
How to prevent users from editing data in view and force to use form with logic?
I am thinking that in a workflow with conditional steps, a user could edit the data in a view and avoid the conditional logic which would give bad data. How can I prevent editing in a view and force editing only through a form?
import record limit
I'm trying to import records to a new application. I receive the following message 'Record limit reached. Kindly upgrade to a suitable plan to import more records.' This is a free account. I am importing 43 records. Each record has 1 field. There are 435 records in another table with an additional 14 in another table. Why am I hitting a limit? Herb Wexler
How to select a form based on a variable?
I have a series of data collection steps that are required to be followed based on the state that you are in (like Texas, New York, California, etc.) I need to associate this state-based form with a lab sample depending on which state sent me the sample. How can I go about doing this? Also- It needs to be fully supported from a mobile device like a Blackberry, Android phone and iPhone. These are the primary data entry tools not a PC. Your help is greatly appreciated.
View Mode Filters Not working correctly
Hello, In my application "SDI Tool Parameter Tracking Database" the view mode filter does not work correctly. I have left the Select District filter included in my "Global Summary of all tools and districts" report for support to review. Please let me know if this is a bug or if i have programmed something wrong. Jason Rapp
Conditional field (step by step)
Hi -- (I already posted this, but as a reply to an "Answered" topic. I'm reposting it here for clarity's sake ; sorry if I'm breaking forum rules) I have a radio field : "Gender" with Male/Female as possible values. I would like to display a text field "Maiden name" only if Gender = Female If I try this : if (input.Gender == Female) it says "Female" is not declared as variable. I tried to use "Set variable", to no luck so far. Would a kind soul provide a step by step tutorial for this? Many TIA's.
How to add a formula that subtracts date and times
Hello, I am new to app development. I am trying to create my own zoho app that is a call log. I have 2 fields that are date and time, one is start time, one is end time. I want to track how long I am on the phone. Can someone please show me step by step to get my Field, 'Total Time' to show how many minutes and seconds I was on the phone please? Thank you!
Problems with forms
Hi, I have a problem, I´ve created the form and when I´m editing it i view it, but when I try to access it shows only the title, but not the fields, two questions then: How can I do to see the form? and: How can I know what is the web address?? Thanks a lot :D
Auto generated table ID?
Hi: Have checked online help, seems have different approaches for getting an auto generated table ID. Can you guys let me know: can we create a field which has auto generated number so I can treat that as an unique ID (for example: start from 1000, increment by 1 for each new record, same as MS SQL, or MS Access table). Thanks.
How to calcuate times (min/sec) between 2 date fields
Hello, I have 2 Date-time fields on my call log. How do I, step by step, calculate the time between the two because I want to track how long I was on each call, (including seconds) I also want to be able to see totals per day of number of calls, and time on each call. Will someone help me with that please? Thank you.
Bug: Schedules module not behaving correctly or saving edits
The Schedules module is still buggy, driving me to frustration again. I set up a schedule to notify some staff members when a certain item w/ an expiration date (field = End_Publish_Date) is 3 days away. Suddenly this morning (1 day after setting it up) we got dozens of notification emails about expirations on items that aren't even in that form! And, to make matters worse, when I go to edit the schedule and adjust its criteria, I cannot save it! The form is called "Check_It_Out", and the schedule
Looking for a CREATOR GURU (Form developer)! Are You available?
Hi, here is the project ...I need your help in order to develop the right Form for my website! As an Advertising Agency (New and Poor! :) )we need to allow our customer to Logging in (So, I think I need a DB in order to store customer info?) and fill out the Online Form (Integrated in our website) and save the order. The Form Order require many fields and may need to be exported as csv. file and organize this file for fast interaction with google or other search engine software to upload the file
"Click Here" link no longer appears when exporting a private embedded views without login
Previously, this was working fine. However, today when I try to export a private view using CSV feed, the link to enable "To access the view without login" is no longer visible. See below. Also, here is the documentation that describes what I am trying to do: http://help.creator.zoho.com/Embed-Form-View-in-Website.html#To_access_private_embedded_views_without_login To access private embedded views without login To access the embedded view without login, select the Click Here option displayed in the
Unable to update multiselect field
I have a form with a multiselect lookup field "Known_Players" that points to the field "Name" of the same form. When the name of a player is changed I want to update all the Player records in which the name is selected in the Known_Players field. For this I have the following code in the on success / on edit event: for each player in frmPlayer [Known_Players.contains(input.Name_before_edit)] { oldList = player.Known_Players; newList = List:String(); for each item in oldList
How to implement IF THEN logic in a database?
I have an app idea where I don't want the IF THEN logic coded in the app. I instead was thinking that it would be easier to manage and change if it were in its own database. Think of it like a conditional question and answer flow. The answer to a particular question will lead you to a different question. In the table I was thinking: Question1 IF answer x THEN goto Question2 ELSE goto Question3. Is this possible like this or does it need to be coded in the logic of the form?
Next Page