The page is no longer automatically updating after adding data to the embed report
I have a page with 2 embed reports and html-button which call the form for adding data to embed report. For example. Page Invoice with Embed Report "Payments" filtered by invoice ID. Button "<a href='#Form:Payments?" + formParams + "&Invoice=" + NewRecID + "'><input type='button' class='addNew zc-formbutton' value='New Payment'>", formParams = "zc_LoadIn=dialog&zc_BdrClr=transparent&zc_Header=false" When I closed the form "Payments", the page "Invoice" was updated automatically. About 10 days it
Criteria Setting Via Deluge
I have a form that has a radio button named 'Filter'. There are two choices namely '2 years' and 'Custom Filter'. If 2 years is selected a table filled with number of students in each department. If Custom Filter is selected, two Date fields namely 'Start Date' and 'End Date' appear. When a user enters a date for each date field, the table should contain the number of students in each department within those dates. Problem: If I select 2 years, nothing happens to the table, it only displays all of
How getFieldValue() work?
I want to know how getFieldValue() work. I did not find any example in the documentation. Can someone please explain it to me?
Bulk Add Functions
Hello, I think it will be great if we can use the attached form to add multi-functions instead of one at a time
Deluge Add Record Script Not Triggering Zapier
When I add a record to a form using the deluge add record script, I receive no trigger action in Zapier, even though the new record is successfully being added to the correct form. I know that form data can be emailed to a form, and from what I have read, this will cause Zapier to trigger, but I have been unable to setup automated emailing at this time. Is this a bug in Creator or a bug in Zapier? Are there any other workarounds available? Thanks for any input!!!!
SORT RECORDS WITHIN RECORD SUMMARY
Hello...how do I sort the the records that appear listed within a record summary? I've got the records sorted in the corresponding report, but they do not sort the same when embedded within the record summary. Any ideas?
Offline Mobile App Works Differently in Each Phone
I've signed for offline mobile app account (2 users). In my phone, I can access all my forms. However, the user's phone can't. And when I tried to log into my account using the user's phone, it didn't show my app offline. Both phones run Android. Why does the app behave differently in each device?
Date Only on Formula Field
I have a form with a date field, not a date-time field, and a formula field that references that date field. The formula uses date_field.addDay(7) to add 7 days to it. That formula works, however it is formatted as a date-time filed in reports. I need the field to only show the date in reports, without the time. The 00:00:00 time stamp is not only unnecessary, but it takes up too much space on the report and is inconsistent with the rest of the date only fields in the report.
Publishing for an Intranet
Hi, I'm reviewing the use of Zoho Creator for my organisation. I only have the trial version so can't play with publishing at the moment but can anyone help answer the following .... Is it possible to publish a report in a way that it's available to our intranet site (Google Sites) but not fully public - ie outside the company. I don't want to create a user account in Zoho for every employee as the cost would be too high. Is there a google site add-on that I provide some credentials to login to Zoho.
Filling multiple lines of subform on add/ on load ?
Hello everybody. Is there any way to pre-fill three (or more) rows in subform ? I have Form lets call it "order" and there is "subform" with lookup "product". I need to have there three lines with products (which are very frequently used almost in every order) pre-filled. I did not find any solution in formums. I dont have any idea how the code should look like.
Hide certain checkboxes based on if statement
Hi, I have a piece of code that reads whether or not a certain value is inputted in another field. If that field is a certain value, I would like it to hide specific checkboxes within a checkbox field. Is that possible?
newbie question
Hi i'm new to Zoho but i like it a lot. i want to build an app that allows me to manage computer repairs i've managed to build the forms and a few reports but now i want to add parts management i have a few suppliers, thats easy to put on a form. also the invoices from those suppliers are easy to register my problem is with different serial numbers something like: -supplier form with name, address and VAT number -invoice form with a lookup field to the supplier form and also a invoice date field
Mobile App and Data Relationships
Hi There, I'm new to Zoho Forms on my android mobile and am still trying to understand how to link records as in a relation ship. I dont seem to see any way to create a relationship between two pages. My first form allows me to enter garden centre addresses and add an image. my second form should allow me to add a date and notes each time i visit the garden centre. Then when I view the reports I would like to see the garden centres address and the dates that it was visited. My other question is it
Schedule Push Notifications
How can I create a form schedule that sends push notifications to my phone?
Criteria as substring?
Hi, I have a list of names (first + last as a string), and I would like to fetch entries from a form based on that name. problem is the form has separated fields for first and last name. I'm looking for something like EntriesListPerName= (Form[ First_Name in NamesList && Last_Name in NamesList].ID).getall() ; but currently the "in" criteria is looking for the full string, and not if it contains as sub string (if in the form First_Name is "John" and Last_Name is "Doe" it will not match an element
Adding columns to a report from a related report
Zoho creator allows me to add columns to a report from a related report. But sometimes the columns I want to show are uploaded files in the remote report. Is there a way to do this? It does not seem to show file upload fields. e.g. Report A has Purchase Orders. I can show the address of the associated company from a related Report-B but it won't let me show (say) the company Tax certificate which is an uploaded doc in Report-B Any workarounds? Otherwise, can the zoho team treat this as a feature
Uploading photos via published Mobile Form - Forces Zoho log in screen
My users have been experiencing this random error for the past couple years. Not sure what causes, did not happen for a while but recently have been getting reports of it. Essentially I have users submitting data via a published mobile form and when the user tries to submit it will force the Zoho login screen and subsequently the user loses all the information they were trying to submit.
A second form to add new data to a report
I'm looking to create a second form that when submitted with add that information to an existing report. For example I have a From & Report call Perspective_Clients. In this form our users add customer information that was submitted over the phone. We now want to also open a web form, to allow customers to register online and be added to the same Perspective_Clients database. Would I use a stateless form? Or would I modify the form "On Add"? Thanks!
Differrence between regular fields and subform fields
Hello, i use simple condition for checking some of fields in my form (located on edit > on validate). I find out, that my script works only for first row of subform. if(Subform_name.Field_in_subform == null && input.Check == true) { alert "field in subform is not filled"; cancel submit; } How should it look like to make it work for all rows of subform ? Maybe its newbie question, if so, sorry for that.
Import additional data to existing records
Hi, I am wondering if it is possible to add (some) data to existing records using one ID field as cross reference. For example I have a spreadsheet, one column 'ID', and a handful of other columns with the corresponding field names. I want to import those to exisiting records where the ID value is equal to a specified ID field in the existing table. The new value should overwrite any existing data. The default import function seems to import only new records. Could the above be achieved with a script?
How to format a text field to include spaces?
Hi all, Was wondering if anyone could help me with this. I have a basic form to collect data which collects UK vehicle registration numbers. At the moment my form just stores this as normal text but I’d like it to format the text in a certain format (ie the way registrations are displayed - at the moment it’s FG10JKP and I’d like it to store it with a space after the fourth character FG10 JKP regardless of how the user entered it. The next thing I want to achieve is to not apply this change if the
Simple application, but can't find a way to pull it off.
Good evening. We have a simple application we're looking to write but can't find a way to pull it off in Creator. Basically, on a form, depending on what radio button you select, when you hit submit, an email is sent with a specific attachment. Sounds easy enough, but our issue is, we can't see where to store the attachments. They're each just a Word doc. The hope was to maybe even store them over on ZoHo Docs or on our website somewhere, but can't figure out how to have Creator go get the file and
Attaching files from zoho docs in creator form
We have invested allot of time creating our soho infrastructure. It turns out that the bottle neck is an inability to link files from zoho docs on to forms in creator. We can upload files but this defeats the object of the cloud. The only way we can associate documents with records in creator is to download the document from docs then upload it again to the form using the attach file field in the form. I am sure I am not the only one trying to provide access or links to files in creator. Also, even
form-mobile
Hi Zoho, Form-mobile links are no longer supported in new UI. Do you expect to bring this back? If yes, when can we expect it? Thanks.
Mobile App Limitations
I have been trying to develop an app for an iPad kiosk. I keep getting hung up on things that work fine in a desktop browser, but not in the mobile app. - Embedded Forms and Reports in HTML Pages show up as a button to the Page, not the Page itself. I tried to embed a Report and a Stateless Form with custom buttons. In a desktop browser it behaves as expected, I see both items on the same page. In the mobile browser I see two buttons, one to the Report, and the other to the Stateless form. Not at
Field update not working in subform
Hello, hoping someone can help! I am making a mailroom app for my company. I have several forms as follows: Form A: Info about packages being delivered Subform A: Collects info about each individual package, includes 'Package No.' field which is unique and is input by user, and also 'Package Status' field (package status are either 'Signed In' or 'Signed Out' Form B: Info about when people collect their parcels from the mailroom, and has a signature field Subform B: Collects info about each individual
Convert a 'Single Line' field to 'Drop Down' without data loss!
Is this possible? When I try this I get an error message that says: Warning: Data Loss Detected All the records and report columns associated with the field will also be deleted. This action cannot be undone. [I understand, Proceed] [Cancel] Thanks.
How to nest forms within forms (not subforms)?
I tried using subforms already, but they force you to list everything horizontally, causing an unacceptable amount of scrolling. I need the exact same functionality as a subform, but with a vertical orientation. Can it be coded manually?
Repeating Lookup Field Values from Last Form
Is there a way to repeat lookup field values from the last form I've just added? For instance, I have field A, B, and C. I would like to submit a form where A is going to have the same value for the next 16 forms, B is going to change every 4 forms, and C always changes. In any case, if the value from the last form repeated into the next, it would save me a lot of time. Thanks.
User added set of fields ...
I'm trying to develop a tool for our factory to organize product requirements, data from product tests and then a report compare the requirements against the test data to see how much of a variance there is. I think I need to create one form to log the product requirements, then a second form for logging the test data, and finally a report comparing the two. All of the data can be gathered via regular fields, but I need the user to be able to add sets of fields based on the specifications of the
Making email addresses clickable in a Creator form view
Hi folks, New Creator user here - I'm building a client management system for a small charity in the UK. Loving Creator so far. This is my first hurdle: I've created a 'Client View' form with a lookup field to pull in details from a master form containing client data, and display the data in other (disabled) fields in this form. Here's part of my Deluge script: temp = Client_master_form[ID == input.Client]; Date_of_Birth = temp.Date_of_birth; input.Postcode = temp.Postcode; input.Email = temp.Email;
Multiple Reports in Record Summary
I'm using Zoho Creator to build a contact database for my organization. I've managed to create forms for both our contacts (with contact information) and another form with their order history. What I'd like to accomplish is when accessing the contact database report that the summary record include both their contact details from the first form as well as a log of their order history. I'm currently unable to combine these elements, do you have any suggestions? Thanks! Hannah
EAN13
Hi, I would need generate EAN13 in Zoho Creator. In Excel sheet, I have this formula in column A (=RANDBETWEEN(978047100000;978047100999) - this formula provides a 12digit number. And in B column I have this formula: =A1&IF(MOD((SUMPRODUCT({1;3;1;3;1;3;1;3;1;3;1;3};-MID(A1;{1;2;3;4;5;6;7;8;9;10;11;12};1))*-1);10)=0;0;10-(MOD(ABS(SUMPRODUCT({1;3;1;3;1;3;1;3;1;3;1;3};-MID(A1;{1;2;3;4;5;6;7;8;9;10;11;12};1)));10))). This is last digit validator for EAN13 code. For example: In A1=978047100700 and in
Zoho Account in free trial even if paid licenced already.
I have been using the account for more than one month, licenced to zoho one enterprise , but now i cannot import more records. Its saying "Record limit reached. kindly upgrade to a suitable plan to import records." even when i am already upgraded to enterprises. please see attached files. hoping for a quick resolution. Thank You, Deepak Sapkota
Access to DB records via a primary key for portal users
Hi, I'm a potential new user of Zoho Creator. Is it possible to identify Portal users so each user can only access records with their primary key in the db? There are relationships between many tables also so this access limitation must carry through the entire application. The database was created by migrating it from MS Access into Zoho Creator - ive tried it with a sample db and it looks ok but the Queries are all lost and the forms are lost?? Does migrating a large DB from MS Access also import
Pricing
I noticed that the pricing on the main page is different than the pricing under my account. https://www.zoho.com/creator/pricing-comparison.html The thing that I'm most interested in is the new pricing includes 25,000 records, the old pricing only included 1000. I could save $40 a year and get more than twice as many records. Is there any way to change my account to the new pricing other than deleting the old account and creating a new account. I didn't find any options to switch to the new pricing
long.toHex() string has halved in length?
I have a script that converts a long to a string using long.toHex(). It appears that in the past few days there is a change such that the string is half the size that it was? It used to be 18 characters, now it's 9. Has there been a change?
Disappearing Records
Early records in my database are disappearing. For Example, in the attachment, location number 211 originally had a starting gallonage on January 1, 2017 of 59.45 gallons. This is occuring with many of my 2015 and 2016 wines. I have reviewed my code and re-entered the data several times. This problem is recurring but I do not see the pattern. Orginally I though the database was cleaving earlier records to make room for new records so I paid for more records to avoid this. In any case, cleaving older
How to set report criteria to "not this month"
Hello, I use Zoho Creator to raise statements for contractors. I have a report, and I would like the criteria to show records *not* from this month (i.e. from any previous month only). So, for example, if it's March 5th and I run the report, I want it to show records only up to 28th February. How do I do this? Thanks!
Pie Chart Legend
We have an employee who is colour blind and |I am looking at proper accessibility for web interfaces. I would like to change the pie chart pieces from a colour to black and white texture but haven't found a way to do this. The other option is to be able to add the label name to the piece. Any help would be appreciated. I don't have a huge coding background, hence the reason I like Zoho.
Next Page