Combining Sub Form data with Main Form data
I am new to ZOHO creator and have a fairly simple requirement for collecting online Data. I collect the data from a form I have created which has a sub form to collect peoples names and details. On completion of data entry I need it to email the details entered. My form does this fine but the data from the subform does not come across, all I get is the subform "record ID" I think. Below is the date auto emailed. the bit in red is from the subform and doesn't give the names or details submitted.
Parameter Types in HTML View
Hello, I am creating an html view to get a nicely formatted, custom output view of my data. I have encountered an issue in trying to pass numeric or date fields to parameters in the html view. The template variable saleprice is of type STRING. But you are trying to update it with an expression of type BIGINT It seems that parameters default as string type. Is there a way in the script to set individual parameters as something other than string? Many thanks. Justin
Multiselect
Can i use a checkbox or a multiselect field to make a hiden subform appear?
Zoho Invoice Line Items are Creator subform lines
Hi There I'm developing an Invoicing app in Zoho Creator. It will take data from Zoho Creator forms and push it to Zoho Invoice for Invoice generation via Integration tasks of Zoho Creator with Zoho Invoice. My Invoice line items are entries of a subform named 'Food' in the main form Named "Food Inventory". I've declared a map variable that holds values for each line of subform. itemsList = List:Map(); itemsList.add({ "ItemName" : row.Food_Item, "ItemRate" : row.Rate, "Quantity" : row.Quantity
formulas loosing brackets
Hi, I have a formula like his one: ((coastweekquarters * 86304) + (coastweekeights * 66816) + (coastweek_online * 50 * 86) + (billboards_number * billboards_months * 30000) + (billboards_number * 15000) + (LinkedIn_Number_Of_Clicks * 2 * 86) + (kenyayetu_how_many * 100000) + (msafiri_How_Many * 1300 * 86) + (Nation_Thursday_Property_Section_1_4_Page * 90000) + (Nation_Classifieds_With_Image * 7500) + (XpatLink_How_Many_Issues_To_Advertise_In
Decimals showing on Number field???
I added some number fields to my form. In live mode they show with 2 decimal places. Curiously if I change them to Decimal fields with 0 decimal points they show as whole numbers.
Error occured while executing on user input script
I am inputting test data into the following form https://creator.zoho.com/essistmgmt/assets/#Form:AGREEMENT and it suddenly closed with the error message above. Can I get more information on the error details to understand the cause?
Just build a database from Google spreadsheet
When I try to edit a record - I get this error No rows found for the table CustomerDatabase in this DataObject
Field Placement
I have a two column form. I have dragged the fields to the desired positions on the form. When I view the form the fields have moved all by themselves. They change positions. They change columns. I end up with the First Name and Last Name fields nowhere near each other. I've moved them multiple times. They keep moving back. What's going on? What am I missing? --DJ
Link to EXCEL - Problem with multiple line fields
I was able to link a view to Excel by using both Excel's Web Data Query and Zoho html permalink . This is very handy because I can build a lot of reports in Excel and then just refresh the data. The issue that I have is with one text field in Zoho, which has multiple line. This field gets broken down into multiple rows in Excel. Any suggestion on how to fix this? thanks
Expert in Zoho Creator required!
I have a small project (10-20 hours) which requires some quick development, and ongoing developments as I no longer have time to do it myself! If interested please contact me via email: ashley@elprofesoringles.es or +34 633188512 Thank you, Ashley Williams
Display the position of the selected radio item
How can I return the position (0,1,2,3,4, etc) of the selected radio item?
Back ups suggestions
I have 3 main suggestions for back ups automatically delete oldest when you reach the limit of back ups have more than 3 back ups per application rename back ups I have an application which I want to back up regularly. When I go to back it up, I see the following message, "Already three backup's for this application assets is present. You are allowed to have only three copies" I always have to delete the older back up before I can click the back up button. Can you automatically delete the oldest
How do I change a number field to text field?
I've a field called student ID, which is mainly populated by numbers. One new ID contains a letter to cannot be entered. How do I change the field type? Thanks Mel
All fields do not show up on the screen in the Chrome browser when using new Creator Builder interface
Chrome browser does not appear to be compatible with the new builder in Zoho Creator. The screen ends on the icon File Upload field. There is no way to access icons below File Upload. No such problems existed in the old builder, which was a better product on many levels. I support opinions expressed by other Creators users that the best decision Zoho could make is to scrap the new builder and return to the drawing board.
Can't duplicate application
Hi, I am trying to duplicate an application. When I click on Duplicate it says 'Duplicating, please wait.' After a few seconds that disappears but the application has not duplicated. Please help- thank you!
Creating A SAS using Creator
I'm developing an application for a client Creator and it's going well. I'm now seeing opportunities for create specialised apps which could be sold as SASs (Software As a Service) - like Zoho itself does with its Business Apps. I may have missed the obvious, but I've not seen a way to do this. I know I can create an app and share it with people who have a Creator account, and I could do things such as using filters so that users could only see the records which they personally added - but that's
Schedule Delete Based on Date
I am building a property management app and need to run a scheduled script once a week to delete records. I need to delete records that are older the 14 days and status is set to "rented". I would appreciate any help. Thanks, Aaron
Just shows Processing on website - Please Help!?
I've created a form through Creator but on the website it just shows "Processing" and doesnt load my form unless i sign back into creator and "save". But again a day later it returns back to "Processing"? Can anyone help?
Merketo Form Submission Error
Merketo form validation not working with javascript function in submit button tag
ZoHo Creator is down for us--anyone else experiencing problems?
We can sort of see parts of forms, reports and views, but in a janky format, cross-browser. Clearly, something is down and has been down for over an hour. Anyone else having issues?
Portal site login issue
After I login, the header is repeated in the loign box area. I contacted tech support a couple of times, but no response. Is the portal feature still beta?
Check for conflicting dates
I am trying to create a form that will double check whether or not a person is already scheduled for a shift that is in conflict with another shift that I would attempt to assign the person to. I.E. PersonA is assigned to Shift1 from 7/1/2013 to 7/7/2013. If I tried to schedule PersonA for ShiftB that is from 7/3/2013 to 7/10/2013, the application will tell me that those dates are unavailable. on Validateif (Shift[ID == input.Shift && Shift_Start_Date <= input.Assign_End_Date && Shift_End_Date ==
Having problem with getYear()
Hi, I want to define a function that returns the no. of row count where the year in A_Date (Date field) is equals to the current year. I tried using getYear() but upon saving, I'm getting undefined and null. Is there something wrong with my codes? Here's my code : int Calculate.AttendanceTotal(int empID) { yr = zoho.currentdate.getYear(); c_VL = Attendance[Employee == input.empID && A_Date.getYear() == yr].count(); return c_VL; }
Margin problems when saving HTML view as a PDF
I have an HTML view that I have enabled the "PDF Header" option. As I expected, the PDF goes over a number of pages, but the problem I have is no margins (top, bottom, right, left) at all on the page. Any ideas how to set the margins?
Null to Zero - can't seem to ge this to work.
I am having difficulty converting null to zero. I posted this question yesterday and was given a response but I cannot get it to work. In a nutshell I have a formula field (InsertCost) that contains 2 fetched fields (decimal) that I need to divide.I have set the input.pubcost and input.allocation default values to 0. But my formula keeps coming up with NULL. (input.pubcost/input.allocation) If the fetched fields contain data there is no problem but these fields often they will have no value and
Show additional fields after radio button selection
Hi Everyone, I am trying to make 4 extra fields show when one of my radio button selections is made. It is actually for Credit Card information. This is what I have been trying on user input: if (input.Payment_Choice == "Paid by Me") { show Credit_Card; Card_Number1; CVV; Expiration1; } else { hide Credit_Card; Card_Number1; CVV; Expiration1; } Keep getting error message on line 1, not sure why. Your help on this is much appreciated!
Annoying Code Comment issue
Hello, Let me start by saying the Creator application builder system and deluge code are absolutely amazing. I have been able to build an powerful application from scratch in less a month. My question is related to being able to write comments in my deluge code for readability. When I write a comment right after an "IF" state state the IF statement somehow absorbs the comment to within the "}". this is very annoying and makes commenting code with a lot of conditional statements hard. For example
Delete Forms
How can I delete a form? ismael1127
Unexpected error due to improper script.
I am trying to view my scripts under https://creator.zoho.com/essistmgmt/assets/edit/function/ Sometimes I get this error. When I refresh the page a few times, the error message goes away and I can see my script code. Can you please investigate why I am seeing the error?
Passing forms as parameters
I have found the help page at https://www.zoho.com/creator/help/script/form-objects.html#Adding_form_object_as_argument_to_the_function and tried to replicate it but am experiencing difficulties I created a function that has a form as an argument When I execute the form via the script builder and randomly select an ID, it works as expected. When I try to insert it into the form actions by calling the function and passing input.ID, I get the following error message. Why is it not working as expected
Linking Fields in Creator to Fields in Project
Is it possible to get data from Zoho Project (let's say a start date) and display it in a Creator database? They would have to be linked by a common record id or number. Something like a join.
Creating a HOME button in Views/Reports
Hi I've been trying to create a link to HOME in Reports/Views, after countless user requests. Have finally found a way of doing this that doesn't require IFRAMEs or embedding. I've just sent a message to support to see it its okay, because it seems to break some unexplained condition in one of Zoho's Help pages. For the record, here's how (and this could be used to create a full Nav menu and other things) Open the relevant View and then * Click on Edit this application * Click Create New * Click
Custom script code disappeared
I was working on the following function udf_generateids.convert_numeric_to_alphanumeric_code and when I opened the function, it ended up seeing string udf_generateids.convert_numeric_to_alphanumeric_code_896426000014261704(int value, int digits, string code) { } My code disappeared. I never created a function with the name convert_numeric_to_alphanumeric_code_896426000014261704 with the random number. The other big issue is that all my script logic has disappeared. There is nothing in the version
help
the link i use to edit my webpage has gone! and i dont know how to do it any other way ... please help??
Multiselect lookups in new builder
I tried creating a multiselect lookup in the new builder but I could not find an option to change from single select to multi-select. Herb Wexler
Power of caret
Zoho creator appears not to support using the caret "^" as a power of When I try and runs this test code below int temp.temp13() { return 2 ^ 4; } I get the following error Lexical error at line 2, column 10. Encountered: "^" (94), after : "" How can I get the power of a number?
Unknown variable causing script error
I want to update the following GLOBAL_SEARCH html view located at https://creator.zoho.com/essistmgmt/assets/htmlview/GLOBAL_SEARCH/edit/ However, I am getting the following error message Error at line :2 The variable 'd' cannot be accessed at this point. There is no reference to variable d in the script. Can you please help troubleshoot? Thank you
File upload: action on the user input
Hi, I would like to set up script that after file upload other features would appear. Which variables i should use in the script formating (e.g. "If" input.file upload "then" show field) thanks, r.
Questions to integrate paypal with zoho.
1. Do I need to setup the paypal developer before I could integrate with zoho? 2. I followed the instructions in https://www.zoho.com/creator/help/forms/accept-payments-through-forms.html#Creating_a_Payment_Form How can I configure the submit button so that it will linked to paypal website to make payment? 3. Can anyone please provide a step to step guide so that i could follow? THANK YOU!!!
Next Page