Zoho Creator and Zoho Recruit question
I run a temporary recruitment agency and currently us Zoho Recruit for my candidate data and Job Vacancies. I have added a few custom fields to suit to my specific needs within the Candidate Module and the Job Vacancies module, however the majority is standard setup. I have a specific group of fields in my Candidate Module for reference details within Zoho Recruit. I would like to pull this data (eg school name. school address, date of employment etc) out of Recruit and then for Creator to populate
How can I make my own template form to use over and over for data in Creator
I see the pre-built templates in ZoHo Creator, can I make my own to choose from when lodaing data in?
how to stop/cancel a form ?
Hi, i have a question : how to stop submitting a form after a period of time ? let's say i want to cancel submitting form by users after two days since i publish the form into the web page. something like a timmer.
Script Builder view truncated - no scroll bar
When I go to write script in Script Builder the right hand side of the screen is truncated slightly. The scroll bar is missing, as is the right side of the SAVE SCRIPT button. The result is that I cannot scroll, and so it is very slow to move around long scripts, which is a nuisance. If I switch to Free Flow Scripting the view is fine. Any suggestions? Is it a problem with the browser, or is it at the Zoho end? (I use Internet Explorer)
Desperately seeking assistance
I'm working very hard to make Zoho Creator work for me. I must be very dumb, but things just aren't working out. I am a volunteer book review editor, and I need to maintain a database of which reviewers have which books. There are some date calculations, easily done in a spreadsheet (I've been maintaining the list in Google Docs), but a database would just work better for me -- reports, etc. Is there someone out there who will volunteer to write the field specs for the calculated fields? I don't
Using Record ID to fetch data - Is there an issue?
I am trying to fetch data from a table using the record ID. Is there a problem with this? The script below is On Load script in a form.. The first 2 lines successfully find the record number from a form and populate the Record_ID field. The last 2 lines are supposed to use the record ID to fetch the customer name (CustName) but Test_Field remains blank. I have checked that the Record_ID is valid. It was generated from another script. I can't see why this doesn't work. EditData = (Record_ID_temp[Key_Code
Edit records using stateless form - Do I need a regular form to pass data?
I am struggling to find a way to upload the data from a table to a stateless form without creating a new regular form to pass the data. Is there a simpler way to persist the data? This is what I planned to do: I would use a 'Custom Action' that is selected from the dropdown against the record to edit. This calls a function to which I can pass the record data through the arguement to the function. Then I want to use the existing data to populate the Stateless form, but I can't see how to do this
Sending an email from a view
On a view I display a url field. When clicked it opens a new tab with the appropriate web page. Is there a way I can have this trigger a deluge script? I would like to send an email to the site owner that someone clicked on the url for their site. Herb Wexler
Creating an archive table
Please may I have some help - new to Zoho, some experience with Access. I have an application : Invoice form : Invoice_ID , Date , Cust_ID Invoice item form : Invoice_Item_ID , Invoice_ID, Item_ID( LookUp from Item) , Quantity, Price(Look Up from Item) , Discount, Tax, Extended_Price Item form The item form prices will change daily / weekly or monthly . So I need to create an Archive Invoice Item Form that has the prices saved for the day the transaction took place. So I need to be able
Totalling amounts
Hi Great idea and I am hoping I can achieve what I want to do. I am trying to create a simple application for managing accounts. I have created a form that contains, simple company information together with details of the invoice (whether credit, debit, how much, type, etc). I then created several views: 1. Debits Unpaid 2. Debits Paid 3. Credits Unpaid 4. Credits Paid 5. Accounts What I would like to do is to being to have a total box for each of the views created. i.e. This is how much Debits Unpaid.
count items in colum using aggregate record
I am tracking apartment complex units that have been cleaned. I have a dropdown field with the following values: 3 – BDR and 4 BDR units. My end goal is to get a count of how many 3 –bedroom units and 4 bedroom units in the column. How would accomplish this using an aggregate record task? Example 4 - BDR Units = 10 3-BDR units = 7 Thanks
Creator API Error 2832: [application owner] parameter is not available in the request
I have a PUBLIC form and I am trying to add data to it via the Creator API. Since the form is public, my call to the API is unauthenticated so I am passing in the zc_ownername in the call parameters. Yet, I keep getting the 2832: [application owner] parameter is not available in the request error in the response. BTW, I am passing in the authtoken and scope parameters in the call. Has anyone run into this problem? Regards Moiz Tankiwala Smart Training & IT Solutions
Custom function with openUrl to open URL that has been entered in form does not work?
I am having some issues with the custom actions. I have a form called "Suburbs" in which I have two fields, "Suburb" (which is a text field) and "RPData" (a URL field). I want to create a view which has two columns, the "Suburb" field and a custom action "View Suburb Profile" I have defined the custom action: I then have created a view, where I can select a suburb, and then click on the custom action View suburb profile, which I want to then launch the RP_Data URL for that suburb. However, when
Custom Actions and Edit menu problem in popup views
Hello ZC team, If a view is opened in a popup window, using zc_Loadin=dialog parameter, and the view has Custom Actions dropdown, look what happens I have to go to bottom of the page to access custom actions. Also, when I access Edit menu, I get a similar result and even worse, not all items are visible. Please solve this as fast as possible - it is a problem with the new views layout implementation which simply broke existing functionality. Also, even if I think that overall the new layout for views,
How to Redirect to a URL instead of getting xml response while adding records using REST API method ?
Hi, I am having a web page using which i am entering the data in to zoho creator using the "REST API Add Record" method.I am using the xml as request method and getting the Response as an xml when submit is clicked. But i want the page to redirect to another page insted of getting the xml response after clicking on submit button. Please provide me information on how to get this done.
I need more detailed explanation of how to add dates from my forms to a google calendar
I'd like My office assistant to schedule appts for my office employees. Based on the employee she is scheduling to service that order, I'd like it to look up their Google Calendar (she has permissions via google to write to their calendars) and insert the appt on their calendar. I've found some on success gapp create event in some of the help, but I can't seem to get it to work. Any ideas for a beginner?
How to check if picklist selection has been selected before in previous rows in a subform?
Hi! I've got a picklist under the field "Item". I need to know how to check if the user is trying to select some Item on the picklist that has been selected previously in a subform. The tricky part is prior to hitting the "submit" button, nothing is updated to the tables yet. So how I can check and prompt user that this is a duplicate selection?
Get Customer Info back to Zoho Creator
After customers are created in Zoho Invoice, is it possible to have Account Balance information sent back to Zoho Creator. Again all of my customers are already in Zoho Invoice and I would like to update account balances back into Zoho Creator. Is there a .getCustomer() function?
Format font when record is edited
I would like to be able to some how edit the font of any field that was edited when a record was viewed/edited/updated. For example: Original field: "Customer:" Field after update: "Customer" I currently have "send email" on success when a record is updated and I would like for whoever views to be able to easily see which field was edited from the original record.
Calculate expiry date
4 years from delivery date is my Expiry date. How could I calculate dates 4 years from now and to output dates as an answer for the expiry date instead of integers. Please help.
Possible Budget Sheet With Creator?
I am not sure what happened to my previous post - if it was ever posted or not. Would it be possible with Zoho Creator to produce a form and view like the following? : http://i.imgur.com/3qsRf.gif The form will be used by 3 parties: staff, contractors, architects. I want staff to be able to specify the rows and columns. Architects will be able to see columns A and B only and fill out B only. Contractors will be able to see columns A, C, and D and fill out C and D only. Staff can see everything and
Send data to zoho support
HI I want to send data to zoho support form from my zoho creator application i m trying to use posturl but it is not working for me can kindly someone clarify me first thing whether it is posible or not and what is the best possible way to do it. Regards Rana Ammar
how can i make a login page and how it works
i make a login page bt i cant understand how it fetch records with given id
If then script using greater than and less than
I have a form called Recruitment, and in that form I have the following fields: Target (number field) Current Recruitment Total (number field) Local % (formula field) Range (dropdown field) Local % calculates Current Recruitment Total/Target * 100 What I want to do is create a report that will have Range on the x-axis and count of Local % on the y-axis. The reason for this is that when I currently create a report, it automatically generates the x-axis for me, and I do not want that. I want
Zoho Creator and Zoho Writer
I would like the ability to connect fields from a single record in ZC into a ZWriter document, with those fields arranged and formatted in a ZWriter Doc. This would work similar to the dynamic fields available in ZSites (that are connected to your ZC databases). There could be a custom action button on a certain view that called the integration API connected to a ZWriter template where those fields exist. Anybody know how to do something like this? Maybe I'm missing an obvious way of doing it?
Zoho iCal feed
Okay I want to create an iCal feed to the zoho calendar. I have been able to create it, but I have a couple questions about ways to use it. My first question is whether or not it is possible to feed multiple fields into one handle. For instance if I have Customer_name, Job_Type and Sales_Person and I want them all to go into the DESCRIPTION= part of the iCal url. Then on top of that is there anyway to seperate those by newlines when they go into the Description. This is really all about changing
Free Plan, App Restrictions
Are there any restrictions to the 3 apps in the free plan? Is there a certain number of questions that it can't exceed if it's a survey?
POST data to external server.
I have been tasked with making an anonymous suggestion box using Zoho Creator. For example, there is a multiline textbox called input_box. Now when the user presses the submit button on the application, what should the script look like? I would like to take this data to a specific connector and then have the data go into a Cassandra server.
View design
In embedded a view in an html view (div tag). This works fine but two things are very ugly and probably a bug. 1. When I mouseover the edit button of a record (no dropdown as everything else is disabled) it turns black. The attached printscreen did not capture the mouse pointer itself, but it is right over the black box. 2. There is a big bar of dead white space where the view header was (I disabled it with zc_Header=false). See attached pic. Any help appreciated (edit access enabled; application
How To Add Product Details into Invoice Section Of Zoho CRM using Map() ?
Hi, I am currently adding the data from zoho creator to the invoices section of zoho crm. I using the following process shown in the url below, https://kbase.creator.zoho.com/crm/push-to-zoho-crm I could able to store the data related to the Invoices like Account Name,Subject.But i am not able to add data to the Product Details Section of Invoice.I want the "Product Name","Qty","List Price" to be stored along with the invoice data. Below is the script i have written for mapping from zoho creator
Passing List Value as a parameter to HTML view
Hi, Is it possible to pass a list() as a parameter to a HTML view? If yes, please tell me how. Thanks for your help. V
predefined path in URL export of CSV
I have a form in which on submit i export a CSV file containing all the data for that entry, which is driven by the URL. I wanted to know if there was anyway i could predefine the path in which the csv is downloaded to. There is only going to be a single user of this form, so the path should already remain the same. Thank you
How to Send Email's Seperately for every user record using a Scheduler?
Hi, I am using schedulers which will send an email upon a given date in my application.The To Address is having the admin address and i am getting those mails. Is it possible to have the email sent to the the email address field associated with that record? Please let me know whether there is a solution for this.
Modeling a Budget Sheet
Is there any advice available on modeling a two dimensional budget sheet? I am planning a sort of bid and budget management platform for jobs. Here is an example created in Excel: The items in column A will be anywhere from 100-200 items and are NOT set by designer/contractor but by my company. Designers will be able to edit column B. Contractors will be able to edit column C and D. Administrators will be able to edit A, E, and F. I would like to emulate this look in both the form and the view. Is
Embed google gadgets in HTML view
I want to embed google gadgets like clock , calender etc in HTML View. How can I do it
lookup questions
Hello I've got a couple of questions about lookups 1) There appears to be a limitation about lookups if the field being searched on has a " in it. I am getting an error stating invalid entries found when trying to add a record. I have removed them and its all ok but can't see anything which states whether or not this is a limitation or whether there is something else. 2) I also have a number of lookups in my application forms and and created an number of views for the users to see the data included.
Problem with the Dropdown Show choices in alphabetical order
Hello, I am having a problem (may be a bug), where I have created a dropdown that onLoad gets all the account names from the CRM, I have checked off the checkbox that says "Show choices in alphabetical order", but it is not alphabetizing them. Is there a way to fix this please? Thank you for your time.
Can't find the error...
Here is my code following a tutorial on the forums about mapping variables. I have followed line through line of the code and am getting an error with the "void" function. In the script editor, the error reads: "Encountered "void" at line 17, column 1., Was expecting one of:"if" ..."for" ..."delete" ..."insert" ... "inserthtml" ..."share" ..."unshare" ..."%>" ... fields=getFieldNames(); form_map=map(); for each field in fields { value=getFieldValue(field); form_map.put(field,value); } void
ZC Mobile - HTML view
Hi guys, Am new to ZC. Is it possible to set 'native' views and forms to be visible to mobile only, while the desktop user will see only HTML views? Appreciate your prompt comments, Gidday Idan
combining string records
I have two string records, "first name" and "last name", and I want to group them together to make a single "full name" string. How can I do this? I've tried assigning variable, but it doesn't seem to work.
Next Page