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
Need Formula field in Subform
Hello, On a sales form I have a subform to track multiple services. In the subform I have the following fields: quantity, description, price, labor and now I need a Sub-Total field but I can't add a formula field to the subform. I was going to add a Formula field called Sub-Total to perform the following calculation in each row: quantity x (price + labor). Then I need a Grand Total to sum up all row sub totals. How can I do this? Your help is greatly appreciated. Iram
Import to Subform does not work with lookup fields
I created Import to insert records into Main form and subform. it works just fine when subform has regular text fields. However, it does not work if subform has "Lookup Filed". Here is how I defined Lookup AUDIBLE_US - Staff - Name (App name - Form name - Field name) And here is what I have on excel file (again, it works just fine with regular field and I know that I can select these values in my subform: 1st sheet: PRODUCT ID Narrator_SubForm TEST3 1,2 2nd Sheet REC LINK ID NarratorSub 1 Alexander,
Simple database issue
I have a simple database I will use to track orders for my own purposes, this has been setup on zoho. I require a solution to this problem on zoho: I have one CSV file like this: SalesRecord, ProductCode, TrackingNumber 1 . A001, 2, A002 3, A002 4, A003 I have another CSV file like this: ProductCode, TrackingNumber A001, XX345 A002, XX346 A003, XX347 I want to import file 1 and then file 2 to have database records like this: SalesRecord, ProductCode, TrackingNumber 1 . A001, XX345 2, A002, XX346
Import Bank Statement
To enable me to reconcile my bank account(s), I wish to import bank statements into my Creator accounting package. I know Zoho provide a number of accounting/invoicing etc. solutions and specifically, Books enables automatic bank feeds. Can I access this functionality from Creator?
repopulate dedleted field.
Hi, I need some help figuring out how to repopulate a deleted field. I have two forms, Assignments Form and units form. The units form holds information about the unit "Unit_number, Unit_size" Th data entry, Assignment form holds information about Task assignment" Assignment_number, Unit_number , Unit_size. I accidentally deleted the "unit_size" filed. from the assignment form and now I don't know the Bedrrom Size of the unit assigned/booked. What method could I use to repopulate this filed?
Custom Filter
I can search within a list and get the expected results, however I am unable to save as a custom filter or view, the saving pop up stays permanently on screen. Is this a bug is there a fix
Developer Acess
Hi, I don't seem to have the ability to define a developer in my application. According to the documentation I can do this through the manage user section. When I click to invite the developer it says in the documentation to click "Developer". Problem is there is no developer option. Nor is the Choose developer option under the General tab as in another account I have. I have an enterprise account so not sure why I can't do this. How can I add a developer to my application? Thanks
Help: Pay per user of application
For a new app, I am trying to come up with a payment model. A customer buys a Zoho Creator plan to access Creator. I have an app that I want a customer to pay me per user per month for access to the app. Let's say $25 per user per month. How can I implement this functionality so that a customer of my app cannot add their own users?
Date-Time Operators
For some reason Date-Time Operators is missing in the support content even though it is listed in the outline on top of the page (Type of Operators) The content simply skips them. I need to calculate minutes elapsed out of two date-time fields. I tried simply a substraction (DateTimeField2-DateTimeField1) but issues an error of inpropper estatements. Any help? Thanks Luis
Call a custom schedule to run immediately from a form?
I am looking to to be able to submit a function to run numerous calculations that result in a report. I would like this to be initiated by the user, from a 'submit' button in a form. i.e. 1. User signs on and enters client financial data 2. Once entered, the user submits the information to run the calculations - I would like this to run immediately, but without tying up the user's session. Like initiating a custom schedule, but to run immediately. Is there a way to achieve this? Thank you!
How to list entries associated to an item?
Hi, I have 2 tables: COMPANIES Company Category Ranking Notes JOBS Title Company Category Ranking Notes . In the companies form, I want to list all the jobs associated to this company and be able to click on these jobs to view/edit them To get this, I have tried to use: a Lookup field: You can see it, it is named 'Jobs'. It does list all the jobs from this company, but is not a list of jobs with the possibility to click on it to edit/view a subform: I could not manage it work, I am a newbie. Any
Employee Table and "Zoho.Login User"
Hi All, I'm trying to complete a number of tasks within my request manager tool and whilst I can find several threads that go some way to answer some questions I'm still not sure how to implement the following: The tool I am creating is to track requests for PC's to go out to a customer site or for a request to collect some PC's back to our warehouse. We will be using this across a number of different accounts and would ideally like the one tool to track all accounts. We will also have team members
Modify records from multiple forms
Hello, I have been trying to figure out how to share information across several forms. For example, I have a main form that is used to capture customer information (named Customer) and another that is used to generate an estimate (named Estimate). I am using the lookup tool on my estimate form to reference the customer form and to bring in customer information (named Customer) but I have not figured out how to get the estimate form to publish information to the customer form. This needs to allow
How to count the number of selections in multiselect picklist?
Hello! We have a form (see it live here under Step 2) where the non-prisoner public can select from our list of potential prisoner penpals and give us their email address. (If you use it, please call yourself Test, test@test.com, and only select the Test prisoner records). Currently, we have an email sent whenever a form is submitted to people who review the requested penpals, and only approve it if there are fewer than 5 penpals requested. Ideally, there could be an automatic cutoff built-in.
Repeated (Add New or Add Another) Fields
Is there any way to create a repeated field(s) or form(s)? For example, lets say that there is Text Field is entitled "ChildsName" and a date variable entitled "ChildsBday". Is there a way to have a button that simply lets the end user repeat "ChildsName" and "ChildsBday" to store the names and birthdays of multiple children? I specifically do not want to have to create ChildsName1, ChildsName2, ChildsName3, ChildsBday1, ChildsBday2, ChildsBday3 and so forth while using Hide/Show functionality.
How do I change the font used in a report?
Can I change the fonts of single lines, dates, email addresses etc. in a report?
Zoho Creator SLA?
Is there an SLA for Zoho Creator? A published uptime service level? Required for certain customers. Thanks,
Capitlizing a name...
Just thought this might come in handy for someone . You can use this function to captilize any text. It says name but it could be anything you want it to be string translate.capitalize(string name) { Uppercase_first_in_name = (input.name.toUpperCase()).subString(0,1); get_rest_of_name = (input.name).subString(1); capped_name = Uppercase_first_in_name + get_rest_of_name; return capped_name; }
map tutorial (Beginners)
Hello Zoho Creator fans, I thought I would make a post about some info, tips, ideas, I have around the the Zoho Creator "map" feature.... The map feature can be extremely poweful if you know how to use it. Unfortunately, there isn't a ton of documentation in the Wiki about it's cababilities.. First talk about what a Zoho Creator map is.... A map holds data! You put data in it by first creating a key and then adding a value. This is called a key, value pair. This key,value concept is used in well
Next Page