Subform dynamic lookup filter lost after creating a relationship with Main form
Please can you help explain how I can filter the choices on a subform lookup field based on an entry in a field on the main form and at the same time keep the subform row choices in the Main form report so I can analyse them and calculate a total. I am very new to this! I am creating an invoicing application. I have created an Invoice form. I have worked out how to select a customer from a customer database. Each customer has an insurer, but the amount I can bill the customer for different tests
Calculating number of days between two dates
Can this be done, perhaps as a custom function? If I subtract date2 from date1 I get a (large) integer, which suggests that dates are just integers under the hood. So there would be a way to do element date match. A good example might be to calculate accounts receivable aging...a fairly common sort of thing. Before I try to hack my way through this, is there a straightforward method or has someone written code they would be willing to share? Thanks!
Reference field Lookup not having the value 20. Adding records from one app to another Error
I am trying to insert records from one application's form to another, but there is one problem. The lookup field DocNumber which links the designated form in second app gives an error during the Insert into process. I tried making the field both Autonumber and typing the value manually. Here is the code I have: Initial application and form name: app1, Form_request Target application and form name : app4, Form_Expenses Function in app4: void form_expenses.createRecord(int var1, int var2, string var3,
Subform lookup field not populated when offline
Lookup fields on the parent form work when offline, but any lookup fields that are in a subform always show the "no internet connection" screen when offline - even if you previously load the list (and theoretically cache it). I even tried downloading the list of values hoping it would use that - but I just can't get it to show lookup values in the subform when offline. Anybody encounter this? I really don't want to have to hardcode the options in a dropdown as the list is fairly dynamic.
Check if subform has records.
Hi! :) I have a mainform and a subform. I want to disallow that a record at the maiform can be deleted if there are records at the subform. Please advise
input null to a functions - get an error
Hi Zoho, I have a function, with few variables including a date variable. I have a script in the function for cases the date variable is null. On some cases when I use the function - I have no date variable - meaning it's null. When I write Date01=null; thisapp.function(var01,var02,Date01); I get an error: Mismatch data type for function 'CreateSolveDeleteFnA' at argument index 15 expected data type TIMESTAMP found data type NULLTYPE How can I enter a null variable ? Ravid
How to build report using check box data?
Zoho Creator says that a known limitation is that reports can't be built from data recorded through multi-select or check boxes. Surely there MUST be a way to do this! It's true that these fields don't show up in the drag and drop menu for me to build a pivot chart from but has anyone found a way to do this? It's pretty essential for my application. Thanks, Lindsay
Adding a rule to style
Hi Zoho, I have some parts of page that I'd like to show only to one user. Instead of using "if" every time on the page, I'd like to create a style. I've created this function: string styles.EditPossible( String UserName) { if (UserName = "CorrectUser") { EditPossStyle="<style>.EditPossStyle{display:inline;}</style>"; } else { EditPossStyle="<style>.EditPossStyle{display:none;}</style>"; } return EditPossStyle; } And i call it one the html page using <%=thisapp.styles.EditPossible(zoho.loginuser)%>
Senmail with Toaddress
Hello Zoho Team, The code below was working months ago, now its not working, can you help me in order to identify where is the error? Thanks a Lot. void busqueda.busquedahr(Armar_Publicacion myRecordID) { for each record in myRecordID { for each email in record.Toaddress { sendmail ( To : email From : zoho.adminuserid Subject : "Busqueda Consultor - Posicion : " + record.Skill
Custom action to edit record in edit mode..
Hi I'm trying to use a custom action use a function to open a form at a specific record...e.g. http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> Here is the command I've using.. I know the form name is right and the reportLinkName is right (as far as I can tell..) - the form shows up but there is no data in it.. when I mouse over an existing record I can see the ID - which I've copied and pasted... any ideas what I'm doing wrong?
Filter subform items based on parent form
I have a purchase order form with a subform for adding items to the purchase order. I only want parts that belong to the vendor selected in the parent form to be available in the subform lookup field. Each part in the subform is related to the vendor selected in the parent form. How can I apply a filter to the lookup field in the subform based on the vendor selected in the parent form? I'm trying to use the Set filter in the field properties section but maybe this needs to be done with deluge.
what happens to data entered into form if user loses connectivity?
Im designing an app for data entry and was curious what happens if connection is lost (or user goes into airplane mode). For mobile users, I'd expect that the reports will be unavailable, but will the form be unable to be accessed? For PC use... Is there a way to have it store records locally until connectivity is restored, then automatically push them back up to the cloud once connection returns? My users travel a lot and I think being able to enter data while in flight would be valuable.
Decision Field width in subform.
Hi Everyone, I'm new here, but am getting my feet wet with a fairly complicated app. I'm just wondering, why can't I resize a decision field in a subform? I have a lot of columns in my subform, and three decision boxes. They are killing my column real estate. I expected this answer to already have been asked, but I have been right over the forum and can't find anything similar. Thanks, LJ
Fetch Record
Hi! I have a Form Orders_form and an Exchange form. I need the customers information to populate (ie. Name, Address, Item Purchased) when I provide the Exchange form the Orders_form Order No. I have the relationship setup...i was reading in the resources and found the code i needed but it doesn't work. What am I doing wrong? I have this setup on the On User Input of the lookup field Orders. if (Orders_form[Order_No == input.Orders].count() > 0) { x = Orders_form [Order_No == input.Orders];
Lookup Criteria Problem
Hi, I don't know why some time lookup field which was set with criteria doesn't show the correct thing. Application "Penta CRM 10" Forum "TATA Send Quotation " Lookup "Select Ticket No" - Link with "To DO Form" Criteria - "Call_Status.contains("scheduled") && Customer_Name_Lookup.contains("tata")" Our one of the ticket no 21396 doesn't show up !! Thanks
"delete previous entries"
Hi Zoho, How can I run a command to delete all but the most recent entry? until now I used the following, but I'm looking for a more efficient way OldRecs = (Form[(rule)].ID sort by Added_Time desc).getall(); OldRecs.remove(0); for each deleteme in OldRecs { delete from Flags_n_Alerts[ ID == deleteme ]; } Ravid
Redirect to different urls after submission of web form
Hi there - we have an embedded form that has a radio option of 3 choices: -pay online after submission -payment already on file -mail payment I can setup the single URL redirect of a successful submission easy enough for all, but I would like to know if someone can show me a way to script that so each of those 3 choices opens a different page, so 'pay online after submission' when selected and submitted will open the payment gateway url, and the other 2 options will redirect to a static html page
Share form script code
Can you please allow us to create common/shared script functions for forms. Right now I need to repeat code across: * Add -> On Load * Edit -> On Load * Field -> On User Input The scenario is a Drop Down field called 'Type' that controls hide/show of other fields on the form. Having to repeat the script across multiple places is a maintenance pain. A custom function will not work as you can do no UI operations.
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
Next Page