help with coding multiple pages fetching data from forms
I am new to using deluge, figured it would be easier than building a database and etc from scratch, however I haven't been around html/scripting since 2005 so im a little outdated and not picking it back up as expected. I'll try my best to break down
Validate and prevent data entry
Rather than using the form validation to revert changes, is it possible to cancel or revert the changes to the original value on the "User input of a field" event rather than waiting until they're done and doing it. e.g. you have an order that has multiple
MYOB Integration?
Can Zoho integrate with MYOB ??
Can't add Application
Hi, I can't seems to able add new pre-built application from the gallery. Please advise. Thanks.
Null Value in Lookup field
I have setup filters in my lookup fields so that only districts and local level government's (LLG's) of a particular province will show when clicked but I keep getting the null value in front of the LLG lookup field. You'll find a screen shot attached
Product Catalog App > Add to Wishlist (Bug on Selecting "No")
It seems the logic used is not properly configured. When clicking "NO" option it will not Cancel the action but will just Loop to Add to List
Can Consolidated reports be created?
Hi I want records of a form to be consolidated and sent to the admin of the Creator Application on a scheduled time is it Possible?
Email all fields, not just edited fields
Hi, I'm using Deluge script to send a confirmation email to customers when the fields in a form are created or updated. When the fields are updated the email only sends the updated field, not the whole form. Which doesn't work for me as the customer wouldn't
include all sub form rows in a workflow email?
Say I have 3 rows of data in the sub form entry. How do I include all 3 rows of data in an email workflow using deluge script? At present it’s only including the first row for me Thanks David
Rendering image and XSS configuration
Dears, I've a view that from 2010 until 2014 was rendering correctly a upload field to show images. Fromo 2014, in the view only is displayed the html code: <img width='64' height='75' title='Foto' alt='Foto' src='http://creator.zoho.com/DownloadFile.do?filepath=/1431032894626_foto.tif&sharedBy=misca'/> I read that maybe run with XSS configuration in Security App options. But with new Creator version is it not possibile. Any solution? (I can't at the moment use the Image field). Thanks a lot Mike
new fields not showing up
don't know if this is a bug or a missed setting. I created a database with various fields. I realized that a few more fields would be needed, so edited the application. The added fields are there - sadly, they do not appear on the 'shown' database with data. any fix, or do I need to recreate from scratch? btodd
Enable report button based on field
I have added a button to one of my reports. I want this button to do something (open a URL) if there is a value in one of the fields. It fires fine for the records where there is a value in the field "related ticket", but it also fire when there is nothing
Help me write a script to email all my entries in ZOHO CREATOR
HI, I think it's a simple thing to do.. but can someone show me how to email all my entries. What email does it come from? Will I have to have an email from Zoho or can I type in my own from who they see who it's sent from? Please help. I am a detail person so please write out as many steps as possible even from starting on the homepage. Thanks!
Updating selected values of a multi select field via Deluge
Hello, I have a form with a multi select field with a couple of options. My form already has a few thousand entries, and now I need to add and select a third option for that multi select field. This is the code I'm trying to use: //Fetching all records of the form Nueva_venta todas = Nueva_venta[ID != 0]; //Go through each record and select the new option for each entry in todas { entry.Acceso.select ("operaciones@simstore.ec"); } The error I get is: 'Acceso' does not exist in this form I was also
Australian address autocomplete
Address autocompletion is a popular feature on many websites that helps users correctly input a valid address. Here is a link to the vendor's website with a demo of the functionality. https://addressfinder.com.au/ They have extensive documentation and
Complete a number of forms offline and then upload them afterwards
Does anyone know of a way to complete records offline and then add them to your creator database afterwards? Could it be done through an external application? Any help/suggestions with this would be greatly appreciated. Thanks, Eamonn
How to Configure push notifications
Hi Community I am trying to Configure Push Notification in creator but the documentation does'nt help me to navigate through the process. Can anyone help!
Sort sub-form fields in report
Hi, I have a form which contains a sub-form as well as lots of other fields. One of the fields of the sub-form is a date field. I want to be able to create a list report from this form which puts each entry in date order. I can see how to sort the data
SalesIQ- Creator integration
When you guys provides the SalesIQ- Creator integration?
Replacing Dropdown-Field by Lookup-Field
Hello, within my first steps with Zoho Creator I made a form with a dropdown field. Now I'd like to change it to a lookup-field that gets its values from a different form/view. But changing the fields type seems to be impossible (probably to keep data consistent?). I would make sure that all values of the existing field (dropdown) would be part of the new possible seletion (lookup values) but anyway ... I can't change the type. (btw: Starting over is not an option, because there's already too much
Sending last Subform Entry in email
Hi All, I'm new to Creator and trying to sort out some Workflows which automate emails. My form (NCR) has a subform (NCR_Actions), the subform is used to log the actions taken against each record. I am trying to automate an email to an email address in the main form every time an NCR Action is added. So far I have created a Workflow - Deluge Script - Subform on add row. I have created a Send Email task in script and as part of the message I want to include the contents of the Action_Taken field of
Record Template Value Formating
Hi, I would like to know how to format the value of field but not the field header in the record template. I can't to seems find the options. Is it possible to change the alignment of the value? Thanks in advanced.
New OAuth workflow and limits on Cloud Function calls
Ok so here's the issue: we have an application that supports workflows for various external Zoho accounts. In order to keep from migrating the application and re-configuring every time, it makes more sense to keep it central. I've gotten an OAuth workflow
How to filter Multiselect Lookup field based on the parent field?
I have a departments table. I have a managers table with a mutli select lookup to departments. A manager may have one or more departments. I have form with the department and manger. I select the department and then select the manager. I would like
have date field default to current date
How do I program a date field to default to the current date? hughes
Increment update record in report
Hi everybody i need your help I’m creating an app on zoho creator i would to insert a bouton in a report who will increment updaterecord in my report with the button +1
Automatic Approval
Hello, Is it possible to create automatic approval workflow in Zoho Creator? for example if submitted form is not approved, after several days, I want it to be approved or rejected automatically by the system.
Deluge script
When I try to save my script I get "Internal error" ni hint on what is wrong. I checked the script code part by part an it all works. The script is 149 rows long. If i cut out parts of it then you can save it. But every part of the code is tested. The
Automatic update lookups
I have Form A with a lookup field to Form B. This look up field retrieves the value from Form B and fetches corresponding data from that report. The fetched data is only accurate at the time of user input in the lookup field - if Report B changes; then
How to restrict file upload types?
Is there a way to restrict or validate the file type in the "file upload" field? I want the users to upload only image file types (jpg, png, bmp or gif), and they shouldn't be allow to upload zip, exe, rar, pdf... files. Thanks
Customizing Report Header Text/Width
I have a report, and I want to customize its header text length because somehow Zoho "miraculously" trim my Report Header text without even bother to provide tooltip or anything like that for my clients to see the full text. So I browse the documentation
How to hide a section using check box
Hi i have a secton which contains around 15 fields. If the checkbox is ticked by the user i want the section to be visible or else the section to be hidden how can a custom code be written for them. Any reference would be appreciatable! Please help me
How to Select a Choice in a dropdown upon Another dropdown input.
Hi i have two dropdown's dropdown1 represents Product and dropdown2 represents Units. If i select choice Description as "Wall Concrete Pouring" then i want Units to be "Cubic meters" . If (input.Description = "Wall Concrete Pouring") { Units = "Cubic
Mobile Quick View Field Labels [Solution]
I've developed two solutions for field labels in Mobile Quick View: 1. [Simplest Method] Create single line fields (or similar-type fields) with default values of what you want the label to be. E.g. Field name = Due Date Label, Field link name = Due_Date_Label,
Check / validate email field in subform against another form
On each row of a subform I want to check whether the customer's email address already exists in our database. FORM = Customers (this contains contact details etc including email) MAIN FORM = Clinics SUBFORM = Sign-up Something like: For each row in
Get ID from Lookup Field
Hi, So I have a form Projects that has a lookup field of "Builders". I want to export my Projects in CSV, but I need Builders field by ID instead of the actual name from the lookup, as the CSV export, exports with the name not the ID. So for this reason,
On edit: hide subform row if it contains data
Hi guys, might be a strange question... But is there a way to do the following: On edit > On load > hide rows in subform if they contain data And then allow users to add new rows with new data. So when form is submitted, data in hidden rows is retained
Relationships when importing data
We have been evaluating Zoho creator and find it has all the features we need. However we have been trying to import our data into Zoho creator from our relational database and do not see how we can recreate the relationships in Zoho with existing data? We have exported all the relevant tables to excel files and have imported them in Zoho creator, but cannot find out how we can recreate the relations between the individual files (example: between customer and addresses, or between customer and bookings).
Basic Loops
I'm using a Count database with several records to trick Creator to make an iteration process that allows me to replicate what a FOR NEXT or REPEAT or WHILE process would allow me to do. Is there any plan to have a LOOP of some sort in future releases. This would be so helpful. Additionally: It would be great to allow the INSERTING or APPENDING of records as this would allow for the creation of a very sophisticated programming environment. Finally: A link in with your other products that would allow
Adding groups to non-stacked charts
I want to show a chart that shows the total amount booked for each publication date in the next week. But I want to show the publications separately. With the stacked charts I can select a stack by, but I can't see how to do that for the bar and line
Next Page