Sorting based on a specific record in subform.
Hi Zoho, I am in my trial period atm for Enterprise Edition. i am about to upgrade to regular soon and upgrade even more in couple weeks. this is my water testing period with Zoho database. so, please if you can, provide me with support as fastest if im about to bring my company onto zoho. i am still trying so hard to find a solution to set up criteria/ or sorting for view based on any single record at all in my subform. I have granted edit permission to support. please check it out. thank you kindly,
Express Plans - Users Create Accounts
Hello There are a few old topics on this subject but I can't find an answer. Using Zoho Creator with a Express Plan allows for unlimited users. Is there anyway to allow users to create their own users account either directly into the application, via the API or using a workflow. I'd like to provide a service where the user will provide their email address, password and other details and then be able to sign into my Zoho application. Thanks for your help. Ben
Alert Loses Focus
I use an Alert from the on Actions on User Action. After clicking OK to close the alert the original field does not have focus. In fact none of the fields on the form have focus. This is with Firefox. I have not tested other browsers. Herb Wexler
API issue, using REST to delete
Dear all, under Known Issues and Limitations for API's there is The user cannot delete/update the records for a shared application. What does that mean exactly, so any application I share I can not use APIs to delete or edit records from it. If so how come under REST API, Under Deleting records there is: When accessed by the application owner: https://creator.zoho.com/api/<format>/<applicationName>/<formName>/delete/ When accessed by a shared user: https://creator.zoho.com/api/<format>/<applicationName>/view/<viewName>/delete/
Critera using an "or" statement
Currently my criteria is saying "if field 'XYZ' is blank", like this: (XYZ is null) But now I want to say "IF field 'XYZ' is blank OR if field 'XYZ' equals 'Yes'" How do I write this? Thanks in advance. Jon
Parent fields empty On Add Row Subform in Edit mode
In my Invoice application I have parent form Invoice and a subform Invoice Lines. When a new line is added in the subform a script copies the unique id form the parent (Invoice) to the child (Invoice Line). This works fine when I create a new Invoice. However when I edit the invoice and then add a line in the subform the reference is not copied. The script is triggered but it seems that the parent field (input.INVOICE_ID) is empty in edit mode. Ivan
For Each statement creates duplicate emails
I have a function that is supposed to collect records of our agents who have not paid a certain bill. For some reason when I invoke the 'sendmail' routine using a for each statement it will send 2 notification emails to each address. I have only 2 records that match the criteria for testing purposes right now and the view I created to match shows just those 2 using the same criteria. Here is the function I call from that view to send the emails: void agent_management.getunpaidfullwebsite (string toaddress )
Zoho Creator (URL Request Structure)
Hello, I know I should really use the API forum area but it doesn't seem to receive as much attention as this one. I'm currently building an application which interfaces with Zoho Creator. I am trying to add records using the REST API. However, it does not seem to be working. My URL takes the form of: My application is definetly called 'Messages' and my Form is definetly called 'MessageForm'. Within this form is a field called 'User' that I wish to populate. https://creator.zoho.com/api/xml/Messages/MessageForm/add/apikey=<api
Help!: Can't view pictures...
Hi! When a user uploads a picture into the form, and you go into the view to download it, the following message appears: ""An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused." Why is this? Thanks!
How can I have 1 form or field update 2 fields in 2 separate forms.
My ultimate goal is to have 2 form field put data into 2 fields in 2 separate forms. Here is current code: if (input.Completed == TRUE) { lastWorked = Checkout [Checkin_Date]; } I get the following error: "Error in statement at line number 3A Boolean expression is expected in the where clause. and but an expression of type TIMESTAMP is specified here" I want to fetch the Checkin Date and input it into a different table. This could happen when someone clicks the "Completed" checkbox. What
Is this even possible?
is it possible to have subform within another subform? Company A : + Store 1: (Product; Quantity; Shipdates) + Store 2: (Product; Quantity; Shipdates) + Store 3: (Product; Quantity; Shipdates) so, a record of Company A should show 3 stores. for each store, there can be a list of products, quantities for each, dates. can anyone try this out? thx
Attach a created file
Our application creates pdf files based on information in the database. Is there a way to attach this file to the database via script or email after it is created or when it's being created?
Limit Submit per User [field] per a sepecific Date [field]
Dear all , i have a form containing 10 fields , i need to restrict the submition to only once per day , the rule should check the following fields to see if they are already submitted. e.g.. Name: (drop downList) containing names. Date: (Date of submition) thank you :)
Force a Save in Script for Grid View
Is there a way to force the save action for the grid view from a script? I have an html view that has 2 grid views and form embedded in it. When someone clicks submit in the form? I would like to force a save action for all changes made in the other 2 grids.
DATE fomula challenge. really need help
Hi , I'd like to have user enter a StartDate, then specify a duration (1 w, or 3 m, or 1 yr, kinda like a subscription plan). I need to get back the ExpDate, and the count down in days to it. This way, I can sort data to lets say 3 days notice before expdate. I really need help. Thanks so much.
Link Directly To Edit Entry
I have a schedule that executes every day, if an entry has not been modified in 7 days it sends an e-mail per a table requesting that the entry be updated. The e-mail contains pertinent information about the entry, but what I would like is for it to include a direct link to the entry for easy editing. Ideally this would bring up the same window as if someone went into the view then clicked 'edit' next to the row. Does anyone know if this can be done?
Hide options in Database View
HI In a database table view ,Is there any option to hide Add , Bulk Edit ,Delete options .. Thank You
Can you change the order things display under the Home menu?
I love this tool - but there's one thing I can't figure out - can you change the order in which forms and views appear under the Home menu? I'd like to group some things together but they are in the order I created them... Can anyone help? Thanks
Imported data in subforms not showing up in application View
I'm importing data into an application that has 4 subforms. The information is going directly into the separate subforms, but then it won't display in the actual application view. I've tried modifying the column properties in the application view, the subforms show that they are linked, but when I try to choose the field to display, I get a little yellow triangle error on the bottom, left of the page when I click done and no changes are made. Any ideas?
Two view requests
1) When clicking Edit on a record in a view the form opens with the words Edit Record on the top. Can this show the form name on the top? 2) When Summing a column of numbers can we add a label to the total row. When grouping items a label for each subtotal and then for the Grand Totals would improve the usability. Herb Wexler
Help Urgent
My Entry Form dont show up on user UI anymore. Need help urgent. everything else still there. I see it on my admin view. is this hacking issue?
Is it possible to add UTF-8 support to ZOHO view ?
oday I exported from ZOHO view the information and chose different formats. * I wanted to ZOHO view Export support UTF-8. * I am from the Latvia. * I am writing in Latvian language and I need UTF-8 support. * Attached photos. *** HTML version is UTF-8 support, and there everything is fine. **** Spreadsheet version is UTF-8 support, and there everything is fine. **** Version of the XML is UTF-8 support, and there everything is fine. *** JSON version is UTF-8 support, and there everything is fine.
order form and order details
I have built and order form and placed a sub form with order items. What I need to do is when the user selects an item to add to the order, it needs to look up the cheapest vendor of that item from another table and populate the vendor, price and item description to the order item record. Any suggestions on how to tackle this? I am new to Creator and Deluge script but not new to programming so technical speak is fine :) Thanks
While in application the forms and views are not sorted
I noticed that when designing an application the forms and view are presented in alphabetical order in the drop downs but when actually using the application they are sorted in some other order. I would like them to appear alphabetically on the application like they are when editing. How can this be done? Thanks! Parker Byron Network Administrator Kansas City Regional Homes, Inc.
SmartPhone problem on the form
I create a contact form and embed it successfully to my website. The problem is when I use my android (2.3.3) phone browser to access to the form, The captcha field doesn't display. Try with Firefox and Opera browser on my phone, The captcha field is Ok, but when I click on submit, the screen stops forever at "Please wait...." text. There is no problem when accessing by desktop computer. Any one is facing this problem? Your help would be appreciated.
Is it possible to validate e-mail field against my valid domain e-mails?
We would like to ensure people enter only a valid e-mail in our domain. Is it possible to validate this?
Embeded Zoho App is showing up as a header in Google Search how can I make this stop.
Usually a link for my site in Google shows up as the title of the page but when i embed Zoho instead of it saying {Contact Us} The link header says {Zoho Creator} how do I stop this.
Is it possible to export a filtered report to PDF?
Hello, I have a report in my application to which I have added two user filters. When I select one of the values in the filter, I can see that the report gets updated to display only those values associated to the filter. However, when I select 'More Actions > Export to PDF' I get the full report (including those items which I purposely filtered out). Is it possible to export the filtered report to PDF? For example. I have a report which adds the total number of employees per department. In my report,
Should Reports be This Complicated?
Hi - I don't know much about Pivot Tables but I want to be able to share a report with my team that basically looks like an Excel spreadsheet (but not showing all the data I have gathered). The pivot table seems very complicated and way more than I need. I would like the column headers to essentially be row 1. And then all the other rows would be the records that I have built in my database. How is this done? Can it be exported? Can it be printed? Thanks so much! Jon
Submitting Files via Email
Is it possible to create a new record including an attached file via email?
Pausing a script
Hi, Is there a way of pausing a script for an x number of seconds and then it continues. e.g. if(entry < 1) { show entry_does_not_exist; pause for 5 seconds hide entry_does_not_exist; } Thanks Nigel
another broken feature - cannot execute function in script editor
Yet another feature that has apparently been broken by the update on Friday... See screenshot taken in Chrome v15 which should be self-explanatory. The function is not executed and the modal dialog displayed is empty.
Notes and Terms and Conditions in Invoice tasks
Are "Notes" and "Terms and Conditions" supported in invoice tasks such as zoho.invoice.createinvoice and zoho.invoice.createdraft ? I read help page but it's not clearly said. We use these 2 fields for writing some information for customers. It seems that other fields including custom fields are supported. So, if it's not supported, could you support these 2 fields as well ?
Justify the data in a column.
I have a view and all the data is justified to the left in the columns except just one column of numbers. How can I make this column of numbers be left justified.
Update fields from external forms in creator.
Hi, I´d like to know how can I get data from fields from a form wich is in my App? This is the case: I´m building an app for Aircraft Maintenance so I have an Acronym, Brand, Serial Nº, Model, etc... I´d like to get this data in a different form only when I insert the Acronym. Is there a tutorial to get the data? Thanks. Antonio Rodríguez.
Multiselect - Returning all selected fields
I have two forms. The first form has a lot of information on different contacts. The second form has a multiselect lookup field where a person can select multiple of the contacts from a list. I am trying to write a script where it will them return all of the selected entries and add 1 to one of the fields. Here is the script I wrote for the same thing except a dropdown box instead of a multiselect: dat = Add_New_Contact [First_Name == input.Find_Person]; dat.of_Appointments = (dat.of_Appointments
calculating number of days
Sorry to be so ignorant on database forms and formulas, however, I created this simple db and cant figure out how to calculate the number of days between dates entered. we have level of care date 1 and level of care date 2 and so on. I would like to have Days Level 1 to Level 2 calculate for me. I have included pic. thank you for any assistance.
How do I edit once contact is created??
I have created a contact, and cannot figure out how to get back to the contact to edit more fields.
Dollar sign in currency fields give error.
Does it makes sense that we cannot include a $ in a USD currency field? I think it is common sense that a $ could be a valid character in USD currency field. What is the point of a currency field if the server is not smart enough to handle a dollar sign? This is very frustrating to my customers. (not to mention it cannot even handle a comma ,) Seriously, why would you use a currency field?
Send email depending on status
I have a field in my form "Status", and depending on the status I want an email to be sent to the customer to let them know what the status is on their order. The problem I am having is that every time I edit a record, it sends an email, even if nothing was changed. For example if the status of an order is "Completed", I can open and close the record many time and an "order completed" email is sent each time, even though I haven't changed anything. How do I set it so that the emails are only sent
Next Page