help
hello. my name is ben and my research group is aiming to deveop a website that will manage records that will be submitted by multiple users. and im wondering if i can use zoho to store the records in the database at the same time manipulate it on offline mode. there is also a prcoess wherein the the input that will be sent by the users will be stored on a temporary storage and will be filtered by the administrator of the application. can zoho do that?
Feature: Browser tabs should display VIEW NAME (useful!), not "Zoho Creator <Your Org Name>" (useless)
I, like most developers while working w/ Creator, keep several browser tabs open at a time, each w/ different Zoho views, forms and editors displayed. But, when you look up at your row of browser tabs and all you see is "Zoho Creator <Your Org Name>" repeated several times... it's useless. BUT, if the tabs were to display the NAME OF THE FORM, VIEW, or EDITOR displayed instead, then that would be really useful (and easy to implement on Zoho's end). Otherwise, I'm constantly clicking nameless tabs
Creator App using Project API
I am using the Project API from Creator. I am trying to get all time logs (timesheets) for all users, but I am only getting the logs for myself. The "ticket" that I have created for the api is using my userID/password. Please help - this is a critical requirement for my application.
Is it possible to have a realtime updation of graphics.
I have a question regarding real time updation of colour of certain graphics. For example, suppose that I own a lodge having number of rooms. Customer 'ABC' is booking a room(i.e.room no. 10) from Delhi at the same time another customer 'XYZ' is booking the same room(i.e.room no. 10) from Chennai. Now the problem is that if customer 'ABC' booked the room(i.e.room no. 10) one second before 'XYZ'. How can a booking agent at Chennai come to know that the room is booked, so that he can tell customer
Automated application documentation
I've created an application in Zoho Creator - a whole lot of forms, views, custom actions, functions etc. While the application is shaping up quite well, I've begun to realize that I have not created any documentation on the application software. Without documentation to fall-back on, I can imagine life getting quite messy down the line. I believe the Zoho team can come up with a simple solution for this. The fields, forms, views along with their actions (on load, on submit, on user input etc) are
Open Duplicated Records in Edit Mode
I'm tracking certain items where new records often are the same as old with the exception of a change of date or other minor difference. It would be useful for the duplicate function to open the new (duplicate) record in edit mode so that I don't have to scroll around looking for it after it's created. Thanks.
on update ....can not make it work....About to dump zoho.
Hi, I am almost giving up witht he On Update command. I am trying to update fields that I called out and following the example and I can not make it work. I want to query using the serial number and puplate the rest of the fields (that pieces is working) but then I want to be able to modify such fields and update them back ino the DB,......... that piece is not working. here is my complete code in case soemone can guide me.... form Actualizacion_De_Players { displayname = "Actualizacion
Changing view criteria based on user?
I have an public form that i have multiple sales people submitting sales information to me from. I want these sales people to be able to view all records that they have submitted. I do not want them to be able to view other sales persons records. Is there a way using html views to have them input a user name and password. If it is correct, view all records that they have submitted? I figure they submit a logon form that then does an if then and determines if it should forward them to the view
Adding a new User
I've been trying to add a new user by entering their email address, but no email is being sent to the new user? Am I missing something? Martyn
500 Internal Server Error
I'm trying to post a new record to my Zoho Creator app via the REST API POST and JSON format, but I get a "500 Internal Server Error" back. I'm using the format: http://creator.zoho.com/api/private/json/<applicationName>/<formName>/add/ What might I be doing wrong?
Another Defect ...
Just noticed ... In List Views ... when specifying Set Criteria ... with Show Restricted Records ... it lets you select the Field Name and the Field Value ... and allows you to click on the Done Button ... but when you return to this section, the Field Name is reset to Modified User IP Address. Tried it in multiple Views with different (single line text) field names ... same result. Is this another case of Another Update ... Another Defect ????? In any case, it needs to be corrected urgently as
Number of Form Fiels Available? I need to have a form with many many fields........
I have run into a problem. I need to collect data various data on a form. I have to collect sampling data on 13 items subdivided into 6 categories having aproximately 7 to 10 questions each. For Example: 1. We require our inspectors to inspect boxes. 2. For the number of boxes recieved, a certain amount need to be inspected. 3. Each box will have 7 to 10 questions that must be anwsered as to the condition of the product recieved. Once the data has been collected, various
Intermittent strange text artifacts in Free Flow editor -- what is it?
I occasionally get very odd text artifacts in the free-flow editor (image below). I've seen this effect in both Firefox 3.66 (Mac) and Safari (latest version), and I think I even saw it in Chrome (Mac) one day when trying to escape the effects. For no clear reason, the editor sudden displays a shadowy replica of the code in light gray shifted down a few lines. It creates problems with cursor placement and readability. This effect is intermittent, not all the time. But I've seen it almost daily.
Is there any way to filter releated fields values with dropdowns choise?
Hello! I have two views with records like View 1 Field A 1 2 View 2 Field A Field B 1 A1 1 B1 1 C1 2 A2 2 B2 2 C2 Both views have fields 'Field A' with values corresponding to each other I need to create a form 3 where selection 'Field A' value = '1' in dropdown for the 'Field B' will show only records 'A1,B1,C1' (releated to 'Field A' value = '1') and on select 'Field A' value = '2' in dropdown for the 'Field B' will show only records 'A2,B2,C2' (releated to 'Field A' value = '2') is there any
Global Search
Over the years several people on this forum have asked how to build a global search. Unfortunatly I could not find an answer in the forum. I need the user to enter a search string and then a view of all records that contain the string in any field is returned. Any suggestions? Herb Wexler
How do you restrict viewing of solutions?
I am using Zoho Creator Helpdesk through Google Apps. I want only certain users to be able to see the solutions. I couldd have some private and some public, but if the only way to do this is to make them invisible to all but the techs, that is okay to. I tried to use the criteria for the Solutions List, but could not find a way to make this work. Any ideas?
Emailing Help
Ok I Am Makeing An Emailing Function In My Forum I Have A Email Options Where They Put The Email In The When They Hit Subbmit It Emails Me But I Want It To Email Me and The Email That Was Subbmited In The Form. Is There A Problem Or A Bug With This Could Someone Please Help Me. Thanks, Russell P.S Sorry For The Spelling
Is It possible access zoho crm database with creator?
We are developing an application in zoho creator embedded in zoho crm and the need to recover customers, articles, contracts ... from the crm database. How we do it? Thanks
Registration for my website
Hi I'm trying to find out if I can seamlessly use Zoho Creator to provide a register and login function on my website. I want the user to feel as if they are registering and logging into my site rather than to a 3rd party database/service. Is this possible? Many Thanks!
Graph Currency
I've created a graph but the currency symbol is $ - how do I change it to £? Martyn
free flow scripting - editor does not work properly in chrome
Hi, I am trying to use creator and work with free flow scripting in the chrome browser. the display is totally messed up
Insert Domain to Requester
Hi; We have 4,000 requester and i like to insert Domain in the requester information.
How does one stop processing of a second click?
I face this issue both in a regular form and a stateless form. The processing of actions for both necessarily take time on the server side, and "Loading" alert pops up sometimes, but frequently it doesn't. The user is therefore tempted to push Submit again, which leads to a duplication of data creation. I found the "cancel submit" option for forms, based on the data having already been created; however, a user pushing the button a second time quickly will beat this creation process and a second
Query only rows where column matches X criteria?
I know this has to be simple. I could write this query in my sleep in SQL, but I'm short on time and trying to figure this out in Deluge. Basically I'm trying create a report that will only list the values that I specify in my script. For example... say I have column called ComputerName that lists out roughly 400 computers. I want to pull a specified list of computers. In SQL I would write it like this... select * from database where ComputerName in ('computer1','computer2','computer3',)
OpenURL query
I want to be able to display transactions between two dates using the following script, but doesn't work: openUrl("#View:Expenses_View?Date_field=" + input.Start_Date;input.End_Date, "new window"); Any ideas? Martyn
Where is the Save Setting being Stored?
I applied the steps described at https://help.zoho.com/portal/en/community/topic/how-do-you-to-sort-on-a-hidden-column-in-a-view#2266000001132452 that tell how to sort on a hidden field. After several attempts, it finally worked. But when I examined the .ds file I was unable to see where the change was made. The script of the view looked the same before and after I did the save. Can anyone tell me where this setting is being saved? Is this setting only good for the user who is saving the setting
HTML view: Error when use Rich text mode
Hi, If I try to make ANY changes using the rich text mode in my HTML view it gives me the following error: Lexical error at line 1, column 12. Encountered: "\\" (92), after : "" It doesnt even let me shift to plain text mode after this. All I can do is press cancel - but then my changes are lost. Please help ASAP Thanks
Delete multiple records
Hello all, Please be patient with me as my experience with databases is very limited,and I am hoping there is a simple solution. In my application I have a form named "Controllers" in this form there are three fields "Serial Number", "Max Temp", and "Hours" I am trying to create a lookup function for the form named "Controllers" I want the function to lookup the "Serial Numbers" of all of the "Controllers" in the form and display them as selectable check boxes. (This Part I know how to do) I then
OpenURL - filter by date
I have a form called 'expenses' with two date fields - startdate & enddate. I want to open the view 'expense_list' but restrict transactions between the startdate & enddate. Can you help with the syntax for this requirement? Thanks, Martyn
Sorting values in a lookup field
I've created a job db which uses job numbers. I have a number of forms that link to the job using the job number. I have set the look-up to sort, but in some forms it's not sorting as would expect - see example below: Job Numbers: J016 J007 J026 J019 J030 J998 J999 J040 and so on... Some forms do sort the job numbers correctly - any ideas? Martyn
error while duplicating application or importing application from a script
Hi, I was trying to make a copy of my application. It says "duplicating...please wait" and then nothing happens. So I tried to export the application as a script and then importing it again via create a new application. Initially it gave me the following errors: 1. If I had anything in quotes in the Notes field of the forms. Eg. Please type your name in "CAPS" It gave me an error on the quotes -- " So I removed the quotes from the Notes field 2. In one of the views I have added a sendmail function
Edit Multiple Records
Well the support team at ZOHO answered my last question quickly, and in a way I could understand so here is a thank you before we get started. I have an application named PRT Collar Tracking, in this application I have a single form also named PRT Collar Tracking. In the form I have several fields for user input. The fields I am concerned with are Collar_Serial_Number, Trip_Hours, Circulating_off_Bottom_Hours, Sliding_Hours, Rotating_Hours, and Total_Hours. I need to be able to edit all of the [Trip_Hours,
Add Record via REST API
I'm trying to add a new record to a form via the REST API. I am posting this: <input type="text" name="Title" value="test"> <input type="text" name="Aspect_Ratio" value="99"> to: http://creator.zoho.com/api/xml/copy-of-encode-details/Encode_2_Form/add/apikey=*****&ticket=**** I *'ed out the apikey and the ticket for obvious reasons. The only thing I ever get back is: An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused.
Data relation of Lookup field broken
I have a Lookup field ('Import Data') called 'Player_Entity' (on form A), for which I limit the choices available in the 'On Load' event with the following code: //Limiting Entity field choices to player tempValue = input.Player_Entity; clear Player_Entity; Player_Entity:ui.add("Himself"); for each recPE in frmPlayer_Entity [Player_Name == input.Player] { Player_Entity:ui.add(recPE.Name); } Player_Entity.select(tempValue);As you can see in the code, there is a field called 'Player_Name' on the
Can't find "On Success" FORM ACTIONS help________________________
I created a stateless form and want to "SendEmail" on success but I am not able to include "On Success" action on the right side of the Script Builder screen. I only see "On Load" "Add_this" and "On Click". How are "Form Actions" like On Success added so that I can then "SendEmail" "On Success"? Also, the form that created the table has at the bottom "on Add" and "on Edit". My stateless form doesn't have that. George www.yourbizzwizz.com
simple dialogs to an alert? like [OK] [Cancel] to continue with the script or abort it.
What about adding simple dialogs to an alert? like [OK] [Cancel] to continue with the script or abort it.
Having trouble with Radio Button functions/expression
The 1st two choices of the Radio Button works correctly. But the 3rd Choice is not working. Once Choice Three is chosen it will not allow to be updated should the client decide to correct his choice. If you start with any of the 2 top choices one you can toggle between the two and you will successfully update. If you choose any of the formulas for the 3rd choice they will also update successfully. But if you choose any of the formulas from the 3rd Choice and then change your choice to any of the
CREATOR - How to CLEAR stateless form data after Submitting??_________________
Please see script for stateless form below. I finally figured out how to update table with stateless form but am not programer and need help. How do I remove the data from the form once it has been submitted AND display a confirmation message like "Your Data Has Been Submitted".... See from at: http://azrealestate101.wiki.zoho.com/GUESTBOOK.html I am keeping it simple so I haven't learn how to do the data field validation. Where is there "beginners" documentation how to build more complex stateless
Hide fields/views based on User Group?
Hi all, I have seen that it is possible to hide fields if a user isn't an adminuser. I am migrating from Dabble and need to set up a database for two groups of users -- editorial and production. In Dabble, I created a "Pages" view for the editorial users and made a few views possible through that. I want to hide the fields/views that editorial doesn't have to think about to make their job easier to do. The production team needs to see more fields, will need more views. From my initial understanding,
Make my app public
It seems the "click here to request for public access" link is permanently not working (Error on page) How can I do to make my app public then? Cheers
Next Page