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
Custom buttons on Record forms (not Stateless)
Please allow us to add unlimited buttons to record based forms and connect On Click script code. I want a 'Button' field type to be added to the palette of control types like Single Line. This would solve some major UX issues for me creating a usable app for users. Properties of this button should include: Standard options including * Field Name * Field Deluge Name * Configure field actions -> On Click handler New options: * Trigger Validation - Yes/No As a very experienced CRM consultant/implementer
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?
"Failed to add data" error message in multiple apps
Hi I have just logged this issue with Zoho support (with access to an app enabled), but getting "Failed to add data" error message in multiple apps when trying to add data in a form submit. The apps have worked for several years and nothing has been recently changed. I deleted some old data to make sure records limits are not being exceeded, and the setup usage limits are all ok. Anyone else getting this issue or any ideas? Apps are not usable, so hoping to get this issue resolved asap
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,
How to translate the view?
Hello Is there a way to translate the expressions such as search or filter in the view mode? Thanks, Vera
Display subform items in another subform?
Hi there, I was wondering if it's possible to display the data of a subform in another subform from a different form? If so, can someone help me and tell me how? (If it's not possible, is there a way to get the data of a subform in simple fields?) I would really appreciate your help, 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
How can i send notifications?
Hello Everyone, I have a form that the employees have to complete it, it's like a report for every day, and the respective people have to complete it every day with his information, so i want to notify to my boss, if someone dont do it, in an specify day, and Notify my boss every week of how many reports are complete and how many are incomplete, so, how can i do it?
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
Is there any way to get access to the Statement Execution count as a system variable in code?
Is there any way to get access to the Statement Execution count as a system variable in code? I am running code and receive error message about exceeding the limit "The number of deluge statement execution limit exceeded the maximum limit" I have read the help file and forum posts on this. I would like to modify my script to avoid these errors and would like to be able to measure the effects of changes. Is this value available in Deluge code so I can write it to an info statement at various points
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
Why the fields in the pivot chart change?
Hello Everyone. My question is: Why in the pivot chart, the fields change it's name? in the translation, and in the form, and in the report the name of the fields are good, but when i created the pivot chart the fields appear like: "Number" , "Number3" or, the name that i have for the date is "Fecha" but in the pivot chart appear with the name of the last field that i created in the form... I saw the translation and everything possible to correct this and i can't find something, help me please, IT'S
Why i am getting this error?
Improper Statements/Expressions found com.adventnet.cache.exception.CacheException: java.lang.IllegalStateException: Cannot register synchronization when the Txn status is STATUS_MARKED_ROLLBACK Possible JavaScript / XSS Vulnerability in statement "null" at line 4599 Can anyone help me on this.
Help Using Schedule To Update Records
I'm using Zoho Creator to report on data from a different software application. I have 2 forms that were created by importing records from CSV files. The first is Player_Invoices and the second is Player_Payments. Each table has a field named Bill_ID (which is a string). I've created a subform on Player_Invoices that I want to display the Player_Payments. I would like the subform to display all the payments that match the unique Bill_ID field for the invoice. I assume that in order to do that
Default Reports to All Application Users NOT All Users
I think this would be a change that would be beneficial to everyone. If you have a customer portal, you don't want to default access all reports to all Users. I have to have people check our portal daily to make sure odd reports aren't displaying. Please consider not Defaulting to All Users.
Problems With Exporting
Not sure why, but 2 of my 35 fields (Columns) are not exporting? Can anyone help?
Complex report criteria
I have a report based on a form, with some criteria to create which are quite complicated. Basically the criteria for the report need to be: select * from FORM_A where value of FORM_A.FIELD1 in (array/collection of values of FORM_B.FIELD2 from FORM_B [FIELD4 >= '1974-01-01']) Which means, for each record in the FORM_A, if the value of FORM_A.FIELD1 is contained in the collection of values from the selected records from FORM_B.FIELD2, then display the FORM_A record in the report. Is this
how can a field auto-complete before someone enter in a form?
Hello everyone, this is simple, How can i do, For a field to be filled or autocomplete when someone enters into the form?
Permalink for Record Summary View
Hello, Is there any way to create a permalink or otherwise link directly to a record summary view for a particular customer? I can filter the base report down to a single record using '#View:Customer_Data_Report?Customer_Name=Customername' in the url, but there doesn't seem to be a way to access the summary view directly. Thanks for your advice, Elizabeth
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
Use form to search criteria in a single database
Hi there - I have a large database that I would like to be able to pull information out of easily. I don't need to add records, I just need to look up information. Seems simple enough. I have only 4 columns: 1. Main 2. Section 3. SubSection 4. Description I'd like to be able to perform a search using one of the criteria, or narrow it and use two or three. Everything I have looked up seems far too complicated. I just am looking to search a database already formatted. I want to be able to type in some
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
Conditional sumif in pivot chart
Hello, I would like to make a conditional formula in pivot chart but I have not been able to understand how the structure works. Try to achieve something like: Sum("Autoview_1483575409618_Ingresos_Egresos Table"."Gastos" if "Autoview_1483575409618_Ingresos_Egresos Table"."Tipo de ingreso" == "compras ebay") I want to add the monthly expenses only if the type of expense is "ebay purchases". I can not do it from filters because in addition to this graphic I want to add another one that is: Sum("Autoview_1483575409618_Ingresos_Egresos
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
Next Page