I don't want xml or json file
Hello, I have a problem with the record update. When I post a form with the attribute "action" like this : https://creator.zoho.com/api/user/json/appname/view/reportname/record/update I always get a response in json (or xml if xml is set) file downloading on my machine. Do you know how to block this ? I judt don't want to download this file.
License for Developers
Hi, I am a freelance developer and new to Zoho Creator. License model is confusing. Could you please someone explain the license model for developers like me? For Eg: I have 10 clients. They own the app. I work for them. Which case will fit for my need? 1. I need to purchase one user Creator license. 2. Each of my clients need to purchase one license for me. So it will be 10 license. 3. I can use Developer Zone. So no license needed at all. 4. Is there any other option?
Best way to transfer forms from one application to another
I need to move 12 forms (stateless and normal) to another application. What's the least painful way to do this? I can't find anything on this topic for creator 5, particularly for stateless forms.
Order Form Save and Submit
Hi i am creating an Order Form for Customers. I want to implement a functionality so that customers can SAVE SUBMIT an order. SAVE means data is saved for later review SUBMIT (approve) means we want to purchase this (the Customer user who submits can also be a different user than the user who creates /SAVEs the order) Also is there a functionality if this is SUBMITed to get this somehow digitally signed by the customer How would you approach/solve this? Thank you! Kind regards Lambert
Separate content from a String
Hi All, I have a form with a rich text field and a single record. The field contains email content My second form sends a notification using the fields value as the body of the email, on success. The problem I have is separating deluge (such as + input.anyfield +) from the HTML / content. My code so far: EC = email_form[ID == 45644000002346541]; req = EC.email_content.toString(); sendmail [ from :"zoho@zoho.com" to :"chris@zoho.com" subject :"subject for this email" message :req ] is it possible
More than one attachments in Send Email task
Is it possible to attach more than one file(PDF- Record Summary) in the Send Email task inside Zoho Creator?
There MUST be a way to update records in bulk. But how?
I have created a database with thousands of records. Occasionally, I need to add another field, after which I need to populate those fields for each of the records. I do NOT want to go through each record one by one to update it. The information I need is in a spreadsheet, which can be converted to CSV or TXT file with no problem. The information is numerical, therefore the bulk update option does not work, as that allows you to update records only with the same value. Most databases allow you
Removing Export Options without Embedding
Seems to me we should be able to customize a standard list's export options. Maybe there is something undocumented to add to the report definition? Cheers, John Whitney
Create a calculations form in Creator
Hi there, I have a excel spreadsheet that with user input calculates points needed to reach end point's threshold It consist out of various of things the client can do to achieve this points. Some the client has done already and some still needs to be done. Currently on the spreadsheet everything that needs to be done is in red and everything that has been done in black. Can this be done.
[ZC Platform Solution] Rebranded Mobile App
Regarding the...new...eerff..Platform. \___( -__- ' )___/ What is the plan on offering our apps as rebranded mobile solutions? Since the new platform is supposed to be a rebranded end-to-end solution, will the ZC rebranded apps be available to our clients? I can't find any documentation or hint of such feature in the dev portal. On the same note, Zoho is now offering the very-tempting Zoho Creator Plus with Flow, rebranded mobile app and etc. at a very aggressive price. At the moment ZC Plus
Can't see Script Builder in Page Builder
Hi, When I create or edit a page in Zoho Creator, I can't see the script builder, or any way to get to the script builder. I think it is stuck in Free Flow mode, or I'm just blind!.
When Zoho creator will introduce two way Real time page - database update like google Firebase or angular model
In today's world real time database is necessary and no body want to refresh page manually. here zoho is laggiing behind with others
Error When Uploading ipa using Transporter iOS
When I try to upload an IPA file to submit to the Apple Appstore, I get the following error: ERROR ITMS-90085: "No architectures in the binary. Lipo failed to detect any architectures in the bundle executable." Im not sure how to resolve this error.
Zoho Creator app for multiple stores
I want to create a Zoho Creator app , it will include multiple stores with the ability of store owners to login into the application and we should track their sales, commissions and they can also track their sales by login , i am confused how i can add them as users , if they don't signup for zoho creator , so i will use customer portal but again how can i track the data related to them.
IP Address of internal LAN subnet
I have a published form that I would like to restrict to a certain subnet in our organization's lan. Windows ipconfig gives me the internal ipaddress, but the system field zoho.ipaddress gives me the external public ipaddress. is there any way I can get the internal address on our internal network?
Footer Issue in zoho creator
Hello, Footer is not acting like a footer, it doesn't appear at the end of the page when i try to print the template. So if i have half the page filled with data it will appear half way down the page instead of appearing at the end of the page. Please Help. Thanks
deluge question
Hello, I want to delete all records in a report containing a given string in a Lookup field every Sunday. I can't get the script working. I've tried multiple ways, without success. Could somebody help? Custom Schedules => Deluge => delete from <FORM> [<Name Lookupfield>.contains("<string>")]; Thanks in advance
SUGGESTION - Integration with Excel via Add-On
My team and I have been using Zoho creator for about 6 months and we see a great opportunity in developing a MS Excel Add-On to sync data. What we mean is an Excel Add-On that manages connections between Excel and the online DB. We developed a bunch of Excel reports based on tables from the Zoho Creator DB. As of now, we simply export the tables and we copy and paste them into the excel report. This is not a great way of sharing data because mistakes can occur during the process compromising
How to download/view the file uploaded in other form into current form ?
Hi, I have two forms, Self Appraisal Form & Managers Appraisal Form. In Self Appraisal Form - User X will enter the required details and uploads a supporting document to it. In Managers Appraisal Form - User Y will check the details entered by User X and should download the supporting document uploaded. Pl help me with some code/script to make this possible. Regards, Prasad
Delete Records using Multiple Conditions
Hello, I have "Kids" form where i have design no, shade no and multiple sizes say 28, 30, 32, 34 and so on and they are updated when delivery challan is created. Now i want to delete the particular design no. when all the sizes of the particular design no is reduced to 0.
Pivot Chart / Subforms
Hello, I am not able to use subforms in pivot chart so i think subforms and pivot chart relation is not supported. Are there any future updates on this topic?
SubForm Script Problem After First Row
Hi, i have a form and a subform under it. I save engine records on my main form. and want to add spare parts to sub form. But my script is nor working well after try to add second record to sub form. I try to explain with the image on attachment. Thanks for help.
Body Maps
Hi there I am looking for a bit of help or advice on how to create a form with body maps. Users need to mark areas on an image and add text to correspond with those areas. This needs to be visible when the completed form is viewed/edited. Any help would be greatly appreciated. Nikky
Show text in popup window after successful submission
How can I implement a workflow to show a text information after successfully submitting a form?
Pictures in forms
Hi, I have a requirement to provide choice of design (Checked , striped etc). For this was trying to see if there is a way to display images and get the user to choose. Possible ? Any creative workaround ?
How to autofill an address field based on geo coordinates
I have an excel file with 3 columns Hotel Name, Latitude, Longitude. Is there any way to import in an address field the Latitude and Longitude and at the same time the system to autofill the address, state, city etc based on these coordinates? I know that there are tools in which by giving the coordinates( manually) they return the geocoded address like the below https://www.latlong.net/Show-Latitude-Longitude.html but I do not want to do it one by one for each hotel (and then import the file to
How to refer to a field object by name
Hello, Is there a way to refer to a field object by name? For example, in JavaScript i can refer to a field the following way, but I can't figure out how it's done in Deluge. for each fld in getFIeldNames() { input[fld] = "My Value" // i want to set the value of a field here } Any help would be apprecaited.
How to add an image in a description tooltip text?
I would like to ask you if you have plans to change the description tooltip of a field as a rich text? Until now is a simple text box. For example, I would like to have an image as tooltip Something like the below https://www.scriptol.com/css/tooltip.php I know that there are alternative ways like add notes field but it is not working with mouse hover like the tooltip.
Send an Email
I want send an email data to my department which is approved in last month.
How to Split the String to Array/List?
Hi.... I have an string like "ABCDEF"...But I want to convert it into list/array like "[A,B,C,D,E,F]"...... Can any one help me?
Financial Year
Hello, How do i setup financial year in Zoho Creator.
Help counting and calculating date differences in arrayed data
I have no experience scripting for arrays, indexed lists, etc. and need help to deluge-script the following business need: I have an event_form, with a date_field, employee_field and time_field. For any given date, the number of records logged by a employee varies from one date to another. I also have a summary_form, with a date_field, employee_field, recordcount_field, and hours_field. The script should accomplish something like this, diagramed in plain English: For each date_field value and each
Form Script Not Work When I Open from Report Edit Menu
Hi, i wrote some script for my form and they working well. But when i open a form with edit menu in report scripts not work at all. For example i use some hide, diasble script for some fields. But i open the form from report edit menu all hidden fields are appear and all fields enable. How can i fix that. Add some codes to a report? or add a diffrent edit button to report. Can you help me? Thank you... (i am sorry for my English if confused)
Printing to Dymo Printer in Zoho Creator
I'm trying to build a system that lets volunteers sign in for their shift. After filling out the form, I would like to use the data from the form to print a nametag on a Dymo printer. Is that possible?
Creating a Lookup Field that Dynamically Filters
Hi Zoho Community, I'm having trouble understanding the best way to create a dynamic dropdown. Let's say I have 5 Product categories: A, B, C, D, and E. Within each category, I have 4 components: 1, 2, 3, and 4. But each component is unique to that product. So product A has components A1, A2, A3, and A4; product B has components B1, B2, B3, and B4; etc. I'd like to create a form that allows our system administrators to edit the products and categories, and I'm currently using a form and a subform
How do I store historical data of customer records for trend analysis?
I am attempting to build a customer profile database that tracks historical data. I work in high performance athletic care. Almost 100% of our business centers around long term care rather than Sales or Deals. For that reason we need a robust solution for tracking incremental incremental changes in a great deal of information over time for each individual, similar to a hospital patient care system. Examples include practice attendance records, injury and therapy progression over time, improvements
Color-coded records in calendar report
Hi, When displaying records in a calendar report, it would be nice to group records based on a field and assign a color for each group. Alternatively this could be done automatically with autogenerated colors like in Page's graph. Here is an example. This would help a lot when reading staff workloads, calendar events per company department, tasks by locations, etc.
Filter report based on subform's column?
Hi there! So i have created a report based on a form that also has a subform in it. They are related with a bidirectional relationship. The problem is that in the report (where i have 1 column from the form and 1 column from the subform), filtering options doesn't work when applied to the subform's column. If you see the attached image you will understand better what i'm traying to acomplish. In that picture there is a filter aplied to show only records from the last month (date is from subform).
How to include the multi Picklist field in Fetch Record Criteria in Deluge Script?
Hi All, Need an help. I have a problem to restrict the fetch record based on multi pick list value( Look up field having capable to select more than one value- bigintlist). Problem Outline. I have a Attendance Form which has a Absent-Students multi picklist and date field. for getting the student information for a month or certain period. To get the Attendance details for a particular student i have to restrict it based on course and semester details. but not on student id to the absent-students
Multi (More than 2) Level Form Relationships
I know that relationships are formed between 2 forms using lookup fields. Is there a way to add a 3rd level to the relationship? For example I have an app that contains Sales Orders. Each Sales Order has multiple Shipments and each shipment has multiple Inventory items. So I have a 1:M relationship between the "Sales Order" form and the "Shipments" form. And I also have a 1:M relationship between my "Shipments" form and my "Inventory" form. I need to create an invoice that has fields from all
Next Page