How can pass a selected client to another view, and list all of the associated notes for that client?
I have a form that allows me to add clients. And I have another form that allows me to add notes linked with a chosen client. I would like to be able to click on a client from a list view, and be taken to a view showing the information for that particular client, and also have all of the notes that are associated with that client displayed right below the client information. Is there any way to do that?
How do you create a date variable
I am building a function and I'm trying to create a date variable... instead of a variable of type long: DateToAdd = input.startDate.addWeek(WeekCount); That creates a string for the variable DateToAdd... is there a way to do this?
Published application updates
Good morning... I was wondering what happens when I publish an application and someone installs it, and then I update the application (enhancement or bug-fix). Will everyone who installed get the new version automatically? Do they have to re-install? Will they loose their data? Thanks,
Clear Database
I know we can do this with script delete from MYDATA[ ID != 0 ]; But it takes time and the browser window cannot be closed during the operation. It would be handy to have (maybe in the edit view mode) a button to click to clear an entire database of records. Cheers, John Whitney
Field from subtable not viewed by Report Builder
Hello, Thank you for Zoho Creator. I understand that with Report Builder, you can select data from only one view and for the data populated in the table. I have created a 'subtable' of regions and I select the required region thank to a drop list (Lookup) If a region has not been selected in the main view, it cannot viewed by Report Builder . Thank you in advance for your confirmation or if there is a possibily to have all the data from this subtitle even when not selected in the view (Value will
Only PDT time zone in Report Date: in exported .pdf views
Hello there, I tried to set the Report Date: which is displayed in the header (on the right corner) when export views to .pdf but I coundn't have any success, allways PDT time zone is displayed. Example Report Date:Thu Oct 13 09:44:59 PDT 2011Tried to change the time zone from the personal information and from application settings but the Report Date: from exported views not changed. Is this a bug of Zoho Creator? If not, how can I change Report Date: time zone for exported .pdf views? Thank you!
Sharing , shared details, when you click the user name, the details box does not show using FF
Actually it does show but it flashes for an instant then the Browser jumps to the top of the screen NOT real useful See attached, click and see what happens maybe its me thanks
Problem Creating or Duplicating Calendar View
When I try to Create a Calendar View, the form drop-down menu shows no forms. When I try to duplicate a Calendar View I get this error:
More Currency
Would you mind add Tanzania Shilling (TZS) into Currency list? Thanks
After intering data, View into individual record as a link?
It is possible? if yes, how?
Stateless Form and upload file
Hello, I'm using Stateless Form to edit another form data. It's possible upload file in Stateless Form and pass the file to the first form. Through setvar doesn't works. Many thanks Xavi
Two Forms Using Common Database
Is there a way to set-up two forms that use a common database? Example: Form 1: Application for Employment Form 2: Employee Database I would like to have both forms populate a common database. Thank you in advance for your time and assistance.
2 forms (light and big) for one entry in creator. how?
Hi! i just make one big form (20 fields) for working by manager with clients data (clients orders) in creator. how can i make a lighter form (5 fields) which client can populate for data via web-site. this populated on web-site data my manager will be manipulate via big form. so, light form - for web-site, for clients data at first, big form - for manager, for working and adding more data after processing client's requests. how can i do this? thank you
Is is possible to hide fields in edit form in a one view but not others
I have a large form and I would like to make it easy to edit certain fields depending on the view. Is it possible to hide fields in edit mode depending on the view you are in?
After filtering views show message: We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com
After filtering views show message: We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com Attached two webpages, with embedded zoho views, showing the same error.
Is it possible to get the IP from a website-name in ZC?
I am wondering of ZC can be used for the reading of an IP-address that belongs to a website, like PING or http://www.selfseo.com/find_ip_address_of_a_website.php can show?. It could be possible within ZC, or, perhaps, by using a service to which you send a URL which returns the IP-address. Reason: I use opendns to protect my users on the home LAN. My old ISP allowed both a fixed IP and the sending of Dyndns info to TNS-O-MATIC on my router. My new ISP does not allow me to use DynDNS type of updating
Displaying ID as different fields
Hello, For some other issues I have to use the "ID" to link one subform to another. Which is fine because in forms you can use the "Display as" advance option to display the field as a Drawing number or whatever else it may be. The problem is that in a HTML file it is displaying the ID as a long number - how do I script it so that the Drawing number (or whatever else I may be using) is displayed rather than a long, unrelated number? Many thanks Ben
Fetch records not showing in shared user
I have a HTML View. It has a search form and when I press submit I get the desired result under it. But when the shared user does the same , instead of showing the result , he is directed to the main form. Pls tell me how to solve this issue.
Limit number of characters displayed in a field
Is is possible to limit the number of characters displayed in a field? For example in the ID field of a record the number of characters is currently 18, however I only wish to display the last 6. Is this possible, and how is it done. Thanks.
Jquery datatable not saving state first time round
Hi there, Has anybody experienced an issue with Jquery datatables whereby the state of the table is only saved on the second attempt. For example, I press a button on the page which takes me to another page. When I go back to the page with the table, the state of the table should be the same as when I left it. The problem is, it only saves the state on navigating away from the page for a second time. Here is the code for my table: $(document).ready(function() { $('#data').dataTable({
We have made an update in precreator
Ok I will be the first to admit and say that this is step in the right direction Good work Thanks Zoho Creator Team ============================ Hi, We have made an update in http://precreator.zoho.com. The update should get rolled out in http://creator.zoho.com on or after May 30,9:00 pm PST. The update contains following enhancements: Support for using authtoken for making API requests to creator application. Now API requests can be made either with ticket or Auth Token.We will make detailed post
Looking for a developer
I've developed an application that I love but want to take it to the next level. Perhaps do some barcode scanning, an HTML dashboard etc... please email me at the address on embedded image of this post . And before the moderators get upset about me posting here, please note that I tried posting in the marketplace and got zero response. I will pay hourly by whatever form you want paypal, etc... please email me your experience and your portfolio and your hourly rate. This is a long term gig and I
"If Updated" Condition - Accountants/Book-keepers, Deluge Experts Please Help
Hey, I'm a little stuck on a problem with a script that updates a dollar amount and a percentage of an account's balance being paid off when a record is edited in another form - It works fine in the "On Add - On Success" action, which the vast majority of entries would be, but I can't seem to figure out how to get it to work or where to put it when "On Edit" Here's the script, where the new "Manual Payment Entry - Amount" record adds to the "Payment to Date" in the Contact Form Record, and calculates
Removing submit and reset buttons and resizing the fields
Is there a way to remove the Submit and Reset buttons? I have built a simple FAQ page and do not need to submit any info. Also is there a way to resize the multiline field?
NView not defined in the Workflow
I got this error message when attempting to save a section code ... NView not defined in the Workflow My code is selected_vehiculo= Veh_culos[Cliente_ID = cod_Cliente]; clear row.ECO; for each x in selected_vehiculo.ECO { row.ECO:ui.append(x.ECO); } How can i fix this problem?
Looking to hire someone to create my form
Hi, I am trying to create a application that takes in around 10 pieces of information from the website user. Depending on what has been entered, it then provides a final value (formulas required). The application is based on hair prices and the estimate value of the piece of hair will depend on things such as colour, length, if it has already been cut or not. As these are not all numerical values (for example, hair color), I cant figure out how to create the formulas. Furthermore, depending on what
problems editing in grid form
When editing in "grid" view I make all the changes I want however when i hit the save button it brings up an error message telling me that the records i tried to edit could not be saved. When editing in regular list view i can edit each record but once again grid form which would save me a lot of time is not working at all. PLEASE HELP!
"More actions" in embedded page
Hello everybody, I need to create a customized web & DB for a client and this obliges me to use the embed function, as my client needs a personalised URL, a header with his logo, contact info, etc. on top of the DB Everything seems perfect, but now I found out that the "More actions" menu is not option in Permalink/Embedded and I really need it so my client can export his DB, print it, etc. How can I sort this out?. Best regards and congrats for offering such an excellent product.
Cannot sennd email with attachment
Hi, I cannot use schedule to send an attachment with an email. Attachment is a view. https://creator.zoho.com/pranavdalal/findata/schedule/edit/ If I remove the attachment the mail goes through. Please let me know if there is something wrong with Attachment syntax. Thanks -Pranav
Tracking League Tables
Can somebody tell me if it would be possible in theory to create an App to monitor and track league tables using Creator and have these link with a players CRM profile? I'm running an Enterprise trial at the moment, and was just hoping to get a steer before I start the steep learning curve! Thanks M
Multi Select addition
I was wondering if there was say a formula or something that would add up each time an option in my multi select gets selected, and maybe total each option?
Functional URLs
I have a very simple search (Find nearest instructor). I want it to take the first half of a postcode (HU3, HU6 etc etc) and display records that match. Honestly thought I had it, but seem to be stuck! Any ideas (edit access given in hope....or maybe desperation!!)
Add or append values to a multiselect list from within a function
Hi, Am trying to do this Form A has a multiselect list could be (list or lookup) with say A, B, C From within a function i want to write "D" to the list, it does not get updated as D is not part of the list defined in Form A uu.Multi_Select_1 = thelist; (where the thelist contains D) Basically i am trying to emulate ui.add or ui.append from within a function Is this possible, i can live with a blank multiselect in Form A to which i can write any type of list also thanks
Update Multi Select lookup via scritp not following list order
Hi, I have a form with a multi select lookup field no alphabetical sorting set on the lookup field My other form which has the lookup values has lets say rows A , Z 1, Hello From a script i update the lookup field and my List:String({"A", "1", "hello", "Z"}); Problem, the updated lookup is not following the order of the elements of the List:String which i used Actually not sure what order it is following, maybe that of the form lookup, all i know is that it does not seem to follow the order i want
Lookup Criteria
On a form I have a lookup to another table. I want to omit records where a string field is longer than 5 characters. When I add this code to the criteria section of the lookup field Str_Field.length() > 5 I get this error Either the left or the right expression in a boolean expression in the criteria has to be a Form/Table Variable What steps do I need to omit these records? Herb Wexler
Tier 3 menu creation
Hi .. In my application The Top Menu is my Main menu and the Left menu is the Sub menus of main menu . Now i need a Popup menus for sub menus of Sub menu . Is there any possibilities to create popup menus or sub menus of sub menu Ex: Tier1 - Money Fact ---- > Main menu (top menu) Tier2 - Real Estate ----> Sub menu of Money Fact (Left menu ) | | Tier3 - Getting started Ownership These are my Sub menus of Real estate
How to? publishing app to marketplace that requires certain views to be set as public, views within HTML views to display without login.
If you publish an app to the marketplace without code, do the public/private settings for views and forms install with the application? Or would the client need to be instructed to set certain views/forms to public if the app requires it to function as intended? What is the best way to code a printable HTML with an embedded view, so that the user can then embed this HTML view into their website and display it without login? So far I see only two ways, make the form view public and use the "embed
A Behind the Scenes Look at Zoho Creator
In this post, I want to provide a behind-the-scenes look at Zoho Creator, a sense of what all of our engineers are doing. First, to step back, Zoho Creator was born of an idea I had way back in 2002. I sketched out the underpinning of a programming language, with some strongly held convictions born of my own experience. In the beginning, that language had no syntax at all - it was living purely as a set of database tables. In programming language parlance, I had defined the "abstract syntax" of the
How to add data to Zoho table from HTML view?
I have an HTML view that displays data from a ZOHO table called "Options". The HTML view also displays a radio button in the first column in each row of data in my view. Up to this point everything works fine. From here, what I would like to do is to allow the user to use the radio button to select an item in the HTML view and then save the selected item to a different table called "Selections". There must be a relatively easy way to do this but I am just not sure how to pass the user's selection
New User instruction
I am a new user, are there any instructional videos taking you through the basics, I will predominently be using the SFA features and so am interested in creating call backs, reminders and possible mass emails
Next Page