Non-professional programmers, to write as a professional management program, because of the ZOHO Creator
各位爱好者、关注的朋友 本人，老郭，非程序员出身，搞业务，做买卖的。随时都想着如何把生活中、业务中的现象和逻辑模拟到计算机里，把他们管起来，同时让这些程序为我服务、工作，只憾没有合适的能游刃有余掌握的工具，只停留在那些望而生畏的代码基础面前，现在找到了，它就是创造者，太适合非编程人员的掌握和发挥，因为他们具备了多年的业务逻辑和经验，只是用创造者这个易用强大的编程工具去实现管理的优化、去迈向管理的起步。 在使用创造者的过程中有以下体会分享给大家.. 1，创造者是业务逻辑和编写程序的桥梁 往往写程序的不甚太了解业务，懂业务的不懂写程序，因此程序通常由专业的程序员去写，而企业的业务逻辑在经济活动中又不断的发生着变化，导致程序的更新与业务管理需求难以同步，使得企业原有的管理程序很难满足企业不断变化的需要。另一方面由于传统的软件开发需要具备非常多的专业基础，致使业务管理人员很难难介入。但当创造者出现了，这个问题逐步得到了解决，搞业务的可用这个工具去根据自己的业务需要轻易的、快速的去定制企业所需要的管理，无论业务逻辑如何的调整变化，业务人员可用这个工具随时调整满足业务的管理需要。 深刻体会:每个企业有很多的个性化的需求，没有一个标准的的软件能覆盖每个企业的所有个性需求(即便是行业标准软件)，但如果使用创造者工具可最大化的解决企业定制化需求问题，使企业的管理正真有一双完全适合自己穿的管理鞋。而且，这双鞋是动态的尺码都没有问题。让我深刻认识到，企业管理程序定制化程度越高，其生产效率是相当惊人的。
Help with carrying variables over to another form.
Hi, Can you help with a task please, let me explain. Form 'a' has a field called customer_name which is a text field Form 'b' has a field called customer_to_print which is an import data field which is taken from the records of form 'a' Customer_name. What I want to do is very simple. when I finish inputting a new name in form 'a', the form takes me straight to form 'b' and I want form b's field Customer_to_print to default to the record i had just input into the field in form 'a' without having
Modify records in form in batches
Hi, i have a problem where a user inputted quite a lot of data via the form and my deluge script is failing. So is there a way to fetch the records in batches? There is a checkbox that is invisible to the users that is by default checked. So this way i can distinguish the new records. My script basicaly looks like this: for each deal in Deals [((Decision != "Go" && Decision != "No Go") && Status == "Request for approval")] sort by NewDeal desc range from 0 to 50 { //do some other stuff deal.NewDeal =
1. Romanian diacritics disappear in .pdf export 2. Exporting 1 (specific) record per page in Summary view imposible
Hello, I discovered Zoho database and it's a great product. I want to implement it for my bussiness but I have two little problems: 1. When in View mode, when I try to export data records in .pdf format if the records contains diacritics they will disappear. Those diacritics are: ș, ț, ă, î, â (romanian language). 2. In Summary view there is no posibility to filter the records in order to view just one (desired) record. Search function is not available (which could be used to filter the records
How to clear a text field in an on edit on load script?
The clear command doesnt seem to be used for common text fields. I need to clear a text field on edit on load with a script. How can I do this? I cant just add a " " (blank space) because it needs to be completed and compared to another field for accuracy. Please advise. Thanks.
Need days since record added calculation- help
In my app, I need to change the status of a record from Available to Unavailable after 30 days pass from the date when the record was created. How do I do this? I was trying to use this formula, but I cant seem to figure out how to get the date added from the system: ((zoho.currentdate - DATE ADDED FROM SYSTEM) / (1000 * 60 * 60 * 24)) Help?
PDF URL request ignored?
Every-time I put in the same script two PDF URL to be open one after the other, the first request is ignored. This is new didn't happen some months ago. For example, I need to save in -my downloads- a PDF containing some records with my contact info. And with the same click save also in -my downloads- a PDF containing exactly the same records but with extra non public fields. Every time I press this button, I only get the second document, while the request for the fist one is ignored. I need the
Public App Login Screen
Hi guys, I have a question that I know has been asked in one way or another before in this forum. However, I have not found answer that satisfies my needs so I thought I would ask the question again. When I develop a Web app for one of my clients using the Java platform, one of the first things I do is to make sure that only authorize users can access this app. So, A simple algorithm of how this would work would be as follows: 1. User accesses login screen and enters credentials 2. The user
HTML view as popup
Hello all, I'd like to popup an html view I've created upon the user making a selection from a radio button. I have used the OpenURL function on the "On User Input" event for that radio button. The popup displays fine but the html view doesn't display properly. Static text is displayed properly but the embedded view below the text doesn't show and instead says "Loading" indefinately. The html view is a simple combination of basic text and an embedded view in list mode. Any ideas why this is happening?
Expiring Date
Hi there, I made a Database with Airplanes (AERONAVES) from our customers (CLIENTES) and every Plane has different Equipment (EQUIPOS) as you can see in the following image: Every Equipment (EQUIPO) has different fields added from a Sub-form and one of the Fields wich is really needed is Expiring Date (VENCIMIENTO) as shown in the following image: How can I Fetch the Expiring Date (VENCIMIENTO) in wich includes the kind of Equipment (EQUIPO) and the Customers/Airplane Details. Im really blocked with
Need help with permissions for public app- confused...
I have a public app: http://creator.zoho.com/redatomnetworks/sportspenguin . The app will allow someone to list a good to be donated so others can get it. e.g. donate a chair for free and others can see the chair listed and contact the person to get it. I want to open it up for anyone to use without logging into Zoho. They need to be able to submit and edit their own forms. I dont want them to be able to delete forms at all once submitted. I also want to hide or prevent access to the Admin views
Two or More forms Insert to one Table
Is it possible to create multiple forms then insert the records on one table (or form table)?
Comparing two strings or two list, Usage Limits?
1) "Solicitar Oficina en Renta" Stateless Form This form searches in "Buscar" Form 2) "Colonias Separadas por Commas" String Field This field provides with "Colonias" separated by commas. 3) I compare the "Colonia" field of fetched records with the string field "Colonias" 4) Them I convert "Colonias" into a List and try to compare each element with the "Colonia" field of fetched records. 5) I do this in order to get this result: Options Searched Roma Sur Polanco Chapultepec Options Available Roma
Display a List on the Form View
I have a contact manager application. On the form where you can input/edit a contact, I have a dropdown box that lets you categorize the contact. I would like to have a list display below that dropdown box which displays the name of every other person that has that catagory selected (should be about 5-10 people). Preferably, I would like to be able to select more then one (a multiselect) and have all of those display. I assume that to do this I have to write a script that will retrieve the names
scripting reference to bi-directional field
Hi, I've consistently had the problem I'm about to lay out in my application and thought it was a limitation of Zoho. However, I don't see it listed anywhere else as a complaint so maybe it's just our application and someone can fix it? The problem stems from bi-directional fields and trying to reference those in scripts. For a specific example, we have a Monthly Meeting form. We use this form to do multiple things, including track attendance at our monthly meeting. The Attendance field is an import
Add "&" symbol in field thanks to Zoho API
Hello I would like to add a field with & symbol Here is my request : <field name='Company'><value>"&"</value></field> Zoho response is : <?xml version="1.0" encoding="UTF-8" ?> <response><errorlist><error><code>2830</code><message>XML document structures must start and end within the same entity.</message></error></errorlist></response> Of course & is an xml reserved character. I have tried CDATA : it does nothing Can you tell me how to add a & symbol ? Thanks for your help Regards
How to give an application to another Zoho Creator user to use it?
Hi I developed a small app. in Zoho Creator. I want to give this app. to another user (on a free plan) to use it under his full control. He may do changes to data and code. I don't want to control the application. What do I do? Thanks. EK
Form Field Criteria
Hi guys, Could you help with this on please. I want to set 2 criteria in an import data field 1. Collection_Date is Null 2. Collection_Date == zoho.currentdate They both work fine on their own but I cant get them to work together. What I am trying to achieve is the argument, if no date is in the field or if todays date is in the field then display name. Cheers Nigel
Can i make form like this image in zoho creator?
How i can make a form like this image in zoho creator?
How to create Autocomplete textfield?
Hi All, Anybody can help me for creating autocomplete textbox. I have already created one form " Test Form" . In this form we have one Field "Manager". I want to make this fields as a autocomplete textfields. when user start input value it should search from "Contacts" Form and field name "Full Name". Below link is my application link which is public. https://creator.zoho.com/sujeetsocial/copy-of-celebrity-invite-database/#Form:Test_Form Please anybody can help me. Thanks Sujeet Kumar
Viewing a Zoho Doc uploaded to a creator form
I attached a Zoho Doc to a creator form using the file upload field. In the view when I click on the link it asks if I want to download the file. I was expecting it to open Zoho Writer and show the document. Is there a setting to get it to open in Writer? Thanks Herb Wexler
Calculating Last Month
I have a view with a date field called Date1. I'm trying to set criteria to show only records where Date1 is last month. . If today's date is any day in October then the view will show all records with a date from September 1st to September 30. Herb Wexler
Effective input view
How can i tell a view that only un-touched form fields should be shown in that view? thanks
Filtering my drawing numbers
Hello, At the moment I have 3 forms: Drawing Customers Works order When you add a drawing number, I use a "look up" to select the customer name from the Customers form. So the creator knows that a specific drawing number is tied to a customer. In the Works order form, the user will select a customer from a drop down box, they then need to select a drawing number but at the moment it shows all the drawing numbers available. Is it possible to filter the drawing numbers that are associated with the
Go to URL & Permalink
Hi there, hope someone can help. I have a form which goes to a Thank You page (another form) when submitted. But, when I access the form via a permalink it won't go to the Thank You page. Anyone know why? Here's an example permalink: https://creator.zoho.com/activeimpact/of-course-we-can/form-perma/Event_Finance/dwWCpEGNk6HCHHugXrfnuDJk8EZbMq5PvPFewTUPgPu89VgDCz23rM62krhOUJnk09CPRgKFMBTU91GnjMmfThessn64VHe8VBZy/
Zoho Challenge API Integration
Would it be possible to get the results of a test completed in Zoho Challenge and use the result in Zoho Creator to verify a passing score? I have built a training application and certain courses would require passing a quiz before they can be marked as completed. Can anyone suggest a solution? The goal would be to get the quiz results via Zoho API and emailid (zoho.loginuserid) of user. Then when the user clicks the custom action to complete the course, it will verify that the quiz has been passed.
Scheduler Scripting Question
Hi I have a Daycare application and I want to charge tuition dues every Monday for Cash paying parents. I know how to set the scheduler but I need help creating a script that does the following: Find the kids who pay "cash" from the payment_type field in the add_kids _form For each kid who pays "cash", select the child's name (ID) and weekly_tuition_amount from that kids record Then create a new entry in add_bill_form with the child's name (ID from add_kids_form) and weekly_tuition_amount amount
Incorrect columns
All of a sudden, I am unable to correctly IMPORT records into http://tinyurl.com/Ind-Vets - A database of Indiana Veteran Graves. This just began a couple of days ago. I high-light and copy info from an XLS table, IMPORT & PASTE into the CREATOR database. I am positive an equal number of columns are in each. But when finished, the first column (NAME) is missing and all other columns are shifted one to the left. In the PREVIEW all looks okay, with info in correct columns. I must load each individual
Please help me implement Global Filter
Hi there I want to filter all views according to a value in a field called Client in a table called GlobalFilter. So, I want each view to show only values where Client == GlobalFilter.Client I'm guessing this won't work because the LHS of that formula is a string and the RHS is an array. Please advise how to achieve this. For the record, I am preventing the user from entering duplicate Clients into the GlobalFilter table. Justin
Custom Printing (Such as Checks) ?
I have an application which I wrote many years ago. I am new to ZOHO but so far what I have seen I think is possible to reporduce with my old program with Create. In my program I have an 8/12" X 11 (perferated into three equal parts) receipt. In my old program I print a three part receipt (All three sections print the same thing). I also print checks. Is it possible to create a report that would allow for custom placement of fields so it could print such a receipt or checks ? Thank you for your
Dropdowns not working?
When I try to use the dropdowns on my form, accessing it from an outside computer and not logged into the site, as any third-party user would do, they scroll in the window, rather than dropping down. Is there a glitch or some change in the way these are working. Since my mouse scrolls three lines at a time, I can't even see all of the options.
Can I set a default value for a field in a view (not in a form)?
Hi folks - I've just started using Zoho Creator, and I'm hugely impressed. I have one general transactions table ('activity') with an 'ActivityType' field to identify different activities. I'm setting up a view for data entry of one of the activities - in this case, 'Swimming'. How can I set a default value of 'Swimming' for the activitytype field in this view only? Many thanks in advance Shane
If, then formula
I am trying to create a formula - (I am a novice for clarification) - I am creating a project database and I have one field labeled Invoice Paid that is a drop down Yes or No. When this is clicked YES, i want another field labeled Project Complete to Yes. Is that possible?
Registration system
I embedded a form in a website with signin required. The signin screen shows as expected but there is no option for a new user to sign up. The application does not have to be very secure but I do need to know if they are a returning user or a new user. Should I build a form to gather the persons email so I can direct them to one page if they are a new user and a different page if they are an existing user? If I ask for an email then I should also have a text field called a User ID. Both the email
Lookup to set a variable
How can I use Lookup to set a variable? I have two forms. Form one has two two inputs, Name and type of participating (Dinner, after-party or btw) Here I have registered all invited guest for a wedding. The other form is for the guests. Here the select the name from form one, using Lookup. How can I copy the participating value from form one, for the selected name, to a hidden variable in form two?
Update existing records using "Import Data" option
My app references records that change daily. A raw report can be generated to show these changes, but I can't import these reports into my app and update the older records with the changes. To be able to do this would be HUGE. If there were a work around (perhaps using the OnChange script) please let me know.
User Authentication
I had developed an app in zoho crm. In that application i made 4 forms. What i want is that only 20 user can see one form with there own records(No other person can see others records). And there is 1 group which can see only 1 form which nobody can see other than people in that group.
Create an Proposal (Estimate) Form
I am a contractor who visits client's home to provide them estimates for their swimming pool remodel project. I would like to create a "form" that I can use to enter the various things the client wants, along with measurements - and this will generate an estimate to give to the customer. for example, I can input the lineal feet of their pool, and Creator will calculate a price (based on the standard pricing I entered into a table). Can someone please help? thanks!
Cannot Create Report
When I try to create a report I get this message " You can only have a maximum of 2 reports under this account. Kindly upgrade to a suitable plan to create more." The thing is-I have no reports at all. Any ideas? Thanks.
does a zoho form have an email address and can I send an email to it
so that the form fileds are filled with appropriate content? would be awesome. what API do you offer for integration with a third party tool, so the form can be filled with information from that tool?
Next Page