RSS feed?
Is it possible to subscribe to an RSS feed when updates are made to a table? If not, make this a "feature request." lpress
Data missing from application
All of a sudden yesterday evening, my users (there are only 2 besides me) reported that ALL the data in the main table (Rentals) of my application is GONE. I have confirmed this as of yesterday evening that this data is no longer in the table. No of my users deleted this data, so I do not understand how this data is just gone. I have logged a support case (1609460) yesterday, but I have not heard anything, The application is http://creator.zoho.com/carlgifford/vacation-rental and the form/table
Importing data into related tables
Because I want to build the workflow and add-on coding required before I start to use my Creator database, before I can import data, I need to create the structure of my database first. So, how do you import related data (using a numerical field to link 2 tables) into linked tables in Creator?
How - Look up and display more than one field from a form
As all things, this sounds simple but I can't figure it out. I have a form for client information with these fields: First Name Last Name Phone Car several other fields I have another form that deals with work done on cars and I want it to pull up some of the fields from the client info form (display only) I have a look up in the work form for last name that looks up the last name from the client info form. I would like for it to pull the telephone number and car off that form and display them in
Having trouble with form submissions
I used the database creator to make a submission form for my non-profit org's essay contest. The form is embedded on our webpage, here: http://thefire.org/article/14663.html Lots of students have been calling me having issues with submitting their essays using the form. I have been telling them to try a different browser, and that seems to work (at least, they're not calling back) but I don't know for sure and I definitely worry that we are missing entries from other students who aren't persistent.
importing data with a schedule
I am looking for a way to import data from a .csv file daily at a scheduled time. The file can be located online or in google docs. Is there anyway to do this? I have not been able to find a way to automatically import multiple lines of data from a schedule. Any Ideas?
Problem using migration tool
Hi I'm having a problem importing Excel files to update records for only one column in the file I'm using. The other columns all seem to work ok but for every record one column is being ignored. The problem cell for each row is a decimal and I'm just trying to insert numbers into it. Regards Simon
Client Has Problems with ZOHO Account Creation Experience
The client I'm developing for thinks the ZOHO Account creation process will be confusing to her users. The main issue she has is the email confirmation. As a review, here's the process: After sign-up, you go to your email inbox and do this: That brings up this page: And then when confirmed: At this point, she wants clients to be directed back to the application rather than this page, which she feels is very confusing: We've had lots of discussion in the forums about making the user experience transparent
Can we limit users view ?
Hello, First of all sorry if this question was already answered or if I posted on the wrong forum. I want to create a shared application with 10 users but I don't want them to see each other data. For example user 1 can only see his own details. Do you know it's possible ? Thanks for your help
Bug with "On User Input" for subform fields
Hi, I've found an annoying bug that comes up when trying to edit the On User Input event function for subform fields. It doesn't let me access the function when I'm in Free-flow scripting mode. Please see the screenshot for more details
Passing Multiple parameters to Embedded View
I'm trying to pass multiple parameters to a view embedded in a Html view. It is not filtering as expected. This is the code I'm using: htmlpage Finding_Duplicates(recid) displayname = "Finding Duplicates" content <%{%> <div elName='zc-component' viewLinkName='Copy_of_form2_View' params='zc_Header=true&ID.contains(<%=recid%>)'>Loading ...</div> <%}%> The "recid" is passed from stateless form, it has multiple ID's. App "grocery" is shared to support. Can someone take a look, please? Thanks, Damien.
Creator capability
Before I start on what will probably be a large project, I would like to know if there any show stoppers to using Creator to create CRM, Accounts and Database Based Web Site modules linked to eliminate transcribing data between them?
payment module with quantities for multiple items
How to create a payment module with quantities for multiple items? I'd like to have multi select checkboxes with a field where input quantity insead of the checkboxes. I know this is not possible. somebody found a solution or a workaround?
Form design: segmenting fields into brackets
On my input form there are 40 fields. I need to categorize the fields into 5 to 6 segments.... how do I design this? Tabs? How to put a horizontal dividing bar between segments/sections? thanks gurus.
Importing Data/Zoho Migration Tool
This is what we're trying to achieve, let's say: 1. We had a form with these two columns: ╔════════╦═══════╗ ║ Job No (UID) ║ Cient ║ ╚════════╩═══════╝ We have already +1000 records for these 2 fields. 2. We added these two new columns to our form: ╔════════╦═══════╦════════════╦══════╗ ║ Job No (UID) ║ Cient ║ Department ║ Code ║ ╚════════╩═══════╩════════════╩══════╝ 3. We exported the data
Pre-select the multiselect field on form load
Hi, How to pre-select some values in the multi select field. For eg: If we take dropdown,i have 5 five items in the dropdown field.And the default selected value will be 1st value in such away how to do in multiselect field. Any help is appreciated.
Selective : Form entry
I need to open up 5 out of 20 free-entry fields for users to enter data online. How can I do this?
Can I Order the Menu on the Live Application?
I would like to be able to reorder the menu that is on the left hand side of the LIVE application, when I click "Access the Application". How do I do this?
Conditional mandatory
For some fields I want to make them "mandatory entry" if some other field's value is equal to a certain value. How do I implement this? Thanks.
Something goes wrong with Zoho Creator
Since Morning I am not able to put entry in one of my form. When I select "Type Of Work" or Engineer, it keep on rotating. https://creator.zoho.com/piju2111/penta-crm-11/#Form:To_Do_Form Given edit access to support. Note: I haven't done any changes in script. I tried all the browsers and different computer.
Best Practice for Forms with lots of fields
Hi, I am developing an app that has a lot of fields, and I am wondering what the best practice is in trying to get them on a page without the need to scroll. The forms need to be stateless as I need to do some pre-processing before storing them. I have more fields than will fit on a decent sized screen with the default two columns. These are some of the thoughts I have had but not found a way to do them or do not know if there is a better way. 1. Have more than two columns in a form. 2. Have one
Dynamically generate chart -- Urgent need help
Hi, I need to generate the graph dynamically.For eg:I have 100 employee in one form and based on selection of employeeID need to generate bar graph for the employee in other form. Thanks, Customer
Changing the list order of VIEW items in EDIT APPLICATION
Is it possible to change the LIST order of the ITEMS under the VIEW menu in EDIT APPLICATION? Craig.judd
Remove all items from dynamic picklist in subform
Hi, I want to create a dynamic picklist in a subform. The problem is, I cannot clear all items from the picklist. Please see the screenshot below for an explanation of the problem. Can anyone suggestion a way of clearing the "Select A Child" item from the initial dropdown box? (I have to have at least one item in the dropdown box)
Built-in Function to get Private URL Link
Related to this post: https://help.zoho.com/portal/en/community/topic/permalink-for-private-app-and-sign-in ZC provides a few built-in functions to get aspects of application urls. It would be vary helpful to also have one to get the url key to share a private view or form rather than having to go to live mode and copy an permalink. One clear advantage for this would be application portability. Cheers, John Whitney ZOHO Creator Developer
Based on first form data,i need to enable/disable the second form fields.
Hi, Please help me out of this. Based on first form data ,i need to enable/disable the second form fields.
Condition in Date field
Hello, how can I develop a code on user input on a date field, that when I insert date the hour is before 4pm then it allows me to choose the day after, but if the hour is pass due 4pm then it only allows me to choose the day after + 1? Is this possible?
Permalink for Private App and Sign-in
When we share a private app's form or view via permalink with the access code like this: form-perma/myform/DN3uYKHrnhjv9gnGmEMYredRrzHr6hbvumH52m4HdfvrUAyQEEKTsYsjpsadM1h5PBpkEUOjRCQ1DvhEaCO3eAWm5En7EvWppQP8/ Is there a way to enforce users to sign-in anyway? The use case would be to capture the user's email and only display records they created. Is this even allowed? Cheers, John Whitney ZOHO Creator Developer
On success of First form data need to post the same values to second form
Hi , On success of First form data need to post the same values to second form. For Ex:In 1st form i have 3 single line ctrls.Once i will enter and save the form,i will get success msg.After that i need to redirect the 3 ctrls values to second form. Please help me out of this.
On updating one record automatically update all records carrying formula fields
I am trying to build a project management application where each task is dependent on its previous task and each task's End Date becomes the Start Date of next dependent task. End Date of each task is calculated by adding a duration into that task's Start Date. What I want to do is when I edit and update a task's Start Date or Duration, it should update all dependent tasks automatically. So far, I have been able to update only one record (either the next dependent task or any one task or record selected
Plans...
... I have a STANDARD subscription but in my EMAIL OF DAY I have 0 (ZERO) quota from 20th of november. WHY? My next billing day is 2 december. Some scripts are not running. Sendmail are not running. My applications are involving public institutions with very important situations. What are happening? Thanks Misca
How to seperate the given string based on comma.
Hi, How to seperate the given string based on comma. EX: string str="seperate,the string based, on comma"; Result[0]="seperate"; Result[1]="the string based"; Result[2]="on comma";
Registration system
I have a private form that captures name, address etc. When someone goes to the form the standard Zoho Sign In form is displayed. This is exactly what I want. However if they don't have a Zoho account there is no option to create an account. How do I get a sign up button to show? I expect about 1500 people to register and I want each to have a separate ID. To add a little complexity I want to avoid displaying the Zoho logo. Zoho is a great brand but some people will get confused. Herb Wexler MBA
If / Then formula
I'm trying to write an If/then formula that says if the total number of items is equal to 1, then the shipping cost is 7.00. If the total number of items is more than 1, then the shipping cost is the total number items * .50 + 7.00. This is my attempt at that formula that is not working. If(Total_Number_of_Item)==1,7.00,Total_Number_of_Item)*.50+7.00) Can I get some help with writing the correct formula?
Creating a Link between form and subform.
I am trying to link a form and subform. I followed the instructions and it shows you who to use lookup in the subform. Using look up it asks which field in the form you would like to use to link the two. This is a problem, there are no unique identifier fields in the form. I tried using ID which i understand is a long unique field for each record but all I get is a drop down that asks me to select an ID out of hundred of IDs even if search and autocomplete is ticked. Can someone show me practically
Can I print a blank form?
I`ve created a customer record form and I would like to print a blank copy of it i.e containing no data, just empty fields. Can anyone help? Thank you.
Security Groups
I'm testing the "Creator" product to see if it will meet my requirements. I want to have different users in different security groups who are able to see forms, views, and reports based on their group. It looks like you can do this! So...I created a simple test. I created three groups with different email addresses in each group. I created three tabs and set "sharing" to be different on each one. I invited the groups. When logging in to the first email address using the link provided in the email,
Updating one form with data from another form instead of copy and paste
Hi I have form called Study Details (parent/master) and another form called Risk Log. There is a one-to-one relationship between the two via a field called WY_ID. I have updated the Study Details form with fields from the Risk Log form, as the current arrangement is causing problems (i.e. disappearing fields due to one-to-one relationship). For example, there is a field called Risk Type on form Risk Log, and I have added the field Risk Log to Study Details. So basically transferred all the
Payment Form Confirmations
After processing a form on PayPal, how do I control the confirmation page? It seems to show a fleeting "payment success" message and then redirects to the original form. Also, I have set-up an On Success email, but it's not working. Are these issues due to testing the form in PayPal's sandbox mode? John M. Whitney
Issue after editing one of form
Hi, I have plan to add one more option in my form, for which I have set the variable. FEM = Engineer_Master [Engineer_Name == input.Engineer_Name]; SEMN = FEM.Telephone_No; After saving it, my form start giving different errors. Attached Screenshot. I have given edit access to support, below is my apps url. https://creator.zoho.com/piju2111/form/686/2/scriptbuilder/ Thanks
Next Page