URL field help
Why does this script not populate a URL field please Thanks input.Print_File = "https://drive.google.com/a/signedfast.co.uk/#folders/0B8WoWXP12Cw0TTR3ZHUyejZQcmM/" + input.Scan_Code; Print_File being the URL field
Restore Data
Hi Zoho team, Can someone please assist to restore the deleted records? I accidentally deleted records which have "Date Filed" for April. Appreciate if someone can help immediately please. Regards, Maricar
Zoho creator on mobile site
Hi. Can anyone tell me why the mobile version of the form loads with the drop down lookup fields like this and if there is a fix for this?
Close a form on submit
Is there are way to close a form on submit? What code do I need to put on "On-Success"?
how to use aggregate functions in a subform context
I would like to use the "sum" function in a subform script as follows: On User Input (for a subform field): input.Total = rows.sum(Item_Amount); This doesn't work at present. Any suggestions? Will this be implemented in future? Anton
Importing Data from Google Spreadsheet Using Deluge Script
Good day to you, I would like to be able to import data from Google Spreadsheet using Deluge script. Is this possible? I'm able to publish a spreadsheet to the web and is gives me a url like the following: "https://docs.google.com/a/mydomain.com/spreadsheet/pub?key=0.............&output=html" Any help would be appreciated.
Fetch data from another app and use in a formula
Hi, I have a app named "skills". I also have a app named "age". At least I have a app named "pointer". In pointer I made two lookups.One from app Skills and another from app Age. What I need is make a formula who combine the field value "specialist" in Skills, the field value "age" and combine in a formula in pointer - input.profile = input.skills + "" + "\" + " " + input.age. The input.skills are from app skills. The other is from another app. I can't use the default value for the fields (the
How to use Map() and postURL()
I have read the ZOHO Creator help guide and attempted to make a form post to an external application and failed miserably. I think it's me not being calibrated on how all the parts fit together. For the reference, the api is from SmarterMail . I'm just going to be lazy and post the form info below and hope someone with a better brain can help The form target to post to is http://xxxxxxxxxx.org/Services/svcMailListAdmin.asmx/AddSubscriber The form fields are all text: AuthUserName AuthPassword DomainName
autofill a field, based on a lookup drop-down list
active form is <test> in <test> there is a lookup field <Item_Num> which is a dropdown lookup field to autopopulate in <test> is called <Item Description> which is just defined as a text field lookup form is <Item_Master> this form has field <Item> that is used to link the two forms meaning <Item_Master.Item> is linked to <Test.ItemNum> In <test> in the field <ItemNum> under the "On User Input" section I have the following script: [note that I am new to script so am I missing headers, "{" or other
Cancel Submit on a Stateless Form
I know the cancel submit function is only valid on a non-stateless form to be added during the validation action, but what i'm looking for is exactly the same function on the stateless form, does anyone know if there's another function out there that can accomplish the same?
Auto Fill selections from list
I have two forms, one for Product information and one for Supplier information. The Product information for has a supplier list linked to the supplier information form, and the Supplier information form has a products list linked to the Product Information Form. Is there any way to have the list auto-select/fill the products name from the Product Information form when I select the corresponding Supplier Name in the list from the Product Information form?
TFA - Deactivate for my users
Since you launched this TFA, my users are unable to create and activate their accounts AND use my application. Why did you do this for all users? You are risking my business which depends on user acceptance. AND you didnt do the TFA in Portuguese!! That s beyond belief. How can you expect people to sign up if they dont understand English? Do you think everyone speaks English in the planet? I can help you doing the TFA translation to Portuguese - but please give me the option to deactivate it for
Usage Limits report is badly broken.
Usage limits as seen from at: https://creator.zoho.com/dashboard#usagelimit is badly broken. The used and remaining measures have apparently swapped. What's worse is that cleaning up data is actually decrementing this 'new' used count. Please take a look at this urgently! -Varun.
Usernames and Emails
Zoho has been busy lately changing some of the authentication processes. The sign-in form in Creator now requests the user's email, although the username also works. I'm happy with this because in the past people forgot their usernames and complained. Since we are moving away from usernames*, it seems confusing that after sign-in the application shows the username and not the email. My suggestions is simple: show the sign-out with the email. *Usernames are now autogenerated by Zoho Accounts and are
Multicheck boxes and subform
Hi, I create a POS for Pizza and i have the follow problem to fix: I create a form that include a subform to choose the product and a second subform with multiply checkboxes that you can choose the extras. For example you can choose: PIZZA MARGARITA and in Extras you can choose EXTRA HAM +0,20$, EXTRA CHEESE +0,40$ etc.... All records works well but my problem is how i can fetch the prices for calculate the total. Right now i try to fetch by: row.TIMH_EXTRA_SUB = EXTRAS[ID == row.EXTRAS].MASTER_TIMH_EXTRA.toDecimal();
Second set of Leads
How can I set up leads for future use by creating a separate category of leads?
How to add to a date but not add time?
I have a field called Checkout_date that has a date without showing a time (i.e. 1-01-2011) I have a Due_Date field that has the following formula Checkout_date.addMonth(4) The result that gives me is 5-01-2011 02:00:00 How can I make it so it doesn't show or doesn't ever include the time, only the date?
Option to have user "add" another group of fields?
I am wondering if there is a way to have the user be able to click to "add" another group of fields. Example: A group of 3 fields for them to fill out: Traveler Name Transportation Notes Then, the user could click "add" and the same three fields would show up again. So they could add (in theory) an unlimited amount of travelers in their group, but each would be individually entered. Does that make sense? Thanks for any help!
Combine Pivot tables to form a single report
Hi, I have the need to combine two pivot tables in Zoho Creator. The pivot table report s are generated from the same Zoho table(Assignments). Pivot Table 1 is a summery of all tasks and income generated in a month. Pivot Table 2 shows the same data presented in more detailed way. Pivot Table two show a weekly breakdown of task and total income generated from those tasks. I would like to combine those two pvot tables to form a single report with the summery report at the top and the more detailed
Multiple records update with zoho api
i have a requirement of updating my zoho records from my website through api. is there a way to update the zoho form records throgh an api of my web app.
Inventory Form Question
I've made an inventory form to receive inventory items and set up initial item quantities. i.e. starting inventory = 1,000 widgets. But I need help creating a new form to enter daily sales and have those sales reduce inventory quantities. i.e. today's sales are 100 so the new total quantity needs to be changed to 900.
Send email to multi select fields
I have to send email to checkbox if selected, how can i do that? if i put input.Email_Copy_of_setup_to == "email list" error in return
Adding notes to a form!
Is there a way to add to a entry i have already saved, without updating the original form i made for example if Mr smith bought 100 apples on Monday and i have logged that. Then on Wednesday he says they are bad, i need to be able to go to his entry and add a note saying this.
Group multiple fields as variable
Hi, I was wondering if there's a way to group multiple fields as a single variable. For instance, if I have a form that has these billing and shipping address fields: Billing_Name Billing_Address Billing_State Shipping_Name Shipping_Address Shipping_State and Shipping_Same_As_Billing it would be great to define, somehow, Shipping_Fields = (Shipping_Name, Shipping_Address, Shipping_State) if (Shipping_Same_As_Billing) { hide Shipping_Fields; } else { show Shipping_Fields; } Instead of
Subform Drop Down Field Width
Hello everyone, This is one of the most common form fields - a lookup to another database referencing products/services/products etc within a subform. However, as it stands now the width of the look up field is extremely narrow and even though there is a horizontal scroll bar on the bottom of the drop down users have a VERY DIFFICULT time selecting the correct record. Please try to address this as soon as possible or as a quick fix until they can be customized just increase the default width....
look up field or drop down with numbers
Is it possible to have a loop up field or drop down with numbers and then work with those numbers on a pivot report. Right now even If I have a look field as number on my pivot is reflected as string and I cannot work with those numbers. see my attached
Center the data in Reports in zoho creator
Is there anyway to center the data on the columns? The current is too much left align
count() is automatically replaced by Zoho platform with count(null) in html views
In a html view I have the following code: <%=users[ID>0].count()%> When I close the edit mode and open it again and return to the view, the code above appears as <%=users[ID>0].count(null)%>Of course, if I try to save the html view, an error is displayed "Field null does not exist ... " So .count() is automatically replaced by Zoho platform with .count(null) - which is a wrong syntax . Regards, George
Manually empty an upload field via script?
I have a file upload field that is hidden or shown depending on whether a radio button is checked as "yes" or "no". That is simple enough to do: if (Radio.contains("Yes")) { show File_upload; } else { hide File_upload; } But, along with hiding the field, I also want to flush it of any files the user may have uploaded, since he could possibly be doing that by accident, and after realizing it, chooses not to click the "[remove]" option next to the field, and instead
Any way to get Minimum Date in a Creator report?
I'm trying to figure out some way I can use a minimum aggregate function (or conceptually comparable approach) on a date field in a Creator report. If there were a Min/Max option like there is for numeric fields in a basic list report with grouping, that would work - but there's not. I tried to use a pivot report, but date fields do not appear to have a min/max calculation option here either. Is there any way that this can be accomplished with reports (I know it can probably be done with custom html
Validate Textbox with scripting builder
hello friends I try to validate a textbox, using a for ech. So i have hte next example: 1.one form that contain a textbox (user) 2 the second form contain different field, dependencia grupo user valor I need to find the textbox's value of the second on the other form, that contain diferent data. I used a for ech y the FORM ACTION validate, but it does not execute nothing. thanks for your help. regard Jorge Caro
Hide form fields from users who are not logged in to Zoho
I have created a form within an app I created using Zoho Creator with numerous fields on it that I don't want non-zoho app users to see. I set these fields to "Admin Only" in the form builder so that now only I (as the admin) can see/edit them from a view when I'm logged in, but I want to be able to invite others to login to my app and see/edit them from a view who are not admins. Is this possible?
Update Lookup based on Dropdown selection
I have a stateless form with a lookup, dropdown and a number of single line fields The form currently works with the lookup pulling back an object when an item in the lookup dropdown is selected, this then populates the dropdown and single line fields with values in the data repository. I'd like to improve the form by allowing a pre-selection in the dropdown list which acts as a filter on lookup. Is this possible?
Export to Excel template
Can anyone tell me if / how I can export a report into a pre formatted excel spreadsheet? I want to be able to manipulate the report using VBA and macros....anybody help?
New to creator - help needed
I am creating a booking form to go on my website. I have a number of questions I have created a client database and want the cient to be able to access the booking form without them having to enter their details or see the names of my other clients. So far I am using look up butthat shows all my clients. I also want the client to see a calander showing dates of their bookings - I dont need to see time as the service I offer is restricted to anytime on a day and is not time sensitive. Can anyone
Zoho Creator Lounge - Whats cooking?
We have a few avenues from where we reach out to our users. An all formal blog portal at Zoho Blogs where we make the high profile announcements and the Forum which is our 2 way communication platform - our users voice their opinions, ideas, suggestions etc and get help from us and other power users when they are stuck up at some place. We felt that other tiny announcements, geeky tips and tricks, ways and means to make any application jaw dropping, informal posts – bordering on technical stuff
can i insert data in subform (Blank/Inline subform) by code???
I have a parent form with a subform. The subform is called "conceptos". i am trying to copy records from parent form, but i can not copy the subform data. i am using this code: propuesta = formPropuestasProveedor[ID == idPropuesta]; //-->The record that i want copy insert into formPropuestasProveedor[ codigoProveedor = propuesta.codigoProveedor codigoPeticion = propuesta.codigoPeticion proveedor = propuesta.proveedor letra = propuesta.letra conceptos = propuesta.conceptos //--> the subform data
Form doesn't show in browser
A small percentage of my users say that my form doesn't appear on their view of my webpage. My form may be viewed at http://www.jaxareagolf.org/index.php/meeting-notice/. My form does use some deluge script. Can this be a browser issue? It shows for me in IE, Firefox, and Chrome. Is their anything I can suggest to my users that they may try? Barney
RFP for Vendor evaluation
Hi, I'm looking to implement IT software and would like to invite vendors to respond. I'm going to put list of questionnaires (which can be designed through zoho creator) with different forms & pages I'm planing to notify vendors to direct to the zohoform, so that they can login and update the information - They should be able to save and come back at a later stage to edit (obviously need to create user) - They shouldn't be looking other vendor responses (restricted to their own entries Can
Failed to Update data
Trying to save and it won't let me, everything I edit gives me "failled to update data.." messages, please help!
Next Page