custom json export (link creator report to external app)
hi just need integrate creator's app database with external application application query data from creator's app via json how can i make creator's view so that external app can access it and query data via json? (in manner as on screenshot) or it can make via Zoho Reports functionality? example of data that external app understand:
Using images as hyperlinks; Adding Alt and Title strings; Setting Image size
Here I am sharing my experence as tutorial; could be helpful Using images as hyperlinks; Adding Alt and Title strings; Setting Image size Scope: Following Tutorial applies to images added as field type image (not file upload). Step 1.Please prepare image named “TestImage.jpg” with approximate size 100X100 px. Step 2. Create form “Images” with 2 fields: Field 1: Type: Image; Field Name: Image; Field deluge Name: Image Field 2: Type: Multi Line; Field Name: “Multi Line”; Field Deluge Name:
Change Report Script to show Totals not all records
Hi Guys, I have the current script to generate a report: spreadsheet Hours_Report_for_Wages_II { displayname = "Hours Report for Wages (II)" show all rows from Employee_Time_Sheet ( Name Hours ) filters ( Date_field "Last Week Hours Only" : Date_field in last 7 days ) group by ( Name ascending ) } Can anyone help me with how I edit this script to the report only shows one row per Name and the total number of
Custom action to send veiw/ report via e-mail
Hi, I'm having trouble understanding how to configure a custom action that would allow me to send a PDF or plain text copy of a Form report/view. I followed the instructions on the How to , however I am still not able to send the report via the custom action The custom actions sends the report but it does not send the report (PDF file) I have a work assignment form which consists of a an Employee field. The employee field is a look up filed back to my Employee tble. My Employees tbl consists of
Postal Code input mask
I was wondering what the code is to mask a input to canadian postal code format.
Any suggestions for this one please
I have 10 staff, within my database I am trying to figure out how to..... 1. allow them to select the days and times they are available to work. 2. allow me to view i diary with them all listed Thanks
Highlight a field
Is there a way of changing the background colour of individual fields? To help users check certain fields, I would like to highlight them.
Pivot Table column with
Hi, I started to use the Pivot Table and I have some problems in the column size, I used the pdf export with automatic size and with A4 and this below the result. The first problem I saw is the column size that seems to e random "carico" is two time "scarico" The alignment is sometime to left and sometime to right Is it possible to adapt it in some way? Thank you Giovanni
Help with timing please
Hi, I am using the following code if (input.Telephone.length() = 11) { sendmail ( To : input.Telephone + "@textmagic.com" From : zoho.adminuserid Subject : "This is Nigel from " + input.Solicitor Message : input.Text_to_send ) } This effectively sends an email that is converted into texts. I often work on files late at night or early in the morning so obviously I cant send then as I do not want to disturb. How can I use the above code
New Enquiry
Hi All, I have just become aware of this product. Our requirements are that we have numerous devices (Approximately 2500 Devices) in the market that generate volume or yield. We measure all the devices weekly and the results are uploaded to a spreadsheet. This then generates a historical representation for all the devices and customers allowing us to ascertain the performance of the devices per Account. It would be preferential to move away from a spreadsheet and into Zoho so that the
Add Question Logic
Can someone show me a screen shot of where I would find the option to add question logic? Thanks!
Create Wordpress post from Creator form submission
Is it possible to integrate Wordpress so that a new draft post created from the data submitted in the Zoho Creator form?
Zoho Creator and USSD (Unstructured Supplementary Service Data) - Is this possible
Hi, I have some forms in Zoho Creator that collect client info. Is is possible that somehow (maybe through API) that the same form can be used to interact with prospective clients via USSD (Unstructured Supplementary Service Data)? For example, client dials a short code on their mobile phone and then a welcome message and options appear on the screen of their mobile phone etc. Please bear with me if my question doesn't make sense. I'm not a techno guy, I'm just a visionary. Any help would be appreciated.
Push Data to an External Website - Is this possible?
Hi, I'm providing a service for clients where I interact with a government website. I collect the clients information which I store in a form on Zoho Creator. Currently, I have to log into the governments website (using a username and password) and enter my clients information on the government's online form. The government processes my application, approves it and sends me a confirmation certificate. I then forward the certificate back to my client. I wanted to find out if I can export/send the
Send form data to external website
Hi I have gone through this guide (Webdata) iprovided by Zoho but I really don't understand it (I don't have an IT background). Please can you provide a sample script of what I want to achieve. This is what I want to do: Order Form on Zoho creator has the following fields: Name, Surname, Email, Address etc. On Add -> Success, I want this data to be pushed to an external site that also contains a form with the same fields as my Order Form found in Zoho Creator. The tricky part is that for me to access
Is it impossible to paste text into script builder?
I'm trying to paste some script from textedit into the script builder and keep getting an error when I try to save the script. Below is the script I'm trying to paste and it looks exactly like the script I built using the builder manually. input.Zip_Code == "27150” || input.Zip_Code == "27151” || input.Zip_Code == "27152” || input.Zip_Code == "27153” || input.Zip_Code == "27154” || input.Zip_Code == "27155” || input.Zip_Code == "27156” || input.Zip_Code == "27157” || input.Zip_Code == "27158” ||
Refresh a Report with New Entry
Hi team, I've built a page that contains a form and a report of that form. I would like the report (or the entire page) to refresh when a new entry is submitted via the form. How do I do this? Danielle
SQL SYNTAX REFERENCE FOR ZOHO
I am trying to find a reference guide for Zoho SQL Syntax: for example this function does not work but I do not have an sQL syntax reference to correct it: void DEFAULT.DELACTS() { delete from acct [(CANADA_TRANSIT_BRANCH like "*editme" && flag_temp == "XIALEGOUYAN")]; }
Lookup field to assciated ID field
I need a lookup field to associate the ID field of child form, but show value from another 2 to 3 columns; how can this be done?
SMS function - International numbers
Hi, I'm from South Africa and our international code on contact numbers is (+27 or 0027). If, I want to use the Zoho default sms function, does my number field have to have the contact number in the international format or any format would do? For example, here in South Africa, mobile numbers start with a "zero". If the international format is required how can I configure my field or script so that what ever "number" is entered into my contact number field has the "+27" international code for South
Can someone help with this code?
I'm trying to setup a function to email certain people based on the zip code entered into a form and I'm getting an error with the following code. It's telling me there's an error at line number 1, which is the whole zip code or statements. if ( (input.Zip_Code == "92807") || (input.Zip_Code == "92808") || (input.Zip_Code == "92823") || (input.Zip_Code == "92870") || (input.Zip_Code == "92886") || (input.Zip_Code == "92887") ) { sendmail [ from:zoho.adminuserid to:"jason@lean-labs.com"
Auto Welcome Email to those that register off our form.
I'm looking to create a welcome email back to those that register for our events after they fill out the form and submit it. I'm looking for this to be automated so as someone registers, it will kick out and email back to them of all the details for the event and a thank you for registering. Can anyone help me with this, I think I can do it but might need some guidance. Thanks - Mike Olivera
Error Duplicating records
Could you please tell me why I am getting an error whilst duplicating a record in mrcomputer/signedfast. I assume it is a scripting error but I don't know. Thanks
Variable not defined help Please
I have for called Staff it has field called Staff_Member It has field called Cut_Code in main form I enter Staff member using lookup field I try to populate Cut_Code from Staff_Member choice by on user input in Staff_Member but the following code returns error when I try to save saying Error at line number : 1 Variable 'Staff' is not defined My code is if (Staff[Staff_Member == input.Staff].count() < 10000) { temp = Staff [Staff_Member == input.Staff]; input.Cut_Code =
Can I Cancel Submit if my field in not hidden?
My form checks from the user if he has filled the form previously or no. If he/she chooses yes in radio button I show an id box to enter the id they used. On filling the ID, some times they try to click submit anyway and it ends up asking for all the mandatory hidden fields which is a mess. I want to cancel submit if my field which determines if the user has filled the form before is visible and not hidden? Is this possible?
Filter a subform?
Is there a way to filter a subform. Perhaps if row.field = "Inactive" { hide row }
Schedule limit
What does this mean please You have reached the maximum Schedule limit permitted for this account. Please upgrade to add more. Thanks
Invoice with Multiple Lines
Hi, I'm working on a project where I'll have vendors across the country that will collect orders and payments for me. They will pay me the total payment less commission that we agree upon. I will grant them access on Zoho Creator - Customer portal where they can keep track of the orders they submit to me. For each vendor, I want to export all the orders they submit (on a given period) to Zoho books and prepare an invoice. I've just tested the export feature from Zoho Creator to Zoho Books and it
Copy Record only once
Hi, I've been testing the script below on copying records to another form: void copyRecord(string Name, int Phone, string Email) { insert into Clients [ Email = input.Email Name = input.Name Phone = input.Phone Added_User = zoho.loginuser ] } I noticed that this script allows you to copy the same record more than once into another form. I want to only copy a record only once. How can I modify this script (or another script) so that once a record is copied into another form by executing this script,
Help with permission of field
I want certain fields to only be accessible to certain users in my company. When I click on the "Show field to" under permission in the field properties, it only shows 'Everyone' and 'Admin Only' Hew can I add individual users to this list please. Thanks
help with script please
I have created a customer database When I wrote I put number field for tel.No. it misses out the leading 0 So I have created new tel no field using single line All works fine apart from me having hundreds of entry's in old telephone field that I want to move to new telephone field. I wrote a function to do this but I cant get it to save Can anyone help please. Function reads as follows....... void telnos() { for each rec in Jobs [((ID is not null))] { input.Mobile = input.Mobileold; } }
Default setting for Rich Text field
is there a way to have a default value for a Rich Text field? For example, I want a table in the field. I tried loading the table into a notes field, and then having the RichText field = the value of the notes field, but that didn't work
Does Creator API record update method work?
Urgently need to verify if updating a form via the API works. Trying to follow the documentation, I am wanting in this case to update the Payment_Status field in the Invoicing_Record form for a single record https://creator.zoho.com/api/<owner>/json/<application name>/form/Invoicing_Record/record/update/?scope=creatorapi&authtoken=<xxxxxx>&criteria=(ID = "1612333000000810121")&Payment_Status=Paid in full This request POSTS ok (200 response) but returns output of the Zoho Creator home page or something.
Shared user edit permission
How do I give my shared users edit permissions. All the posts are a few years old and shoe the old system Thanks
No access in China again
The access in China to the Zoho.com suites has always been intermittent since several years ago. Recently it has been more frequent. Some days in China we can visit zoho.com OK. Some days the creator.zoho.com suite does not load at all. Maybe it's high time you guys put some image servers in China????
Fetching wrong data
Hi, I have a Condo management app where I have two Condos with the same Unit Number but located in different properties and belonging to different Mngt_companies. I am using "Fetch Record" to auto fill in details such as Mng_Company and others. When I select the Property and unit number, the wrong Mngt_Company is Fetched. I have deleted the record in my master units form and recreating it but nothing seems to fix my issue. Thanks for your help. this is the script I am using: if(input.Unit_Number
how to set popup window size
Hi, Can anyone tell me how can I set a popup window size? I tried to follow an example in the forum where they put the size in the parameter field: "height=500px, width=500px" but it does not work. Cheers
Auto fill changed fields
Hi Lets say I have 1000 records I add a field 'Week of year' I have a field called Visit_date which has an on user input Script that reads ' Week_of_year = Visit_date.getWeekOfYear()' Script works fine My problem is how do I populate the 'Week of year field' without going into every record and activating the script in the field by changing the date. Thanks
Is it possible to auto populate existing records with new information?
Our Creator database consists of a main form with several sub forms linked. We use the main form to collect demographics and the sub forms to collect specific information about the product purchased. We would like to be able to pull reports that include information from the main form and a sub form. I believe the easiest method would be to add the demographic information to the sub forms (I have worked out the code to auto populate this information moving forward) but I do not want to have to go
send email to Group (as defined under USer Management, not as a form in a creator application)
what is the script for referring to a Group if I want to send an email to that group on a field-update action. the group is not a list of emails in a table in the application. The Group is defined under "User Management" I know zoho.adminuserid refers to "me". but if the group name is "Cost_Change". then what is the deluge script to find this? thanks
Next Page