some lookup still return actual value rather than ID
Hi All, I still have two lookup fields that return actual value; all other lookup return ID. It gets confusing sometimes but not a problem. i'm just curious anyone know why?
Field On User Input trigger not executing
The on user input trigger for a field in a form that was working several months today no longer seems to work. When data is entered into the field (any field with an on user input trigger) the user interface shows the spinning icon showing that the back end is processing the trigger -- but the trigger never finishes. I have changed the figure to simple put text into another field on the form and I get the same result. Has anyone else had this problem? Any ideas how to even begin to debug this?
'row' is invalid collection error
I have a form and on this form I dragged in a subform from the buttons, then I added the below script to each of the subform fields that contribute to the Sub Total. All worked well. However then I decided that I needed the other type of subform where I have a linked field so I created a new form with the subform fields that I needed then added it to my main form with the linking. Then I added the below code to the Qnty field and clicked Save Script, and got the below error: Error at line number
Is there a way to export, update many fields, then reimport our database
We have a database where we want to update the "Status" of 500 different entries. Is it possible to export the data, update and then reimport? Or some other way to update easier then going into each entry?
Please document best practices for URL links in applications
Related: https://help.zoho.com/portal/en/community/topic/find-and-find-replace Zoho Creator support should document best practices for using relative url links for better application portability. Forms Views Pages This seems outdated: https://www.zoho.com/creator/help/url-pattern/zoho-creator-url-patterns.html Cheers, John Whitney
Give ownership of app to someone else
Hello, I have developed an Zoho app for a friend in my account but now I want to transfer complete ownership to him. My buddy and I both have the $10 zoho creator paid subscription. How do I do this? Iram
Picking a specific value from a list in Deluge
We have used Creator to create a kind of CRM that links contacts (customers, in our case teachers) with interactions (in our case, usually some kind of field trip or outreach program). To facilitate this, we have a bidirectional relationship between 'Teachers in attendance' on the Interactions form, and 'Interactions' on the Contact form. It works pretty well, as this allows us to view all of the times a given teacher has worked with us over the years. However, as each related field from the interaction
SQL Server to Zoho Interface/Integration
I have a client with a mission-critical SQL Server-based application. The application is not going to migrate to a new platform for the foreseeable future. However, they do want to build a customer portal that would give customers access to order status information and also enable customers to enter orders. Naturally, of course, Zoho comes to mind for that customer portal. Our expectation is that the Zoho portal app would have its own database separate from the SQL Server system - and that the
How to remove all sub tabs ?
Hi, How can I remove the sub tab 'Companies Report' ? When I click on 'Companies' I already go to this report and I only have 1 sub tab below 'Companies'. So I want to get rid of this unuseful sub-tab. Best regards, Chris
Looup Filter Error .. How to solve this ?
Hi , I am new to Zoho Creator. I am creating form that contain two lookup fields . like Country and state . But In that I can't create filter . I attached screen shot . Have a loook
How to hide fields when editing report
Hi Very new to Zoho. I use to code PHP no worries and would prefer to use it but then my manager can't make changes. I don’t think the manager has setup the database correctly from the beginning but I need to make a few changes while i redesign the Zoho database for him. I have a calendar view for routing jobs for guys in the field. When you click on a job in the calendar it opens the view we want and shows the fields we want. The problem is that when we click edit from there it shows all the
custom interface button?
hi how can i make new button on creator interface and tune this button to make specific workflow for picked entries? example this button for picked workflow will be change each entry settings and save them
Backed up App but can't import
Hello, I recently backed up one of my apps then downloaded the .zip backup file. Then I logged into another Zoho Creator account and didn't know how to import the app and all its data in one fell swoop. Could you tell me how to do this?
Reporting showing separate row per record in a subform
Hi there, Ok title may not be clear but.... I have a main form that holds the Delivery request details and for each delivery request I may have multiple items going out and for each item I have to record the Asset number and/or Serial number. I have a products sub form in my main table that I can add the product name (default qty is 1), the serial number and the asset number. I need a report so I can run a daily dispatch report, that details a row for each product shipped and certain required fields
Long function statements
This works: exchange_rate_map = exchange_rate_record.Rates.toMap(); return exchange_rate_map.get(input.Currency_Code).toDecimal(); This saves OK but fails at runtime: return exchange_rate_record.Rates.toMap().get(input.Currency_Code).toDecimal(); Any ideas?
NO IDEA WHAT I AM DOING- Subforms
I want a field in my subform (Cust_Ref) to automatically fill from the given input in the main form (Claim_Number) I have tried using a number of things in the script builder but I can't get ANYTHING to work. I need to know how to write the code and WHERE EXACTLY to put it. I am at my wits end. Nothing I have entered has even been saved by the script builder (I am hitting save script and getting a success message)... when I go to check to see if it worked and go back to the builder the code I entered
How can I tell how my form and subform are related
Hello, I have a form. On this form I created a subform by dragging the subform button. Then if I remember correctly I used the blank subform. Then I created the fields manually in the subform. But now I would like to know how is the main form and subform related. What if I enter subform records in the wrong record and want to move the subform records to another record? If I new what the related field was and if it was visible I assume I could just change the related field in the subform and the record
301 response code when adding a record to a form in zoho creator
Hi guys, I updated a python script I use to add records to a form I have on zoho creator. I use the new url schema https://creator.zoho.com/api/<ownername>/<format>/<applicationName>/form/<formName>/record/add/ instead of the old one https://creator.zoho.com/api/<format>/<applicationName>/<formName>/add/ and it returns 301 as response code all the time. The authoken is valid and I removed the old field zc_ownername. Any ideas on how to fix it? Cheers
Available CSS
I have really enjoyed using Zoho to create an app for my small business. Now that I have learned the basics I would like to begin using the powerful HTML features. This question relates to furthering that desire. Zoho appears to have some very handsome built-in CSS classes for use with HTML views (zc-rowheader, zc-viewtable, etc.) I have tried searching the Help Center and Forums for a list of these classes and their attributes to no avail. Is there any possibility that Zoho could post a list
Saving Map Data
I have created a map variable for exchange rates accessed from a live web feed. How do I save a Map variable in a form?
New Built in String function(string.matches(<regular expression>))
We have introduced new string function matches for testing if the string matches a given regular expression. This function will be useful validating a given string for particular format. For ex, following code snippet can be used to validate a phone number string for the formats - (123)456-7890, 123-456-7890, 1234567890, (123)-456-789, (123) 456 7890, 123.456.7890, (123).456 7890 phone = "(123) 456 7890"; if(phone.matches("^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$") == false) { info "Please
Basic Newbie Support questions
Hello All, I am very new to zoho and have some basic questions. Can I connect a different form to the "back end" tables? I don't see any access to data structure to connect different forms. I would like to create different forms for different people. Some for just inputting data and others for changing or viewing. Can I create a form in a different view that will allow me to see ALL the records? Right now I have my one form and one report to show all the records but no way to change them. In
Create one record per multi select
Hi, I'm looking to create a single new record for EACH selection in a multi-select. I have a stateless form "Add Campaign" asking all the same fields as the main form "Campaign" except that the stateless form has a multi-select for the field "Test Name" while I would like each record in "Campaign" to only have one Test Name. Therefore, on the stateless form "Add Campaign" I would like help with the script when the user presses "submit", it will Add a Record in "Campaign" with a single Test Name
User List & Group Member List
We use the User List and Group Member Lists all the time to manage the many people who access our Applications. We would find these lists much more functional if they appeared in a basic table format rather than thumbnails format. The tables would just have two or three columns (username, email address, and I suppose maybe avatar), which could be sorted by either username or email address. We've got to imagine that many other Zoho Creator users would find this more functional. Please jump in, if
email description, not record id
hi there is complex app number of service tables and one main app in main app there is some conditional lookups (for records from service tables) when using main app - user picks records all works good - in main app we can view picked records from service tables (names/descriptions) but when zoho via workflow sends email - in email there is not names/descriptions of picked records but unique id of that records how can i in sendmail send names/descriptions of picked records?
zc classes
Hello, where can I find the explanation of the classes zc available for use in html pages? example: class = "zc-edit-a" class = "zc-zc viewrow-row-1" class = "zc-zc-formheader formheader-height" class = "zc-formbutton" etc. .. Best regards David
I am trying to use a list field in a formula field, and instead of the text from the list, I get a large number
I have 3 forms. In form 1, I enter a list of hospitals to be use in a Schedule form as a dropdown. In form 2 I enter a list of nurses to be used in a Schedule form as the person being scheduled. In the Schedule Form, I have a drop down, Facility, that is linked to the hospital list form; I also have a field Nurse Name that is linkd to the nurse list form. I then create a formula combining the text of Facility +" "+Nurse Name. Instead of the text I selected from the dropdowns, I get large intergers.
When you embed in HTML-page report from other app, you can't use Add or Edit buttons
HTML-Report: When you embed View from another zoho creator application with Form/Report (not IFrame) - you cant edit or add new elements in this View from this - you always get empty popup window with message: "There is no such form in Zoho Creator ". It's beacuse you use short links for add and edit like "#Form:form_name_from_another app" to get form in popup window, and it's not working from another application Do you plan to fix it?
Error Msg: "Wrong DataType specified. The Template Variable null should be of type LIST."
Hi Folks, I have recently edited a script that was working just fine and now I have hit a problem that I can't solve. I have several Multi-Select dropdown lists with data type stringlist. I wish to set this field to null. In my script, if I enter "input.Task_Fertiliser_Supplier = null;" then the script saves with no error. However, when my program runs, I get the following error message: Error details: - Error Executing the workflow On User Input scrip of Task Type. -- Wrong Data Type specified.
Scheduled task to update Invoice Payment Status in Creator
Hi Team I have ZC and ZI. ZC currently creates invoices in ZI and keeps a lot of the created invoice ID. I need to set up a scheduled task that runs through records where payment status = "Not Paid" and check each record in Invoice for any change in payment status. If paid it should update the Payment Status to Paid. I can do this for an individual record using GetInvoiceInfo() but how do I nest that inside a For Each function so that it runs through each record and checks/updates? I currently have
Totaling Subform
Hello, On a form I have a subform. In the subform I have fields such as Qnty, Price, Labor and Subtotal. I have set diluge to update the subtotal based on data changed in the other fields, all is good. But now I need a total field to add the Sub_Total fields in the Subform. How can I do this? Iram
Combining 2 strings, and converting to a Date / Time field?
I have an application where a user selects a report date, and then a starting time. I have a date field for the report date, and a drop down menu with 15 minute increments for the starting time. I am trying to combine these two fields, and then place them in a Date / Time field, but I can not get it formatted right. Here is the code I currently have. datetime_string = input.report_date + input.start_time_input; input.start_time = datetime_string.toTime("MM/dd/yyyy"); Which gives me the result
Show / Hide / Disable fields
Hi Zoho Development, Some forms by necessity have a significant numbers of fields that often need the use of show, hide, enable and disable. Would you consider a future enhancement where the coder could use an asterisk (wildcard) to denote any characters. For example, show AA* would display all fields with the Deluge Name AA[something]. The coder would then have the ability to name fields in groups to suit their application and instead of multiple lines of show, hide, enable and disable, it might
Dropdown list filter issue
Hi All, I feel I should be able to solve this but I'm getting nowhere :( I have dropdown lists of available resources. These resource tables use a lookup for the location of each resource. I want to only show resources available at the user's location in the master form. The master form also uses a lookup for the user's location. When it comes to specifying the filter to only show the user resources available at their location, I just can't make this work. (If I could convert the lookup location
Custom "Record Summary" changes Record Limit to default 10 in List view without consent
Hello, If using a custom Summary View, using the "View Record" function in a List view will change the Record Limit to 10 when you return from it. Steps to reproduce this are: 1) Create a new Form and View and create a record 2) Set the View's "Records per page" setting to anything but "10" 3) Create a new Record Summary under View Settings -> Record Summary 4) Populate the new Record Summary with anything or nothing 5) Right click on a record in your View and use the View Record function 6) Use
Iphone App for lower resolution Images?
Hello, I am developing a Zoho Creator database and I have an image field which I have been using to upload print screens from Iphone. But now I would like to start taking pictures directly from my Iphone then upload from my camera roll into zoho but I get the error "File image.jpg is too large to upload". I understand these images can be big and I know about the 5MB limitation. Does anyone know of a nice and easy Iphone app that will take low res pictures so that I can upload from my iphone camera
Syntax Errors?
I can't seem to see the errors in this one. Here are my goals: If ${Accounts.Prelim Financed Amount} <= 20000, then 395 If ${Accounts.Prelim Financed Amount} <= 50000, then 595 If ${Accounts.Prelim Financed Amount} <= 100000, then 795 If ${Accounts.Prelim Financed Amount} > 100000, then 995 This is the nested forumla I have, but it keeps coming up with syntax errors... IF((${Accounts.Prelim Financed Amount}<=20000),’395’,(IF((${Accounts.Prelim Financed Amount}<=50000),’595’,(IF((${Accounts.Prelim
New Bugs: Developer Zone
I have noticed the following irregularities: Please note, the developer account is an OLD account (old price list). 1) When app is republished to a client with an old price list account: All seems to work as it should...HOWEVER, when using the "Copy Data" function in the Developer Zone (client side) from the earlier version to the just installed updated version, all looks fine on screen, but in fact NO DATA was copied. 2) When app is republished to a client with a new price list account: After installing
Problems with sharing applications
Greetings! I just moved us from a free subscription to Express Standard. I still cannot enable sharing for all users under our domain. I select the option, click Share it says it's enabled it then nothing. Our account in enabled for your tech support folks to access it. It's for the Policy Database...we want it enabled for all users under our domain. Help...thanks! Joshua
full database backup
hi how can i make full backup of all databases of my app? in admin console there is backup only of application
Next Page