database restructure help
Hi I'm at the stage now where I need to restructure my database as I've decided on a solution which will meet my requirement to avoid duplicate rows. My issue is this - I have two core tables of 'organisations' and 'stations' as well as a table linking them to manage ownership relationships. Historically I have linked owners to the stations through a lookup on the 'station' table but this has left it impossible to sensibly manage joint owned stations. What I want to do is copy all the
on import (excel file)
Hello, I have three fields in a form I created (serial number, module type, is used(checkbox yes) On the import the user will select from the excel file just the serial number. I want the checkbox to be automatically set to false ( I imagine since it is not considered checked it is false, but I think it is actually Null instead) and I want the module type to be 0. Is there a way on import on each field imported the two other fields get their default values? Thank you.
Zoho Creator Maintenance - Aug 5, 2012 (09:00 PM - 09:30 PM PST)
Dear Users, Due to database cluster restructuring for better optimization of the system, Zoho Creator service will not be available for a short period on Sunday, August 5, 2012 between 09:00 PM PDT and 09:30 PM PDT We regret for the inconvenience this may cause. Regards, Karuppuchamy.
Help on viewing a related record field captured using aggregate records function
I wonder if anyone can help me please? I'm relatively new to Creator and i'm struggling to find a way to do the following: Using the syntax below, I can capture the appropriate value for the "Date_Worked_1" field, but i'm stuck when it comes to returning the value from another field in the same record that this returns. Suggested_Date = jobs[Allocation == "AVAILABLE"].minimum(Date_Worked_1) ; What i'm aiming for it to return the value for a field called "Hours_Worked_1" from the same record that
Want to include a Linking icon in Form View?
Hello developers and Support team. I have any application and in this application there are many forms and different views. i want to palace a icon like help icon to all forms views, where when user click on that icon they will automatically redirect to an another address. please see below picture for more clarification: If it is not possible to add icon to the form header then also provide me an alternative for where i can use it? Cheers
Common script
Hi, I've created a form that has a number of look-up fields. When the look-up values are selected, it changes various numeric fields, I therfore need to re-calulate all field upon update. I've copied the required script in each field. As the code is common, is there an easier way to call a script to re-calculate. This way I only need to maintain a common script? Thanks, Martyn
Can I submit once to multiple tables?
I need to have a single form that contains fields associated with different tables. When the "submit" or "save" button is pressed it saves the field data to the appropriate table. An example would be: Data entered into the "part description" field would save to the "Parts" table. Data entered into the "List Price" field would save to the "Pricing" table, and so on. Is this possible? Thanks for looking at this.
Is it possible to use foursquare data as an input to a form in zoho?
I would like students at my school to be able to register onto a zoho database through the foursquare app - is there any way of doing that?
Import data to existing app
I'm sure it's someplace! I exported the data from my ZOHO creator app, then made some changes in excel and now I want to import the data, replacing the current data. I can't find an import button. Herb Wexler MBA www.PreventingMediocrity.com Norwalk, CT 06854
User Permissions
Hello, I am working in ZoHo and I have a Permissions question. Basically, is it possible to control the permissions of each user based on what I need them to be able to do? For example, I have an "Application" form, and I want to allow my HR department to be able to accept and reject applicants using the appropriate drop down fields, which I, as an administrator, have hidden. Currently, I am the only one who can accept or reject these applicants. UPDATE: I have created a duplicate
Need to create a standing order form with log-in
We have 1500+ members. We need to provide them with a standing order form for materials that allows them to log-in and change the order as needed in the future. Can this be done as a zoho app?
Zoho Creator and Iphone app
Hi, I would like to know if It´s possible create a form using Zoho Creator and them include it in a iphone app (so it can be part of an iphone app) It is possible? Thanks,
Backup Failed
Hi ZC team, I have tried several times a backup for one of my applications and that is failed all the times, on the description field says "null". Applications Name is: Gestion Comercial CLM Group, I have shared this app with support. Please let me know. Thanks.
How to export as a PDF using the new view?
There were several changes to the layout of the creator view this month and I'm a little confused. (Source: https://www.zoho.com/creator/views3/view.html) I'm trying to export one record as a PDF and can't find the option to do it. Zoho shows its done: and yet...my view only have the option of "Records per page". I also don't have the drop down where "Contact View" is. (The insert image option isn't working now...otherwise I would upload the screenshot). What am I doing wrong?
Live data feed no longer works!
I have a large Creator application that serves data to Excel via your old Export/HTML functionality (using Excel's External Data feature). Since your upgrade, this has stopped working. It seems your upgraded design does not allow me to have live feeds anymore. I tried using Excel's External Data functionality to link to an HTML view -- but this won't work because there's no way to disable pagination and show all records in a single html table. Export to HTML/XML/etc all seem to generate a URL
Passing Parameter to an Embedded View
Hi, Is there a way to pass parameter into an embedded view to display only select records? Thanks! V
Wrong entry populates form when submitted.... Argh!
I'll try to make this brief..... I have an application that has 2 forms (Buy and Customer) and two views (Buy and Customer), and one HTML page. Form "Buy" is filled out and then submitted, which then generates the HTML page from which I can send straight to a printer. Problem is when I have 2 entries that are similar (these are names - Last_Name and First_Name), the wrong entry often gets put on the HTML page. So if there is, say, a "Thompson, Darryl" in my database, and also a "Thompson, Matthew",
New UI seems to adversely affect two column Forms that contain CSS and HTML in notes fields
Hi Zoho Team! I have been using Notes fields to display dynamic data in my Forms using a combination of deluge script, HTML and CSS. Immediately upon trying the new UI for views yesterday I noticed that a number of my forms were displaying their content differently. On forms that used the two column layout (as opposed to the single column layout), Notes fields were dramatically changing the widths of the columns. These columns have always been locked into a 50/50 split of the width...in other words
Need help creating custom invoices
I am using Zoho CRM for my ad sales, but it does not allow me to create a sales order that will work as an insertion order because I need special fields for each entry, like start and end dates. It seems like I should either be able to create a form in Creator and embed it in CRM sales oder or create a custom form with an html view like an invoice. From all Iv'e read this is doable, but I can't figure out how to use creator enough to do it. can someone either give me some tips or point me to a tutorial.
Help Help Help
I'm having a hard time with this simple thing. I want to set the email address according to who the lender is. Can somebody please help me with this simple. If the input.lender is "mary" then the input.lender_email = mary@test.com I cant seem to get this simple thing to work in script.
Write to a third filed based on selection form dropdown.
Hi, How would I accomplish the following task using an ON-Input Script? I have a table where I keep employee Name and info. In the same form I have filed called Roles which have a value of Admin, Employee 1 ext. I would like to add an on imput script that would automatically write a value to a third filed called Rate. If Input.Empoyee is equal to Admin write $40 to the Rate filed. Thank you very much for assistance in advance.
Copying application doesn't copy data
Rather than shut my site down to deal with your new behavior of not allowing public views in private apps, and not allowing to get get an embedded shared link from a view that's in a public app, I thought I'd copy my app, make the copy private, then get the embedded shared link for each of my views and update my pages. But my data wasn't copied with the app so it was a complete waste of time. maureenshea
CAN I PRINT ADDRESS LABELS WITH THIS SOFTWARE AND IF SO, HOW?
How2 do I print address labels?
Order online with zoho creator
Good evening, I asked whether it was possible with ZOHO CREATOR or another application, put on the website zoho a control module online for my clients. Namely, I give a password to each of my clients selected, and when he connects he can choose the product and order online. And I get double the order. I ask because I read somewhere that it's possible but I am French and I do not read English, I use a translator. thank you
new calendar view - display field
The text displayed on the weekly calendar view is very brief and can only be based on one field. It would be helpful to be able to display multiple fields as the display field and show the full text of the field by wrapping the lines when there is sufficient vertical space or otherwise showing them on mouseover when there is not enough space.
User Option >> Add linked Record
I am really hoping I can achieve what I need in Zoho. I have two Forms: Patient and Follow Up. Patients will be a list of patients with various details. Follow ups will be a list of notes linked to individual patients. There can be many follow up records to a single patient. I need help with: 1. Generating a short but unique ID for each patient. 2. Allowing a user to select a patient id (linked) from the Follow Up form. I have tried using the Zoho ID but it is too long and meaninless to the user.
One or more fields were dynamically changed
Getting the message "One or more fields were dynamically changed. Please resubmit the form." What could be causing this? I have neither On Update nor On Success scripts in my form.
Can't embed view on website (for public view)
Am on free plan and worked hard to develop small creator database and view. Now it tells me I can't do a public share embed even though I only have two other apps. Thought I was allowed 3. https://creator.zoho.com/phillytechnews/mmm/#View:mmmform_View
form grid view rich text
You should be able to limit the height of a rich text field in a grid view, or at least make it look similar to a multi-line format. If there is a lot of text, the height of each submission gets a little ridiculous.
How can I include subform data when submitting a form via email?
With regards to the help topic on submitting a form via email: https://help.creator.zoho.com/Email-Data.html#Adding_form_data_via_e-mail_in_user-defined_format I have a form with a subform. I need to be able to submit the subform data via email as well - my case a Customer has an Order. Can you please clarify how I can do this? At the moment my Customer Email Template just shows available fields as: Field1: Field2: Field3: Order: Putting values into Order: doesn't seem to work - is there a way to
An open letter to the CEO of ZOHO ...
Warning: this post contains strong language that may be deemed "disrespectful" by the targets of this complaint ... the author makes no apologies as it reflects the anger that he (and his clients) feel about the systemic problems with the ZOHO Creator platform. Sridhar: Following on the heels of the snafu in April (whose report I am still patiently wait for), the ZOHO Creator Team made another platform change a couple of days ago ... and promptly broke existing functionality ... for two of my clients,
Restore my earlier settings
Dear Sir /Madam Good Morning Last week I have received a popup at header level for updating some ZOHO features. I updated the same. But after updatation I found all our forms become left align. Could some body tell me how form can be align center or how i can restore my ealier settings. Shiv
Fetch and Update records from sub form
I have a parent for in which have a sub form with several values in each record. how can I fetch and update the sub form in the parent form
new calendar view - display field showing html entities
The display field is showing " :" instead of a space character when it is set to display a lookup field which uses advanced display options consisting of more than one field with a space in between. For example, first and last names.
Note Width
How to set a fixed width for the "add note" field?
Minor Changes/improvements to Zoho Creator
A couple suggestions for Zoho Creator When Adding or Editing a record from a view show the Form name on top instead of Add Record or Edit Record. When sorting a view by a URL field sort by the link name instead of the URL
Hide all fields "on load"
Hi, Anyone have thoughts about how to hide all fields "on load" without having to enter each hide/field command individually? It would be great if there were a script that would auto hide all fields on load. Thanks. Robin Hide
adding a new user
I want to add a new user so they can view my forms and reports, but I do not want them to be able to edit any of them. I also want them to be able to sign in with their own username/password. Is this possible? I am currently using the free version of creator. Thanks.
Using two pick lists and call functions
Hello, this may be an easy question but I cannot get it to work for the life of me. I am using Zoho Creator and am trying to get the records of my accounts in a dropdown list (this part works fine) and then get the associated contacts in another dropdown list ->on add->on Load crmAccount = zoho.crm.getRecords(("Accounts"),1,200); for each AccountName in crmAccount { Company_Name:ui.add((AccountName).get(("Account Name"))); }and then on the account drop down list on update I want the next list
How to enable this functionality?
I need to make a following application: I post jobs that a selected group of individuals (workers) may choose to accept. Not all jobs will be offered to very individual. After reviewing the list of jobs, a worker may choose to bid (and add a new offer) or not to bid. A worker should login to see jobs offered to him/her and review the list regularly. I want to create all this with just two tables: jobs and offers. I encountered a problem that I don't know how to overcome. How can a user hide a job
Next Page