Go to URL after form
From a list view, I have a custom action which leads to a form: void Company.AddCalendarEvents(int CoID) { openUrl("#Form:Calendar?Company=" + input.CoID + "", "same window"); } Once I enter values, and hit submit, the form re-loads, but it's not useful to me as the Company Value is not pre-loaded. I would like to either: - have the form reload with the same CoID value OR - re-direct to a different url what do I do?
Can you filter a subform based on a data in the main form?
Can you filter a subform based on a data in the main form? Example I have an employee Data Form and an Employee Time form (for time entry) Can I add the Employee Time as a subform to the employee Data form and only show the time records for that employee? does this make sense?
Creator form code to embed on webpage (not iframe)
Is there a way to get the html / java / whatever code of a creator form so I can put it on my webpage? The iframe embed code does not work for me as i need to be able to add my own css to the form. I need to be able to manipulate the way the form is displayed beyond what you can do in creator. If i could get the source like you can for a CRM form i should be ok. My main problem is i need to put the form at the bottom of the page and the drop down menu from the search form field appears below the
Using ZCStyles
Hi I found this application called ZCStyles (https://creator.zoho.com/public/showAppInfo?ownername=srhyne&callbackUrl=zcstyles) and tried using it. But, noticed that the <style type="text/css"> tags got wiped the next time I opened the note. Maybe that's a bug? Could you please guide a little how to use this application? Could you please guide on changing the theme of my application? I have my own theme and want to customize the application's look and feel.
quote a column in HTML hyperlink
Here's a part of my code below, <p align="middle"> <a href="<%=y.Map_Link1%>"> <%=y.Name%> </a> </p> <p align="middle"><%=y.Map%></p>An example of expected output, two lines for each of the record, both contains hyperlink XXX school (name ONLY) XXX school map Map_Link1 is a column in my form contains all the Google Map addresses for each of the schools. I don't know what to change in order to make the href part to work. Here's a wrong output I have. 75th Street Elementary
File uploader tool has stopped working
I can no longer access any of my Zoho accounts through the File Uploader tool. Do you know any possible reason for this? Earlier it was working but now i am not able to login into it. Your team has suggested us this tool to bulk uplaod the files from the hard drive via an exe file. You have provided the below given link to us to download it :- http://code.google.com/p/zohoclient/downloads/detail?name=FileUploader.exe&can=2&q=
Problem Setting the Field Permissions
I am a Zoho Creator Enterprise subscriber. For the last two days, I was not able to set or edit the filed permissions for all the profiles. Does anyone also has this problem?
Error while summing rows in subform
Hi, I have a subform called Bin_Weights. I am using the following code to calculate the total net weight: temptotalB = 0; for each record in Bin_Weights { record.Sub_Total = record.Net_Bin_Weight; temptotalB = (temptotalB + record.Sub_Total); } input.Total_Net_Weight = temptotalB; The script saves but has the following errors when I run it: Error details: Error in executing On Add Row script of Bin ID. Error. Error in executing For Each Record task. Error in executing Set Variable task.
All Requests report wrong HTML
As you can see from the attached picture the issue I'm experiencing has something to do with HTML escapes. It seems Zoho sends HTML link code (subject column) with < and > instead of < and >. This leads the code to be incorrectly interpreted by the web browser as plain text instead of HTML. Any advice to resolve this issue? Thanks, Marco
How to set up a detail Records Count?
I need a quick report of how many records per form I have in database. How do I set this up?
Best way to create Master-Detail Forms / Sub-Forms
What is the best way to create a master - detail form when a master has multiple sub-forms where each sub-form needs to be entered and maintained by a different role 1. Create a master form and then in the master form add sub-forms. Assign access rights for each sub-form based on roles. I guess in the form entry and the form report view this will show only those sub-forms assigned to a particular role when they are viewing it. Also in the Record View it lets you select the sub-forms to be added to
Accessing text of lookup field record rather than record ID
I've been working for several hours on trying to retrieve the String value of a record that I am accessing via a lookup field, but I cannot seem to figure out how to do it. Here is the script I'm using: RepresentativeItems = (Products1[Representative == input.Representative1.toString()].ID).getall(); Basically I want to be able to populate a subform with all of the product sales by a representative, which I will select from a drop-down list, as you can see in this photo: My problem is that when a
Call Function with CRM
We have a "Product List" app in ZCreator and when we add/edit/delete a line is this app we want this data to push to "Products" module in CRM. I seem to have configured this correctly other than on edit and delete I can not access the unit price field because it is not a string field. I have been editing the app and On Edit -> On Success -> Call Function (Integration Task) with CRM -> Update Recod Thanks for any help
Published Report Permissions
Hi, When I set the criteria on my report to.. "Email" == zoho.loginuserid ..it works fine when I access the application, but when I publish the report and access that particular published URL, no records display. However, when I set criteria to.. "Email" == "me@myemail.com" ..all records with "me@myemail.com" are displayed. Why does publishing criteria work for a hard-coded values, but not work for system variables? This seems like a bug..
Error on add row script in subform
Hi, I am using a subform called Order_Details to enter the products and quantities on a Purchase Order form. In order to filter product availability by Supplier, I have written the following script which runs "on add row". itemlist = Winery_Supplies [Contacts == input.Contacts]; clear row.Product; row.Product:ui.append(itemlist.Winery_Product_Name.getall()); The script is filtering the products by supplier in the Product field but the following error appears when a row is added in the subform:
Signature Field
Hi, We have equiped our Sales Team with Android tablets which they use to record site visits. What we would like is a field for customers to sign a free form with their finger or stylus which records their signature in a field as an image for future reference. Is there any way to currently do this or the scope to do it in any future release (if so, any ETA)? Lastly, would be good for paying users to be notified of any issues with the platform currently experienced. This will reduce support cases
Permission Denied To Update Record(s).","code":2897
Using the REST API (I know where the documentation is : (https://www.zoho.com/creator/help/api/rest-api/rest-api-edit-records.html) to try to update a field on a record. Am getting a response with error 2897 - Permission Denied to Update Records. The view has edit permissions already. Here is the request url: https://creator.zoho.com/api/<owner>/json/student-record/view/myob_invoice_line/record/update/?scope=creatorapi&authtoken=<mytoken>&criteria=('ID = 1612333000001258123')&SYNCDATE=20140905Can
Can MS Access 2013 Custom Web Apps Use ZOHO Creator
The "Custom Web App" Template in MS Access 2013 is designed I believe to be "created" on SharePoint or on what MS call the Home365 versions that support (via shrepoint again as I understand it). It would be a good thing but I do not have access to SharePoint of the Home 365 equivalnet. So my question is can I create a MS Access 2013 "custom web app" on my ZOHO account? If so - what would be the general Web Locactin URL/Address ??
For a List type report is there a way to display/print only the totals rows?
For a report type of "list" you can group by certain fields. When you run the report it shows the grouping header row, detail rows and then a totals row. I want to display/print only the group heading and totals rows and not each detail row. Is there a way to hide the detail rows so that only the group header row and totals row displays/prints? For example we have a table that captures payments (receipts) from donors. This table (view) is linked to the donors table. On the donor summary by name
Can I randomly sort a view?
Hi there! I have a view / report listing potential penpals which is embedded on a website. People are more likely to choose the people listed on top of the list, which I think is based on how recently the record was added or modified. We would like every penpal on the list an equal opportunity to be selected, so we would like the ability to randomize the way the records are listed. Can this be done? Thank you! ~Reed
Confirm nessage before executing a custom action
Hello, do you know if it is possible to add a classic confirm message before executing a custom action? Something like a javascritpt confirm "Are you sure?" (Yes or Not). Thanks
Zoho Creator - Zoho CRM Zapier link
I have a number of zoho creator forms. I have set up Zapier triggers to zap over the information to Zoho CRM. It works fine with a manual entry to the form. However, when I imported from a spreadsheet into one of the form databases, it failed to trigger the zap of data over to Zoho CRM. I have questioned Zapier and they can find no error on their end. They said "It appears that possibly the API does not support spreadsheet uploads". and suggested I contact Zoho support. I have not heard back from
Sort in For Each Statement
Hi All, I am using the Deluge "for each" statement in a script but I need to treat my records in a certain order. Do you know if I can use a "sort" statement within my "for each" ? It does not seem to exist. Any workaround ? Many thanks ! Guillaume
File Upload Tool
The Zoho FileUpload tool which allows for the bulk upload of files into a File Upload or Image field is not allowing me to login to any of my applications. Is anyone else who uses this tool seeing the same problem? Is there something wrong on my end or is the application broken?
Unable to Connect to Messaging Server
I am constantly getting this message in Zoho Creator. I have not set up any SMTP messaging server or mapped any custom domains.
Help with permission of field
I want certain fields to only be accessible to certain users in my company. When I click on the "Show field to" under permission in the field properties, it only shows 'Everyone' and 'Admin Only' Hew can I add individual users to this list please. Thanks
text field limit length
I have a form that gets filled out by a posttoUrl. Basic information , Name Address etc.. Recent changes in the data has my text field for zipcodes getting the zipcode +4 . I need to validate the text field is only 5 characters and eliminate anything after that
Using 1 field to pull multiple fields from another form
Hi, I am very new to this program and I'm hitting a few roadblocks. I'm trying to look up a name on one form, but I need to pull a few items that is in the record into my existing form. For example, in the first form, I am using a look up to find the doctors name that is is the second form. Along with pulling the doctors name from the second form, I want to pull his credentials and city and state into the fields and prepopulate those fields in the first form. Help! Thanks! Trish
Import File Exvel
Anybody know what is the limit of records that can be import from Excel file? I need to import a document with 19000 rows in Excel and I'm not sure if Zoho allow this.
disabling a mandatory field
Hi, I have a form in which I am using the hide and show features to customize the form fields according to the selection made in a lookup field. This functionality is working fine, thanks to advice from the very helpful forum community. I have three fields in the form that are mandatory: -Vineyard -Grower -Lot Depending on the selection made in the lookup field that customizes the form fields through the hide/show feature, either: -Vineyard -Grower or -Lot is displayed in the form. For example,
Deleted data
Is there currently anyway to retrieve any data once deleted? Can I become a paying customer and then have this service?!!!!
help with script please
I have created a customer database When I wrote I put number field for tel.No. it misses out the leading 0 So I have created new tel no field using single line All works fine apart from me having hundreds of entry's in old telephone field that I want to move to new telephone field. I wrote a function to do this but I cant get it to save Can anyone help please. Function reads as follows....... void telnos() { for each rec in Jobs [((ID is not null))] { input.Mobile = input.Mobileold; } }
Default setting for Rich Text field
is there a way to have a default value for a Rich Text field? For example, I want a table in the field. I tried loading the table into a notes field, and then having the RichText field = the value of the notes field, but that didn't work
Deluge Script Disappearing in HTML Views
Hi, First time I have used HTML views was yesterday and I was finding them very powerful and had screens working perfectly, however this morning I have looked and lots of the deluge code is now missing! Seems to be the <%=rs.X%> in the cells of tables. I am using Chrome on a Mac. Has anyone had this problem? Thanks Gordon
Validate that file name of upload is not a duplicate file name? SOLVED
(FormName[File_upload == input.File_upload].count() > 0) doesn't seem to work. Neither did (FormName[File_upload.contains(input.File_upload) == true].count() > 0) Any suggestions? (And as usual any help will be greatly appreciated!) SOLVED IT: The problem with the above attempts was that ZC adds a unique string of digits prefix to the front of each File_upload field string to differentiate that file from files uploaded to other records which might have the same file name. The solution
Need to combine 2 fields together
Hi, I am trying to merge a date (Start_Date) and a time (Start_Time) field into 1 field (Start_Date_Time). I need there to be a soft return between the Date and Time in the combined field. So, first, what kind of field do I use? I am using a multi-line field so I can create the soft return in the field. Any help would be appreciated. Thanks! Trish
Creator embeded form look up fields are transparent?
I want to use a zoho creator form on my webpage but i need a way to modify it's appearance. You can see my form on my webpage below. It is in the orange footer at bottom of page named (Boat Selection). http://precisionsails.mybigcommerce.com/ I cant seem to figure out why the drop down fields are transparent. I want them to have a white background, not transparent, how can i change this? These are lookup fields in my form. Also is there something i can do to have the menu that drops down appear up
Is this kind of workflow possible with Zoho Creator
I’m currently evaluating Zoho Creator and am just wondering if you could point me in the right direction. I have a process I’m trying to move out of lotus notes. In a nutshell: User fills in a form with a few details: Product name Product supplier Price This form is then sent to a department for approval. If they approve it, they add a code (free type) to the form. The form is then sent on to yet another department, who do something else with it. At this stage, we need to save a copy of the completed
hide command not hiding fields
Hi, I have a form named stage with the following field and data: -Stage -Grapes -Fermenting -Juice -MustI have another form named Analysis that contains fields that I would like to hide in function of the stage chosen. For example, if the user chooses "Grapes", I would like to hide all fields except Brix and pH. To test my syntax, I have only been trying to hide the "Lot" field. I have used the following to try to accomplish this: if(input.Stage.toString() == "Grapes") { hide Lot; disable Lot;
Editing the email contents in automated email notifications
I'm trying to setup a form to notify different email addresses based on the zip code entered in the form. The email notification needs to have the form data in the email body. I try to update the email notification with the HTML code below but it doesn't save. Name: <%=Name%><div><br></div>Email: <%=Email%><div><br></div>Zip Code: <%=Zip_Code%><div><br></div>Phone: <%=Phone%><div><br></div>Contact Method: <%=Preferred_Method_of_Contact%><div><br></div>Service Needed:<%=Service_Needed%>
Next Page