Gather Data for very month
How can i add data of aspecific person for the whole month? Because i want to send it automatically every first day of the month Hi ' Sales Agents Name ' Please review the attached file, that includes your pay statement for the Month of " Month name" If you are unable to download the file or if you have any questions, please contact you payroll administrator for assistance.
Comparison Website with user logins
We need to make a comparison website to compare features of around 5000 products. This will be based on type of product and then model comparison within a type. Users will be able to get registered to the website for detailed features. Therefore this website will be based on a database which will hold types of products, models of products, manufacturers, suppliers and different types of users (with different user levels) Professional with similar portfolio please contact ASAP Many thanks
Why are my embedded public reports suddenly asking people to log in?
I have two embedded publicly available reports on my web site. Twice now, one or both of them have suddenly changed from just being available to this message: You have logged in as Public. You are not allowed to access this view. Please click here to login as a different user. Click here to go to your Home Page. What's going on? Why did the visibility change without notice, and why are they now asking people to log in? Thanks, Alex
how - view field but can't edit?
hi for app there is few users who works with incoming entries. need functionality: 1) for new incoming entry there is auto-fulfillment of entries (already works) 2) user for assigned to him view can open and edit entries (already works) 3) how can i make access restrictions for fieldA so that user can open and view inside this fieldA, but can't to edit text of this field ? example - fieldA is phone field. this field auto fulfilled via web-site. user can open entry and view all data, but he can't
Account suddenly canceled for no reason!
I can't access my account. After persistent calls and emails I received a matter-of-fact response that I cancelled my own account. I absolutely did NOT cancel my account. I had just upgraded and paid for entire year! I'm at a loss here. I can't get anyone to respond to my issue with any compassion or willingness to help. I'm using the account of one of my team members to post this message.
Dynamic Picklist based on radio button selection
I can't get the following code to work. if (count(Surface[Type == "Film"]) == 0) { clear Top_Surface; } else { film = Surface [Type == "Film"] sort by Type ; Top_Surface:ui.add(film.Film_Tafetta.getall()); } It seems if i change the above code to the below code, i do not get an error but i have another problem instead. if (count(Surface[Type == input.Membrane_Configuration]) == 0) { clear Top_Surface; } else {
Form object instance: function for pulling data?
For a form-object variable defined for a custom-action , say variable formObjectInstance1 , what system function can I use to pull all data in a form and put the data in an email message? somethine like input.formdata; for formObjectInstance1 it would be something like formObjectInstance1.writeAllFieldValues() ? I have been trying to find such a function/method but could not... can you help ? thanks.
Reports module in Zoho Creator is not working properly after adding a field from another table to a report
I have problems with reports based on a "Transactions" table. For instance, the reports and graphs don´t show all values in the field "State" and the aggregation of a column "Amount" is not given the same results compared with the same operation made directly over the table view. The problem arouse after I added a column called "budget" to the table, which is the ID to link to a new table where we have another field called "budget amount" (money type). After that I developed a new report based
Can't Duplicate application.
Can't Duplicate application. On the home page I click on duplicate ... a popup says duplicating but that's it. The application is not duplicated https://creator.zoho.com/workspace/beller32/home. WHY?
Uploading images on a stateless form or importing bulk images
I am working on a creator app that will function as a survey, so the user interface will be public. There is an option to upload an image file on the survey. Ultimately, I want to display a sample of the images on a future survey. I see that on a form, I can select "Local Computer" as the browse option, but I would prefer not to make the form itself public. The "Local Computer" option is not available on a stateless form, so it appears I cannot make a public stateless form with the same field.
One to Many
I have the $25.00/month version of creator - I discovered it does not support one to many (subfields). Does anyone know what I have to do to get this option?? Thanks
Updating mass records
I need to update 4,000 records with one try. Do I need to use Deluge scripting to do this? To learn Deluge systematically what is the best resources/training courses/ Thanks!!!!
Automatic email for a form
I have configured Zoho Creator in a form, so that whenever a record is updated an email is sent. I can see that the emails are successfully sent when the records in a form are individually updated. But when I mass-update/bulk-update the records, the emails are not sent. Is there a way to fix this?
Help. Form should trigger invoice, however on public hosted website this isn't happening.
Hi Team I have an inspection booking form in ZC. This form creates an invoice in ZI and sends it to the client on submission of the form. This works perfectly if I run it in the same browser as my admin account. However, if I submit this form from a clients machine (or any other computer) the invoice is not created. I can only presume this is a security issue. What security settings do I need to set to allow a form that is publicly hosted to generate an invoice? My account is under vic@thepestmanager.com.au.
Fetch Records Explanation
I am not familiar with coding and I'm having some trouble understanding the Zoho documentation for how to fetch records. Would someone be so kind as to break down this function for me in a way that is easier to understand than what Zoho documented?
Improve connection between Notes and Tasks
Apologies if this has already been raised - could not find any reference to it. Currently in ZohoCRM Notes and Tasks are two separate areas. As a work flow, it is common that while entering Notes there is usually a direct Task that needs to be added as an Action . As an improvement, it would be cool to invoke a Task directly from within the Notes section and link them too, to avoid having to close and save the Note and then start a Task separately. (Currently if you maintain lots of notes on a
WHY is Developer Status No Longer Available??
WHY is Developer Status No Longer Available??I have been a developer for 2 1/2 years. I have always had my clients assign me developer status, which makes it very easy to provide on going support. I found out from a new client that Zoho no longer provides developer status for applications. This makes it much more difficult for me. I have to log on to the clients account with their userid and password. This is very unwieldy and cumbersome, and makes the clients uneasy about security. Existing clients
Eliminate Table Borders in Rich Text
Hi, I create tables through code in rich text fields to get data to line up. It works well, but I cannot find a way to eliminate the borders. Any suggestions? Bruce "Speedy G" Peaslee The World's Fastest Programmer
Data deleted by error, and can't import by zoho issue.
We deleted by accident all the data from de form Presupuestacion, our last backup is from 19/05/2014. Can we restore our data? I tried to import some data about 1 -2 weeks ago, but Zoho creator give this error: Thank you, greetings.
New fields automatically added to report?
If I change the design of a form, can the new fields added to the form be automatically added to the relevant reports/views as well? Thanks.
Update parent status
I have two forms, Vehicle and Log. Vehicle form has two fields...VehicleNumber and Status while the Log form has Employee, CheckOut Date, CheckIn Date, and VehicleNumber (lookup) as the fields. Now every time I check out a vehicle to an employee using the Log form, I want to update the Status field to 'Out' in the Vehicle form. We just signed up for Zoho and I am trying to come to terms with Deluge scripting and its syntax. Appreciate if anyone can help me get started with the code.
Sharing data between Managers and Line Staff
Hello, I created a new inventory database with a Form with that has all of the fields that the Managers want to track. Now I need to give Line Staff access to some of the inventory fields and hide the rest. Do I create another form pointing to the master inventory Form? How can I achieve this? Iram
ERROR "problem encountered while creating the application null"
Error message "problem encountered while creating the application null" any thoughts?
Create list of record IDs selected from a Lookup Multi-Select field
What field type would hold a list of the ID numbers of records selected from a Lookup Multi-Select field, and what does the script look like to create that list upon user input at that Lookup Multi-Select field? As always, I super appreciate the help offered here. Practically speaking, what I want to do is to reset records that were updated via the Multi-Select field when the form was first created, that in Edit mode have been de-selected.
If else if sytnax
Can someone let me know what is wrong with this syntax. I am getting an error on the first line (improper statement) this in the deluge for the heightfield upon user input. if ( (input.Widthsizefield >= 24) && (input.HeightField >= 36) ) { input.Currency= 218 } else if ((input.Widthsizefield >= 48) && (input.HeightField >= 60)) { input.Currency = 372 } else if ((input.Widthsizefield >= 60) && (input.HeightField >= 72)) { input.Currency = 473 }
QR Codes or bar codes integration to zoho....
Is it possible to integrate some sort of bar code scanning into a zoho create application? What I am thinking is using this website http://qrcode.kaywa.com/ to input a comma delimited record from zoho to create a QR code. That code could be printed and placed on a product. Someone would scan the code that is on the product with their phone and then email the record to zoho creator application. You can email records that get input into zoho creator application correct? What they would be emailing
Database won't duplicate
Logged two support requests, no response to date. Can't duplicate Marine Cargo database is first issue. Second issued can't ceate new form from template quickquote in database marine cargo, error 500 appears.
update a row
I am new to zoho. i have been trying to learn about zoho since two weeks. currently i am working with zoho creator where i created an application(Employee Management). In the application i have a form where there are fields as follow: serial number as an auto number field Email as an Email field Date as Date field Is Entering or Leaving as radio field(options: Entering and Leaving) Arrival time as single line field Departure as single line field while accessing the application user has to enter fields
ZH Creator to ZH Invoice integration
New to ZOHO creator ... I'm using zoho.invoice.createinvoice () in ZOHO creator. All works fine in test and I can create an invoice in my own ZOHO Invoice account, however I need my application to create invoices in other ZOHO Invoice accounts. I can also do this using the appropriate ZOHO Invoice API, using AuthToken and API key, but don't necessarily want to do this. Is there any similar way that I can use zoho.invoice.createinvoice () to create an invoice in any (authorised, obviously!) ZH Invoice
How to update a list
Class_Numbers is a multiple-select variable There's no built-in function to actually add a new value to the list. for each student in Attendance [(Clock_Out is null)] { student.Class_Numbers = student.Class_Numbers.add(some_value); } Cheers, John Whitney
Count number of records that match criteria
I have a form where employees put in tickets when they break their devices, what i'm trying to accomplish is to make a label that shows on the form the amount of times that particular employeeID has broken a device (by counting the amount of records that exist with that employeeID) input.lbl_Broken_Count = Service_Ticket_Entry[Employee_ID == "input.Employee_ID"].count(); I read the count function and came up with the above code however when i try to save i'm given the below error: Variable 'lbl_Broken_Count'
Subform fields not calculating
Hello, I created a form called "Add Sale Subform" then I added a Lookup field to it so that I could add it as a Subform to a main form. In each of the fields in the Subform I added the below expression on User Input. input.Amount = (input.Qnty * input.Part + input.Labor - input.Discount); The updating works fine when I open the form separatly from the main form. But when I open the Main form where this subform is connected the subform fields don't update when modifying them. I tried changing
New Array Intersect Function Issue
This picture explains it: However it works in free-flow scripting mode Cheers, John Whitney
Simplifying form choices and adding to DB
I imported a rather large DB (Excel) into Zoho as the base of my application. I have fields such as State which I would like to change on the form side to a drop down for the user. I would like these values to still populate into one overall State column (for ease of reporting). Is there an easy way to do this?
Disable fields based on logged in email address
Hello, I would like to add a formula to the On Load of a form to disable the below fields based on if their loginID equals any of the following hard coded email addresses: johndoe@yahoo.com, janedoe@hotmail.com, DaveJohn@outlook.com I will enter the real email addresses later. Serial_Number Model_Number Date_Received Could you help me with this script?
Creator: show records that have one (non-unique) field repeated
Hi - is there a way to output a View, that we can then do bulk edits on, which shows only records that are repeating multiple pieces of data? For example, if I have a recipe database and I want to see all records where any ingredient is used in more than one recipe. so this is not filtering for one ingredient, but rather to see all records where any ingredient is used multiple times.
Formula field not adding up
Hello, I have a formula field field called "Total" withe following expression (Sub_Total + CC_Debit_Fee) Both of the above fields are currency fields, the Sub_Total is updated by fields in subform. But for some reason the formula field doesn't do anything when I enter information in the two fields. It just stays blank. What is wrong with the formula field? Iram
Free Embeded Forms
Hello, I've been toying around with creating forms in Zoho Creator. On the main page before creating an account, much of the advertisements references free embedded forms, but the only way I can find to do that is by Publishing the form. Whenever I attempt to do so, I get an error message that free/trial users are not able to do so. Is a paid account required for the ability to embed forms or am I doing something wrong? Thanks in advanced for your assistance,
Mismatch data type for function get at argument index 1 expected data type BIGINT found dataType STRING
Hello Please tell me how to solve the following problem?
Look up Field in Form Not Filtering in Response to Critera
I have a Lookup field in a form that is not responding to changes in criteria. Regardless of what I put in as criteria the results remain unchanged as if I did nothing. You have access to my application named: PDmobile The form is: EvBroccoli Thanks for any help.
Next Page