setting user permissions for data access
Hello I'm currently building my application and populating it with data which currently stands at a few thousand rows and will eventually grow by a few thousand more. My question is that eventually I'm going to move this into a sustaining phase and will be trying to engage with external users to update data based on the company they work for. My goal is to limit view access based on organisation(s) or maybe an organisation and country. These are all currently captured in the database.
please add individual days of week to schedule frequency options
Please consider adding the days of the week as options for scheduling so that scripts can be set to only run on specified days - for example only on business days or only on weekends. Checkbox inputs would make this more flexible: [] Monday [] Tuesday [] Wednesday [] Thursday [] Friday [] Saturday [] Sunday
Default Values not working on Excel Import
HI There - It's Day 1 of Zoho for me and so far it's making sense. One issue that I need help on... My form has about 30 fields in it. Four of them have default values set up. When I start adding records I will always be importing an Excel file. The excel file only has 10 fields in it -- none of which are the ones that are supposed to have default values. After the import, the ten fields are populated, but the default value fields are not. What am I missing? The default fields do work if I enter
Public form for data entry by staff
I have a public form that uses captcha and sends two emails. One email is established under Set Email Notification, is sent to staff, and includes user submitted data. The second email triggers on Success and goes to the email account entered in the form. Because the form has hidden fields, I do not want to sent user submitted data back to the public website visitor. My challenge is this: Sometimes staff need to add data from hard copy, i.e. printed forms that clients have filled out. When staff
Displaying Subform records in HTML View
I am trying to display all the subform records that are submitted on the within a single entry of the parent form in a HTML view. My code is below, I cannot seem to get the loop right. It is only showing a single entry on the HTML page. htmlpage Call_in_Report_HTML(ID, Id1) displayname = "Call_In_Report_HTML" print = true pdf = true content <%{%> <div style="width:95%; margin:0 auto;"> <%a = Call_in_report_new [ID == input.Id1.toLong()]; for each a in Call_in_report_new [ID == input.Id1.toLong()]
Embedded Google Calendar Permission Error - ICAL feed
I made a change to one of the ICAL feeds on my Google calendar that is embedded in an Zoho Creator HTML view and now I am getting a permissions error ("Events from one or more calendars could not be shown here because you do not have the permission to view them.") when I try to view the calendar in Zoho Creator (without being logged into the Google account that owns the calendar) I have re-added the calendar feed MULTIPLE times with the Public setting (altough I think that the first time I added
Help with scripting function
Please can someone assist me with this. I've created a simple app which consists only of 2 forms to simplify the problem. The forms are Quote and Items. Items is a subform of the quote form. I'm trying to script a custom function which will add a new record in the Quote View which has the same data as the original record INCLUDING the data from the subform. Here is what I've done: void revise(int ID) { dat = Quote [ID == input.ID.toLong()]; subform = dat.Items; name = dat.Customer;
How do I get rid of these items on my application?
Hi there - just wondering how I change my application HomeScreen - see attached picture I have decided just for ease of use to use a stateless form instead of an HTML generated view Thank you Jonathan
iFrame Video within a Form Notes Field
In a form notes field you can format text and insert images - I would like to embed a video - the reason is that I am creating a "Frontpage" for the application in a stateless form as its much easier that fiddling with HTML for me anyway! When I open the notes field to edit and switch to source, I can paste Vimeo iframe code into the field. Then, when I switch from source to a real view then the video still appears. I then save the notes field and it seems as though the iFrame tags are then stripped
basics offline options
would be possible to imagine a very basic offline version of zoho creator? in my opinion very basic means possibility to store locally added or modified data and upload them asap. conflicts can be solved manually one by one. working on windows at the very beginning also on bb iphone android in a short period. inm ready for a small mounthly investmnt for development nt in this direction assuming the option can be ready in aprox 6 mouths. thank you
comparing fields with nulls and spaces
I have a multiline field on a stateless form and on a corresponding master form. In the on load section of the stateless form I set the value of the stateless form field to the value from the master form field. On submit I send an email if the information was changed. The problem is the email is triggered because the master field has a value of null and the stateless field has a value of blank. Is there a better way to compare the two fields so that nulls and spaces\blanks are treated the same?
Formula Fields Not Updating
I use a lot of formula fields for simple things like displaying full names of a contact or creating a URL link to a details HTML page. Quite often the formula result does not update or gets somehow corrupted... This has been happening for a long time but I'm only now getting around to reporting the issue... Simple example. 'Admin' Application, 'Contact' Form, 'NameEmail' field has formula = First_Name + " " + Last_Name + " - " + Email Right now, the majority of my contacts are displaying first and
Populating fields with data from related different forms
OK Here is an issue that I have tried to simplify: My application has 2 forms MAIN DATA MAIN which has 2 fields MainSalesPerson - LOOKUP (linked to DataSalesPerson). MainEmail - Fetch data from the DATA FORM DATA which has 2 fields DataSalesPerson - TEXT INPUT DataEmail - TEXT INPUT In MAIN, on user selection of MainSalesPerson, I want to fetch the corresponding email from the DATA form field DataEmail and display it in the MAIN Form field - "MainEmail". I cannot seem to understand how to get this
Posting data from Zoho to REST Api
I am trying to post data from a Zoho form to an API through XML so that I can push a list of updated records upon each add or edit to the Canvas API. This should be really easy, but I am not grasping the concepts of the built in function for HTTP requests. Could someone help with some sample code? Look at the reference data API starting on page 12 of this document: http://www.gocanvas.com/content/images/file-uploads/Canvas_Webservices_-_version_1-3-0.pdf Trying to do something like this in deluge
problem with condition evaluation
After the last update, some of my html views generated errors. The problem is that it is a very used piece of code which was correct until last update. An example: if(recid != null && Contacts[ID == recid.tolong()].count() > 0) { // some piece of code } Iff recid is null, the code Contacts[ID == recid.tolong()].count() was no more executed . This was the behavior before the last update and it was convenient. The condition checks if the record is null and ONLY if it is not null it checks if there
Please tell me if this is possible in ZOHO.
I am going to build an audit form that will submit a bunch of building data into a database. Example data: Building Name Building Address Owner Name Existing Measure A - Potential Measure A Existing Measure B - Potential Measure B I'm then going to submit this data into a database. Here's where it gets tricky: A) I want to be able to pull this information back out of the database into the exact same form (so I can pull up any given site and see the full details again and be able to modify it (possible?)).
Form Schedule Did Not Run
I have a form schedule setup to send an email on a specific date (later than today). Send Queued Posts { Execute on POST_QUEUE_FORM.DELIVERY at 01:00:00 } POST_QUEUE_FORM contains a date-field DELIVERY. However, the schedule did not run recently as anticipated. I do have the frequency set to ONCE, since I only want one email sent. Am I doing something wrong? Cheers, John Whitney
String to int
I can't find out how to parse a String to an integer in the deluge scripting language. Hopefully someone out there can explain to be how this is done. Thanks
how do I get an e-mail when a field is updated?
I have a form with multiple fields. I'd like to get an e-mail anytime one or more of the fields are changed and SAVED. However, I would ALSO like the e-mail to say: 1. Which fields were updated (what they previously were and what they currently are) 2. Give me a link to that particular data-set I know how to send the e-mail on update, but I don't know how to pull out the variables that tell me the above 2 listed items. Any help? thanks! - Quan
Reset Total value on update
Hi All, My form has several fields for numeric values to be entered. At the bottom is a total field. I set an "on user input" script for each field as follows to update my overall total at the bottom: input.Total = (input.Total + input.FIELD1Value); field 2 value etc.. This works fine and when I tab out of field the total updates. BUT.. If I go back to FIELD1 and change the value it adds this new value to the total also, so my total is way off as it has not reduced the initial value. Can someone
Application Database Alternatives
I would like to create an application using Creator.......my issue.....my application database will be very large.....using Creator's database could get expensive....is it possible to create a appliaction within Creator and leverage Z Reports as my database....or any suggestions.....also are there limitations using databases other than the Creator database? thank you
formula function
I have a calculated field which needs an input from one of 3 formulas. Every time I input date into this field, I need to pick one of the 3 formulas. Do I need to hire a programmer to implement this?
How do you reference the value represented by a bidirectional field?
I'm trying to wright a custom schedule script that references the email addresses to send to, from a form where the email address is populated from a bidirectional relation. My script errors I assume because it is receiving the ID number from the bidirectional field instead of the actual email address value I have the child form display. Here is the code I'm trying to run: temp=""; for each x in CRS[Received == false] { temp = x.Report_Type; for each e in Test_Staff_Roles[Notice] {
Zoho Reports within Zoho Creator Tab
Is it possible to embed or <iframe> Zoho Reports within a Zoho Creator Application Tab? (not a report,chart or dashboard) But the ability to use the functionality of Zoho Reports within a Creator app... To give my users a more seamless experience? Both products are great....
Modify existing record and save as new record.
Is there a way of opening a record in edit mode and saving it as a new record? What I want to do is use the data from an existing record, modify it, and save it as a new record in the table. Any help would be appreciated.
Zoho Creator Payment - pass other data to PayPal?
When I use a payment form option, is there any way to pass additional fields through to PayPal besides the Item Name, Quantity, and Amount? We are trying to track all of our PayPal purchases through the use of SKU's (stock keeping units) corresponding to our internal account numbers, so I'd like to be able to pass an Item ID field through to the PayPal portal. Any way I can do that?
Update 2 rows on another form on submit
Hi, I have a form "movements" and another form "Stock" with different locations. When user enters 200 for "Item A" in form "movements" I would like to reduce the qty of "Item A" in form Stock for that item and location, and increase the qty of Item A in another location. Stock type will be chosen on the movements form. Stock will always originate in the same location and end in same destination. I tried the following for on submit, on success: if (input.Stock_Type
Double Vision when editing a Script at Creator with Copy and Paste
Please look ar this video : https://berryforms.box.com/s/73fcc58a28b2b13fa485 Ariel Segall Cloud Mobile Forms Zoho Partner arielsegall@CloudMobileForms.com (877) 436-8133
look up not working
hi i have tried and created two forms namely order form payment option my problem is when i use the option of look up in the 1st form for a field in payment options .. the field in the payment option form is not working
Auto Populate of Fields isnt working correctly
I have an application that has all of the club information in it (club number, member number, member info etc.) It has multiple clubs in it and within those clubs it has multiple member number. There are member numbers that are the same within seperate clubs. For example I could have club 0259 and member 7 but also club 0176 has a member 7. What I am wanting to do is on a display_20_scores stateless form I have then choosing the club number from a dropdown, then I have them choosing a member
formula function
I have a calculated field which needs an input from one of 3 formulas. Every time I input date into this field, I need to pick one of the 3 formulas. Do I need to hire a programmer to implement this?
View Link to related table wont stay disabled
If a Link to a related table is enabled for a view in the Column Properties section and then disabled it does not stay disabled. When I go back to the column properties the link will be enabled. It can easily be disabled again. The problem is that I may be in the section to make some other change and not notice that it is enable. I have tested this with two different applcations. One using teh old UI and one using the new UI. ------ If I have the link enabled for a field set as a Group clicking on
Getting the ID of a subform entry in the same manner as an ID is returned by Insert Record
Hi When you create a record using insert Record you an get the ID back as a variable So when you create an entry or entries in a Subform any way to get the ID back in the same or similar fashion ? Thanks
update multiple rows with fetch
Hi All, I have a form 'Stock' with 2 rows of data 'A' and 'B' for different quality of same stock. Another input form will have values that I want to add to both rows on submit. by add i mean if row A stock has a column with 10 and the input for that column is 10, then the new value will be 20 in the stock form. I've got fetch working for one row A, but would like to know how to perform fetch and update for both on same submit? Should I perform a second fetch? Thx, Rob
Search ID by contains
Would be helpful if you can search the ID by contains, it is such a long number that typing it in complete for "is" is prone to errors i end up making a string version of it and storing it but for every form it gets tiring
How do you export a report as a PDF with the filters intact?
Hello, I want my users to be able to export reports to CSV, XLS, or PDF. I see that currently only PDF is supported. However, even this functionality is severed limited if the PDF doesn't preserve the filters that the user has set. Is there a way to work around this issue? Or is this already possible and I'm just missing it? And/or can this be added as a feature? Regards, - Kevin
Summary Box Sizes
Hi! Wondered if you can help me. My view for the forms is on Summary (The box) But why are some of them bigger than others? (Some are small and some are stretched, even though they hold the same information?) Thank you for your assistance.
Update record in another application dropdown box
Dear Sirs, I am currently working on Zoho Creator to set-up a database for product samples. I have 2 app. Both with only one form and one view. The first app is to create new samples from a form (Create_Sample) or view/modify/delete them from a view (View/Modify_Sample) Sometimes, we need to pack several samples in one box (to send them to another place for example) So I have a second app in order to create a new box from a form (Create_Box) or view/modify/delete these boxes from a view (View/Modify_Box).
Inserting table field in a form
Zoho Creator has various basic fields to drag and drop onto the form, but I have found no way to insert a simple table into a form. I hope to create a table with two columns and five rows. Under the first column will be a list of car brands (Ford, Chevy, Dodge, Nissan, and Honda). Under the second column will be five cells for the user to input the number of each brand sold during the month. Is this possible in Zoho? Thanks for your help!
Reports and Views jpg.
I wish Zoho Creator could send views as jpg. and also reports as jpg. why is that not supported and also it would be great if the view would be exported the same way that it is displayed . It lets You set the display tab but when the view is exported or sent as attachment it doesn't come the same way.
Next Page