Re get data FromSQL 2000 by getUrl tasks
Hi Akash: This is a http link through a query from SQL 2000, and then use the getUrl parse the xml file in the creator, the format is the basic reference creator to help complete the test data seems crawl, but can not display the data and found a different format, as follows 1，the sample from zoho creator 2，the sample from my link Grab the data format is as follows： my function code as follows： string test() { sm = "<table class=table zc-viewtable>" + "<tr class=zc-row-header>" + "<td class=zc-viewrowheader
Stuck on Fetch/Update Records to add a number value to a record (Sports-focused developers, please help - images provided)
Hello, I'm having trouble figuring out how to update a record from a value entered into a subform. I'm going to explain the process in plain English and my problem (I'd rate my skill in deluge as "low intermediate") 1- My "Game Score Entry" form is used to enter and update sports scores using a lookup field that contains entries from a "Team Info Entry" for the team name. 2- To keep in-game stats and attendance for individual players, I have a "Goals/Assists" subform with a lookup field that clears
Funtion for Currency Fields
Hello ZC team; I have this situation, in Application B I have a form with fields like: Name, Contract Number, Customer, Rate,etc. On Application A I have a form with lookup field Name, Contract Number, Customer, and other fields like Price,etc. I need that when I select the field "Customer" in App A a function is called in order to fill Price field from the valued stored in App B (in fact rate field). Both fields are currency type (Price & Rate). The link in both applications is the Customer which
How to format currency fields in HTML view
I've created an HTML view. Some of the fields I'm showing are currency type, but they display as regular numbers. Example: $42.00 shows up as 42. The tax shows up with all 4 decimal places. Is there any kind of format function that would allow me to show these fields as currency in the HTML? Thanks.
Auto Filters not working
A number of auto filters on my application have suddenly stopped working. I have emailed details to support and need this investigated and resolved as matter of extreme urgency.
Use Same Subform Twice in Main Form
Is it possible to use the same subform twice in a main form? I have already created an application in which this is the case, but the scripts that worked in the on user input of one of the first instance subform fields will no longer work now that I've added the second instance of the subform. Each instance of the subform has a different name. Another peculiar thing is that the subform contains a picklist that I've dynamically added to in the on load section of the main form. That works. However,
Fetching data
Hello, I have Googled and searched your forum for an answer but I can't seem to get the code to work. I am either looking at this wrong or making it difficult for myself. I have 4 forms Drawings; Material; Purchase_order and Work_order The Material form has been put as a sub-form in the Drawings form. There is a field in there called "size" which is a single line text I wish to "fetch". In the Work_order form the users selects a Drawing number from a Look-up field which is linked to the Drawings form.
Convert String to Time still having problems
This is the error message I get with the following script, please help? It worked fine for the first few reservations, this is the application Copy of Reservations form Reservations { field alignment = left column { First_Name ( displayname = "First Name" type = text width = 200px ) Last_Name ( displayname = "Last Name" type = text width = 200px )
authorization problem in record-edit
Good morning, I have build a small application with zoho creator, and I have shared some forms with other users. In only one case I open a form in record-edit mode via Editing Records via Record ID using (http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname>). When I use this function logged with administration grant, it's ok, but when I use this function logged like another user, the system generate this error: You have logged in
multiple lookups - data consolidation
i am trying to organize information about the training sessions of athletes, i have a lookup field connecting a certain days workout to a certain athlete, but sometimes athletes work together - how can i link the days workout to both athletes and still be able to get streamlined search / graph results? i have tried multiple lookup fields (athlete 1 / athlete 2 / athlete 3 ) but sometimes "john" works out alone, or may be logged as athlete 2 or athlete 3 on other days workouts, i would like to be
Comparing Strings
Hi How do compare strings such as if string1 begins "s" { string2 == string2 + string1; }
My convert date and time is working intermittently
Hi I am getting error messages from my application that I built to make reservations. It worked perfectly for the first 10 reservations, then it started throwing out error messages and started to work sometimes and not at all for my staff. Maybe the 7:00 am needs 0's? like 07:00am to convert the date time string picklist to a Zoho 24hour time calendar? Currently I turned off all of the scripting using the // marks, but this is what the script with action looks like form Reservations { field
Data from 2 forms displayed in one view or report
Hi, I'm trying to get data from 2 different forms to display either in one view or report. I have one form which has details for properties on the market including the asking price of the property. I have another form which has potential buyers details including the maximum they are willing to spend. What I would like to see is a view or report grouped by properties with a sub-list of potential buyers for the properties based on the amount they are willing to spend being higher than the asking price.
Subform - Invalid Entries Found - Please Correct and Try Again
Dear All, I have added a subform to my main form. Every time I try to submit, I get the following error message "Invalid Entries Found. Please Correct and Try again". I notice that some others have had a similar problem, however I couldn't find a solution posted. For reference, Im using Mac OSX and Safari. Any help would be greatly appreciated? BW, Mike
AddMonth question
What value is AddMonth supposed to return when it overlaps into a month in the next year? For example, I am adding 3 months to a date field and the date is in October. I expected it to return a 1 for January but instead it returned a 3. Can you help me on this?
Calculating total hours
Hello, I need to calculate the total hours on a Works order form I have - but I am unsure how to fetch the data. The app work's like this: A form called Machines has the run time of each item identified by the Drawings form. This is linked with a field called Drawings_no There is another form called Works order which the user selects the from drawing_no field and enters a quantity then I need Zoho to do a small calculation of the quantity the user entered times the run_time stored on the Machines form.
On Mouse Over anyway to achieve something similar within Views
Hi, I have Zoho views for my data and if needed i can have HTML views in place Would be very very nice if my user can put their mouse on a record and see some additional information In my case mouse over a room record and see the name of the occupant As i understand Java script is no longer supported in Creator has anyone found a way to achieve this Thanks
Splitting a big form into multiple forms, then sending all data to just ONE view
Is this possible? We can't get around General error, message from server: "Got error 139 from storage engine" with our big forms (HUGE annoyance, by the way -- Formstack doesn't have this issue!). Therefore, we want to split our big form into maybe 3 smaller forms, embed all 3 in our site and then have all 3 populate just one single view. It would be way too time consuming for our client to have to search through 3 or more different views to get data for just one application.
ID usage question
I've been trying to make sense of the ID field and hope someone could straighten me out. Simple process: Input information into Form_A ID record is populated in View_A Ok, that's easy enough to understand Now, where my question lies is how to get View_A.ID to follow a record through several forms? Technically, I'll be using a UNIQUE IDENTIFIER, in my case "Opportunity_Title". This field will be referenced in every form beyond Form_A as a it steps through each stage of the process. As each Form_n+1
Populate separate field from the drop down
I have a pick list for Mfg, when I choose the Mfg, I also want it to populate the Mfg Phone, Phone being a separate field. Mfg ( type = picklist values = manufacturers.Manufacturers.Manufacturer displayformat = [ Manufacturer ] allow new entries = true [ displayname = "Manufacturer" ] sortorder = ascending searchable = true width = 206px on update
Get input parameter from current URL into iframe
I cant seem to get the code right to get the variable from a non-zoho-based URL into an iframe for instance a person has come to my microsite from a a parent site (which has passed a parameter), this has put them on a landing page with the following address www.MyMicroSite.com/UserName=JohnDoe the page itself is built in Wordpress and has zoho iframe snippet on it. I want the zoho form (within the iframe) to accept the variable JohnDoe from the URL and populate the value in the field called "userName"
Usage Limit Exceeded
My application has just started reporting usage limit exceeded messages. These messages are incorrect and my application has stopped working. Please contact me immediately to resolve this. My username is paulansell1965. I will email support with my contact details but am sure you already have them
Add a record through the html form
Hi, im trying to add a record through the html form with using curl, i read all guides, but it doesnt work here is the code: if(isset($_POST['button']) && $_SERVER['REQUEST_METHOD'] == "POST") { $message = strip_tags($_POST['message']); $_SESSION['message1'] = $message; $fname = ucwords($_POST['first_name']); $_SESSION['fname'] = $fname; $lname = ucwords($_POST['last_name']); $_SESSION['lname'] = $lname; $companyname = ucwords($_POST['company']); $_SESSION['companyname'] = $companyname; $address
How to make a View column with a display name and an underlying URL?
I have form/table with several hundred rows with two fields: Advertiser_Name (example: "Ford") Advertiser_URL (example: "http://www.ford.com") When I create a View including the above columns, how can I show JUST the company name, but make it a clickable link with the Company URL? Normally, I would create the following: <a href='http://www.ford.com' target='_blank'>Ford</a> I assume I can do this in the "View Definition" screen. Is that correct? Please provide instructions and a code snippet.
Parse variable from current URL into iframe
I cant seem to get the code right to get the variable from a non-zoho-based URL into an iframe for instance a person has come to my website from an adwords campaign, which as put them on a landing page with the following address www.MySite.com/AdCamp=ID2 the page itself is built in Wordpress and has zoho iframe snippet on it. I want the zoho form (within the iframe) to accept the variable ID2 from the URL and populate the value in the field called "referring_source" in the embedded form. How would
Change a Single-Line Text field into a Multi-line Field w/o data loss
Is it possible to change a Single-Line Text field into a Multi-line Field without losing data. I have a form with data for which I would like to change a single-line field into a multi-line field but I'm worried it might delete the pre-existing data. Thanks.
Stateless form Buttons 2nd row?
Is it possible to add a second row of buttons in a stateless form. Both Chrome and FF will automatically wrap a single row of buttons if the screen is not wide enough to display all the buttons. However IE 8 & 9 do not wrap the buttons. Another solution would be to add the ability to logically Hide buttons. This gives the ability to only show buttons that are relevant to what the user has entered on the screen. Another solution is for IE to work like FF & Chrome.
Picklist preserves previous choices
Hi tech support We have an application (for church service and roster) which contains multiple dropdown picklists. These picklists' choice is empty and dynamically generate items according to choices from other picklists. It all worked fine until recently. What I discovered is every time dynamic picklists generated, selected and submits, the chosen item actually inserted to the picklist statically. After 30 odd times, the dropdown picklist has 30 entries. On the form, using 'clear picklist', I can
Formula Field Update Frequency
My app is designed for elderly people. I need a formula field displaying how many months have passed since the record has been updated. But my formula will always display CERO because the record is updated everytime I try to update the formula field by giving the order r.formulafield=r.formulafield; ¿What is the "updating frequency" of the formula field ?
Copy Name from form to sub form
I've read through all the topics, but I cannot get it to work. Seems to be simple. Main form is named "Contacts", sub-form is "Invoice". I just want the field "company" to populate into the sub-form. on load on "Inventory" Input.company = company.company Help please!
how to round robin like functinality in leads
leads gets a number from 1-6 and after it again number starts from 1 and end on 6.
Trying to wright to Subform field inside a "for x in" loop
In the code below, the "Notes" field is a Subform field I'm trying to wright to when an auto reminder email goes out. I can't get the syntax correct to access the Subform field. What am I doing wrong? The Main form field name is "Notes" and the Subform field name it wrights to is "Notes" I've tried y.Notes.Notes, row.Notes, y.row.Notes ******************** for each y in test_emails[Received] { y.Notes = zoho.currentdate + " Auto DEL notice"; // Trying to create an entry in Subform field "Notes"
Schedules Attach Summary View as PDF
Is it possible to attach a summary view to an email in the Schedules section? Currently it convert the Summary view to a regular list view. Herb Wexler
Cannot create invoice through a form in Zoho Creator
Hello, I have created a form in Zoho Creator and I am trying to ask Zoho Invoice to create an Invoice. I am using the script code below (which I found in your help page:https://help.creator.zoho.com/create-zoho-invoice.html input.Invoice_Detail_Status = zoho.invoice.createinvoice({ "CustomerName" : input.Customer_Name, "ItemName" : input.Item_Name, "ItemRate" : input.Item_Rate, "Quantity" : input.Quantity }); I get the following error when I am trying to save the script:Error in statement at line
Action button windows with forms loading with large white space on the right
This happens quite alot with deferent forms I'm opening for filling out. My form is jammed on the left half and white space on the right half. If I go into the delveloper tools elements inspector of my browser, I find the Table containing my two column form <td> tags, but also this third <td> tag. <td elname="zc-formTableFix" style="vertical-align:top;width:99%;"> </td> If I remove this tag using the browsers developer tools window, the form than looks correct. Question, Why is Creater adding
Embedded reports not scaling correctly in Dreamweaver created site
An interesting one this one. I built a site with ten embedded Zoho reports. This was a very simple site and worked just fine. I adjusted the iFrames to 600 x 500 and the ZoHo content scaled perfectly. I then decided to do a better job based on CSS using Dreamweaver CS 5.5 (don't ask) and the reports did not NOT then scale properly and were elongated only showing about a quarter of the bar charts in the vertical direction. Actually it was very browser dependent - the only common thing was that no
Fetch record using checkboxes (Multiple Values)
Currently I have a form i.e (Finance Entry) in which we make Payment or Receipt entries. One of my another form having the entries of our Customer Outstanding. Form name: Payment Outstanding (eMail_Tool). In [finance entry form] I have to fetch the value from [Payment Outstanding form], I am able to do so using "Lookup - dropdown" (single entry) this is script I using in "Lookup - Dropdown" [Update_PO] // Variable FPO = eMail_Tool [Ticket_No == input.Update_PO]; // if (input.Customer_Name ==
Appending items in Lookup Field which display value is different than its value
Hi, In one form, we have a lookup field looking for ID but, displaying the description. Then, when we try to programmatically append a new item (we have also inserted the new item in the corresponding form, programmatically too), the only way is setting the new ID but then it displays the ID, not the description. It looks horrible! Is there a right way for appending the item correctly and displaying the description (the ui.append() function has only one parameter, for the value). Thank you very much,
Simply adding an image into my form to be displayed when the form is being filled out...
I just simply want to add and image to my form to be displayed when the user is filling out data for reference reasons. Through research it appears that this can be accomplished using the Notes filed; but I am not understanding how to get the image I want to use in an appropriate area so that the URL tags in the Notes field can reference and access it. Does my image need to be uploaded to Zoho somewhere so that it can be used in the NOtes field? Pardon my ignorance; but I thought it should be rather
Dynamically Created List Bug
Here's a picture of a test form's checkbox field with one item: In the form's code, I clear the checkbox and dynamically add items: clear ITEMS; for each r in LIST { ITEMS:ui.add(r.ITEM); } In live mode, it looks just fine. So I select an item and submit the form: Back in edit mode, the item I selected is now appearing! Somehow, the form's definition code was changed. This also happens for anonymous users submitting data with the form. I view this not only as a bug, but a security issue. For
Next Page