Warning for Gmail users in emails sent via Zoho Creator
If you use Creator to send email notifications having at "From:" your Gmail address, the recipients with Gmail accounts will see the following warning on the top of the received message: This happens starting with today. It is not a message such as: "Sent via zoho.com" - but the warning above, which can make the recipient suspect that the message is not a legitimate one. I suppose that it is a change in the way Gmail "reads" the information from the email headers, but I hope that there is something
Need help email notification.
hello all, I would like to enable email notification on a stateless form, based on the following criteria: my application is based on managing the sales task force, I use the stateless form to update the status of the clients that the salespersons talked to. In the form, I do not capture the salespersons email id, but I do have their email i.ds. How do i enable, that when each client details is updated, an email is sent to the sales person about the status of the client, including the details? Thank
Frame tageting is broken again.
Hi. Behavior that has been working for 2 years is now not working. The submit success message is breaking the frame targeting. Use Case: 1) Target a frame using the anchor link attribute TARGET. Like this: 2) Open this page and click this link: Matthew Trouts <a class="_Lnk" target="tskCal" href="http://creator.zoho.com/ensobase/david_bartels/Listings/record-edit/All_Listings/243881000033951289/&zc_SuccMsg=Finished" style="font-weight: bold;">Matthew Trouts</a>3) The proper form loads in the Frame.
How to get current table name in the ZC Deluge?
Hi How to get current table or Form name in the ZC Deluge? Thanks Stanley Guo 2012-2-14
Is it possible to reference a form dynamically in Deluge Script?
Hi! Is there any possibility to reference a form dinamycally using string literals? Something like this: Form myForm = zoho.getForm("App", "FormName"); myRecords = myForm["Foo" == "Bar"]; It would be fantastic!
Cannot delete record
I have 2 forms: "EP Configurations" and " EP Core and Menu Default" I added lookup filed "EP" to " EP Core and Menu Default" from "EP Configurations" - > field "ID". Later I decided to get rid of this field. (I deleted it) Now, If I added new record to EP Configuration, and then try to delete it, system hangs forever. The only way I found to delete this record, is to create "EP" lookup field again on the " EP Core and Menu Default" screen I shared the application, you can take a look "EP
Help with Date calculation
Hello all, I would kindly like to request for help in writing a code that does the following: On my form, I have two date fields, 1 with the date, the client makes an order and the other when the client is to make a payment. I would like to do the following: within 14 days, of entering the 1st date, the second date should be updated i.e the client should make the payment, if not then send an email to the client informing him/her of the due payment. If however, within the 14 days, there is a payment,
How can I have Zoho Creator Data automatically entered in a Zoho Docs spreadsheet?
I set up a paypal payment through zoho creator and would like the info (conditional to choice made in a drop down box) and payment amount automatically entered to a zoho docs spreadsheet that is embedded in a private page so customers can see their balance in real time as payments come in. Does anyone know of a quick way of getting this done? Any help would be appreciated.
Newbie Q: linking tables
I really am a newbie with this and I am struggling to follow the way all the parts connect. First of all I wonder how tables are linked or for that matter constructed? I gather that forms are the basis of tables and views are used to display the data. But really I want several forms to send data to one table and I need some data to be created automatically, for example an ID field. Then I need to link tables, for example that ID field. I have a whole lot more questions but to start perhaps this will
Print Button?
I'm wondering if there is anyway to add a "Print" button at the bottom of a created form that will be embedded in a website? I'd like for people to be able to print the form they've filled out before hitting submit or have it automatically print when they hit submit. I'm not good with code or script so if that's what I need to do, help would be appreciated.
Zoho not working
Cant get access to Zoho Creator, are the servers down. Please advise as I cant work.
Printing one record per page
I have a view with a list of customers and products. I have grouped products by customers but now i'd like to print the list in defferent pages for every customer. is this possible?
Fix this please. Form does not show up.
OBR Consumer - Business Management Application shared. Form name: Business Order I can see the back end, not front end. I need this fixed asap please. Thanks
Can't copy or duplicate application
The application won't copy or duplicate, which of course is necessary to test it.https://creator.zoho.com/utl_la_rochelle/adherents-utl/ Can you help? Thanks so much Joël REMAUD Webmaster jremaud@utl-larochelle.org
Recent Improvements
I am sorry to say, but the recent improvements made to ZOHO Creator make it a lot harder for me to keep my data updated. The "locked in place" Add, Search, etc. force me to have all columns showing regardless of how wide the view is and regardless of what columns I am changing. I believe it used to float to whatever size the view was, or at least should. I cannot now find the "global" changes option to selected rows. I no longer see the number of records.
An instance for .contains() fails for .getall()
Re-posting my comment from here as a bug report: https://help.zoho.com/portal/en/community/topic/more-fun-with-lists I was testing the ability to fetch a collection of records as a list using List_B = {"c", "e"}; List_C = (DATABASE[(List_A.contains(List_B .get(0)) && List_A.contains(List_B.get(1)))].ID).getall(); I made a test app for support that uses this exact same functionality: https://creator.zoho.com/niskypto/list-test-2/# Use the "Select" form to enter two elements. You will find the alerted
Start a New Page for Each Record When Printing From Summary View
How can I start a new page when a new record starts if I am printing from summary view?
Problem with hide/disable of subform field
I have the following statements in the on edit on load section of a form hide Order_Actions_subform.Courier_Count; hide Order_Actions_subform.Owner_Count; They work as expected. However when I switch to scriptbuilder mode the statements are converted to hide Order_Actions_subform; hide Order_Actions_subform; Which hides the entire subform! Herb Wexler
How can I pass a value to restrict a picklist from a subform when adding a new record to the lookup form that populates the picklist?
For instance if I had a main form that contained the field "Country" 1. and a subform in which I needed to add a new entry into one of the subform's field's picklists 2. and the lookup form that populated the subforms picklist had both a "Country" and "City" field, 3. how do I filter the lookup's "City" field by the "Country" selected in the main form? Or in other words how do I pass a the "Country" variable value 3 levels deep to the lookup field. I can easily do it if it's a lookup for a field
Multi Filter multiselect
I am currently developing a resource manager for a group of shops and would like suggestions on how I can filter a 'Multiselect' field using a Lookup picklist listing area managers. I have 4 affected zoho creator forms. resource_form Field: available_to (lookup populated from shops_form[shop_name]) shops_form Field: shop_name (simple line text) Field: area_manager (lookup populated from manager_form) manager_form Field: name (simple text line) order_resource_form Field: multiselect (populated with
Zoho Deluge Script documentation--many images are broken!
Hello, I first noticed this last week, and it's gotten worse. The images for many of the deluge script documentation pages are broken. Examples: https://help.creator.zoho.com/Defining-a-Function.html https://help.creator.zoho.com/Invoking-a-Function.html https://help.creator.zoho.com/Delete-Records.html Many of these images are directed to "/attach/1.0/Deluge-Reference/" I've noticed that the -working- images are in "/attach/1.1/", but trying to get broken images by that rename isn't working for
Form list is not in alphabetical order
I have so many forms that I've had to go to a naming convention, however the entries are not in alphabetic order. How do I fix this? App is CIC Reports and it has edit access
restoring yesterday's accidental loss of data
Yesterday I was working on my application containing over 150 records and hit the restore button accidentally. How do I go back to Feb. 6, 2012 records?
ADD / Remove modules
hi..is that possible to rename the main modules like FORM, VIEW, and add extra modules ??
Could allowing email notifications upon form submission make my email address public?
I saw an increase in spam to my email address after allowing email notifications. Could email notifications make my email address public?
Dynamic picklists. Field selected vs field visible in form
Hi, when using Dynamic pick lists, how can I populate the pick list with say, IDs form the applicable records of the target list, and yet see other field in the pick list like name for instance. In other words I wan to emulate what the default picklist field does in a form. you link to a field but can see other field/Fields. I want to link to IDs but wan to see name. thanks for the support, application details below My application: Sistema de Operacion Yaxche Form: Productos Cotizados Dynamic Picklist:
Multi Line --> List
Hi, How can I convert data from Multi Line field into a string list (each line in multi line field to one list item)? Thanks for help, Leszek
Dynamically Updating Subform Links
Hi there, I'm having trouble updating systematically updating parent form links according to new subform information. I have a parent form, FORM A, which has the main information about an organization, address, phone number, etc. On FORM A, I have a subform, FORM B, which would contain transaction information. Each transaction contains a ton of information so I want to be able to add transaction information individually without having to go through FORM A each time. Because FORM B is also a form
How do I create a keyword list based on user input?
I need to be able to have a list of all keywords that have been entered popup so people can choose from existing keywords, or add their own, the way Google blog does. How do I do this? Is there an "other" feature in the value checkbox lists that people could put in their own words for categories etc.? I have to fix this to finish off our database and "go live. Help! Thanks, CatherineTodd, ctodd1000 at gmail dot com.
Formula - Net amount from multiple options
I have tried, and (probably stupidly) failed to create a formula that fulfils the following function. It is really a postage type formula. The following fields must be filled in by the sender: Letter type: *Postcard *Letter *Package Letter size: *small *large *packet Location: *UK *Abroad - Europe *Abroad - World I would like a "net value/total cost" type field to update depending on the combinations of options chosen. Apologies if similar questions have been asked before, but I would appreciate
Grabbing variables from URL Query String within functions
Is this possible? I have a custom action button set to appear on each row of a view, and as part of the action I want to be able to take some values from the record in question, as well as a parameter from the URL query string. I know this can be done in HTML views with parameters but is there any way to do this with a standard function script?
Image Field
I am creating a database for resources at my school, and am going to enter details such as name, location, etc. I want to enter a small image of each resource, so included an "Image Field", but can not seem to get an image to load. What am I doing wrong? Am I missing something obvious? Any help would be greatly appreciated. Thanks.
Searching creator app via mobile
I developed a creator app with multiples views that have the search function available. When I access the same creator app via my mobile phone, I cannot do a search in the same views. I don't see the search function anywhere. Can you please advise as to what to do since I need to be able to search for records via my phone. thanks, Ray
Variable not passed to subform record after the 6th record is added.
I have a subform that receives a value "Country" from a selection in the Parent form, when a record is added to the subform. The following script works up to the 6th record then fails every time on the 7th and stops the form from being submitted with an error. The attached screen shots are from the same page but it was too long so I had to capture into several consecutive images. There was a 4th image but just found that 3 attachments are max. ************* Code to pass Country to Subform record:
Filtering a View while the filtered field does not show up in the view. Is it possible?
Hi, I understand that in order to filter a standard view that is posted in an HTML view, it is necessary to have the field I want to filter for, active in the view. If this field I want to use for filtering is something meaningless to the user, say for example the record ID, I would preffer if the field actually does not show up in the screen taking valuable space that can be used to diplay more usefull information. If I diselect the field though then the filtering does not work and I end up with
Picklist behavior is strange and not working.
I pass a value of a Deal to a form to be looked up and then populate the lookup using the following code. if (input.cmd != "") { //input.cmd is the deal ID passed. theDeal = Deals [ID == input.cmd.toLong()]; input.Deal = theDeal.Deal_Name; }This is not working anymore. (I haven't touched this code in a year!) Also, why do these two drop down look different?
Open URL with Http Header
Hi, I would like to write the user help documentation with an external tool. I choose Google Sites - it's easy and looks good. Our costumer needs security, so site pages cannot be public. Then, I try to open the desired site page passing the authortization as http header. When I use getUrl it works fine but, then I receive the html page as text - I dont' know what to do with it. When I use openURL, ops, I cannot pass http headers. Is it possible to pass http headers to openUrl function? Is there
Search button on the views is not working.
This morning the search button was working fine, then stopped working. I've been trying the search button several times during the day and is not responding.
De- Dups, DeDuplicating, Removing Duplicates, Eliminating Redundancy
Stamp out and obliterate redundancy! I use Z Creator to keep a large database of addresses for a free snail-mail newsletter I use in my marketing. I am always trying to add names of new prospects, delete defunct prospects, and, in general, keep the list clean. I currently de-dup by dumping the list into a spreadsheet, sorting the various columns and using a simple formula to check for possible duplicates (If A2=A1 Print "Duplicate"). I then scan each possible Duplicate and decide to drop or keep
Calendar - Start & End Dates - automatically populate the dates in between
I wanted to use ZOHO Creator to build a holiday request system for my team, so they can request holidays, I can approve them and they can see everyone's bookings on a calendar view. However - I ran into the same problem that it looks lilke many 'Zoho-ers' have come across in the past.....at best you can register a START and END date in a calendar view.....but difficult to get the days in the middle - without manually entering a record for every day. Having looked through the forums & discussion boards,
Next Page