Using "clear" on a picklist in s subform results in invalidTaskInSubForm
According to the doc https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html I should be able to use "clear" to clear the current values in a subform picklist on the On User Input. but it does not work. list = Member_Rep_Shift [ID == Appointment_Details.Shift_Picked]; clear Appointment_Details.Time_Picked; Appointment_Details.Time_Picked:ui.append(list.Available_Hours.getall());
I have a simple formula i added on delete row in my subform. but its not updating the main form until i delete the second row
input.Tax = 0.0; input.Amount = 0.00; x = 0.0; for each row in Activity { if (!row.Bid_Work) { x = (x + row.Amount); } } y = 0.0; for each row in Activity { if (!row.Bid_Work) { y = (y + row.Tax); } } input.Tax = y; input.Material = x; row.Total = (row.Tax + row.Amount);
Lookup Fields can't be set as "Read Only"
Hi - I am working with Users & Permissions and I have set some Look Up fields as "Read Only" for selected users. Unfortunately, these settings don't seem to work correctly. While I can NOT change any other fields that is set up as "Read only", I can still modify Lookup Fields as well as file upload fields. Any solutions on this? Thanks,
Issues dynamically populating a SubForm at the OnAdd.OnLoad event
I want to know how to populate a subform at the OnAdd.OnLoad event of a form. I already know the ID of the fields I want to populate it with, as they already exist in the subform and I simply want to replicate them. I am having issues with the dynamic creation of the rows in my SubForm. For context, I am building a feature that allows the user to create multiple versions of the same record, with minor changes, and so I built a custom action that redirects the user to the onAdd of the form, with a
Stateless Forms and Pictures in Subforms
These do not seem to work on mobile version. Is it in the pipeline?
Can i create a form dynamically using zoho creator ?
Hi, I have a multi check box selection, I want to create a separate text box for each and every check box selected. Is it possible in zoho creator. Please help!
How to Add Multiple Records
How add Multiple records to form using url post . Because I need to transfer data to another form in another application .
Apostrophe in URL has stopped working
Hi I've had an application for years that loads a variable through the URL with an apostrophe using %27 ie - http://[URL]/Add_Performances?Venue=King%27s%20Theatre%20Glasgow but it has now stopped working. All non-apostrophe variables are fine. Any ideas? Robert
Link to form in emails to external users
Hi, I am developing an application which under certain circumstances will send emails to external users with a link to a form for them to enter/update data. there are 2 types of links - link to a form to allow external users to create a new record - the link will contain parameters which will prepopulate certain fields on the form. - link to a stateless form to allow external users to update a record - the link will contain parameters which will prepopulate certain fields on the form. When the submit
Commas in decimal field causes problems
I have an application for our contractors time and expenses. The expenses are entered as line items in a subform. This application adjusts the total each time the date, amount, quantity, or currency type is selected or changed. When users enter commas in the decimal field for the Amount, it causes an error that stops the script from continuing so it if there was already a total calculated, and someone changes the Amount, and adds a comma, it won't calculate the total, which is fine, but if there
Publish/transfer an app to another client's app
Can you create an app in your own account and then publish/transfer directly to a client's app? Don't see instructions on how to do it. Joe
Add New Entry link not showing in lookup field
The link does not show for users that are not administrators when the lookup form (the form that supply the records to be looked up) are in another application. Is there a workaround for that? Thanks
Add notes field does not accept <style> tags
Dear All, In an Add note field if I add the <style> tag like the image and click the Insert then if I go again to the add note to edit something then the box is empty...I tried to click all the buttons (insert-edit HTML etc.) but nothing. Why this happens? If I want to have a style for example in a Add Note field (with <style> tags) then everytime I must delete the add note field and add a new one with the new style?
Share - Make Public option is not displayed
Hi Zoho, I like to share a particular form publicly, so anyone can fill in the particular form. I am following your instruction https://www.zoho.com/creator/help/application/application-sharing.html#Make_Public_to_all_visitors_over_the_web, but I don't see the option "make public..." displayed. I can only share with individual users or groups. How do I enable the "share publicly" feature? Thank you, Ivo
Set null to all fields in the form
Hi, I am trying to write a script on user input of a specific field so when user select the null (something like -Select-- ) then the rest of the fields will automatically set null values. I can try by below code but since there are lots of field so I am looking for short way to do that so I don't have to write all fields individually. Can anybody please help me . Code : if (input.Update_TVStation = null) { input.field01 = null; input.field02 = null; input.field03= null; input.field04 =
Zoho Creator form Integrated into Custom Module
I am using the Zoho Creator to develop forms that speak to the Zoho CRM. I am able to have a form create an entry on submit for the standard modules, however it stops working when I try to apply it to a custom module. For example, in one of my forms I have the following script to run when the submit button reaches "on success": myFieldMap = map(); myFieldMap.put("Product Name", input.Product_Name); myFieldMap.put("Product Description", input.Product_Description); //function to push data to CRM response
If Statement in a Function
Unsure if this is possible or just bad code. void OffHold(int ID) if (On_Hold_Date == "null"); { alert "Sorry, You can not take Off Hold that is not On Hold"; cancel submit; } else { rec = On_Hold_Test_App [ID == input.ID]; rec.Off_Hold_Date = zoho.currentdate; rec.Due_Date = zoho.currentdate.addBusinessday(2); } I'm receiving the following error message: Error at line number : 2 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Help with Date Function
I'm working on a weekly inspection application. The function I need will reset a date field based on the current date. But rather than resetting the next inspection date by one week, I need it to reset the date to whatever next Monday is. Example: Today is Wednesday 24-SEP-14. On-submit should reset the next date to Monday 29-SEP-14, not 01-OCT-14. Cheers, John Whitney
Restrict user access to certain records in reports
I have multiple users from multiple facilities accessing the database. I don't want all users to see all records from all facilities. How can I restrict the records in a report to one or more facilities, depending on the user trying to view the report? For example, John creates records for the Middletown Facility. Debbie creates records for the Milwaukee facility. Jane creates records for the Denver facility. Sara supervises John and Debbie but not Jane. Sara shouldn't be able to view Jane's
How to fetch data and show in textbox
I am trying to create a textbox that will show work # related to employees under their time cards. Is there a way for me to retrieve work # from one form that they fill out (which they are assign to and have to clock into) and show in the time card under the employee? I like to keep track of the work # they do each day. Could someone give me example on this please. Thanks in advance.
urgent: cannot load form from view
as well, when adding a record I receive message "Unabble to load data" I made some changes to field lengths (appearance and max length) as well as deleting some unused fields. please help. what field or script is causing the error?
Set submitted ID record as default in a lookup field
Dear All, I have two forms Test1, Test2. In the submit button of the Test1 form I have an openurl which redirects to the Test2 form. Now, Test2 form has a lookup field with the IDs of the Test1 form. My question is: When I click the submit button of Test1 I would like the submitted ID of the form to be the default value in the lookup field (in Test2 form). In general I want when I click the submit button then the ID of the submitted form to be the default value in the lookup field (which keeps the
insert a specific value from picklist to another field
Hi, I have a pick list -- Status -- field and which contains several values like -- Duplicate, Review and No Need . What I am trying to do is insert 'No Need" value from the lookup field Status to CD_Status field of Chanel_Database form. Can you please help me to fix . Below is my code if (input.Update_primarychannel != null) { insert into Chanel_Database [ Added_User = zoho.loginuser CD_ChannelType = "0.1" CD_market_id = input.Update_MarketID CD_Network
How do you do the same native form refresh on page with report and form view?
I've been reading the forums regarding refreshing portions of the page. I've tried the iframe method with no avail. My application is a simple inventory tracker, and I'm currently working on the inventory checkin workflow. I have a page that has an inventory checkin form at the top of the page, and a list view of the recently created records at the bottom. I'm not using the native form submit, as there will be instances where I want to scan in one UPC and then attach several serial numbers to it
When creating a record with script, how can I create a checkbox field 'checked'?
I've tried setting the field as true, I've also tried passing in the value to be selected, but every time I create a record with the script I'm using, all the values are set, except the check box. Please help.
Combined Reports issues
Hello, I need to combine two forms in a report, but I've been having problems because sometimes the report doesn't display the field data. I've tried this from the Zoho documentation: First: https://www.zoho.com/creator/help/forms/creating-relationship.html And then: https://www.zoho.com/creator/help/views/create-a-combined-report.html And it works but only with some fields, I don't understand why but sometimes some fields doesn't display any information in the report. For example, if I relate the
Application not working on iPhone
Has anyone had any success in getting applications created with Zoho Creator to work on smart phones, particularly via Safari on an iPhone? I can get the initial form to display, but when taps Continue to go to the next page, the next page never loads.
Count lapsed times between Added-Time for Records created by the Emailed Data process?
BACKGROUND INFO: I have onSuccess script that works fine for the regular add record process, but doesn't work when records are created through emailed data. The script (shown below) enters the lapsed time between the creation of the new record and the most recent record created that day with the same value in the Person field, i.e. that meets the criteria : (Person == input.Person and Added_Time == today). This image shows that the first record created (Record Number 1) using the normal Add within
RTF - edit a table
I can insert a table; is there any way to add or delete rows once the table has been created?
creator embedded form click through background
I have embedded a creator form on my webpage. The problem is that this form is above several page elements and in order to make the creator drop down menu in the iframe to work, the height needs to be set fairly large. Trouble is when doing this all other elements and links on the page below it can no longer be clicked because the iframe is on top. I need to be able to click through the background of the iframe form. Can this be done? How can this be done? Al already have the background set to transparent
Run two different scripts on User Input Action
Hi, Is it possible to run two different script on User input Action ? Actually I have a stainless form to Update the data of another form. Below I describer What I am looking for . please help me to fix it. On User Input of TV Station below is script code : if (input.Update_TVStation != null) { dat = TV_Station [ID == input.Update_TVStation]; input.Update_ST = dat.Add_ST1; input.Update_Market = dat.Add_Market; input.Update_BM = dat.Add_BM1; input.Update_RF = dat.Add_RF1;
Data in reports won't refresh
Hi, I am updating data in one table on my app, but the data will not refresh in the reports of the other app that is pulling information from the first table. I have tried everything I can think of, clearing cache, restarting the browser, and nothing works. Basically the only way I have figured out is to look up all of the data again and again and that is not feasible when I have over 300 records that need refreshing on a weekly basis. Does anyone have any ideas? I am basically updating information
count and total scripts in subform work on add but not on edit
Hi, I have the following count and total scripts that work on add but not on edit: Count script on add row: count = 0; for each record in Bin_Weights { count = (count + 1); } row.Winery_Bin_ID = count; Total script on Gross_Bin_Weight user input: temptotal = 0; for each record in Bin_Weights { temptotal = (temptotal + record.Gross_Bin_Weight - 93); } input.Total_Net_Weight = temptotal; I am populating the Harvest form from my Work Order form by the following: if (input.Work_Order_Operation
Can't delete apps
Hi - I created 2 apps in my account and now want to delete them. I click on the delete symbol and confirm but the apps remain. I have enabled support access and app names end with "-delete" Thanks, Jeff
How do I lookup data in one form and populate it in another
I have two forms - one a registered players form that I will be pre-populating with an import file. I have a registration page where I want a volunteer to put in the last name of a player and if there is a match populate the registration page with all the information we have on that player - I have tried the fetch records but cannot get past an error message - any scripting help would be very much appreciated
Conditional Criteria to filter Report? PROBLEM SOLVED
BACKGROUND INFO The weekly cycle in my app is Thu-Wed. Records have an integer field called WK which stands for Week. Records created Thu-Sat are assigned the week ahead, i.e. WK = Added_time.getWeekOfYear() + 1 Records created Sun-Wed are assigned the current week ahead, i.e. WK = Added_time.getWeekOfYear() QUESTION How can I set a criteria to select records on a report so that IF viewing the report on Thu, Fri, or Sat THEN record criteria is Week = Added_time.getWeekOfYear() + 1 and IF viewing
Rich Text Pop-up
Hello Experts! I have a well organized report (a List) which shows a series of records with specific sorting and grouping. Users started asked me if they can add notes to specific records with specific messages. This would be easy to accomplish with a multi-line or a rich text box. The problem is that when I add the notes to the table, the table starts looking weird with some record taking just one line and other taking huge space to accomodate the notes. Ideally, when I look at the list, it would
Zoho CRM field in Native Mobile App
I realise that forms using the Zoho CRM field aren't available in the Native Mobile App. I am curious if this is because of a platform constraint on the Native Mobile version or will we see this in future? I am developing an app that requires CRM contact data and know that I can code a method to pull down contacts that meet criteria x and populate a dropbox with them, but its not as clean. Really hoping we will be able to use the CRM lookup field on Native Mobile at some point... Thanks, Mark
Error in executing zoho.invoice.createinvoice task
Hi Team I have been using a Zoho Creator to Zoho Invoice creation task for several months. Today it stopped working. The error it produces is this: Error details: Error in executing On Add - On Success script. Error. Error in executing Set Variable task. Unable to update template variable invResp. Error evaluating MAP expression : Error in executing zoho.invoice.createinvoice task : Error.. Here is the code that I am using to create the invoice.. .Can anyone please tell me what is wrong with
Need Help
I am farelt new to Zoho creator and had schooling on Microsoft Access, but it has been years since I did any coding and this is almost a different way of coding. It just seems I just can't get it right on this. Here is a draft of what im trying to do: If Company_Name = "Company" { Labor_Total = Labor_Hours * 60 } { Else Labor_Total = Labor_Hours * 70 } Note: -The Company_Name is a dropbox...would I need to give the comapny I put in there a value and if yes how? -Labor_Total is a currency
Next Page