Is there anyway of editing the "added time" field in records
For very various reasons the data we had needed to be edited so it was done in excel. Now when we added it, the added time was all the same. Is there anyway of changing this?
Fetching a record from a dropdown/multi-select/radio List
Having trouble fetching a record from a dropdown/multi-select/radio List. I read somewehre that this is a known limitation. For Example) Form A has a field "Customer Status" with 4 radio button choices Form B want to pull the selected status into a new field Does anyone have a workaround. Thank you.
Importing: Excel to Zoho Decision Box
I'm having a real hard time trying to import a two column excel file into Zoho properly. This column contains to field: Number, True/False. I'm trying to import it to an existing table in Zoho so that the True/False field is updated. I've tried changing the true/false values to 1,0 and yes,no and it still will not update the values in my table. Really need help. This should be a simple process...
Move application to another account
I have a Zoho Creator application on my account. Now I want to move it to another account (not share!) with all forms, views and tables(with data!). (another developer will support it. And as I understand there is now ability to set two developer on one application) How can I do it? Thanks
Run schedule on certain days of a week?
Hi, Is it possible to program schedules to run on certain days of the week such as Mon, Wed & Fri? Thanks! Vishal
Initiating many records - HELP
UPDATE::: I seemed to have found the issue, but it bring up another issue. First off, what i thought was a limit on the number of records that i was able to initiate at a single time, was wrong. The problem was in the special charters that existed in the zoho reports database such as [ & , - \ () ]... After I manually removed them, the record initiation worked as it should... Now my next issue is how do i get it so it will except the special charters listed above? ------------------------------------------------
Can't rename column
I have tried repeatedly to rename a column in a view, but every time I save it (it appears to be saved on screen) but then the change disappears every time I refresh page or open it up again. https://creator.zoho.com/phillytechnews/phillytechvcinvestments/#View:venturebase_View
Relationships between applications?
I am using the free version and have created three applications - inventory, orders, and customers. I have tried using lookup fields to automate the orders form (bringing in data from products and customers), but cannot seem to get access to more than the single field I choose in the lookup field. Creating formula fields, or criteria in other types of fields, in the orders form does not see have a way to access other fields in the Products or Customer applications, except the single field chosen
Is zoho creator going to help me get more traffic by being seo friendly?
Is zoho creator seo friendly? Will the search engines look at the data as from my domain?
INserting (fetching) email via API
Hello, Is it possible to insert (upload) and email via the CRM API? That should of course include the ability to define which object to "associate" the email with, and all the relevant email fields (Subject, From, To, CC etc) with the body (in HTML or free text). If yes, is there a sample code available? Thanks,
Open a second form based on a decision on another form?
Is is possible too have a user open new form based on a choice made another form?
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
Next Page