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").
How to use Zoho Creator as a
Hello. Has anyone successfully been able to use Zoho Creator as a "front-end" to their own hosted and managed Database Server using MySQL, MS SQL 2005/2008, or Oracle? If so, how did you do it? Was the response time pretty fast? What were the obstacles and challenges that you faced? Any ideas and suggestions to this would be greatly appreciated. Thank you.
Email data
When using Zoho's email data feature, is it possible to email data with a formula field? For instance, if I have a formula field (fmlaContact) that will concatenate the data of a first name and last name, can I update the database via email by simply leaving the formula field blank? Eg: FirstName:Leo LastName:Leonardo fmlaContact: Thanks, Leo
Fetch Record: select from two different forms
I am creating a donor form. I already have a member and a constituent form (two separate ones) -- they need to be separate. I would like to use one ID code from the member / constitutent code to fetch a record from either form. Here is an example: MEMBER: Student Jane, ID 33333 CONSTITUENT: Benefactor Organization, ID 22333 Member donates $50. Constituent donates $100. In the DONOR form: I want to fetch either Member or Constituent in one field and have their address record show up (just address,
Payment Information: Amount split to different codes
Is it possible to take one amount and divide its purpose among several categories? I have my donations divided into CATEGORY & CAMPAIGN. My example: Donor gives $260. $200 is for Annual Fund, $30 is for Merchandise, and $30 is for Supply Donation. Is it possible to split one entry into 3 allocations without having to create three records>
Need Rnd() function
There's something I'd like to try to do with Creator, but I need a Rnd() function (return a random number between 0 and 1) and a Randomize Timer function to seed the random number generator. Or a way to include some JavaScript or something. Thanks! fredramsey
Migrating from MS-access to Zoho problem
I need to convert my Access database to Zoho Application for testing purpose but I keep getting the following error popping in "Migration from MS access to zoho cloud" software: Problem encountered while creating the application Encontered "#" at line 1211. column 29. was expecting: <DATE> ... I was wondering if you are going to enable the right to left text in anytime soon or if it is available already please direct me toward applying it.
Bugs in views with criteria on look-up field
Hello, I am trying to define a view for a sub-group of elements of the database by defining some criteria for this view. When the criteria is on a field with a standard type (text, list of elements,...) it works, but when the criteria is defined on a "lookup" field (fetching the list of values in the database) it does not work anymore. A simple example: I have 2 forms, one for the definition of a client, one for the definition of a sales person in my company. Each client is linked to a sales person
Formula field to pull value from another form with specifc criteria..
The Lookup field only allows me the following types: Dropdown, Radio, Checkboxes, & Multiselect. I need the ability for a Formula field to pull a single, specific value (text, number, etc) from another form based on specific criteria (i.e. ID == ID). How can I do this? Is it possible via Deluge scripting?
add multiline-records by email
I want to add records with multiline-fields by email. My problems are: Line breaks get lost: Line1 Line2 becomes Line1Line2 and record containing ":" can not be added: a: text1 b: text2 c: text3 becomes because the content is automatically allocated to the field a, b and c (even if they do not exist). Please advise me how to solve these problems. Hannes.
Zoho Web Developer
Hello I think Zoho Creator is a great enterprise application generator (EAG). I think it could also be the basis of a great web application framework (WAF). As an EAG, I think it pretty much hits the mark; I don't think it needs much more. As a WAF, I think: its pricing is inappropriate, it needs some payment processing features, and it would be a good idea to better leverage Google's App Engine. I suggest Zoho introduce a new product, perhaps called Zoho Web Developer. This should have all the features
How does Zoho Creator Licensing work for Multiple Applications with Different users?
If have a Zoho Creator 5 user license as an example, and for my "Beatles" application I have the zoho users: John, Paul, George, Ringo, and myself as the Developer. Can I also have another application called "Van Halen" and allow the users: Eddie, David, Michael, Alex, and myself as the user? or am I just limited to the have the users under my "Beatles" application? Thanks.
How to influence the working of the Cancel Button - for example redirecting to another page
I supposed that the Cancel button could bring the user to a different page or something like that when clicked. I do not see how this ought to work. Can anyone help me with this? Point me to something? Kind regards
URGENT!!! Re the Deluge Script builder don't work now!
Hi I got black screen when I used the "set varirable" task , even the previous "set varirable" also don't work,if you click the "edit" will get balck screen , what's happen? please reply as soon as possible. waiting your help and thanks Stanley Guo
My app is gone
I just began to try to use Z. Creator for this first time this afternoon. I started an app that I called "Moody Log," modeled on an old Palm Pilot program. It was not difficult to create. I was able to enter and save data with no apparent problem. I'm sure I did everything that was necessary to save it. Nonetheless, only two hours later it has now disappeared. I am not happy.
Next Page