Please help: Boolean expression to show who should be in attendance...
I have a list of participants, they have 5 checkboxes on their record signifying Monday through Friday. I also have a form for attendance. I would like my attendance for to simply have a yes or no next to the participants names'. What I can't figure out is how is how to display their names with a yes or no radio based on if they are supposed to even be here on the given day. For example, if today is Tuesday and I have 5 participants schedule to attend on Tuesday, and 7 total (2 not scheduled for
Snake eating it's own tail?
I could be wrong but this seems like it could be really bad. Does not Zoho worry that by having a marketplace where developers can quote, build and charge you for their knowledge it could hinder the concept of public applications let alone community support? I mean I have many questions about how this system works and I worry that little if any will get any attention from people who know what they are doing, if I knew I would certainly sell my services and feed my children than give away the knowledge
Freezing Screen when trying to access With Action - Free Flow Scripting for a Form
I can access the free flow scripting for a form and all other actions, except for with action. Everytime I click on this link my window freezes. There is scripting information within this link that I need to view. Is there another way to access the scripting information?
Why is my Home Library application not showing on my blog site?
Using Zoho Creator, I created a Home Library of my DVD collection, then developed a "Borrow a DVD" application which I embedded on my blog site. The application contained fields by which my friends could fill in their name, phone number, e-mail address, etc. for whenever they wanted to borrow a DVD. Everything looked great. The next day, however, the application form could not be seen, but in its place was a Zoho login form. Why is the original form not showing, and how do I get it back? (BTW,
Can I upload a new sheet with the Zoho Sheet API?
Hello, I'm trying to implement the Zoho Sheet REST API from within Creator, uploading some CSV data. I call a postUrl sending data using the following code: url = "http://sheet.zoho.com/api/private/xml/uploadbook?apikey=<myapikey>&ticket=<myticket>"; data = map(); data.put("content", mycsvdata); data.put("workbookName", "TESTUPLOAD"); data.put("contentType", "csv"); response = postUrl(url, data); which executes without error. When I look in Sheet, the new Sheet is there with the correct name, but
Share to Users - Customize Message
I am trying to find where you can change the default customize message that appears when trying to share a view to another user. Can this be done? Thank you for all your help
Show address in form when organization name is chosen
Hey guys! I have a drop-down lookup field listing organization names (names come from the form "organisation" which also contains other information on the organization, hereunder the address). When a name is selected I would like the address of the organization to appear as text underneath. How can I do that? Thanks in advance... J
Autofilter Picklists
Hi - I currently have a form, called form1, with a last name and first name lookup field. The lookup fields arepopulated from a single line field on another form, called form2. I am trying to figure out some scripting that will allow me to have the first name lookup field, on form1, autofilter so that when a last name is selected only the corresponding first name will be displayed. (For example, if I have Bob Jones entered on form2, then when I select Jones from form1 I want the first name lookup
Any suggestions for Zoho Creator Application Development Form, View, & Function Naming Conventions
Hello. While considering that good and proven software development techniques utilize some form of standardization of naming conventions database methodologies I'd like to know what the Zoho Creator user community is using to make their development projects easier in order to conform to naming standards and database normalization. This is what I'm planning to use for naming conventions (for the actual "link name" as the form will have its regular name in the "XXX" part of the form name): Forms -
Need help undoing an import of info into a database.
I need help! I was managing an email database and thought I'd somehow deleted most of my records, so I imported them again from a backup, only to find out that the original records were there but hiddend because of a search I'd previously used. Now I have a database full of duplicates (my original info, which I'd spent hours editing, is what I want to keep!). Is there a way to remove the info I most recently added in one go?
How to create a user login audit trail
Hello. How can I create a user login audit trail every time a Zoho Account user logs into my application? I need this for an audit control functional requirement for an application that I'm building. Any solutions / suggestions would be greatly appreciated. Thanks.
Combining Zoho Creator and other Zoho Apps like Zoho Forums, Invoice, Business, Share, Wiki, etc.
Hello. I'd like to know if any of the Zoho Creator developers out there are using Zoho Creator with other Zoho Apps and how well they interface together in allowing bi-directional communication (whenever possible). My interest in this is due to that fact that I don't want to reinvent the "wheel" so to speak if a Zoho App already provides the functional capabilities. For example, I have functional specs from a client that requires a Web Application where the majority of it's functional requirements
order by into a view passing parameters via the url
I wonder if there is any way to apply "order by" into a view passing parameters via the url. Thanks! Sergio Galiano
Experiments with some built-in Map and Field functions ...
In this post ... http://help.zoho.com/portal/en/community/#Topic/2266000000625224 ... user srhyne (Stephen to his friends) mentioned ... Put all your form fields and form values into a map variable WITH 7 LINES OF CODE! fields = getFieldNames(); form_map = map(); for each field in fields { value = getFieldValue(field); form_map.put(field, value); }Being the "push the envelope" kind of guy ... my immediate thought was ... Can we reduce this to just one line of code ? What if you could create a User
Criteria for Custom Actions
This idea may be a little obtuse to describe, but let me try: I like the ability to add the custom action (function) button to list items... What seems missing in this feature is criteria for when these show up. Rather than just a YES/NO for displaying for all records, does it not make sense to have an addition option to display the custom action button based on some criteria per record? For example, in an approval workflow, some value for the record must be "needs approval" and the criteria would
How to Embedd a view (filter by the the form input) into the same form (stateless)?
I have a form called Tasks and Bits I can do: I would like to create a stateless form that has one drop down box which displays all the the task owners. When the user selects an owner from the drop down box I would like the form... Bits I can't do: ..to display a list of the tasks where the owner is euqal to the one the user slected in the drop down box. I though this could be done by embedding a view of the tasks which had been filtered dynamicaly, but I am not sure how to do this. Hope someone
E-mail parsing
Zoho creator looks great for data collection and reporting, but I want to populate database with e-mailed information first. Can I somehow receive e-mails from specific mailbox for parsing purpose?
Relational database
I have three tables that share a unique id in common. I need to create a form that can query each of those three tables and bring back the matching results into a table. I would like the records referenced in the table to be links that will open up a report, printable as a pdf, that can pull info from each of the three tables. How do I do this?
Share A Single Record
I have several forms and views within a single application. I am trying to share a single record to another individual without granting them access to all information within an entire form or view. I tried creating a filter and creating a permalink but as soon as the filter is removed the individual can use the permalink to view all information. I also tried exporting the data but continuously receive an error that says the applications (XLS, PDF, HTML, etc.) are not available. Does anyone have
How to do if condition on a list box string list
A form with a checkbox called "I_ want" with 2 options, "General info" and "call back" and with a checkbox "product" with 2 options, "supportCenter" and "Servicedesk" I need help for the IF statement where "I_want" is a string list based on 2 selected value out of listboxes he/she is redirected to a URL On submit I want to have a script if (" info " in input.I_want) and input.product == "supportcenter" { http://www.manageengine.com/supportcenter ( then go to) else if (" info " in input.I_want)
is there anyway to hide sensitive information with stars?
My users have to enter social security numbers and other information i want to hide with "stars ****" as they are typing. I would be very grateful if someone can tell me how to do it, or suggest a work around
nulls
Can the zoho team either make it so numeric fields are either 0 if they are null or the default value is put in there if the user clears it or can we get an isnull function were we can replace the null with a number of our choosing. That would be a great addition. Thanks, Shadrach
Add a button that link to a form for people to fill in
My application involves a list of job records with a 'Apply This Job' button for each record. I know there is an example in Zoho Creator where you can add define a function that sends an email How do I go about doing the same except that this function will bring user to a form with pre-filled data? Thanks in advance
PDF miniature in view
Hello everybody I need to my small office workflow pdf minitaure in view mode. I know how to upload image and have miniature in view like hear: http://creator.zoho.com/startuphouston/houston-startups-database/#View:Startup_Company_Input_Form_View I want to do this same but with pdf document. If it is possible please write me any suggestion how can I do this. I have another question. I need one another solution if it is possible. In view mode when I put (not click, move cursor on the image) mouse
currency problem
Hello, I'm trying to build my first database. It's a database that I want to use to compare different fishing boats. I would like to put different form field, like: boatyard name type of boat lenght weight .... price I have a problem with this field because I have prices in $ and €, how can I put the numeric value and than select the currency? I would also like to build an automatic converter $-€. I tought about creating a new form with a numeric value for the change and than use a formula for the
Password field
Need a password field for user to enter password...
OnLoad Hide a Column in an View?
See the code below. This code is embed in a HTML View so that I can display several other views on a single page. Essentially the embedded view below looks for for Applications where the MOBID (on the main page) is equal to the MOBID associated with the app. The problem is that in order for this to work my embedded view has to have the MOBID column present. I was wondering if it is possible to hide a column in a view using an OnLoad deluge script so my users don't see it. <center><table width="90%"
Heads-up Zoho: Google Chrome browser for Mac not entirely friendly with Zoho Creator forms/views
Zoho Support, You may already be tracking this, but Googles Chrome browser for Mac still in Beta (but far along... ver.4.x) has several critically problematic issues with Zoho Creator in edit modes for forms, scripts, etc. Appears to be mostly javascript/display related issues. Because Chrome is a "light" browser (loads fast, clean, uncluttered), many (including me) will likely adopt it as a primary browser. I urge Zoho to coordinate w/ the Google Chrome development team to assure Zoho Creator
Wide Spread Issues? More than one person reporting them
More than one person is reporting data or other items vanishing. This seems to be a growing problem, not just mine. Also, particularly the database applications take TOO long to load, and then there is no data in the forms and tables. Others are reporting similar problems.
Converting small decimals to scientific notation bug
In my deluge script, I had entered X>.0001. After I saved the script I left the page. When I came back to edit the script my script now read X>1.0E-4. However, after making edits to the script and trying to save I receive an error stating Encountered "E" at line #, column #. I have to change all of the 1.0E-4 to .0001 before I can save the script. Either deluge needs to understand scientific notation, or small decimal numbers should not be converted to scientific notation. -Rick
send permalink without edit permission
Hi, I am trying to send a permalink without edit option (only view) to any email, not only to registered users. How do i do it?
Why 'on success' is disabled in http://creator.zoho.com/zhaoshiting/test/test/record-edit/test/299974000000557572/
Note: The application is public, you can click here and try it. It cann't pops window when clicking 'update' button in http://creator.zoho.com/zhaoshiting/test/test/record-edit/test/299974000000557572/ The code as follows: on edit { Update ( type = submit displayname = "Update" on success { openUrl("#Form:test", "popup window", "height=100,width=100"); }
How send SMS from ZC
Hi Yoge I have read your blog for "How to send SMS from Zoho Creator apps" and install the script (.ds file) ,but still don't know how Replace those parameter, so I give your my third-paty SMS provider information,hope you give me instruction one by one (my account and password sent you by email) The Information as bellow and waiting help Thanks Stanley Guo Third-paty SMS provider information as bellows 3,Short Message Service HTTP protocol access instructions Smart express letter of the API
Page-Center Text in an HTML View
This is really crazy, but I'm finding it impossible to center text in an html view. This is not working: <div style="text-align:center;">Please Center Me</div> Nor is this: <div align="center">Please Center Me</div> Also not this: <center>Please Center Me</center> In all cases, the preview AND iframe views all push the text to the left: Is it broke? Or am I just being really dumb?
Suddenly the "Insert Fields" box in form editor is blocking access to edit fields
Something has changed and now when editing a form the Insert Fields floating box is in the way and I can't edit the fields it is blocking access to. The Insert Fields box is in the way now.... wasn't that way before. I've checked it in a couple of different browser types, and it's the same in both. Zoho, you've been tinkering with the interface.... :) Please fix. Thanks. Greg Malone Santa Fe, New Mexico, US
Parent window url problems
Why this link doesn't work in a parent window??? There's anyway to make it work??? <a href='#Form:Seguimiento?Entidad=<%=LEntidad.Nombre%>&zc_LoadIn=dialog' class='zc-edit-a'>Add New</a> Thanks a lot Sergio Galiano
Narrowing choices in lookup field
I will try to, as simply as possible describe what I am trying to do. Please let me know if it is possible and if so, how. - Within an application I have 3 forms. Schools, Teachers, and Events. - The School form has a field called Schools. Schools is a single line entry field. - The Teachers form has two fields called Teachers and Schools. The Teachers field is a single line entry field and the Schools field is a lookup field that references the Schools field in the Schools form. - The Events database
bar code / scanner interface with creator
Does anyone know of an interface that can be used with Creator to scan barcodes (eg. each time a member attends class, their membership card is scanned for their individual bar code and their attendance at a class on a specific day is recorded in Creator?
ZOHO CREATOR
Hello to all. I've create a zoho creator applican, whit inside a choice list whit the date. www.bee-tse.org When the people fill my form on succes will receive an email. How I can send different e-mail differs according to the chosen date. For example after the choice choice a: Ok. Presented in Rome Choice b: Ok. Presented in Milan THANKS IN ADVANCE Laura
Formula field to Count specifc
I need help writing the Deluge script for a Formula field that counts the number of records from another Form. ------ I need to count the total number of records on a Form in my Application that meet certain criteria. The field is not from the same form as the Formula field so the Deluge script will have to reference which script has it. i.e. Count the number of records in the 'Donors' form where (Status == "Paid").
Next Page