How can I change the formatting of controls in creator?
Hi Zoho User/Developers, I want to show 2 radio option in a zoho form. I just want to make them visually different. Like first option need to have blue color and second as red. And need to increase their size also as on ipad i want to cover the whole area. This will help our user in long run to provide input by just looking at color rather reading text. Please let me know how can I do this. Thanks
Unable to updates a notes field in a function
Why can't I update an 'Add Notes' field on a form object? Every time I find what looks like a workaround for a Creator limitation you prevent me. In form scripts for Add -> Load, Edit -> Load, field -> On User Input etc, I can change input.notes value. Letting me do this in functions allows for bulk updates when it's value has to be re-calculated. I am trying to get around limitations that I have outlined here in details to present a quick list users can choose from to access related form objects
Is there a record upload limit for creating and app or form?
A few times I've uploaded a larger file (maybe 3,000 rows, 10 columns in excel) and the import process for zoho creator just hangs with a blank webpage. Is there a file limit of some sort or any idea why this would happen? Thanks, Brady
Lookup pulls string, not ID
Seems like a lot of questions along this vein go the other way -- people want to pull a string not the ID. I actually have the opposite problem: I have lookup fields in forms that date back to 2013 that pull strings, when what I need is IDs. Here's the Form definition text in question: must have School_Group ( displayname = "School/Group" type = picklist values = Schools.Name_of_School displayformat = [ Name_of_School + "
Free form script field intellisense
The list of fields displayed when editing in free-form script mode is from the wrong Form. In the screenshot it is showing fields from Contact which is not the selected Form.
Form Names
The standard for form naming appears to be 'Add XXXXXX' The issue is this title is also displayed when editing records which is confusing. This could be solved by letting us rename the display name of items in Sections. I can call the form 'Contact' and in Sections set its display name as 'Add Contact'
delete subform records when main form deleted
Hi - I have a subform with a lookup field back to the ID of the main form. If I delete the main form, shouldn't it delete the subform records? Or do I have to script this somehow? Right now, when I delete the main form, the subform's lookup field is cleared, but the record remains. Thanks for any assistance...
Сode re usage in form
I have a big block of code using in a form and I would like to reuse it in different places "On user input". It looks like Function; however, I also need to use not only operators llike input.name = something, but hide/show fields. How can I organize this? for example: can I transfer Form as an object to Custom Function? or some other way to avoid the repetition the same piece of code?
ifnull does not always work?
Hi Zoho, I have the following script on my html page: date01 = null; <%=ifnull(date01.toString(),("N/A"))%><br> <%=ifnull(CRT_Entry.Renewal_Date.toString(),("N/A"))%> CRT_Entry.Renewal_Date is off course a date field, just like date01. what I get from the following script is: N/A null Why ? Thanks Ravid
how do i only get date in datetime field
how do I only get the date in date-time field? thank Regards,
Is it possible to delet or update field based on expire time /date ?
Hello all I know how to update or delete field on success submit but can do that by condition, For example, when patient didn't show up his visit will change from Pending to No Show next day automatically. Thanks Fahad
Update Record
I have the report "Lista de insumos" dependent on "Materiales Report". I need to update automatically when I update the records in "Lista de insumos" also in "Materiales Report". Any ideas?
How to check whether there is a new record
Hi, I have been tried the following code to let me know there are new record: x = test [Added_Time.toDate() == zoho.currentdate ]; if (x.count()>0) { return true; } else { return false; } but i got error message "Error at null" How the script is supposed to be? Thanks, Regards
Dashboard Assistance
I've created a simple Dashboard and need to do a count on total employees but I am not sure where I would put the script. I've done it in the past and somehow forgot would someone know how to insert the count script? any info would be appreciated thanks!
containsignoreCase, can it be used to fetch records
please can this be clarified for me? it looks you can't use containsignoreCase function to fetch records Records=Form[Field.contains("text"); ----> this is ok Records=Form[Field.containsignoreCase("text")]; ------> Error (Not able to find 'containsignorecase' function) Records=Form[contains(Field, "text"); ----> this is ok Records=Form[containsignoreCase(Field, "text")]; ------> Error (Not able to find 'containsignorecase' function) any alternative? I am looking for speed here as there are lots of
website builder does not permit text editing
Just started a few days ago; put cursor in middle of a text block of existing text and there is no editing capability. Cursor just sits there. The editing menu appears (font, size, etc) but your cursor cannot manipulate, change, add text. Replicated the same scenario in Edge and Chrome. Windows 10; state of the art laptop, less than 2 weeks old. Was able to create and modify text a few days ago. Now, the entire website builder editing is down regardless of what page or text block I choose.
URL is being removed from links in a notes field.
Hello. I have a notes field that I am using to display links so that the person who is updating a record can download the files from the image fields like in the screenshot below. I am having trouble making links to files that added using a URL instead of uploaded. I have the following code to create a link from the field's value: if ((input.Image_2 != null) && (input.Image_2 != "")) { if (Image_2.contains("http") && !(input.Image_2.contains("zohocreator.com") || input.Image_2.contains("zoho.com"))){
CUSTOMER PORTAL
Hi, How to add users to customer portal ? Is it only able to do by application settings or any other way? In library management application,day-by-day the customers(users) will be increased.If the person who handle this app may be an end user and cannot have the permission to access the application settings,then how can he enable customer portal to his customer(users)
How do I only get the date in date-time field
Hi, How do I only get the date in date-time field? Thanks,
Resignation Date to automatically make an employee inactive
I am trying to figure out a way to create an action that if a resignation date is selected to automatically make an employee inactive
Update child form with stateless form?
Hi there I have a parent form "Booking" which contains a "Date Booking Made" field. I have a child form "Booking Detail" which contains a "Booking Date" field - this field was added today. I need to find a way to update this "Booking Date" field to match the "Date Booking Made" field on the parent. If it helps, the "Date Booking Made" is the same as the date for the timestamp of adding the record. The "Date Booked" field is also that same date. I've tried this but it didn't work. for each line
Custom functions with events and distances between UK postcodes
We require two custom functions to be written. 1) We require a function that will be actioned via a custom button. When clicked, a new window should pop up showing dates and times. These dates and times are supposed to be the dates and times a sales person can attend a meeting with a prospect, based on logistical availability. All sales people should have 4 customer meetings each day, usual meeting times are 10am, 12pm, 2pm and 4pm but these times can vary depending on customer availability. We need
How can i stop the loading of a form in On Load?
Hi, I have a statement in a form's OnLoad event and if the condition is met I want to give an alert message and just exit the form. I don't want to load the form further. e.g. of statement I am using if ( value1 = wrongValue ) { alert(("You are not allowed to access this report. Thanks")); // Here I want a statement so that form can't be loaded and no fields are shown. I don't want to hide // any controls. } Looking forward to it. Thanks Manpreet
How to compare subform rows to old on "On Edit -> On Validate"?
Hi Zoho! I have a form with a subform, and on my On Edit -> On Validate I'd like to compare the data entered there to the data before the edit. How can I achieve this? Thanks! Ravid
how to Paged query using REST api view records?
how to Paged query REST api view records? here is best wishes from zhangqiang I was using REST api view records. for example ，there are tens of thousands records in a view。 I was using REST api view records to get records and It will return all records(tens of thousands records) by default . IT took 30 seconds and had 12.33Mb. IT is too big. My requirement is that only call back 50 records from 1 to 50 ,and when i pass the next page parameter, it call 50 records again from 51 to 100.
Record Summary to show filtered records?
Hi there Is it possible to have a record summary display filtered records? I have Parent form of Course Instance - this holds Date, Trainer, Classroom. I have a Subform of Details - this holds Student Name, Booking Status. I only want the record summary to show "Details" rows where the Booking Status is equal to Confirmed or Deposited Paid (therefore it would exclude Booking Status of Cancelled or Transferred). Is this possible? Cheers Aaron
Sharing
Hi, I am having real trouble sharing. I have created an application. I have gone into set up and activated the user and given them permissions. I have then shared the application with the user. The user gets the email, but when I login as the user it says I am logged in, but says "You are not allowed to access this application. You are not allowed to access this application." What am I doing wrong? I am signed up for the free account, and as far as I can see if gives me the ability to share with
input function vs lookup field
Hello, I have three forms (marked bold): Customer New task has a lookup field based on field from Customer. Then i have custom action which (among other things) creates record in Report: void VytvoritProtokol(date Do, date Od, string Uloha, string Technik, string Z_kazn_k, int recid) { rec = New_task [ID == input.recid]; rec.Protokol = true; insert into Report [ Added_User = zoho.loginuser Koniec_z_sahu = input.Do Kr_tky_popis_probl_mu = input.Uloha
Lookup field vs insert function
Hello, I have two forms.. in 1st i have an useful custom button which uses insert function and inserts data to another one. something like this: insert into Form2 [ Name_in_form2 = input.Name_in_form1 ... But when i put lookup field instead of regular text field it will not work anymore. Is there any simple solution for this ? Thanks very much
Record Summary Print Error on Chrome
Hi, I think there is a problem with custom record summary with google chrome print mode. I created a report summary for invoice. When I selected print record summary directly, chrome print page printed half of the page (image1) if I download pdf, there is no problem (image2) I opened page with safari on mac, also there is no problem In addition, 2 weeks ago I created different record summary and It has no problem like this. (WTF :) I deleted report, I create 10+ different record summary, different
I like to integrate mercadolibre to Zoho creator
I like to integrate mercadolibre to Zoho creator. I am not aware of API and I want to know if it would be very complex and if there is a precedent that this is possible. Mercadolibre is the equivalent of ebay here in Mexico. I would like to have Records that will synchronize me with the publications to modify prices and some other things, thanks! Thank you
Accessing all company apps from one html page
Does any one know if it is possible or how I can make an HTML page with tabs and subtabs or menus that can be linked to all the company apps that I have created in Zoho Creator? To create a page, well I noticed that it should be done from within an application, so I created a Parent App , called "Company Systems", created only one single HTML page that has one tab, I am hoping that I can create more tabs and sub menu in this single page that can be linked to other applications, forms and reports.
Get a record with a specific date range.
Hi, I want to get records of a specific month and year by adding the date to a date field and I can not do to work. I have tried several ways and I do not get it to work, it does not filter me the data. .This is my code; str=input.Mes; /// Is a date field/// mes_1=str.getMonth(); mes_2=str.getYear(); mes_12=mes_2.toString(); mes_3=mes_1.toString(); Moneda_prueba = Gastos.sum(Monto);
Updating existing records by email
I am having several existing data entries to which I would like to allow users to email documents. Is this at all possible or can this only be achieved by logging in, locating the relevant record and upload the document? All records are defined by a unique code.
Search with Lookup Field
Can someone help me fix the error? Error: In Criteria left expression is of type BIGINT and right expression is of type STRING and the operator == is not valid Code: htmlpage Search(searchid) <%{ name = Personen[ID == input.searchid];%> <%=name.Name%> <%=name.Vorname%> <%}%> I'm still a beginner, Thanks for Help
Sending html form upon change in drop-down?
Hi Zoho and everyone :) I have an html form with a singel drop-down field. I'd it to be auto-submitted when the drop-down change. how can I do this? Adding onchange="this.form.submit()" to the field did not word off course... will appreciate any suggestions on this one Thanks! Ravid
What is the best map location addon for creator?
I have multiple addresses in my customized app and I would like to see them on maps... I was told I will need to use a third party APIs and integrate it into Zoho Creator... Which is the best and where do i find it?
Href Link to the same html page ("refresh") does not work!
Hi Zoho, On my html page I need to create a "refresh" button. when using <a href="#Page:Page_Name">Refresh</a> - it does not work (page does not reload). same link is working fine when directing to other pages. this is happening in all of the html pages. Please fix this ASAP, I need this function... thanks Thanks Ravid (P.S., I'm using the reload button since the OpenURL does not work when adding entries to a Zoho-form using a POST html form, s either fix will be appreciated :) )
How can I open the QR scanner automatically?
How to opening the QR scanner automatically after doing a QR scan?(do it succedively)
Multiselect Lookup to single/multi line text. Problem with BIGINTLIST
Hi, I am trying to put data from my Multiselect Lookup field into Single or Multi line text field for further use in other Forms. The Multiselect Lookup field is called Positions_names (One person can hold several positions in the organization) and the text field is Positions. So far I have a solution which only does half of the job. Pos = List(); for each r in input.Positions_names { Pos.add(r); } input.Positions = Pos.toString(); The output is ID number 3232752000000042103 instead of text.
Next Page