adding a value to a longlist field type in DS
Hi, FormA has a lookup field of IDs from FormB called formb_ids. I would like to update formb_ids (add an ID to the longlist type) with a variable v. How is this written in DS please?
How to change copyright information on pages
Dear Everyone, How can we change the copyright information appearing at the bottom of pages "© 2013 ZOHO Corp. All rights reserved." to "© 2013 My Company Name. All rights reserved.". Thank you. Kashif
Message field in "Scheduler" not accessible
I am trying to create a schedule for one of my forms; specifically, trying to program the app to send out an email alert one week before the driver's license of the company vehicles' drivers expires. I run through the "When to do" but when I get to the "what to do" I can only get as far as inserting the message subject. The field for the actual message is visible but not accessible. I cannot type on it and it does not show the tabs shown in the "Message Subject" field (Insert Expression, Switch to...).
Uploaded File Validation
Is there any way to validate a file-type and size? I'd really like my users to post only PDFs, JPEGs, or Google Docs under a certain size. Cheers, John Whitney
Paypal Integration question
Hello, I have a quick question on how paypal integration works. When the customer is making the payment from a payment form setup through creator, during that process do they have to create a paypal account or can they just pay with their credit card? As a note I do not want that to be the case as it makes the payment not very business friendly. I want a customer to be able to just pay with their credit card. Thanks David
automatic updating of database from external link/spreadsheet
I am new to Zoho, but am very interested in Creator. I have forms being submitted via another service which updates a google spreadsheet in real-time. I believe I saw something mentioned in a forum about the scheduled updating of a database from an external link/spreadsheet. Is this possible, and if so how, because that would be awesome?
Import from Google Spreadsheet with Merge
Is it possible to import data from a Goole Spreadsheet using merge data so that records are edited not just added again? Just like in the migration tool?
5 FORMS INTO 1 REPORT
I have created 5 forms that are all linked together by one common reference number. I need the output results to all populate into one report. I do not want to look at 5 different reports when the forms have been completed. Can someone tell me how to merge 5 reports into one easy to read report?
populate form via email
hi there is form on website which takes from user name phone city email form sends email notification, it is possible to customize notification how can i populate creator's app via email from web-site form?
Has Zoho changed the login process for new accounts?
It appears that Zoho has changed the login process for new accounts. Previously when a new account was created Zoho asked for a username and email address. Once the account was created the username was required for login. Now when a new account is created Zoho does not ask for a username, but ONLY an email address. The email address must be used to login. I have 75 users who were set up with usernames. Can users still log in with the username? Or do they have to use the "email address" associated
Dropdown
Hi I have a dropdown box where the user must select a certain period (three , six , twelve months) When the user select the option the formula needs to calculate the correct amount of days to add onto the input date. Ex . - if user selects three then the amount of days must be 91 that are added onto the date entered. How would the formula look ? any ideas ?
Delete a View
How to delete a newly created VIEW. Made a duplicate View by mistake and want to delete one of them.
Field Types
I had an application running on the old Builder Platform. Now when adding items to it, such as a lookup field, when I start to write a script, that field, gets a field type change to an Integer. I wanted it to stay as a string. Can I change it at anytime?
importing data to a subform from the main form
Hi, I saw this forum https://help.zoho.com/portal/en/community/topic/importing-data-to-a-subform#2266000002822095 and I tried using the steps but really it doesnt work for me, I don't know if the title on the spreadsheets are wrong but is it already the same with the link view name. I have allowed edit access on the application named SAMPLE. Please help this is urgent thanks.
Upload file - Creator API
I am trying to send a file to the creator using a java code through the API creator as shown in the link: https://www.zoho.com/creator/help/api/rest-api/rest-api-upload-file.html # http_method But all attempts are returning 500 error. see the parameters sent with POST: Url = https://creator.zoho.com/api/xml/fileupload/ applinkname = XXXXX FromName Requisi_es fieldname = teste_1 recordId = 836809000002270003 " filename = filename.pdf scope = creatorapi and the file ... tried to send with Content-Type
Dropdown dependent on dropdown? How ?
Hi Just make new form. Logic is next: 1 dropdown - choice of city , 2 dropdown - choice of firm in this city. How to make this logic and how upload to creator those dependencies "city-number of this city's firms" I have about 90 cities. In each city form 40 to 2000 firms. Thank you.
Lookup Issue with New Application Builder
By default, the new app builder uses ID numbers for lookup fields. You can select the display name however. I have a lookup filed type using checkboxes, so the values entered are a list. This is how it appears in the Report view: But this is what happens if you email this field: Is there some new deluge aspect to get this to display names rather and ID numbers for sendmail? Very Frustrated with the New App Builder, John Whitney
HTML views
Hi Zoho, I was wondering if you have some information on how to create html views. I have read this article: https://www.zoho.com/creator/help/views/create-html-views.html I don't find it that useful. I am looking for some more detailed information about how to insert deluge queries into the html code. For example i would like to create a table. In that table I would like to get values from one of my forms. At the top of the table I would like to have a user defined field where the user can choose
Views: Is it possible pull a value two tables away?
I've searched as best I can, but I'm falling short on terminology. Forgive me if this sort of thing should be easily answered. Here's a description of my project: We are using our Zoho Creator database to record interactions with school groups who visit our institution. Each Interaction is tied to a School. Each School is tied to a School District. Interaction --> School --> School District Our institution receives tax support from a given region, and schools belonging to districts within that
I want to put the forms I created onto , or view and use them from a secure webpage How do I do that?
I want to put the forms I created onto , or view and use them from a secure webpage How do I do that?
Dynamic View
Hi I have a number of Stateless forms that hold information for engineering configuration. The Current Config ref is stored in a variable that is global (via a table). One part of the config is a set of Widgets, Each Config can have up 10 Widgets each widget has 5 parameters. I was going to code this as 10 static sets of data in the main table but thought I would be knocking on the limits of Zoho and fields in Tables. So I was looking at a Master-Detail set up just for this part of the config
No <return> allowed in message body of scheduled report
When you create or edit a report schedule (under workflows), and would like to modify the message body of the email message such that something meaningful is added to the report attachment, then you cannot use a <return> to start a new line. If you do, you will get the error message "Error in scheduling parameters: null", which is not telling you what's wrong...
Another backup error
New app, built from scratch, backup is successful. When restored gives error: "java.sql.SQLException: BLOB/TEXT column 'Descriptio_1388351000001002559' used in key specification without a key length"
In IE, record edit link triggering reload to home page
If one clicks on the gray Edit button, no problem, but should one click on the Edit row of the hover menu, then the link, instead of opening the record for editing, triggers a re-load of the home page. If this in not a common problem, let me know and I will open a support ticket. Thanks,
Newbie design question on code vs description in Dropdown/Lookups
Hi everyone, I am new to Zoho Creator app builder tool and this forum. I weren't sure if my previous post got through. So I am going to try again.... I have a simple question. When you setup the Dropdown/Lookups, can you setup a dynamic lookup list where it can display a description value on the Dropdown, but store a code value into the Form record? For an example, if I have a US State setup Form, the Form will have a CODE field and a DESCRIPTION field. The CODE field may have "AL" and the DESCRIPTION
Multiple Criteria
If I want to set a view criteria can I use multiple fields to set the criteria? For example: DATE1_Drop == something; DATE2_Drop == something
Auto fill a field
Hi! Here is my situation: 1.) I have a Dropdown field called Property Sub Type & Description with several choices (e.g. 105 Commercial Real Estate - Retail, 107 Commercial Real Estate - Lodging/Resorts, etc.). Next to this field is a field called Property Sub Type. What I want to happen is have the field Property Sub Type field auto filled with the data being put in Property Sub Type & Description field but with a bit of modification. E.g. If user chooses "105 Commercial Real Estate - Retail" for
HTML View, Populating a table with fixed number of columns
I wan to populate a table with fixed number of colunms with records from a form. The idea is to display an iframe (in a zohosite) with products that belong to a selected category in a 4 columns by unlimited rows table. the question is this. I can have the records to display in a collection variable like this: Products_to_display=Prdoucts[Category==input.Category]; now I need to populate the table, one product per cell (say the product name for now), with the condition to have only 4 columns. I
pivot table report window in Chrome not working propperly
Hi have you noticed that when using chrome a pivot table report's window does not allow you to get to the bottom? it keeps returning you to the top? This does not happen in Explorer. Any advice on how to fix this? I'd like to use Chrome. Regards Luis
Encoding a string in a HTTP Post
Hi, I'm trying to use the Google API for adding placemarks on maps. The HTTP body needs to have the following: <atom:entry xmlns='http://www.opengis.net/kml/2.2' xmlns:atom='http://www.w3.org/2005/Atom'> <atom:title type='text'>Faulkner's Birthplace</atom:title> <atom:content type='application/vnd.google-earth.kml+xml'> <Placemark> <name>Faulkner's Birthplace</name> <description/> <Point> <coordinates>-89.520753,34.360902,0.0</coordinates> </Point>
copy formula error?
hi there is working code in creator 1 filed - formula field, calculation works well try make new formula field (new builder) just copy code of old formula in place of code of new formula builder says "Expression not supported in forumla" how copy code of 1 formula to code to 2 formula?
Data format errors: Enter a valid date format
Under Applications Settings, I modified the date to dd-MM-YY format When I load the form, the date fields still show the old format. Also, when I select a date from the date picker, it shows the old format. When I submit my form, I get an error. When I change the date to '07-07-13', then it works. The date format specified in the form and the date picker is not in sync with the application setting.
Newbie design question showing description but storing code value on Dropdown/Lookups to
Hi all, I am new to the Zoho creator app builder tool. I have a simple design question. I came from an Oracle development background. In many Oracle typical screens, there is a List of Value widget like Dropdown that is based on a SQL query or dynamic query. Typically, there is a code and a description value where you want to show the description on the drop down but physically store the code value. How do I set this up in Zoho Lookup or Dropdown form widget to do this? For an example, if I
Updating a field
Hi Could you help please -- I am sure this can be done.. I have a Form = Clients that has a field = HealthPlan - Yes/No When the Client Purchases anything : I have a Form = ClinicalDetail ( like Invoice Detail) - I have a Field = Discount in a subform called Rows ( main Form is the Clinical ( like Invoice) - which holds the Client ID I would like Clients that are on the HealthPlan - to get a 10% discount - so that this applies automatically. So I would apply script to Form = ClinicalDatail
Issue with saving scripts - new creator script entry
Hi all I had an issue when updating the form scripts ("workflow") for an existing customer. Their database had been created using the previous generation of the Creator design platform. I needed to add some script lines to their existing code. I was able to paste them (using the freeform scripting interface) and save it into the On Load script area, and it "stuck" correctly (it was still there and working when I looked later). However, when I also pasted into the Validate area, and did a Save
Posting to Database
Ok, forget about my last post. All I want to know is if it's possible to insert a record into a Zoho form, from an external website, without forcing the page to refresh? I will learn any language I have to, I will do whatever I have to...I just need a way to submit a record into the database, without a page refresh. Currently, the only method you have listed is submitting a form. That refreshes the page. I need my plugin to execute onLoad. So if it automatically posts, then refreshes, the user will
Ajax, Json & adding a record.
I'm currently trying to test to see if I can come up with the code to add a record to the database. This is what I have: $.ajax( { type:"POST", url:"https://creator.zoho.com/api/c.mart6780/json/boxoff-mw/form/Stats/record/add/", data: { authtoken:"<MyAuthCode>",scope:"creatorapi",UserID:"56464",MWName:"Test",Attack:"980" }, contentType:"application/json; charset=utf-8", dataType:"json",
Adding a additional field in subform
Hi All, I am developing Tour Plan application for a Pharma company for MR. I have 2 forms: Employee: Employee ID, First Name, Last Name, Location etc... Leads: Company Name, Contact Person, Lead Type, Phone, Address, City Now i am creating a form called Tour Plan The First column will have drop down menu to select the Employee First and Last Name. Once selected, it will fill all other information from the Employee table. The second part is to add Leads. I am using subform. The first column in subform,
Report based on drivers name
I am trying to create a database to track loads run by my trucking company. I am hung up on generating a report for the driver's payroll. My trucks typically run with team drivers so I have fields for "Driver A" and "Driver B". I also have fields that indicate the number of miles the load is and the rate per mile each driver is to be paid. I need a report that will pull the pay details for each individual driver whether they are listed as "A", "B", or both. (A driver may be listed as both if
How about a India phone number for Zoho creator support?
Or do you just not care anymore? Varun.
Next Page