Reporting on data entered into both a form and subform
Hi, I am struggling with something which seems pretty basic... I have a main form 'Booking' (parent item) and a subform 'Booked_Item' (child items). Each Booking may contain several Booked_Item's. I can easily enter details into both form and subform - this works very well. What I am struggling to do is produce a simple grid which includes one column for each field entered into both the Booking Form and Booked Item Subform. My thoughts on what could be the cause of problem (THIS MIGHT BE COMPETENTLY ON
Zoho Creator App - Show Lookup Selection on Load (Not "X option selected")
Can you change the app so it shows the lookup selection when the lookup is scripted with an on load formula? You have to select the lookup to see what is selected. Picture below is taken with newest creator version on IOS. Our employees are having to select the lookup to verify the default value.
Import Data to Look up field
Hi, I have two form FormA and FormB. FormA has a field -- Group Name FormB has three fields below TV station Group Name -- this field is the lookup field from FormA Type There are already records in these two forms.But now what I want to do is adding new field "Google Search" in the FormA in addition of existing field "Group Name" and delete all data from FormA and import the data again with two fields. But problem is that when I delete all data from FormA then it will automatically delete
Text without Space?
Hello, is it possible to enter some Text in my textfields without Space? Regards Carsten
Signature field not showing on PDF
I created a Record Summary for a form with a signature field. When I view the record the signature shows. However when I click on the PDF button the record summary shows but the signature image does not display. The same happens when I include the record summary as a pdf in an email.
Zoho Creator - Calendar View
Hi All, Is there anyway of word wrapping the value used in Calendar View? At the moment, each entry in the calendar is shown like "Spray Crops fo...." and some how I need this to be longer and not truncated. I have tried changing the column width for the view but this appears to have no affect. Many thanks for any responses!
How Can round the formula field result?
I have a formula field come out the result is" 24.6568532685244", How can I round it to " 24.65 " ?
Subforms
Hi All, I'm having a small issue with Subforms where I need to allow only certain users to be able to add information to the contained dropdown lists. This is difficult to describe so here's what I'm refering to: Is there some way I can show or hide these Add buttons? I thought that setting permissions for the Subform would solve this but not that I can figure out. I'm probably missing something obvious. Many thanks!
Disabled search function on report
Hi everybody, I don't want to allow my users to use search function on report. My report are filtered and i want to show only restricted record and not the entire list of my records. I notice that a user can use search function on report to show the entire list. (for exemple with put "not empty" on a single field) I found on zoho zupport that : openUrl("#View:My_Report?zc_Search=false","same window"); It works pretty well but i have a new problem. The adress in my web browser show this : https://creator.zoho.com/my_account/ressources#View:My_Report?zc_Search=false
Comma in the field of currency.
Hello, Has some form or script that formats the field of coin to receive "," comma, example: today if I fill in the amount: 20000 autamaticamente and saved as 20000.00 and I would like to save as 20,000.00. Thank you so much!
Creator to Quickbooks - Timesheet Module
Can someone tell me if it would be possible to create a Zoho Creator application that can interface with the Timesheet module in Quickbooks? I have seen in the documentation (https://www.zoho.com/creator/help/script/quickbooks-add-record.html) that the supported modules are: Customer Vendor Item Invoice Account Employee Department Is there ANY way to create timesheet records in Quickbooks from a zoho creator app? Thanks
getting "unable to connect to messaging server" message
I just signed up for a new account and am trying to setup a little database. When I clicked on "configure on click actions" to go to the Deluge scripts to try to make a timestamp field I got this "unable to connect to messaging server" message. That message is still there after 10 minutes. 2 questions: 1. If I had a real working database and my app was "unable to connect to the messaging server," would that prevent a user from adding a record? (Eventually I want users to sign up for a membership
Field permission settings not functions properly
Are certain field types unable to be truly set to Read Only in Field Permissions? Using Field Permissions for a specific profile, I have set a number of fields in a form to Read Only. However, users with the specified role can still edit specified Radio fields and Date fields even though they have been set to Read Only. Single Line Text fields and Dropdown fields I set to Read Only in Field Permissions are not editable by the profile (behaving as expected). Therefore, I know I have set up the Module
Work with DropBox or Amazon S3
Hi, I'm wondering if it is possible to get data from DropBox or Amazon S3 cloud storage? I'm storing thousands of pdf files there and I'd like to fetch them somehow into a Form in Creator. (they are quite organised and the filename can tell a lot of information about the content. They can be even in one folder/bucket there) i.e to get the data like: filename, get the url link to them, last update, etc. And then I'd like work with them further in Zoho Creator where I'm building my app. It would be
Script is not running on edit screen
I have some scripts running for some of my forms and I have noticed that these same scripts are not working when the record has been created and you go into the edit screen. Am I correct to assume from this that any script created for the form does not automatically run in the 'on edit' screen? Are you kidding me? Please advise.
Dynamic picklist
Hi, I have three form and each are inter related by lookup field --Market-- . Market Form ; Market ID County Form: County Name Market Name--( lookup field form Market Form) Fips State MVPD Form ; MVPD Name Market -- ( lookup field from Market form) county ( look up field from county form) I am trying to create dynamic picklist for county field in the MVPD form . When user select Market name of the MVPD form then county form will populate only those county name that are related to the County Form
Nested for each statement - evaluation form reminder. Any ideas?
Hi there. I have a course management app. Delegates are enrolled on a course, which has a number of events. After each event delegates complete an evaluation form. I want to create a function that checks who hasn't completed their evaluation form and sends them an email to give them a gentle nudge There are five tables I'm working with - Delegates, Enrolments, Courses, Events and Evaluations. What I had in mind was to create a list of all the expected Delegate - Event combinations, then to create
Test Vs. Production
I'm very new to Zoho, but is there anyway after testing my applications I can clean all the data and start using the application for production?
Variable 'row' is not defined
Anyone else seen this error message ? Help appreciated. Trying to auto-update subform price once the subform product selected. The price is to be fetched from the product form. Going crazy as this code is taken from a ZC blog and cant see why it doesnt work. ZC doesnt recognise the phrase "row" ?? //Fetches the information from the "Products" table selected_Product = Productsform [Product_Name_Field = row.Order_Item_Name]; //Updates the value of Unit Price using the stored value from "Products"
Passing data to a lookup field in a form
Hi there I wonder if anyone can help. I've created and published an evaluation form which has a lookup field to my delegates table. I'd like in the email I send to include a url so that when they click on it it automatically selects their delegate record in the delegate lookup field. I just can't seem to get this to work. Not having any difficulties passing data through urls to place into normal text and date fields, but can't get it to work with lookup fields. I thought it might be that I needed
Giving a Variable a Parameter Value
Dear All, I have an HTML view with an embedded Stateless form the form has a drop down menu. When you select an item from the drop down menu and click on the stateless form button, the stateless form will open the same page but will add a parameter called ParaID. How can I get hold of what that parameter is? How can I create a variable, let us call it "SelectedParaID" and give it a value = ParaID Thank you, Sam
Publishing app to marketplace
Can anyone please explain to me why I haven't received any feedback regarding a ticket i opened with support a week ago?! Ticket number [##5425448 ##] I have finished up my application and until today cannot publish it on the marketplace.. this is getting extremely frustrating! I sent credentials to support, granted edit access to the support & done everything as requested.
Plus sign in URL parameters
I have an application in which I preload values into a form using URL parameters. These parameters are generated from an external (to my app) HTML page using a form submit. These values are user inputs that are likely to contain both spaces and plus signs (+). The URLs are properly encoded, with spaces changing to "+" and the plus signs changing to "% 2B" (without a space). However, when we get to my Zoho app, the values automatically populated into the Zoho form do not convert the"+"s back to spaces.
Multi Select Checklist hide other field if certain selection
I have a multi select field that has about 10 check boxes representing products. Any number of check boxes can be checked. When certain boxes (eye wear products) are checked off, i need to show another field for lens size. If non of the eye wear products are checked I do not want to show the lens size field. If an eye wear product and another product are checked I want to show the lens size field. I can't seem to get this to work. It seems that i partially works but the field does not hide when
Change order of Reports showing in the drop down menu of Creator
Screenshot Please indicate how I can arrange the sort order of the reports / views that appear in the drop down menu from a zoho creator app. I have looked around the forum and could not find any answers. Thanks
Zoho report/view with dropdown: limit values
I need to design a view/report based on a form, with a lookup field : it's a drop down with about 20 values. I need to dynamically limit and restrict the selectable values to about 3. However, the 20 values should still be selectable in other views... so this should not be programmed at the Form level, but at the view level... anyone had this experience???
Update field in another form
I have a form with Job_Details in it. For each job in Job_Details i have a JSA link to a JSA form. I want to make that when i click submit to create a JSA in the JSA form that it updates the JSA Complete field in Job_Details to "Yes". I have already setup that when i click the JSA link from Job Details report that is passes the Job_Number onto the JSA form. So i want to use the Job_Number from the JSA form to update the record in Job_Details with the same Job_Number to show that a JSA has been done.
Zoho creator app ios camera
Hi guys, I'm trying to understand if zoho creator is a suitable option for us. I have a question regarding the use of an app on iOS, is it possible to access the iPhone's camera through the app? What I need to accomplish is that the app (created with zoho creator) user can take a picture using the iphone camera and store the image in the form. Thanks!
IF syntax - user guide example doesn't work
Sorry if this is very basic, but I'm stuck when setting this up (I'm a very new user). For debugging simplicity, there is no other custom deluge code on the form (just a decision box, and a submit button). I'm trying to set up a conditional IF statement for the "on click" action of the button, that evaluates whether a decision box is checked. Taken straight from the user's guide, I set it up like this (substituting the name of the decision box on my form): if ( (input.box== "false") ) { alert "Please
Back up restore failed
Hi, I try to restore drc-timex v3 backup but the restore failed and I see the following error message : om.adventnet.persistence.DataAccessException: [t_255467000006116494] The size of the value [Atelier DVs Critères 2010] of the column [Etape_Missi_255467000006116516] specified in the row [ Could you please investigate ?
Disabled field format
I am having instances where a disabled field does not appear like the other disabled fields. It is a dropdown field, but not a lookup field...the other fields are all lookup fields and they appar correctly when disabled. When it is enabled, it looks exactly the same as when it is disabled
Mobile Forms Date Edit Causes Crash on iOS 8
I am unable to edit the date on a shared application as tapping on the field causes a white box to appear at the bottom and application is non-responsive.
data from a lookup field displaying incorrectly in email notification
I have a form (let's call it Form A) in which, among other things, a user selects a site name from a drop-down list. This list is generated using a look-up field to pull in the site names from another form (Form B). I also have an email that is sent when a user updates another field on Form A, and among other things, I want to pass the site name in the email. However, instead of showing the actual text of the site name, what gets passed is a string of numbers. I'm guessing this is some sort of key
Permalink using http
Hi there. I'm struggling with a website issue using Zoho embedded forms and to address it I need to turn the https links in my forms into http. Any idea how I can do this?
Report refresh for multiple users
Hello . Is it possible ,in zoho creator application, to update data in a Report view without refreshing a webpage after one of the users edited - apdated -created - deleted a record in the under-laying database . Regard Sergey
Using ZC and Google Apps: Manage Groups not available?
The Manage Groups menu item as described in the ZC help pages is not functioning. Anyone else?
HTML page return null
Hi there, I'm creating an html page where I'd like show a column of a form (Commesse). I attach an image that explain what I'm doing, anyone could tell me why result is null? Thank you
Calculating between dates
Hi all New to Zoho Creator but have come from FileMaker/Access style things. I have an "expiry date" and I would like to show "number of days until". According to my logic "expiry_date - zoho.createdate". According to Zoho help it needs to be "(expiry_date - zoho.createdate) * 60 * 60 * 60 / 1000)" [something like that]. But... well the formula syntax is right but the result is weird. I either get "3" or "-345600000". (depending on the various calculations I am entering!) So given the "expiry_date"
get current http - url as an initial value
Hi, I've been trying for over a year in Zoho to get the current browser address information (current url -http) to populate "on success". I have over 200 subdomains with 14 forms per, and want to know which "subdomain.domain" (browser address) the form was filled out from. In my case, I don't need to "get" the "/abc.html". Just [subdomain.domain]. As it stands, I'll need to build and track 2800 forms to accomplish this (or become a perl, java, php expert) I used to use Godaddy's "Easy Database".
Associating Subform Records with Main Form Record?
I am creating an application to schedule a person to go to different stores and perform inventory of items on the store shelf. I have created a Main Form and SubForm. The Main Form is for the Inventory Scheduled event. The Sub Form is the items that are to be inventoried at that Scheduled event. Thus when a new Main Form Record is created (Scheduled Event) I want to run a script which automatically add records to the SubForm and auto fill the fields (Items to be inventoried). I have written the
Next Page