Is possible to get data from a Zoho Spreadsheat?
Hello, We have a form in our Creator. The user type some data and we need to use this data to do some calculations. Is it possible to call or get in some way this calculations from a Zoho Spreadsheat? Thanks,
Open a record-summary with an openurl statement?
Is it possible to open a record-summary with an openurl statement? I would like to do this from a decision box on a form. I want it to popup over the form and when it is closed come back to the form. Is it possible to automatically bypass the browser from blocking this as a popup?
how to localize system menu?
hi need localize system menu.
Mail merge from filtered list
Hi. I have a database that records pallets in and out of our warehouse. I need to create a mail merge or other method of printing pallet labels which contain some of the fields for each record in a filtered list. Ideally I need to create an A4 label for each record which print when selected without the need to export the data to .csv files and merge with another office program. Can this be done from within Zoho Creator. Thanks.
Image in html view using publish url
Hi, I have one HTML page name is Welcome and one report name is Image Report. I want to fetch the image from Image report and displayed in Welcome page. Finally i want to embed Welcome page in my website. how to get a image src link in (Image report) publish url? Thanks Satya NHM
Delete record from a Form and Insert the deleted record to another form
Hi, I am trying to figure out script that delete a record from FormA and insert the same deleted record to another formB Below is sample what I am using to delete the record if (input.Update_Sub01 != null) { if (chan_count1 < 1) { delete from Chanel_Database[ (CD_tvId == input.Update_TVID && CD_channel_NO == input.Update_channelNo01)]; } } I want to insert the above deleted record to another form - FormB Could anyone please help me ? Thanks Arfater
Change dynamically radio button values in a subform which are related to a lookup field
Dear All, I have the following subform which consists of a lookup field (Excursions) and a radio button (Radio). The excursions are loaded in the on load action when I open the form. I would like when I select the Radio (Full Day in that case) in the 1st row then to show the 'Full Day' automatically in the 2nd row (because they have the same Excursions Selection). When I select 'Half Day' in the 3rd row then to show 'Half Day' in the following 2 rows (4th-5th) etc. In other words, if I have the same
how to localize buttons?
hi just made localized text on buttons in form. but when open entry - there is text in english how to localize it correctly?
Verify Records exist in one form that are in another form
I want to verify that records exist in more than one form. FormA and FormB I want to verify that records exist in FormA that are in FormB ( I would like to count the number of records not in FormA)
Disable subform fields one by one
Dear All, I would like to ask you if it is possible via deluge code to disable only some fields - cells in a subform. In the following example I would like to disable the fields one by one. Is it possible? If yes, do you have a short example to show me?
insert new record based on data called in a subform
Have a button on a subform, and when I select it I want to insert a new record into a separate form. I am having trouble.
Error while inserting data
Hi, I'm trying to add data from Form A to Form B, I have added the script in Form A "on edit - on success". Form name explanation: Form A = To_Do_Form url - https://creator.zoho.com/appbuilder/piju2111/penta-crm-11/form/To_Do_Form/workflow/edit Form B = P_L url https://creator.zoho.com/appbuilder/piju2111/penta-crm-11/form/P_L/Sales_Ticket/workflow/edit Script in Form A: insert into P_L [ Purchase_Date = input.Closed_Date Purchase_Ticket = input.Ticket_No
How to get IOS data for a single contact into a ZC client form
In many cases the basic date already exists as a Contact in in the IOS Contacts app. Is there any way now with the new Apple extensions to transfer the contact data directly into the ZC client form? For example the app Docusign can now immediately access the IOS contact on the Ipad and use the data. This is very very useful and eliminates constant duplication of data entry.
Get Zoho Support Record by ID
Hi, I have to build a scheduled task to get a record from Zoho Support and check its ticket status on a periodic basis. I can use zoho.support.getRecords(), but it returns multiple records which is not what I need. Is there a function I can use to fetch a single Zoho Support record by id that is equivalent to Zoho CRM integration function zoho.crm.getRecordById()? Thank you.
Concatenating 2 fields from different tables and showing them?
Hi there I have Contact Header (eg; Companies) and Contacts (people working at that company) = so far that is good. I then want a Leads/Projects that is linked to Contacts. So ideally I'd like to be able to see a list of Contacts and Companies for the user to select from. Example: (Contacts combined with Companies) Abby (Internet Spotters) Tony (Freds Emporium) Will (Angus Traders) So when the user creates a new Project then the user would auto-type/select from a drop down list of Contacts. The reason
how to close a stateless form
I have a stateless form that popups up on a condition. one of the buttons is to close the form. it dose not close. what am I missing.. openUrl("#Script:dialog.close", "same window");
OT - Creator is really good - but not well explained... (not complaining as such)
I do really like Creator and it has a lot of depth but some of it is quite buried. This is not a complaint - just a concern. Example; the "Pages" can (if I knew) really customise the look / feel of an application and I have been reading through the documentation and I think it is all there - but just a case of working through it all... I mean in Pages there is a little tiny icon in the upper right where it shows all the fields you can embed into your page. And in Reports there is a whole report writer
How do I populate an email by clicking a URL in a mobile view
I would like users of the mobile version of my application to be able to click a link within a record that invokes an email to be sent to pre-selected email addresses and includes inputs from the record in the body of the email. Example: A record is created by an administrator that represents one step from a checklist describing how to install software. In that record, 4 contacts with email addresses are assigned using a multiselect lookup dropdown. They are support personnel for that step. A user
HTML special Characters
Hi All, I want to include the up arrow ↑ and down arrow ↓ html special characters as part of a text string for a field value. However, when I try to add the html entity name, the string just shows the characters and not the symbol. Perhaps special characters are not supported in field values? Thanks in advance for any help.
Sendmail Custom Action
Hi All, I'm very new to Zoho and coding in general. I'm looking to create a custom action that will allow the user to select a record or multiple records and email it to an email address they specify (or at least to themselves if that's not possible). Is this possible? Can I email the record using a record summary template? Tim
How can I put a message on a screen that is dependent on the combination my form inputs
I'm struggling to create my first application and would appreciate some guidance. I want o create a small 'expert system' that displays a different answer based on different combinations on inputs. I can create an entry form easily enough. But I'm lost to know what to do next? thanks
Pivot chart creation
Hi, Is there any way to make the following chart from Zoho Creator? . Thanks Satya NHM
Is it possible to move a record from 1 form to another?
Hi guys I have set up a simple form which I want to use for inventory purposes. Each item is stored at the warehouse for a certain amount of time, before it is bought back to the production unit for work to commence on it. I would like the ability to move a record from the form that shows all of the items stored at the warehouse to a seperate archive form of records that shows all of the old items that are no longer stored at the warehouse. Is this possible? Many thanks Tom
On Validate allow either the Added_User or an adminuser to edit
on validate - I want to allow either the Added_User or an adminuser to edit a record. Other users should not be able to edit the record. I've tried a few different statements at "on validate" but cannot get them to work. I am an admin and I attempt to edit another users record as the test. So far, test failed. Any help is welcome. Two examples are below of statements I've tried to use. >> I've tried this if (input.Added_User != zoho.loginuser)||(zoho.loginuser != zoho.adminuser) { alert "You
PDF conversion for multi-page dynamic pages
Hi, I have a dynamic page generated from data in a form that fills in a template. This works fine and displays well rendering all HTML as it should. The issue I'm having occurs when I try to use the PDF exporting functionality. Since some pages extend over multiple pages, text at the bottom of the page overflows failing to respect margins and any padding. I have created a print-only style sheet that defines margins for the pages and padding for specific elements but the overflow is constant. Can
How to sum related records?
Hello, I have two tables: one list my works and another one relatated counts worked hours. I would like put a formula in works table that sum all worked hours for selected work. Thank you
Creator does not seem to have CRM's workflows?
One of the things I like about Zoho CRM is the "workflow" - Creator says "workflow" but it is programming. It is a shame it could not replicate the CRM "workflow" module. Does anyone else see any utility in it? Thank you Brynley
Criteria from multiple fields for lookup
I know similar situations have been addressed, but I'm having trouble implementing a solution. I am working with 4 forms right now. Crops_form Section_form Planting_form Harvest_form One record in Crops_form is related to many records in Planting_form One record in Section_form is related to many records in Planting_form In the Harvest_form, there is a single-select look-up field "Crops_field" which looks to the Crop_form a multiselect look-up field "Section_field" which looks to the Section_form
Make fields smaller? (lots of fields on a form = lots of scrolling to see the fields)
Hi there Is there any trick to squeeze more fields onto a Form? One of my Tables has about 25 fields and the standard way Zoho lays them out means the user has to scroll down to see them. I don't see this being possible but thought I'd ask anyhow. I have also tried to break the Form up by making some fields looked up in a different table - but this would be a 1 to 1 relationship. Thank you Brynley
Zoho.support.create function call
I submitted a support request last week, but, not unexpectedly, there has been no follow up from Zoho technical support. I am hoping for better response on this forum. I am trying to integrate several Zoho products (Creator, Support, CRM, Projects, etc.) into a workflow. At this point, I need to have Zoho Creator submit at ticket in Zoho Support via integration task/call function zoho.support.create. When the function is executed, the ticket gets created correctly. However, the data contained in
Domain validation
Hi I have ".photography" extension domain email ,i try insert the email like as " name@abc.photography " but its not inserted in form Thanks Satya NHM
email field limitations
Is there a limit on the number of characters that can be after the . in an email address? This email produces an error when I try to save the form. name@xyz.consulting A shorter domain does save name@xyz.consult
How to display the first item in a list... as the first item in a drop down box?
I've created a list from items stored in a form, sorted the list and placed it into a drop down box. "Everything works as expected". I would like to display the first element in the sorted list as the default choice in the drop down box. As it is now: As I would like it to display: I'm thinking the syntax should be something like --> input.Service_History = <sorted list> element (1) ; Thank you for any help Alan
Auto populate crm fields contact and account in creator
I have added a contact and account field from the CRM to Creator. When I access it form the CRM I would like it to auto populate the contact in the CRM I was just viewing. How can it auto populate those fields? Joe
Authorizing Zoho Creator to use Google Calendar
I am trying to add an event to the google calendar using a form in zoho creator. I'm unsure if I will need OAUTH 2.0 working between zoho and google. If this is the case. Is there an example for connecting to google calendar with oauth 2.0 authorization? Here's what I have so far posttest = "https://accounts.google.com/o/oauth2/auth?scope=calendar&redirect_uri=https://creator.zoho.com/oauth2callback&response_type=token&client_id=Client_id_from_google_oauth"; responsy = getUrl(posttest); The error
Google map not showing in add notes field
Hi 1) Google map not showing in add notes filed i use below script input.plain = (("</br><div width = '320px' height = '320px' style='border: 1px solid #A4A4A4;'> <img src='http://maps.googleapis.com/maps/api/staticmap?center=" + input.Address1 + "&zoom=17&markers=size:mid|color:blue|label:S|") + input.Address1) + "&size=320x320&sensor=true'> </div>"; 2) is it possible to insert map in image filed? Thanks Satya NHM
how to add file via webhook?
hi how can i add file from any system to creator's app via webhook?
Is it possible to call a function that opens a form record in Edit Mode and then Updates that record?
Reading here it seems I've painted myself into a common corner here at ZC... BACKGROUND INFO: I have a form dense with scripts and formulas, lets call it JOB. Another form called INVOICE is populated with information from JOB. In order for an INVOICE form record to be correct, one has to make sure the JOB form record that will feed data to the INVOICE form record is up-to-date. Currently, to make sure an INVOICE form record is correctly populated with up-to-date JOB data, one has to manually
help
help
Validation -- between Zoho Report Query Table and Zoho Creator Form
Hi, What I am trying to do is to validate the user input comparing the Zoho Report query Table. I have a Stainless form which is used to update the Data inside creator. and I have another query table in Zoho Report also .. now I want to make user input the data correctly based on the Zoho Report Query Table. So I would like to create a script that validate the inputed data inside Zoho Reports Query Table first if it is true then user can enter the data. Zoho Report Table Screenshot : MVPD :
Next Page