Passing string longer than 255 characters to an HTML view
Dear ZOHO, I want to pass a string longer than 255 characters to an HTML view. I generate such a string when I invoke a function. In the html view that is generated, I have to set this variable as type STRING. There is no type such as LONGSTRING for example. Please see the attached screen shot. How can I achieve this? Thanks for any help. Silvester
Create View that accepts a URL parameter for record retrieval (for use with REST API)
Hi there, I have searched high and low through the documentation and forums and can't figure out how to get this working, so I'm hoping someone here can lend me a hand! I am using the REST API to pull in data from my Zoho Creator app to an external website. Data entry happens in the Zoho Creator application, but public perusal of the data happens elsewhere -- and I'm using Views to aggregate and build the data I need to pull in as JSON objects. I need to create a view where I can pass a URL variable
How do I create a link to associated records filtered by the record?
I have a form where I create projects. I have an form where I create messages, some of which are associate with some of those Projects. In a Projects View, I would like to have a hyperlink to the Messages that are associated to it. How would I do this?
Custom function not pulling individual record
I got this to work on a separate section of my application but can't get it to work here. It's pulling all the records, not just the individual record matching the ID. Situation: I have an Equipment form and in that form is an Invoice_Number lookup field. I'm trying to create a custom button that when clicked will pull up the invoice record based on the Invoice_Number field. I used the same script for a maintenance custom button for the equipment form and that works fine. However, when I modified
On User Input script executed at On Update
Initially I thought that the problem is related to a single application belonging to one of my clients, I reported it to support a few days ago, but it seems that it was not even understood. I discovered that the problem is in fact a generic one, not at the application level, probably introduced after a recent update. The fact is for some fields, I did not test for all kinds of fields, On User Input is executed also at On Update for a field. See a sample application as example (it is also shared
Criteria : Since last connection
Good evening everybody, I apologize in advance if the question has already been asked... I'm triying to have a different view for each user, in which will appear the contacts entered since the last connection of the user. Explanations and details: My contacts have a State field (NY, NJ, CA...). I have one user for one state. Each user can add contact for any state, but is allowed to view contact only for his own state. For each user I want to have: - a view with all the contacts from
Script to Send Email if Value is Null for Field, Date Ranges, Batches (oh, my)
I did a quick search in the forum for this topic but came up empty. Please redirect me if this thread exists. I use Zoho as a tracking mechanism for international shipments. A lot of the tracking has to do with dates - e.g. ETA west coast, ETA final destination, ETA delivery, etc. What is the syntax for the null "if ETA west coast = null" send email? Does the "null" in the code need to vary depending on whether the field is a string, numeral, multi-select, etc.? Another question I have is that
How to get monthly calendarview of sessions
I have a table with sessions. Each session has start end enddate with about 3 days long sessions. How to get a monthly calendar view of this sessions as html-site? What about using Google-Calendar? Ralf...
How do I create a view :One to many relationship with nothing on the "many" side
How would create a list (view) of one to many relationships where "the one " exists but there is no matching "many"? An example of what I am trying to ask ( but doing poorly ) would be to create a view that shows all projects where there are no tasks created. In this example, the tasks table ( form ) would hold a field for projectID which would hold the relationship. thanks in advance
Using checkboxes or multiselect with import fields
I am trying to create a lookup formula that aligns with input fields within my form (see example: https://help.zoho.com/portal/en/community/topic/can-forms-do-nested-lookups). It would be like completing this example, but trying to allow for selection of multiple cities and/or states. I can designate the column as 'checkbox' or 'multiselect' after I make it an import field, but am not seeing this when I got to access my application. Any ideas?
Has Daluge Script compiler changed?
Hi, appreciated ZC team, Until now, this code without first statement did not compile, and now it's possible and necessary without first statement to work: records = MyForm[ID == 0]; if(someCondition){ records = MyForm[Field == "Value1"]; }else{ records = MyForm[Field == "Value2"]; } for each record in records{ doSomethingWith(record); }Have there been changes in the core programming? This change affects me in several HTML views.
How to lookup values for preset or viewonly
I have a form CourseType where every coursetype is explaind with name, duration, price and so on. At a form "Courses" i have a LookUp for [coursetype].[Name] and [trainer].[name]. I like to have a field [duration] which should display (on editable) the value of the matching [coursetype].[duration] of selected coursetype and a field [price] which should preset (and editable) with the value of [coursetype].[price] of selected coursetype. Any hint how to do? Thank you Ralf...
Help ICal Feed Works for Zoho Cal, but not for Google Calendar
https://creatorexport.zoho.com/rrsaddleclub/test/ical/google_calendar_feed/**********/DTSTART=real_zoho_start_date_time&DTEND=real_end_time_date&SUMMARY=First_Last_Name&DESCRIPTION=Riders_Names_Ages_Weights&ZC_FULL_DAY_EVENT_VAR=ALL_DAY Yes the access by I cal is turned ON I have just hid the access code to limit access on this forum This worked for Zoho Cal just fine, but I need to get Appts to go to Google calendar for access by android Suggestions?
How fill Field with Average of 5 Fields in Form
I have a form with 5 values each between null or 1 to 9. Now i neet a dynamic field with average of the fields with a value (non NULL). Any hint? Ralf...
Special character problem when switching between Script Builder and Free Flow Scripting
Dear ZOHO, In an html view, I want to be able to display the text with HTML codes etc. I'm building a view for this. I have two problems. 1 When I switch between Script Builder and Free Flow Scripting, special ASCII codes get interpreted into the (finally) intended character. This is very annoying when developing. Why can the code not be exactly kept. This is an example of code that gets flattened. Before: Stem = (r.Stimulus_RT).replaceAll("<","<"); Stem = Stem.replaceAll(">",">"); After Stem
Linked forms: Can a lookup field picklist be set to display only un-picked records?
I so far have not discovered an indication for a linked lookup field between two forms, for example, from a child form "B" to a parent form "A" to display only un-picked records to link to. The relation is one-to-one in this example. Can the lookup field and displayed picklist be set to only display unpicked linked records? Many thanks.
Criteria area is hidden on choosing "deselect" twice.
I'm using MSIE8 on Windows 7 64-bit. Steps: Navigate to the user input scripting section of a field. Make sure Script Builder is displayed. Drag "deselect" over. Select the "DeSelect All" option. Select a field, obviously. Click "Done". Drag "deselect" over again. Bug: The "DeSelect" option is selected by default, which is fine. However, the criteria area is hidden. Selecting "DeSelect All" then "DeSelect" redisplays it. But, a bug is a bug, you know. MSIE8 is apparently fundamentally incapable
The deselectAll function has (<value>) in it, and I can't save the script.
Steps: Navigate to the user input scripting section of a field. Make sure Script Builder is displayed. Drag "deselect" over. Select the "DeSelect All" option. Select a field, obviously. Click "Done". Bug: The function is inserted as: FieldName.deselectAll(<value>); When I click "Save Script", it errors out at that line.
Zoho Creator REST API: JSON result string formatting?
Hi there, I'm new to Zoho Creator and I may be about to ask an elementary question. I am using the REST API to display some view output in a web application. But when I make an API request in this format: http://creator.zoho.com/api/json/<app_name>/view/<view_name>/apikey=<api_key>&ticket=<ticket> The resulting string I get starts wtih something like 'var zoho1234567view2 = ' and ends with a semicolon, meaning I have to do some string parsing before I can run json_decode() against it. Am I trying
Dynamic form field generation
I need to create survey forms that allow users to add and fill out as many of a particular field as necessary. For example, I have users who need to enter information for each property that they own. Users all have varying numbers of properties. I would like to the user to start the form with one "Property" fill-in and then have a button below that which says something like "Add another property." When clicked, this button dynamically generates another property field on the page. I know there is
Number to Text converting function!!!
I have a client who would like to display in words the number entered, in portuguese. This could possibly be written in a function. Anyone have any examples of one? Thanks, Damien.
Datatype Error Driving Me Nuts!
Hello. I'm brand new to Zoho and Creator, so forgive me. I'm attempting to port over an excel spreadsheet into a Zoho Creator application. In setting up my form, I'm attempting to calculate a value based on two other values in my form. Paid_Miles -> Number, Required, default value = 0 Actual_Miles -> Number, Required, default value = 0 Variance -> Formula Here's my formula: if((Actual_Miles > 0),((100 - (100 * (Paid_Miles / Actual_Miles))) / 100),0) This is supposed to check if Actual_Miles is zero
How do I evaluate for NULL?
I want to trigger an email alert when a record is updated and a specific dropdown is set to "-Select-". The following statement does not work: if (input.Guide == "") thanks Glen
interface bug in drag and drop form editor (notes field)
Steps to reproduce: Drag and drop a notes field to a position between existing fields on form Format text and click done "Please wait" continuously displays until page is refreshed Note field either does not appear, or appears in the wrong place after the page is refreshed I am using the current stable release of Chrome (12.0.742.100). Anton
Function not working in header but works in each record
Possible bug in calling functions. I have a function that only has an openurl statement. It is called from a view the intention is to open a new view. When I set it in the View Header it does not work however when calling the same function from 'Each Record' it works as expected. An alert/info statement shows that the function is being called but the openurl did not open a new view. Here is the function void Rides_Full_Year() { //op_52=CURRENT_YEAR openUrl("http://creator.zoho.com/soundcyclists/scbc-ride-list/view-perma/Schedule_List_Full_Year?Ride_Date_op=52",
Filter a record by a certain field not being blank
Hi, I am trying to create a view that only shows records that have a value for the field "Payment_Date" I have tried setting a filter that "Payment_Date" does not equal empty (I left the field blank) but this did not work. Is there another way to do this? Thanks
Create Function to pass value from one form to another
Hello, I'm new to Zoho Creator and love it! But I simply cannot figure out how to create a function, and it appears that I will need a function to do what I'm trying to do. Here's what I'm trying to achieve: I have a web page with 5 tabs. Inside each tab is an iFrame holding a zoho form. So the user can simply click on the tabs to access the various forms. Up above the tabs is a zoho form with just a single input field. I want the user to be able to put a value into that lone input field and
error occurred while creating the report
I am trying to create a report but get 'error occurred while creating the report'. The application has 14 forms & 25 views.Currently there are no reports. I am using the 'Business Free Edition'. I tried creating a report from different views with the same result. Any idea what is causing this error? Herb Wexler
Disable RTF not working
I have a form with a RTF that is disabled. However users can type in the box and on submit the changes are saved. The RTF field is used to display information from a RTF field on a linked form. All of the toolbar controls are unchecked. Herb Wexler
data validation
I was trying to validate a form with the following code: if (count(Address[Address_Name == input.Address_Name && client_code == input.client_code]) > 0) { alert ("An address with the name already exists for this client. Please enter a new name."); cancel submit; } But it is not working. Sometime the validation works and throws the alert and sometimes the user can enter the data successfully. I thought it was a really easy validation. Am I doing something wrong or there is something wrong
How can I do this: Public can add records, but not edit or view details of previously entered records
I have a "Public" app which allows people to register themselves for events on a calendar. For privacy reasons, I can't allow other people to edit or view those previously registered people. How might I achieve this?
How can I do this: Provide an "Admin" area only available to signed-in user
My "Public" app allows users to register for events on a calendar. I need a separate Admin area only accessible to signed-in users which allows the Admin to view/edit/delete event registrants. Any tips would be appreciated.
Change view based on drop-down?
My organization is trying to decide between QuickBase and Zoho Creator and a question will help clarify if Creator can meet our needs: Is it possible to have an HTML page which has on the top half a set of dropdowns, through which on the bottom half a different view is generated? An example would be: 1) On the top I have a drop-down list of offices that collect donations for a non-profile 2) On the bottom half a different view table is generated based on the drop down selected in 1. Additionally..
Error On User Input Script
I'm having this error, could someone helpme with this? Thanks Error details: Error occured while executing on user input script. Unable to update variable Address r.Address is null r is null This is the Script associated r = Store [Store == input.Store]; input.Address = r.Address; input.City = r.City;
Any samples or advice on how to script the following ?
I have one form that has personnel with hourly rate. I have another form tallying the number of hours worked in a task. I'd like to generate a view (from second form) which multiplies the number of hours x hourly rate to get cost for the task. Then this form could sum the cost for the total cost at the bottom. Any ideas of what the best way is to do this ? Any help would be appreciated.
Field not updating
For a disabled lookup field ("Problem Field") I set the value through Deluge script in the 'On User Input' event of another field (on the same form). So depending on the value selected in this field, the value in the Problem Field changes. This works fine for existing records. On new records the value remains "-Select-" until I save and reopen it. My app bmpm is shared with support (edit access). To reproduce: - go to tab 'Admin' - open view 'xxxx' - click 'Add' - In field 'Player' select the entry
Error "Invalid entries found. Please correct and submit again." Lookup Fields?
Hi, Everyone I have just completed a database and I am getting the error "Invalid entries found. Please correct and submit again." I am guessing that it might be some kind of problem with the Lookup Fields and the dynamic update I have on dropdown list. Anyone has any idea on how to solve this? Please let me know. Regards, Leandro PS: I have just submitted it to support.
Pulling data from another table (UPS tracking numbers)
We have two tables: Open Orders (has a Sales Order # entered at order start) Tracking Data (imported from UPS with the Sales Order # as a column once the order has shipped) Trying to create a view that will list all the line items in Open Orders and pull the tracking number from the Tracking Data table when the Sales Order # matches. Any advice is GREATLY appreciated.
Creating a relationship
I am trying to do this by following your Help at Creating-relationship. When I insert the lookup field in one form and open the "select field" box for the other form, there are no user-defined fields available to choose from. Can you provide any suggestions or more detailed help on this?
Can't create view with restricted records where date field equals null
I am trying to create a list view that only shows records where the date field is null. But whenever I check "Restricted records" and set Datefield equals null and click DONE, the criteria is not saved. How can I do this?
Next Page