Problem: Cannot assign a single value to a dataobject
Hi, I'm getting the following error: "Cannot assign a single value to a dataobject" whilst trying to iterate through a list. Could you take a look? The code is at https://creator.zoho.com/ahatton/kidsoccer/htmlview/Viable_coaching_slots/edit/ (edit access provided to support). and pasted here for reference, for other people. lstTimes = list(); ... for each timeSlot in lstTimes { if (timeSlot.startsWith(hour + "-") && timeSlot.contains(day)) { numSlots = numSlots + 1;
Doubleups in fetch records
I am using a fetch records to narrow the output of a lookup picklist, when I reun the fetch records, and then add them to the picklist I am getting multiples of the same, and the sorting doesn't seem to work. When the form loads there aren't doubles, just when you narrow the results. Here is the code to narrow: I put a clear in to ensure that they were clearing before adding... hazards = (Hazard_Register[(Site == input.Location || Site == "All Sites")].Hazard_Name sort by ID).getall(); clear Hazard_Name;
Help updating records on user action inputs
Hello, My team and I were attempting to have one form impact another form's data once it was updated. We wanted to make it so that when a client in the "Client Listings" form checks out a bike on any particular day [Check_OUT_Date], it will then change the status of that bike [ServiceStatus] from "Online" to "In Service" in the "Bike Listings" form. We believe it is possible to do this, and we almost made it there, but we got stuck because when we went in and tried to edit it in the "Actions on
300: Stacktrace error
I am looking at a form and I can see the following message "300: Stacktrace:' before the form fields begin and also some more codes at the end of the form "296: 297: 298: 299:". I also can't update the form elements. Can you please resolve?
Choose how CRM field fills in Creator application
In my application I have placed a CRM field called Customer Name, which is pulling from Leads in the CRM. When I execute my application, the field is being filled with the Lead Name (John Doe), instead of the Company Name (XYZ Company). Is there a way I can have the field fill with the company name instead? My goal is to select the record from the Leads module in CRM and have all the contact information for that lead populate respective fields on my Creator form. I tried to add the following to "On
Using loops, how can I send e-mail reminders everyday until a certain date has been established?
This is a rental application. I am having trouble setting up a loop to where it keeps on sending the customer an e-mail message reminder of their past due item every day until they have returned their item. I need a loop that runs and executes the code below and stops once the customer's Actual Check In Date is reached (ActualCheckInDate) Here is my function code so far: void emailoverduereminder.EMailOverdueReminder() { // Please write your Form name here, which having record that dues deadline
Default sort order
It seems that over recent times, the order in which records on my main table are being displayed is no longer that in which they were added. I can't quite see whats changed and wondered if you might be able to shed some light on the issue. It is the 'Train2Drive Pupils' application, and the 'Pupils' view. For example, Chloe Buckley was added before Joanne Cook. I have left support access open just in case you need it. Many thanks, Adam Smith
Help with script to create a new record on user action
Can someone help me, I need to create multiple records based on user input (radio button), replicates of original records with only date fields modified. any examples where this is done?
trying to DeDuplicate using a function
I'm trying to write a function that will help identify duplicate records by using a primary field as a flag. I'm not sure why the following isn't working, any thoughts? void deDupe(date added_time, string city) { pile = List:String(); for each rec in Lead_Master [(City = input.city && (Appointment_Date is not null))] { var = rec.Primary_Phone; if (pile.contains(var)) { for each check in Lead_Master [((Added_Time = input.added_time && City = input.city)
Tab Filtering
Hello, I would like to know if there is any way of filtering on a tab level (rather than view level) I have 23 tabs each for a separate country. Under each tab I have a set of views with data from my forms. There are 10 views in total (eg. General Country Information, Key Economic Information, Key Demographic Information etc.). I might change things on one of the views (to exclude or include certain fields). When I do that I would like this to apply to all my tabs at once - so that I don't have
Tab Filtering
Hello, I would like to know if there is any way of filtering on a tab level (rather than view level) I have 23 tabs each for a separate country. Under each tab I have a set of views with data from my forms. There are 10 views in total (eg. General Country Information, Key Economic Information, Key Demographic Information etc.). I might change things on one of the views (to exclude or include certain fields). When I do that I would like this to apply to all my tabs at once - so that I don't have
how to apply built in functions to formula fields in forms?
I have 2 time fields: etime and stime I need to calculate number of hours between these times, rounding up, in a formula field. I tried: ((etime - stime) / 3600000).round(); but it wont apply the round() function when I test, and when I go back to editing the application and viewing the formula, it deletes .round() I'm not sure how else to do this, can anyone help?
Zoho Creator as document assembly app
Hi I want to simplify the creation of contracts for prospective clients. I use Zoho CRM to capture the lead/account/contact etc I use a linked Zoho Creator app to capture the technical specifications of their requirements. Some requirements would be a simple merge field - data captured goes into contract as is. Other fields may be conditional. If one option is selected, then add a block of text to the output (e.g. terms or conditions). Some fields may be dependent (can't choose option 7 if you didn't
Paypal Hangs
I have an application that uses the PayPal integration. For most customers it works perfectly. However some after completing the PayPal function they get please wait screen do not close this screen. The transaction is completed but the please wait screen never goes away. I have not been able to find a pattern. I know it has happened with Internet Explorer 8 and Safari and possibly other browsers. Have other people seen similar results? Herb Wexler
Is there a problem with creator today?
Is there a problem with creator today? I cannot add extra records? Urgent
Form Duplication on the Fly
Can I duplicate a form using only deluge script or am I forced to manually navigate the creator menus to do so? I want to use a sinlge form as a template and then duplicate it on the fly with code and then populate the fields with data from other records. How is this done? Can it be done?
Question about for each loop
I have a database with following structure: Form1 Name Quantity Flag Name1 30 True Name2 14 False ... The Flag Field will be True if the Quantity is the largest. When I add a new incident the script should check the Quantity if the new one is larger than the previous, then the previous Flag should be False while the new one will be True. In this case a "for loop" with index should be convenient. Please any one give me a hint! Thanks!
Render image in form
Is there any way to render an uploaded image in a form? I'd like for the users of my application to be able to see the photo they have uploaded right in the form, rather than have to submit the record and then go to a view to check if they selected the right photo. One workaround is to use the Rich Text field to show the image, but that looks fairly ugly. Thanks!
Cannot save deluge script
I have previously been able to save Deluge scripts as backups for my application. However, it is not working now for some reason. Can you please resolve the issue? I have tried with both Chrome and Safari web browsers.
Deluge "While" loop?
Hi there, I'm afraid I'm having trouble with something that's probably very basic... I'm writing a function that inserts a given number of records into a form. One of the arguments for the function is "NumberOfRecordsToCreate" (int). In pseudo code, this is what I'd like to do: while Count < NumberOfRecordsToCreate insert into <formname> [ <fieldname> = <expression> ] Count = Count + 1 end I can't figure out how to do this in Deuge script? Many thanks for any help! Cheers, Katie
How To Generate Reports that Records Changes?
Hi, I am trying to generate robust reports. For instance, this database is for a Bike Rental program. I am trying to generate robust reports for each bike (how many times it was check out, who checked it out, when it was checked out, the service status history of each back etc.). I learned that I currently am only able to see the current status of my current bikes and clients. Therefore, in order to see the robust history, I would need a report to generate the history and all the changes. Is there
How to do automatic e-mails for calendar deadlines
Hi, Our team is doing the Zoho creator app, and we got stuck on something. We were trying to make it so that when a bike is due, it will send out an automatic email to them and let them know two days before it is due. We were having a hard time because we're kind of new to this program, and we were confused by you guys' scripting. We weren't sure if it was necessarily a specific kind of language like Visual Basic, java, etc. or not, so we weren't sure where to exactly start. Maybe just knowing that
How to filter dropdown menus/lists?
We have a dropdown list (Bike_Info) that we need to filter out. The dropdown list (Bike_Info) pulls data from the “Bicycle Listings” Form (Bike_Listings) and displays the bike serial (Bike_Serial) of all the bicycle records. We need it to filter out the list to only show Bike Serials with a Service Status (status) that are “online” and not display the bikes that are “in maintenance, checked out, etc.” Is there a way to do this? Thanks!
Where is the Access Application Button in Creator?
I looked at your guide where you explain to click on that button to start to input data, but neither with Google Chrome nor with Opera I can find that button! The only way I found to access the application to input new data is to refresh the page, return to the dashboard, click on the link to creator and then select the application I want to use. Is there any chance to get that button? Is it caused by an extention? I know it is odd that it happens with both the browsers. Thx.
Zoho Creator API Filter Issues
I am able to do a general call like this: https://creator.zoho.com/api/json/fuelorders-v2/view/Order_History1?authtoken=AUTH_TOKEN&scope=creatorapi&raw=true and get a response: { "DF_Fuel_Order": [ { "Ship_To": "455 Coors", "Product_1_Gallons": 1000, "Terminals": "", "Product_2_Gallons": 7500, "Product1": "Conv 91 Premium with 10% Ethanol", "Product2": "Conv 86 Unleaded Gasoline with 10% Ethanol", "Product_4_Gallons":
Create a weekly stock report
I'm using creator to manage the product stock. I would like to make a report that shows how many a certain product are in stock. For example, on week 2 we have purchased 30 hard disk and under week 2 we have sold 5 hard disk and week 3 we have sold 6 and so on, while on week 4 we purchased more hard disks to fill the stock. I recorded the date for each purchase (positive record) and sales (negative record). So in my database it will look like this: Name of product Qt Date Hard disk
Required field only if other field is empty
Hi there, I am trying to add a check on validation of my form. The form enables users to input size and price of products. For the size I have a picklist (dropdown) of available fluid measures (25 ml, 50 ml, 75 ml etc.). This field is called 'Size'. Sometimes, however, the user might not know the actual size of the product in fluid measurements. In that case I would like them to provide a description of the size in a single line field (Operator_Name_for_Size). This is the code that I am using,
Remove shared application which user is closed
Hi, I changed my email and closed my account with the old email. However I have a shared application now it is in my other account. How can I removed this application? Thanks!
Complex List Requirement
This is easy to describe but hard to encode: My client wants to select a start date and end date and then make a list of all dates in between that occur every 7 days. Example: Starts: 27-Jan-13 Ends: 10-Feb-13 The list would then be {"27-Jan-13", "03-Feb-13", "10-Feb-13"} Cheers, John Whitney
Help Needed with "If" Formula
I need the total number of Ads for Conferences, which would be distributed in "Welcome Packets" I have attendance by professions. My formula works by just adding the professions. But I need to implant an "if" formula. My Outreach methods include: Trainings, Booths/Displays, Ads. I need the summing of the attendance "if" Methods_Field == Ads. I've tried MANY formats, the "sumif" function worked in Excel that the db was imported from. Here is what I have now: If(input.Method_Field==input.Ad)
how to copy subform
I have a form (transaction record) with a subform. I want to copy the whole form info. (for the second+ same transaction) with the subform, then I will edit some info necessary, then submit to produce a new transaction record. But I could not find the way to copy the subform correctly, since every transaction with different lines of subform. I set default 1 row for form on load, so every time I could only get one row (last row of the copied transaction) I put the following code in form on load if
How to use values from subform for calculation
Hi there, I am developing a form which contains a sub-form. The sub-form contains a numeric field. I am trying to sum the numeric values from all sub-records and present the result in the header (the main form). Please advise! Thanks, TLV
What happens when I reach my record count limit in Zoho Creator?
I use the Standard Plan in Zoho Creator. Can you tell me what happens when I reach my record count limit? Will I be unable to create new records? Or will I be charged for records over my limit? I have several people adding records to the database, so I want to know what to expect. Thank you.
Linking Zoho Creator with Zoho CRM
Hi I work for a small IT repair business and have recently started using Zoho Creator and CRM. Using Creator i have built an app which acts as a job sheet which i fill in as i am working on a customer's computer, this app includes fields such as what the problem is, the work i have done to solve the problem, costs etc. What i would like to be able to do is have some kind of lookup field in my job sheet app so that i can search for a customer that is stored in Zoho CRM, this meansa that rather than
Trying to link Zoho CRM Record and Zoho Creator App
Good Evening, In short, I am trying to accomplish the following: When in a zoho CRM potential module record, hit a button that will be bring up a creator custom form. this custom form will have CRM fields (auto populated depending on which CRM record they were on) and new fields. When done entering the data, there needs to be an option to print as pdf. This attachment should also save to the crm record of the potential. Is something like this possible using Creator and CRM?
Edit Mode Problems
Recently I've notices some problems with the form edit mode. Highlighting a field and clicking on 'Actions on User Input' takes me to the On Add->On Load section instead of the code section for the field. Also if I highlight text in the Free-Flow scripting and press ctrl-c to copy and then click on the On User Input for another field the text shows without me pasting. This happens in firefox and chrome. Herb Wexler
SumIf assistance needed
I have tried writing this many ways and I'm not getting a good formula.... Can anyone help? I need: If "Method_Field" (which is radio button for 3 options, user must select 1) is "Ad" Then the # of attendees from the RCC-Staff + Law_Enforcement + Legal_System_Prof + Healthcare_Prof + Social_Services + Educational_ Prof + DV_Prof + Disabilities_Specialists + College_University + Multidisciplinary fields Resulting in a cumulative total number of attendees from the training, where the ad was placed
Button to cycle trough records in a table
I have uploaded my access application and need to be able to cycle through records in a table using 2 buttons one for next record and one for previous record. Please can someone inform me how this can be accomplished?
Custom search creator database
I am using the it asset manager and I would like to create a custom search on the home landing page. I am able to create a search for a single view but what I really need is to search the enitre database (all views). Is this possible?
Downgrading Link for ZOHO Creator does not work
Hi, I want to downgrade my Zoho Creator from Basic to free, but the Link "Downgrade to the free plan" is not working, its not a real link at all! When I copy it and paste it, it gives me "javascript:;" and no Link. Can you please downgrade it manually for me? And do I need to pay this mnths fee even if I haven't used it at all? Regards, Atia Ahmed from gestaltungsWerk, Germany
Next Page