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
Similar way to PHP Sessions in Zoho Creator
A short tutorial in W3schools about PHP Sessions writes the following: When you work with an application, you open it, do some changes, and then you close it. This is much like a Session. The computer knows who you are. It knows when you start the application and when you end. But on the internet there is one problem: the web server does not know who you are or what you do, because the HTTP address doesn't maintain state. Session variables solve this problem by storing user information to be used
Is it possible to turn off Profiles and Roles?
I find the Profile and Role management extremely confusing. I prefer to use just the "Share" page under "Application Settings" and manage rights by user. Unfortunately, it looks like the Profile and Role settings are overwriting what is stated in the "Share" page. For instance, I set up a specific user so he can see just one specific report. The "Share" page is set up correctly, but because of the fact that his Profile is "user" and his Role is "Employee", he can still see other sections and
How do I restore a previous script version?
For some reason I can't update my script all of the sudden. It was working fine a few days ago but when I tried to edit the script today I keep getting a null message. I can't figure out why so I'm wanting to restore the script to a previous version that worked just a few days ago. I can't find how to do that anywhere in Zoho's help. Can someone tell me how to restore a previous version?
Fetch Data
Hi, I have created a form called Physician Demographics with an Auto Number field. Within the form, I created a sub-form called AZ Medical License which includes a date field called Expiration Date. I would like to set up a scheduled event based on this expiration date. I have created a schedule that runs on the date and would like to email a reminder to the Email1 on the record with an expired date. I have created a fetch data in order to have access to the fields in the Physician Demographic
Reserved seating
I'm developing a registration form for an event. Would like to allow for reserved seating. Actually reserved exhibitor tables, but seating seems to be more common use of such a widget. Any idea how to set this up on Zoho Creator?
compare with another form and delete the row if criteria Matched
Hi, I have two form FormA and FormB , There are two common fields between two forms. Below is the screenshot of the two Forms, FormA: Note: TV station : Look up field of station Name of Station Form Network -01 ; look up field of Network name of Network Form Network -02 ; look up field of Network name of Network Form Network -03 ; look up field of Network name of Network Form Network -04 ; look up field of Network name of Network Form FormB: Note: TV station : Look up field of station Name of Station Form
Validation function on Add and Update
Hi there, In my forms, I have a lot of controls with Alert messages that I have coded in the Validate functions on Add and on Edit. A lot of these validations are identical in the Add and Edit. How could I code once and use these validations in both Add and Edit ? I have tried to code a function "Validate_Form" but the Alert task cannot be called within a function. Any idea ? Many thanks !
Delete row from another form
Hi, I have a delete_form which have a field called -- TV Station . The TV Station field is the look up field from another form Station_List . Now when user select any station name from drop down list of Delete_form then I want to delete this station from another form LPTV_form , where TV station is the lookup field of the Station_List form also. I have tried the below code but not working might be because of two field are look up to another field if (input.TV_Station != null) { delete from
Allow an admin support staff to enter and edit records?
Some of our sales reps use a shared support staff member to enter and edit records in addition to the individual sales rep. What would be a useful form structure for this? Currently if a sales rep enters a record the system value Added User can be entered as a criteria in a Report to filter all appropriate records for editing purposes. The criteria would be Added_User == zoho.loginuser This is made more complicated if some records are being entered or edited by a shared support staff member.
is it possible to insert a record into a subform of one form, from separate form?
is it possible to insert a record into a subform of one form, from separate form? example: insert record into subform of form2, from a field in form 1
can you link to a file upload field in a stateless form
I have created a stateless form to show data from multiple forms. When I select a lookup in the stateless form I want it to give me a link to a file that was uploaded in the corresponding form.
auto populate lookup field based on previous field entry
Hi, I have form which has five field like below TV Station Form : TV Station Not -01 -- -- (lookup field from Network form) Not -02 -- -- (lookup field from Network form) Not -03 - -- (lookup field from Network form) Not -04 ---- (lookup field from Network form) Screenshot of TV Station Form view ; What I am trying to do is to fetch all respective values from the fields --Not-01, Not-02, N ot-03, N ot-04 to a picklist Network of below form when user select any station name. Say User Select TV
zoho reports is not updating
The following is the code I have used to update the data from Zoho Creator to Zoho reports, unfortunately it is not updating the records. And no error is generated at the creator screen. I just want to update one record based on date criteria. rowInfo = map(); rowInfo.put("Date", input.Date_field); rowInfo.put("NewDaily", input.New_Cars_Daily_Sales); rowInfo.put("UsedDaily", input.Used_Cars_Daily_Sales); rowInfo.put("WholesaleDaily", input.Wholesale_Daily_Sales); criteria = " \"Date\" =' " + input.Date_field
Next Page