Update multiple records at one in Deluge
Is there anyway to get Deluge to update multiple records at once. A record in Table A has multiple records in Table B. Some data from Table A is replicated to Table B to speed performance. When Table A changes, I need to update all the records in Table B. This does not work Fetched_Records = Table_B[Key = TableA.key]; Fetched_Records.Field_to_Update = TableA.New_Field_Value;Other than iterating every record with a "for each matching_records in TableB" is
Creating login for member
How can i create a login area for members and able to send them login id and password? thinckchina
Mailchimp Webhook
Hello Guys, I want to receive the mailchimp webhook call at a public zoho creator html page but the parameters that the webhook sends to zoho are in array format like that: data[email] data[web_id] data[merges][LNAME] data[ip_opt] I think that zoho creator pages only receives single variable parameters like (x , y, a, b). So, how can I make that happen?
Creating a formula from excel land rounding it to a percentage
=ROUND(IF(H6>=4.999%,F6*0.04,IF(H6>=4%,F6*0.035,IF(H6>=3%,F6*0.03,IF(H6<=3%,F6*H6)))),2) Trying to create a formula to calculate the employer retirement match for an employee based on the above formula. Above is the Excel format. I want to round to .01,.02,.03,.035, or .04 The "H6" would be Employee_Deferral_Percentage. The "F6" would be the Employee_Salary.
Archiving Records
Hi I have a preschool app that includes a Child Registration Form and Attendance Register. The Register includes a look up field of the children's names to be selected from. I want to hide the names of the children who have left the service from this look up field (whilst keeping the original records). I added a radio button with 2016/17 and 2017/18 options so it is possible to filter the records but this doesn't hide the names in the look up field. How can I only include current pupils in the look
Fetch records from a sub form and fill dropdown field
I have a Product form with Product and Price for various sizes. Please see the attachment pic1.png. I have a estimate form to select the Product. Once I choose the product, it should show available sizes in the dropdown. When size is selected, it should calculate the cost of the product. Please see the attachment pic2.png. 1. How do I fill the dropdown the sizes based on the product selected? 2. How do I get the price when the size selected?
I can't create my first app
Hello, I'm trying to create my first application in Zoho Creator, but I get the next error: Someone can help me please? Thanks
populate field automatically based on certain criteria
Hi There, I'm trying to populate a multi line field based on certain criteria matches from another form. I have Form A which has a selection list of skills (via a dropdown). On Form B (which is a capture new employee form), I have the same skills dropdown selection available. Once Form B is completed, i want the user to go to Form A and select a skill via the dropdown. Once the Selection has been made, i want a multiline field to populate only with Employee names that have the required skill. Could
Standard Deviation in a subform
Hi, I have a subform (named Samples) in order to add multiple rows with Total_Weight and Number_of_Samples. I would like to calculate the Standard Deviation of the samples and display it in the form (the parent one) I worked an script that use On user Input of Total_Weight and Number_of_Samples. Nevertheless it requires a huge amount of iterations, then I would like to do the calculation just one time (when the people fills all the rows or something like that) Do you know what is the more efficient
zoho creator and zoho forms difference
hi! can you explain what is difference between zoho creator and zoho forms. many years use zoho creator as internal database. for what purposes usually people use zoho forms? and what business and technical tasks zoho forms solve?
SelectAll or DeselectAll from a function
For a multi-select lookup field is there a method to SelectAll or DeselectAll from a function? These statements are available in the code sections of the form. For example I have a lookup field that shows all available skills. On the form I can use Skills_List_lookup.selectall() to check all of the boxes. But this statement is not allowed in a function.
Joining multiple forms
I have just started using Zoho Creator. I have a very long application form that I have split into multiple forms. How do I connect these forms so that they behave as a single form?
Syntax Error with Multiple IF and Else if statements
I'm pretty new at this, and I can't figure out why I keep getting the "improper statement" error. I've taken out the specific field names and text, but i've left the structure completely in tact. Any ideas? (the error starts at the beginning of the "If" statement and is an improper statement error. Status1 = "<TEXT1>"; Status2 = "<TEXT2>"; Status3 = "<TEXT3>"; Status4 = "<TEXT4>"; Status5 = "<TEXT5>"; if ( Field 1 != null || Field 2 != null || Field 3 != null ) { Bid_Status == Status4
How can I georeference forms automatically?
Hi guys, I want georeference automatically the forms and then put this field in Record Summary? if possible create this? Regards, Manuel
On Load set variable of User lookup field
Hi - I have a task form that includes a "Users" look-up field set to display the all user's Email Id. I'd like to set this variable to the logged in user but still allow the option to select another user manually if need be. Under workflow I have added the following code under On Load: input.User = zoho.loginuserid; However, it is not selecting the logged in user or anything else....any ideas? Is it perhaps because email addresses are being used instead of username? Thanks.
OpenURL in a function not maintaining navigation framing
We have a record review form opening in a popup for a user to complete a task allocation, which is defined in a custom workflow form. On submit it redirects from the popup to the edit form for the associated record, but in doing so "removes" all of the navigation and tab header controls in the process, presumably due to the "New Window" parameter in the openURL statement in the function, causing just the report URL to load at the top of the Window DOM in edit mode. There is no longer any zoho creator
Calculating Employment Duration
Hi All, I struggled to find a solution that would calculate an employment duration based on a user selected date and Publish the result to a field as follows : 2 Years 4 Months 5 Days as an example. Here is the solution i could come up with and works (I hope this helps for anyone reading this): CurrentDayEmployment = input.Employment_Start_Date.getDay(); // Gets the selected employment Days of the year I.E 01-02-2017 would produce 1 CurrentYearEmployement = input.Employment_Start_Date.getYear();
Extracting usefull data from South African ID number
I want my client to be able to input their RSA ID number (it's a bit like the American social security number) into a field, and have the information in the number used to autocomplete other fields in the same form. South African ID numbers contain info on: Date of Birth (and therefore age) as well as gender. If one of you Zoho Creator Superstars can show me how to have the Date of Birth field autocompleted after the client fills in his RSA ID number; I'm sure I can do the rest myself. The first
how to find a space or filled space
I have a column of data. Some are filled with 8 digits. Some are filled with 8 digits with spaces. How do I search for only those without a space ? Example: 22996218 or 22 996 218. I want to find all that have no spaces.
Time zone in report pdf
I am trying to export a report in .pdf format. Thought my application settings show IST time zone, the time zone shown in the report header is GMT. How can I change the time zone in the report header as well ?
Sorry, we are unable to load the form.
a message appear when loading a form : " sorry we are unable to load the form " the below form cannot load usually this form didn't have any issue with me any ideas? https://creator.zoho.com/shehabcorpservice/service-status/#Form:visit_records
How to show/hide fields in Form B based on value selected in Form A
Hi, Say I have a multi-form app. The user will start at Form A and when he/she clicks submit is redirected to Form B. I am trying to show/hide fields in Form B based on a value selected in Form A. For example, if it were a Deluge script, it would be something like this: Form B's on load: if ([variable from form A] == "true") { hide Variable1; } Is this possible? Thanks, Isaac
Zoho Creator header in printouts
Hi, I configured the print option. Whenever I print the document, it is printing with Zoho Creator - invoice creator header and the https link as footer. How to remove that. I just want the invoice I created to be printed as company invoice. Regards Janaki
I think I'm looking to create subforms
Can I create subforms with Zoho? Or perhaps there's another way to accomplish what I'm after. Basically I want to enter demographic information about clients, customers, etc. which could include multiple phone numbers, multiple email addresses, repeat purchases, etc. all on one form. Is that an option or do I have to switch from form to form and link them all? Form 1 - Name, address, date of first contact Form 2 - Email addresses Form 3 - Phone numbers
Calendar from date field is not displayed completely on phone screen
Hi Everyone, I made the Visitor Sign-In form as described in the "Creating an Application" video from the Zoholics videos and ran the form on my Samsung Galaxy S7. The form displays correctly but if I tap the date field, only half of the calendar is displayed on the phone screen. What do I need to do to centre it on the phone screen? Thanks. Truly, Emad
not abe to activate print option in creator
Hi, I followed the instruction as shown in the zoho help to execute the print option. However when i go to the live mode, I not able to view the same. This is a very important step in my app. Please help. Below the steps I followed I opened the page - > settings -> Header Option -> Clicked on PDF option - > Done button - > Save Script - > Live Mode - page downloads but not the print button. How to address this.
Dynamic url in pages
Hi, Good day to you! Based on the loginuserid, I want to open the dashboard page I have tried the below code which is not working. <% if(zoho.loginuserid == "vedavalli@itkeduserv.com"){ var="https://app.zohocreator.com/itkes/masaa#Manager_Dashboard"; } else{ var="https://app.zohocreator.com/itkes/masaa#Telecaller_Dashboard"; } %> <a href="%{var}">Click here to go to the dashboard</a> this var receiving value but it is not getting assigned in href.. Is the format right? Thanks ITKES
Trying add records via API and a PHP cURL function...getting permission denied error
Trying to add records via the API and PHP cURL, getting this error - {"errorlist":{"error":[{"message":"Permission Denied To Add Record(s).","code":2899}]}}. Please advise Here is my example code: Here is an html page with a form - <html> <head> <meta http-equiv="Content-Type" content="application/json"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content="">
last 30 days search
When filtering for "last 30 days" or "last 7 days" anything with today's date is not included. Is there a way to create a filter that essentially says "today or last xx days"
Changing Messages from ZOHO
How can I modify the "Data Updated Successfully" and "Please Wait". I have a slow DSL connection, and when I change the information in the database, the messages cover a large amount of the data and I am forced to wait until they disappear before continuing. I know I must wait until the change is actually made, but if I could see the data while it is being changed, I can be planning what to do next. I looked on the Internet with this question and your site says to open DASHBOARD and then FORM PROPERTIES.
How to add print button in creator
Hi, I am new to the creator. I am working on a form to print a copy of the same when I use the Print Button and also create a copy of the form in my system in some assigned storage place. I changed the name of Submit button to Print. Now when I am trying to add a rule or edit this button to perform print action, I am not finding any options here. Please help.
Deluge script for maximum(added_time) functionality changed (timezone??)
Hello, In my form I have a script which until yesterday worked fine. But now it returns wrong data. It reads last record by added time. It returns time 9 hours back, it is really strange, because the seconds and minutes are OK, just the hours are 9 hours back, as if the code would work in different timezone? In below case, - l_last_day variable returns the wrong time. Please help!!! Code: l_akt = Visits[ID != 0 && Added_User = zoho.loginuser] sort by Added_Time desc; if(l_akt.maximum(Added_Time)
Problem trying to download using curl
Hello. I am trying to download a report result in CSV format using Zoho Creator's API using curl, but I keep getting "curl: (35) Unknown SSL protocol error in connection to creator.zoho.com:443" errors. The URL begins with "https://creator.zoho.com/api/csv/..." and works flawlessly if I try it from a browser. I have even tried adding " --cipher rsa_rc4_128_sha" as proposed here, with no success either. I am behind a Windows proxy. Could you please tell me the right way to do this? Thanks in advance.
How do i export my Zoho calendar to my Google calendar
How do i export my Zoho calendar to my Google calendar? I found sync but that only brings in my google calendar to zoho. I need it to go the other way.
Field for hours and minutes
Hi. How to best create a field for Hours and Minutes? I want to have a field where I can input how many hours and minutes was used, then create a report that summarize the total time spent. Format for the field should be HH:MM Best would also be if I could write it in format HHMM and then the app auto insert the : between. Any one that can help?
How to Upload to Application from PHP
Hi everyone, i have been using Zoho Creator for a while now and it has been amazing, however i tried uploading to my application using Guzzle PHP library but i always get an error. Please any help would be very much appreciated. $zoho_url = "https://creator.zoho.eu/api/xml/fileupload/scope=creatorapi&authtoken=********************"; $client = new \GuzzleHttp\Client(['verify' => false ]); $client->request('POST', $zoho_url, array('Content-Type'=>'multipart/form-data'), array(), array(), [ 'form_params'
How can I add all records from a previous form into a multi-select field on a new form?
I'm building a simple app to manage a tutoring company (eventually all but payroll). I have Form A, where the user can add a new Content Area (such as Mathematics, Natural Sciences, etc.). I also have Form B, where the user can add a new Tutor. There is a "Qualifications" section on Form B where I want to have a Multi-Select (or a Checkbox) field where the user may select multiple Content Areas that the tutor is qualified to tutor. For this reason, I need all records from Form A to populate the choices
Can I not add multiple formula fields to another block
Hi, I have used formula field and calculated a percentage. I have used the output of this field to calculate one more percentage. Now I want to add all these into another field - obviously a formula field. However, in the refer fields block these fields are not visible. Ex: formula field 1 = ((9/100)*CTC) Formula field 2 = ((5/100)*formula field1) Formula field 3 = sum of (formula field 1 + formula field 2) - however I am not able to view these options under refer field in the formula field pop
Master Zoho Creator @ Zoholics Developers '17
This August, Zoho is hosting its annual app development conference, Zoholics Developers. This event is a three-day workshop designed specifically for anyone who wants to learn about, build, and improve their skills with Zoho Creator. We'll lead interactive workshop sessions where you can refine your skills, one-on-one sessions where you can chat with an expert, and showcase Creator's new features. You should come if: you want to learn more about building custom applications with Zoho Creator. Whether
Bringing ZOHO Creator Apps to a Single "Dashboard"
Hello, New to the ZOHO community and appreciate any help. What I am trying to figure out is if it is possible to bring the individual apps that I create in Creator into a single interface in ZOHO? I hesitate to call it a dashboard because that term carries with it the connotation of KPI's. I'm not referring to KPI's here. So far, I have created a CONTACTS, TASKS and NOTES app in Creator. What I want to do is to embed those apps into a page where I can quickly go to those apps. It would even be nice
Next Page