Replace MS Word Automation with Zoho
Hi, I am trying to import my ms access app in Zoho. So far so good. My MS Access app is using MS Word automation, running VBA code from MS access, to produce specialized MS Word docs on users demand. Users download them from my FTP area, where my access app is storing them. I am wondering if such a Word Automation scenario can be applied to Zoho, and better if such a "word processing server" exist. Best Regards, Theodore
Function not returning correct value
I have a test function not returning the correct value. int temp.temp8(int digits) { powernum = 36.power(input.digits); return powernum; } When I input 4, I get 1679616. When I input 5, I get 6 but am expecting 60466176 When I input 6, I get 4 but am expecting 2176782336 What are the number size limits or is there a problem with the power function?
Shared Apps listing in Home page is not up-to-date.
Even after an application is not shared anymore with a user, the Shared Apps tab on the Home page continues to list it. -Varun Yagain.
Change font color when a field has a value
Hello. I am using Creator to maintain an editorial calendar. We'd like to be able to see at a glance when a report has been published by making the text color change if the "published" field has a value in it. How would I script that? Would I use "on user input" or "on update", and what variables would I include? I am not a programmer so I greatly appreciate your help.
The Count Function / Deluge
I am migrating a database from Filemaker Pro to Zoho Creator. The database contains responses from online surveys submitted by customers of our software product. I am brand new to Zoho Creator and Deluge and I'm stuck on something I assumed would be easy. It probably IS easy but I could use some help. The records in my file contain three fields that I would like to count. Field 1 - "Edition". This field might contain 7 different values and it might be blank. Field 2 = "NPS_Score". This field might
Help with field please
Within my database I am using a drop-down field to sort the days of the month using the grouping feature. it works very well apart from one thing. In the drop-down choices I have (for Sept) 01 Sunday 02 Monday 03 Tuesday 04 Wednesday al the way down to 30 Monday Next Month (Oct) the 1st is a Tuesday So I have to edit the field and change the choices to 01 Tuesday 02 Wednesday 03 Thursday 04 Friday al the way down to 31 Thursday Is there a way to automate the field please Thanks
Import form and subform setup from ms access
Hi, being new to Zoho creator, I am trying to import an existing accdb. Is there a way to import the forms-subforms setup from my access app? I have a form with 8 sub-forms in my app that are used as data entry. Best Regards, Theodore
Use subforms for multiple entry
I want to add the production tools of our customers to a database. So a database with machines linked to an account in Zoho CRM. I have one form (MachineEntry) where you can describe all the specifics of a machine (name/type/year). From another form (MultipleEntry) I want to add multiple machines at once by using MachineEntry as a subform. Both MachineEntry and MultipleEntry contain a ZohoCRM lookup. When you add a line from MultipleEntry in the MachineEntry subform, it automatically fills the
Marketplace issues
I can't get the demo to run without pre-loading it with records that I don't want to transfer in the install. When shared or made public the app works fine. As a demo it won't work. What exactly is the demo? Is it a copy of the app? Could my problems relate to certain code that doesn't copy well? I can't delete Screenshot images...only upload additional images. Removing the app from Marketplace doesn't clear anything. Any insights are welcome...please help.
Street address
Is there a way to set up a form to accept the following? Address: Apt/suite: City: State: Zip code: I would like to be able to validate that the address is a real address. Currently I'm using a text field but I occasionally get something other than addresses when users input to this field.
Set variable not working in the custom button of stateless form
User Name: kumar.n Application URL: https://creator.zoho.com/appbuilder/kumar.n/reportissue Access To Support: Granted -Neeraj
Change the Order of Dropdown Items
Is there a way to change the order of items in a dropdown menu without affecting prior reports? I don't want to delete and re-add the items in another order because won't that mess up old reports? Thanks, Juliana
Why does Zoho hate me?
I've been trying to get in contact with support for a week and no response, then I started a topic and it vanished. Can someone please get in touch with me to review my issues? Thanks!
Configuring customer portal, but stuck on error 500
I tried configuring my customer portal, but stuck on error 500. Please see attachment... What next to do?
Email Data and field deluge name
I am trying to add a record by sending an email to the forms's email address. I am using a specific format to populate the fields. However, not all fields are populating. I have a field in the email called CallNo#. When i enter that into the field deluge Name field the system automatically replace the # with an underscore. I assume that i cannot use a # because on its use in URLs. Can somehow fields be mapped? I cannot change in the email field because they generated by a Commercial Computer Aided
Configure field actions - Zoho quick start guide error
Hi All, I'm new to Zoho and am following the quick start guide to build some sample apps and forms. I'm having trouble with an exercise in the Configure Field actions part (https://www.zoho.com/creator/help/getting-started/quick-start-guide.html#field_actions): While I'm trying to use the fetch deluge task to assign rec variable the value of the record to be fetched from the Product form, I use the expression: rec = Product[Product_Name == Input.Product]; Following all the instructions in the page,
Update records in Zoho forms - bug or error?
Hi, I'm trying to build a simple app that just adds points to students based on the type of networking events they attend. The following are the forms/reports used: 1. Students - list of student records with id, name and e-mail (and points accumulated) 2. Events - list of events with event_id, name and points 3. Event attendance - Form where I will select an event and enter student ID so that student gets the required points In the event attendance form, once I submit the form, I want the students
Published app, report function not working, why?
I just published an application to marketplace, why is it that the report function is not working? see here
Subform: On Delete successful
I have a subform and it is very important to know when rows have been deleted from the subform. As a result, I have actions on the On Delete Row in my script There is a bug when user click the "X" to delete a row from the subform but do not click update on the main form because they change their minds. The actions on the "On Delete Row" still get performed even though the row was not successfully deleted. As a result, I am getting unnecessary notifications. If the row does not successfully get
Deleted subform data persists in database
When I add data to the subform embedded in my main form (A), I can see the data reflected in the view associated with that subform. I just noticed that when I delete a row of my subform in form A, the data still appears in the view. Because I am using the subform data to populate another form (B), this results in erroneous data being propagated to another form. This is troubling to me - when I delete data from a main form, it is gone. Why then does subform data persist after deletion?
Can This be done?
Hello all, I run a Heating firm in the north and need a database system to suit my needs but struggle to find any software or online databases. The only software i can find that suits my needs is from a company call commusoft. The software looks great but the costs are really to high to merit using it. So the question is can i make a zoho creator database with such fictions as customer details, postcode look up facilitys, Service reminders, appliance database and fault history? The website for
How to create a list of missing submissions
I have a app that i made to capture time for our employees. I have an employee list that I am working with, so there is an established base list of employees. What i need to do is create a function (or a button in a stateless form) that will allow me to generate a list of employee who have not yet submitted their timesheet, based on a date field (Week_of). Any help would be greatly appreciated. Thank you in advanced.
Fetch records from drop down
Dear all, I would like to fetch a record from a drop down field in the main form to a text field in the sub form. can you tell me how to do it? thank you, michael
REstrict users to update certain fields only
I wanted to create a view so some users will only be able to see certain fields of a forum; plus they can only update certain fields but not all... how can I do this? Thanks.
Window closes unexpectedly with file upload
Hi, One of my users has reported an issue where she was editing the A012 record from the view at https://creator.zoho.com/essistmgmt/assets/#View:AGREEMENT_View She tried to upload a file to UPLOAD CUSTOMER AGREEMENT and then tried to change the file. She received an error message and the window closed unexpected. I was not able to reproduce the error as I tried creating test agreements and attempted to upload files. There is no mention of that error in the error log Can you please investigate?
User hits Submit button and goes to next page...?
Hello, I am new to Zoho Creator, and to scripting. I have created several pages of forms, and would like the user to click submit and go to the next form. How can I customize the Submit button for that to happen? Perhaps the bigger question is related to what I am doing. I am creating a database that tracks a Site, the Collections in a site, and then the Objects in the Collections at the Sites. I'd like the user to fill out the Site first, then tell me about the collections in the site, then the
how to get a report based a simple form's user input
How to: I am building an inventory database. I'd like to present the user with a simple Form to input an "inventory location". Once to user submits the location, the user is presented with a Report view displaying the inventory for the location. As with the standard reports the user could then edit, view, delete.... Is there an example for this and some basic guidance anyone might suggest? Thanks in advance B
change symbol
Hi, 3 Fields Name Job code Scan code Name John Brown Job code BRO1276/1/402 Scan code John Brown BRO1276/1/402 Code is input.scan_code = name = job_code All this is no problem apart from this I want Scan code to read John Brown BRO1276-1-402 I want - instead of / The reason I cant do this when entering the job code is that we cut and paste Can anyone tell me how to change the / to a - in a formula Thanks
Table pointing to itself
Am I right in thinking that you cannot have a field in a table that's a lookup to another field in the same table? I'm thinking of implementing a Glossary in Zoho and it would be nice to have 2 or 3 "see also" fields which users could click on to show other entries. A bit like a Wiki! (But I don't want to use Zoho Wiki .... just in case anyone was going to suggest that idea!) Alex
New App Builder: Set Filter on Lookup is not supporting a criteria based on another input field.
The editor basically just lies about succeeding to save but in the end, the criteria is not applied at all. I'm referring to criteria that include another input field e.g. SourceColumn == input.FilterValue -Varun.
Online Store login process
Building on your new feauture for payments, what is the best/suggested way to have customers login in order to be able to create an order. Note that I am using also Zohosites and I am trying to integrate everything into a decent online store application. I expect the customers to be able to browse my views with product details without loging in i.e. using public permalinks/frames. But when the customer wants to place an order then I need him/her to login in order to asign customer information
Login option based on database of registered users
Hello, I think I have read everything about login page which dated far to 2007. I wonder if any suggestions or changes been made so far? I am trying to figure out the way how to use the database form and allow users to enter their email (as username) and password ( as they chosen) to access a web page link. I believe it should be not as difficult, as database is there - form should recall and compare the data entered into fields to data in database and if correct send to web page. I think it should
Format Note Field in Script
Hi I would like to know how to format the note field via script. Thanks!
Sorry!! Unable to display this page
Just read with the new updates on the fix of the bug list, but I can't understand what's happening to my new published app in the marketplace... please see here
Parts average price/cost
Dear all, I have a form to enter parts used with the cost/price and kilometer in another form, I would like to have a historical average price and kilometer off all a particular part the question is: 1. how can I pick only 1 part from many parts, get the prices, then make 1 average price. 2. I also want to have a historical average kilometer used, based on the kilometer when they change the part. for example. maybe they change a radiator at 1000 km. then another at 4000 km. then the difference is
Add a folder on computer
When I enter a new record on my database I create a folder on my computer to store the results of the job. So I create the record go to the field for the folder name Copy the field entry go to my desktop create new folder name it the text I copied from the record My question is Can I get creator to create a folder on my desktop and name it as the content of a specified field Thanks
Exporting to spreadsheet - cannot get to the button
Hi I am having a problem on IE and Firefox when trying to export to a spreadsheet. When I click on the cog then export the list of options appears but they do not appear next to the export option. There is a slight gap so when trying to select the spreadsheet option it disappears. It's really frustrating. Does anyone have any ideas on why this may be happening? Thanks
Issue: Getting schedule to start based on subform variable
My application allows users to request invoices from our accounts department in the Client view by creating a record in an 'Invoice Info' subform. Currently once 'Update' is clicked in the main form, it determines whether a new entry has been made in the subforms (simple tally of records before and after the Update) and if there is a new record it sends an email to our Accounts Department with the relevant information on the client and invoice (from the sub and main forms). I am trying to extend
How do I find the string length of a multiline text field?
I want to limit the max characters in a multliline string and strangely there isn't a standard option. SO how do I do it in code? I tried if(input.mytextfield.length>500) but I just get an error.
Problems with nested functions
In my script, under a previous working version I had the following code and it was fine Version 1.0 temp = thisapp.udf_history.get_field_changes(input.HIDDEN_FIELD_CHANGES, "POSTCODE", ps.POSTCODE.toString()); However, when I made changes to my script, I kept getting errors so I was forced to use Version 1.3 postcode_string = ps.POSTCODE.toString(); temp = thisapp.udf_history.get_field_changes(input.HIDDEN_FIELD_CHANGES, "POSTCODE",postcode_string); I think zoho creator has issues with nested functions.
Next Page