Create a printable format from Zoho Creator
Basically, I am creating a database of lesson plans for teachers. I want to then be able to extract the data to print out in multiple ways in an easily understood format for teachers while keeping the formatting (italic, bullets etc.) that I used when I input the data into the Zoho Database from my Zoho creator App. For example, I have the following fields (most in drop down menus): Unit Name Unit Number Overall Week Number Unit Week Number Day of Week Number Materials Objectives Vocabulary Set
I have a problem creating Invoices from Creator
I am trying to set up Invoice creation from a form in Creator but get the error message Error in statement at line number 1 The field input.Invoice_Detail_Status is of type BOOLEAN. But you are trying to update it with data of type MAP What type of field should Invoice_Detail_Status be? Hope someone can help Thanks David
File download and public access : how to restrict form ?
Hello, I have read some posts about linking a file into email. I discovered that my application should be public to allow people downloading things. But how can I protect a form of being sent or even viewed while keeping my application public to access download file ? What I need : - Uploaded files should be downloadable from an email - The form used to upload file should only be accessible from allowed-only users. How to mix public access required by download with user restriction in my app ? Thank
Added form
I have created a bid form and would like it to link to my contact info. How do I do this? Also, I would like to get rid of the image download on the contact manager. I tried and it gave me a dialog box list other places it is used. How can I get this to go away?
Just imported a application form into my website, why do people need to log-in to access the forms?
I just inserted the forms into the iframe of my joomla site, when I see it live, it requests a log in for people to fill out the application. Is there a way to make it available without a log in? that defeats the purpose... HELP??? this is for an animal adoption app. Thanks!
Web forms input to Zoho Creator Basic?
Is there a way with Zoho Creator Basic to have a form on my website send data to my Zoho database automatically?
two form/views in a single view
Hi, I would like to know how I can have a view in which I have the summary of a selected record (Form 1) , and then below a list of records (Form 2) linked to the record summary listed above. An example of what I want to achieve is a work order record summary on top and then various daily update records linked to that work order ID. This would be similar to a sales record summary above (form 1) and then a list of products sold (form 2) below. thanks for your help...
download attachments as files -- login for FileDownloader app not working
Hello Zoho, Back in March, I posted a topic about downloading attached files as docs. I received a response about an app that I downloaded and I remember this working really well - https://help.zoho.com/portal/en/community/topic/download-all-attachments-as-docs However, I just tried doing this again, and my login credentials get rejected. Is there anything that's changed that affects the behavior of this app? It is REALLY useful. Thanks, Kim
adding days to dates
I need to add 365 days to a certain date field. In an other topic somebody wrote: If you have a Date field in your Form for Start Date, add another date field(Expiry Date) in your Form and write a code in the On success of the form as follows.... input.Expiry_Date== input.Start_Date.addYear(2); I am trying this, but I think I need a more detailed explanation. Where do I add this expression? And how? Thanks for you help!
Allow attachments - other that just Scheduler
I have a script set to run in Scheduler to send an email with a view PDF attachment. I am trying to now make a funtion to do the same thing (rather than just making it scheduled). it is telling me: "Attachment is only applicable for scheduler actions" Is there a reason for this limitation? Does not make sense to me.
View with a record summary and below a list of records linked to the one on top
How can I create a view that shows a record summary on top and a list of various records linked to the one on top. Say, we have a sales order with client, date, etc.. on top. We want this info on top of the view for the selected record. Then another form (sold items) holds products sold and are linked to their sales orde, i.e. the sold item record have a look up field linking to the sales order. I want to see the sales order details on top and a list of sold items linked to that sales order
can not edit an app taken in marketplace for free
hi all, hope u r fine !! i ve download an app in marketplace for free, the name is easy salary. But i can t edit it, when i try to do so, i can only see a "share mode" do you have any idea ? btw...i just discovered zoho creator for 3 days now, and woww you ve done a great job guys !! francois
Zoho Creator csv feed to Zoho reports
According to your slideshow available at the below link to make data available from Creator to Reports, from view mode, you select 'more actions', Export data and select CSV feed (a screenshot is provided). However, the options within export data is different for me and all export data options exports and downloads the data in the selected file format. There is no option to select a feed. Please advise urgently as I have just spent 2 hours trying to find pages in your help section as your 24/7 phone
Sub Forms?
Was sub forms part of Creator 3.0?
Auto Filters Activating more than one at a time
Hi, I have a view with auto filters derived from form Lookup entries One filter is the name of the Sales Rep, One filter is the Status of the sale So i can autofilter on the Sales Rep name OR i can auto filter on the status What i would like to do Auto filter on the Sales Rep and then further filter on the Status So an Auto Filter of an Auto Filter Any ideas ? Thanks
Accidental Mass Delete - Help!
I have created 2 views that receive data whenever a form is submitted. They both store user input, but one view also records the user's application status. The other view is only a holding place until user input is process by a real person. After processing the data from the second view today, I did a mass delete on the view, since I only want data stored in that view that has not been processed by a human. To my dismay, I found out that all of the input user data in the first view was also deleted,
Edit a related field in a combined view
I have a combined view with fields from an employee application form and fields from a related manager review form. When I use the edit button on the combined view, the fields from the manager review form are not available to edit. Is it possible to edit fields from both forms from the combined view?
Cannot fetch data in reports.
Please look into the report title: PANB Contact Participation based on view of the same title. The report, it cannot fetch complete data from the field :Individual contacts (a pick up field, single entry). It can only pick up 5 out of 60 entries. Edith
Error in Sample Application
Dear zCreator Team, I was redirected to a sample application for DateTime Picker (https://creator.zoho.com/sampleapps/time-format/form-perma/Date_Time_Picker/) in this URL (https://help.zoho.com/portal/en/community/topic/masked-edit-textbox-in-contact-form) I think the sample application is not working. It is throwing an error message "Error occured please contact application owner." as illustated in the attachment. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
HELP! URGENT! Custom views: 'There is no such form in Zoho Creator'
Hi, We've just tried to categorise our data by saving it in different views. However, when we go to edit an entry, the site crashes and we get a message saying 'There is no such form in Zoho Creator'. How can we edit our entries now they are split into different views?
All fields are CDATA'd in REST API Call
ZC Support, What causes your REST responses to come back with all the record fields CDATA'd? PLEEASE help me on this one. Also, why did you decide to go with named attributes for each column rather than true elements? It seems that it would be much easier for users if you made every field an xml element rather than an attribute... example: What you have now... <records> <record> <column name="ID"> <value> <![CDATA[325302000001325913]]>
Masked Edit Textbox in Contact Form
Dear zCreator Team, Is there a way we can create a Masked Edit textbox for time picker so that the user can type 20:00 or 08:00 PM (URL http://www.asp.net/ajaxlibrary/AjaxControlToolkitSampleSite/MaskedEdit/MaskedEdit.aspx) and/or see attachment As the user types the words can be formatted automatically... ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Putting data in two separate forms at once
I have an equipment form and an IP address form. Currently I have it set up that to connect these two forms, I have a lookup field on the equipment form where you choose the IP address and on the IP address form there is a lookup field for the equipment ID. However, that means I have to enter data in two places. What I'd like to do is when I put in the equipment ID on the IP Address form that it automatically will put that information in the IP Address form and in turn puts whatever that IP address
Change a shared app with no source to have access to source?
Hey i have been trying for way too long now to get an application to share properly and be able to update it and move the data. This seems to be impossible. I have several support tickets open on this one and have run out of time to fix this. Finally, I have decided to scrap this completely. Its just not work the time anymore as it seems impossible It's going to create a lot of work needing to make updates an application once for every one of my customers separately even though they all use the
Add Paypal payment option in form.
Hello Respected members Please add a PAYPAL PAYMENT field for forms in zoho creator. by this PAYPAL payment is also allow as a required field. Thanks REGARDS NP
How do I insert paypal in the form?
I created an application and I need to input a paypal link for my clients to pay registration fees. Please advise mercij
How to make a next and previous button?
Hi, I would like to find the index number for a given record ID. Here is example, markRec = market [ID=123456]; and then find the index number indexRec = market[ID!=0] range from markRec.index to markRec.index; Reason for doing this: I can build a next or previos button to fetch the previous or next record. Any suggestion? Many thannks.
Usage Limit for Schedules
Any chance I may be able to get my quota on Usage Limit for Schedules up to 60 a month? After doing a lot of testing this month I lost a lot of the options, next month it should normalize and 50 total should be plenty. Thanks for any consideration you may have.
Accidental Mass Delete...help!
I have an application that is feeding 2 views. While I was editing one of the views, I wanted to delete all of the information, so I did a select all and delete. To my great dismay, when I went to the other view, all of the data was gone in that view too! What happened? Is it possible to retrieve any of the lost information? This is a very substantial amount of work down the tube. I was using the alternate view for time-sensitive information, so I still need the data available to others but I only
Extend with Wrappers
If you follow my posts, you know I'm extending ZC with custom php scripts (api's) hosted elsewhere. It would be really cool if we could do this here. I suppose the developer would submit a code block to ZOHO for analysis and approval, where it would be wrapped inside Creator as a custom function (with defined input requirements that produce specific output results). These functions could then be offered in the marketplace where others could buy the custom function (think app store) and install it.
Search for negative values in view
Hi all, One of my views shows records from a form that contains one "number" field. This field is used to imput numbers, which are either positive, or negative. Negative values are entered preceeded by the "-" symbol. For some reason, in the view that displays those records, all negative values appear alongside the positive ones, but it is impossible to search for the negative values: whenever I input a negative number in the "search" field corresponding to the field, I get an error message "Please
I REALLY DO NOT LIKE THIS PROBLEM.
Do you have to be a rocket scientist or a computer genius to work these programs..........why is it so difficult. My first two applications I had to copy&paste because ZOHO did not accept xlsx files. As of 08-19-11 they do, but I can't the date format to my liking... month-day-year xx-xx-xx
Tweet!
https://twitter.com/#!/JohnWhitney/status/106401098188853248 John M. Whitney
2 columns layout
I'm creating a form on Zoho Creator and I don't like the 2 columns layout. I didnt manage to change that. I can use 2 columns but then I should at least be able to insert a note that will be one column only. This note will introduces a new part of the form, and then 2 columns again. Is that possible? Just like this: Part 1 a d b e c f Part 2 g j h k i l
How to import multi-select or checkbox fields?
I am new to Zoho Creator and I am exploring the application to see if it will serve well as a shared database platform for our small group of users. The database we would like to share is currently in a single Excel spreadsheet where a checkbox field is stored in multiple columns containing binary values (0,1): Focus_1 Focus_2 Focus_3 etc. I have looked through the Help documentation and I'm starting to look through forums, but I don't see an explanation for how to import this type of field. Thanks
Help! Scripts and dates
Good afternoon all, very new to Zoho Creator, wonder if anybody could assist me. I have a start date box which is populated by me, I would like to populate 3 other boxes from this, however I would like it to add dates: Start Date: 24/08/2011 Reveiw 1: 31 days added to start date Review 2: 98 days added to start date Review 3: 168 days added to start date Thanks Martin
How can an administrator collect user browsing history for form and views
Hi How can an administrator collect user browsing history for form and views, the user add new record can collect records, but when users use views,so do not know how to collect,need your help. Awaiting your help Thanks Stanleyguo
Slow calendar display
For the same data I have a Calendar view and a List view. The list view comes up in a few seconds. However the Calendar view took just over a minute and a half to show. There are only 68 records for the month of August. Why does it take so long and is there anything I can do to improve the speed? Herb Wexler
View criteria and nulls
I have two views of the same data with different criteria. The first is ((Status == "Active")) The other is ((Status != "Active")) I imported data with no value for the Status field. The data did not show in either view. Does the criteria ignore records that contain nulls? Herb Wexler www.PreventingMediocrity.com
Filter specification in form view
How can I specify a filter on a date field using a filter specification such as "This Week" or "This Month" ? This is available in the reports filter criteria but not in the view format. Any Ideas ?
Next Page