Authenticated Zoho Users for a Form
I remember seeing some posts on this a while ago, but I cannot find them (this new forum has so much eye candy it's giving me a headache - sorry Zoho!) I'd like to prevent non-authenticated users from submitting a form. Is this the best way? if (zoho.loginuserid == null) { alert ("You need to sign-in to your Zoho Account to submit this form."); cancel submit; }
Record limit help!!!
Im building a simple database and want to set a 50 record limit as the attendants to an event are set to be 50, how could I do so?
How do you know if someone filled out application?
Will I receive an email or do I find it when I sign in? I have had my application set up for a little while now and check it daily but no one has filled it out yet, that I know of. I just wanna make sure I am not missing an potential clients.. Thanks for the help.. Heather
Dropdown to Checkbox
Hello. I'm trying to pass every selection in a dropdown field to checkbox, but I didn't succeeded. Everytime that I select a value in the dropdown replace the first value for this last. This is a task form and I want assign the task to several users. I don't want put directly a checkbox(multi-select) field because the user list is long and I prefer a dropdown selection, and every user input must be added in a checkbox field and selected it. In the dropdown field I want include groups of members too,
Filter lookup field by multiple criteria
Hi Everyone, I am setting up an appointment form that allows the user to select an interpreter, based on several criteria (see screen shot). The interpreter lookup field should filter the list by the following criteria: Language Method Availability (Start Time & End Time) It is quite easy to restrict the interpreters by a single criterion, such as language, as I simply add script to the User Input of the Language field (see code below): //Requery the AsscoLang combo box to show only those interpreters
How to acces Label Name in Deluge ?
Is there a way to access the label name of a field in Deluge Script ? Thanks, Pascal
Insert url automatically
Hi, My form has the following fields Month (Dropdown Choice) Results 2009 URL Link Name Depending on the Month value I need to insert the URL with Link Name EG Month = January Therefore if (input.Month == "January") input.Results_2009 == URL and Link Name = Results. Field "Results 2009"does not appear in script Field Actions Thanks
zc_LoadIn=dialog for existing record.
Hi all, I'm trying to get the ajax-modal window to open for an existing record with the zc_LoadIn=dialog arg and it's not working for me. Form is loading in new window. Here is my code: theDeal = Deals [Deal_Name == input.iDeal]; pathDeals = "/ensobase/home/Deals/record-edit/All_Deals/"; lnk = "<a href='" + pathDeals + theDeal.ID + "?zc_LoadIn=dialog' >Deal</a>"; Any ideas? tt
HTML View and Mobile access
Hi, I am unable to access a HTML view from a mobile device. Before I go any further I want to verify with support that Views of HTML type are accessible from the mobile access point. A pointer to where this is discussed in the Creator help system would be ideal. Thanks, Tony.
Has anyone created buttons that can execute SSH commands
Hi everyone, i would like to thank any responses in advance. I have started to play with the zoho creator and i was wondering if there is a way and if any has any insight to be able to run ssh commands inside the application. We want to be able to control some hardware with our database. Thanks.
A twist on autonumbering
I have implemented the autonumber solution in one of my applications, and it works perfectly, but had a question regarding the duplication of a record. In my application, the user enters a bunch of information about an event. When the user clicks the submit button, the On Add > Validate event will process the autonumber script. But in this application, there are many instances where one event doesn't differ too much from another, so using the duplicate function built into Zoho's list view would
Suppress Custom Action after execution
I have created a custom action on a view for each record ; however, once the user clicks this once, I would like to not show (suppress) this action.
How to use the JSON input
Hi I have a Database and I want to use the JSON stream in my app. However I cant see it working. I am not a JSON expert but after googling it seems I need a key in order to be able to import it into my web app. Please let me know how can I use this.
Newbie looking for help creating "if" syntax
I am creating an activity sorting application. I want to be able to calculate the amount of time allocated to certain categories of activities. I am working with these two fields: Field: Time_Spent (numerical value of hours spent/allocated to a particular task) Field: Frequency (checkbox list that includes: "Daily" "Weekly" "Monthly" etc. What I want to make happen: When selecting a value (checking the box) in "Frequency", if user selects "Daily", multiply the value in "Time-Spent" by 5 and place
Autopopulating Field with Realted Data via email input. (got that? lol)
I thought for 10 min and could not come up with a more descriptive subject. ;-) I have a form that is populated via email from multiple websites. I have a "source" field to track which site sent the mail. (So if the form was on abc.com I know that.) What I am trying to do is populate an email contact field from another (related) form. Example my "Contacts" form for has: abc.com, joe@abc.com 123.com, 123@gmail.com So the goal is: When a mail arrives and the "source" field reads "abc.com" populate
create graph from data
I have an form setup that collects registration-type data (name, address, class). I'd like to create a view of this line graph of this data with the count of names for each class. Can I do this is Creator? If so, how?
Long Private Key Strings
New topic branched from here http://help.zoho.com/portal/en/community?ftid=2266000000321064 Long private key strings are meant for private sharing of individual components to very large number of users. Here you also run the risk of the keys being shared to unknown users and if they are, then you have no control over it, unless you choose to either regenerate it or revert it. We would advise you not to use them in the application logic in the first place. Instead we recommend you to use the authorization
unescape in code
I'm doing some custome html view, and i'm making an external link where i want to provide the parameters unescaped. However, if i do <a href="someurl.com?<%=unescape('a=1&b=2')%>">Bla</a>
The code editor wont let me, saying there is an error. How do i do this?
Importing data via email
Hello, the graphic on the Product Overview Page says you can do it, but I'll be darned if I see how. I have several dozen sites that collect data email it. I'm trying to get ZC to read those emails and put the data in the db. After 30 minutes of looking for how to do this, I give up and ask for a link or other guidance. Thanks.
Filter command needs to let me pass in a string for the <criteria>
Dear Zoho Developers, I want to create a search page for my users where they can search on multiple fields and I am having trouble when it comes time to write the Filter statement. It seems like the only way to write a Filter statement is to hard-code the <criteria> part, e.g. contacts = Contact [ name == input.name && expiration_date > input.exp_date ] However I want this to be variable; if the user only enters something for name, the statement should be: contacts = Contact [ name == input.name
Help with multi select
Just re-iterating this as did not get a response. I have a multi select box in which a number of filters are applied to so that when the final selection is displayed the use has only a few choices. Of the 200 parts, by selecting a site, and then a fault type the list is reduced to 6-10 selections. This work fine while there is nothing selected, but once the incident is edited, the selection is lost, and I want to re-apply the selection (which is often more then one part of equipment) so that it reflects
Link between Forms
Hi, I have created 2 forms but do not know how to link the variables between the forms. I have,eg. - Form A with variables A1 and A2 - Form B with variables B1 and B2 - variable B2 should derive from A1 + B1 Can anyone advise me as I'm confused by the script builder? Thanks lots. Thomas
Multi Select Checklist
Hi, I have a multi select checklist which changes acording to differenct criteria selected within my form. When the form loads on edit, the exsisting selectections, which have been checked, do not show up as checked on load. I figure I need to use the Select / Deselect feature, and fetch the what the current record should be, and on load, check the boxes. Something like: current_equipment_type == Incident_Report.Equipment_Type_New
Equipment_Type_New.select(current_equipment_type) Is this down the
Formula Program Assistance (If>Then)
I am currently using the formula listed below to lookup the previous record and pull data. Altering the formula listed below, how can I write the formula so any number that returns as negative, will be altered to zero? if (count(Main[ID != 0]) > 0)
{
rec = Main [(ID is not null)] sort by ID desc range from 0 to 1;
//fetching the last added record
input.Usage_P1_SQUD7442N4 = ((input.OnHand_P1_SQUD7442N4 - input.Shipped_P1_SQUD7442N4 - rec.OnHand_P1_SQUD7442N4) * -1);
}
else
{
On Submit Mail Question
I am having difficulty with the simple email notification feature once a Creator form is sucessfully submitted. It seems I can only have 1 email address in the "TO" field, and 1 email address in the "CC" field, and 1 email address in the "BCC" field. How can I set it up to send the email notification to 2 users in the "TO" field and 4 in the "CC" field. See code below: sendmail
(
To : "who@who.com"
From : zoho.adminuserid
CC : "who2@who.com"
Reply to : "who3@who.com"
Upload file - Client Side API
Hi all, I'm trying to add a Upload field in a html page using the Client Side API, but it doesn't show up. All other fields from the same form are no probleem. Maybe I am forgetting some special settings, like with a picture field ? code: <td><script type="text/javascript">Zoho.writeLabel("ImageUpload");</script></td> <td><script type="text/javascript">Zoho.writeInput("ImageUpload");</script></td> The label shows, but the input field not. I also couldn't find that
Fetch and display multiple records from stringlist on user input
Hi, I'm a newbie developer. I'm trying to figure out how to write a script, but my brain is hurting. In a form called Add_to_Assignments I have a lookup field called COMPETENCY_A_A that's displayed as multi-select checkboxes. The data is from a form called Add_to_Competencies that has two fields: COMPETENCY and AREA_OF_KNOWLEDGE_C. In the Add_to_Competencies form, the AREA_OF_KNOWLEDGE_C field is a single-select dropdown lookup from a form called Add_to_Areas_of_Knowledge. What I'd like to do is
Deluge: can a field reference itself (instead of specifically referencing itself by name)?
Is Deluge capable of allowing fields to reference themselves, instead of specifically referencing itself by specific name? I.e. User checks a decision box called "iwantblue". The following script would run "On Update": if (input.someotherfield == "Blue") { alert ("You have already chosen blue; choose another color."); self = false; } meaning the box would become unchecked after an alert box, instead of: if (input.someotherfield == "Blue") { alert ("You have already chosen blue; choose
Newbie question: if statement in a Formula field?
Hi everyone, I'm new to Zoho and am building my first app. I'm pretty excited by what I've seen so far and look forward to learning more. I've got what is probably a simple question. I would like to generate a Formula field called Name Line that displays either the individual's name or the business name depending on the value of the field contact_type. I tried the following but got an error saying it didn't expect an "if": if (contact_type == 'Individual') { name } else if (contact_type == 'Business')
Reference Formula Assistance
I need some newbie help on a formula in Zoho Creator I have 2 fields I need to do the formula on Field 1: Todays_Inventory Field 2: Todays_Shipment I need to do the following formula (Todays_Inventory - Todays_Shipment) - [The entry for Todays_Inventory in the previous record] How can this be written to look into the last record entry and pull the data number for the Todays_Inventory field? Thanks in advance.
Problems viewing X-Axis Labels in a Chart View
I am having a small difficulty with a Chart View of a Line Chart in my Zoho Creator application. If you reference the attached sample image, you will see that on the X-Axis, you can not see the axis labels. The X-Axis is set to match the "Date" field, however, You can not see the dates on the image. One 1 chart, I the labels were drawn at a 45 degree angle automatically, but I can not seem to find how to do tell this chart to do it. Also, how can I set the chart to in chronological order to where
How to get the correct record ID from a selection in a picklist where there are multiple records with the same criteria?
This is a tricky one that doesn't seem to be addressed directly in the Deluge documentation, unless I've missed it. A lookup-picklist displays a list of names to choose from. In that list there happens to be more than one listing with the same value, e.g. "John Doe" and "John Doe". When a user selects one of the "John Doe"s, I want to know the record ID# of the selected "John Doe". But... if I use the method seen below, how do I know that the ID grabbed is to the *correct* John Doe that was
Send email on date
I have a view that contains dates and email addresses where multiple emails addresses are related to a given date. I can, of course, login to Creator, select a date, and have that action send an email to all the corresponding email addresses. My question is can I have the system itself do that automatically? What I'd like is for the system to once a day, see if the current date matches an entry in my view and if so, send an template email to all the matching email addresses.
Confused by lookup field
I have a status field that I use to track the reservation record. I have a couple of statuses that I write via script that I do not want to be set by a user. So in my lookup table I only included the statuses I want the user to set. If I create a new record or edit a record I also see the statuses that I have written via script in the lookup field choices it is not just the values from the lookup table. Why is it showing these extra values. That does not make sense to me. Is there a simple way to
Lead Owner Tab
How do I edit the lead application in Zoho Creator so each user/lead owner can view only his/her leads not all the leads for all lead owners in the CRM? I can't seem to find the instructions neither any functions that disables users from viewing everyone's leads. Your helps is very much appreciated. Thank you.
"Item" checkboxes and Total Amount on an Order Form
I have an Order Form of sorts with a Total Amount field. I have a checkbox field for different items on my form with associated hidden price fields. When a user checks an item's box, the Total Amount field is updated to include the associated price. However, the SAME action happens when a user unchecks a box, i.e. the price gets added again to the Total Amount field. Granted, I'm just playing around right now, so my code looks like this: if (input.items.contains("Fruit Loops")) { input.total
HTML View styles
Is there a reference list of the styles that can be used in an HTML view? I would like to format an HTML view to look like the standard creator views but am unsure how to do this.
How to pass a For Each record parameter (r) to a different HTML view and access the record passed in the parameter
I'm trying to pass a record index number as a parameter to a second HTML view and use it there to access that same record... and I'm failing after much effort. I have an HTML dashboard view that successfully lists records from a form using a 'for each r in <formName>' loop. I've put a link w/ each output record that links to another HTML view that will (when this works correctly) elaborate on details of the individual record being clicked on. I've setup the second HTML view w/ a parameter called
Can I transfer ownership of an app to an alternate user account that I use?
I created my first Zoho account and started app development. But then I created a second Zoho user account that I wish to use as my main account, but I also want to transfer complete ownership of the app created under the first account to my new main user account and continue development from there. Can I do that? Or do I have to start over again w/ the app in the new user? Greg datazen1@gmail.com Santa Fe, New Mexico US
Confusion about sharing after changes
I'm getting confused about how best to share my application with my colleagues. I'm building an internal system that a great deal of my co-workers (50+) will be accessing. We're currently in the testing phase, so i'm still adding new views and forms to the app. I find that even though I add these users in the "sharing" tab, the new views/forms don't automatically show up in their view of the app, but instead a second listing of the same application shows up in their Shared Applications tab and
Next Page