Similar way to PHP Sessions in Zoho Creator
A short tutorial in W3schools about PHP Sessions writes the following: When you work with an application, you open it, do some changes, and then you close it. This is much like a Session. The computer knows who you are. It knows when you start the application and when you end. But on the internet there is one problem: the web server does not know who you are or what you do, because the HTTP address doesn't maintain state. Session variables solve this problem by storing user information to be used
Is it possible to turn off Profiles and Roles?
I find the Profile and Role management extremely confusing. I prefer to use just the "Share" page under "Application Settings" and manage rights by user. Unfortunately, it looks like the Profile and Role settings are overwriting what is stated in the "Share" page. For instance, I set up a specific user so he can see just one specific report. The "Share" page is set up correctly, but because of the fact that his Profile is "user" and his Role is "Employee", he can still see other sections and
How do I restore a previous script version?
For some reason I can't update my script all of the sudden. It was working fine a few days ago but when I tried to edit the script today I keep getting a null message. I can't figure out why so I'm wanting to restore the script to a previous version that worked just a few days ago. I can't find how to do that anywhere in Zoho's help. Can someone tell me how to restore a previous version?
Fetch Data
Hi, I have created a form called Physician Demographics with an Auto Number field. Within the form, I created a sub-form called AZ Medical License which includes a date field called Expiration Date. I would like to set up a scheduled event based on this expiration date. I have created a schedule that runs on the date and would like to email a reminder to the Email1 on the record with an expired date. I have created a fetch data in order to have access to the fields in the Physician Demographic
Reserved seating
I'm developing a registration form for an event. Would like to allow for reserved seating. Actually reserved exhibitor tables, but seating seems to be more common use of such a widget. Any idea how to set this up on Zoho Creator?
compare with another form and delete the row if criteria Matched
Hi, I have two form FormA and FormB , There are two common fields between two forms. Below is the screenshot of the two Forms, FormA: Note: TV station : Look up field of station Name of Station Form Network -01 ; look up field of Network name of Network Form Network -02 ; look up field of Network name of Network Form Network -03 ; look up field of Network name of Network Form Network -04 ; look up field of Network name of Network Form FormB: Note: TV station : Look up field of station Name of Station Form
Validation function on Add and Update
Hi there, In my forms, I have a lot of controls with Alert messages that I have coded in the Validate functions on Add and on Edit. A lot of these validations are identical in the Add and Edit. How could I code once and use these validations in both Add and Edit ? I have tried to code a function "Validate_Form" but the Alert task cannot be called within a function. Any idea ? Many thanks !
Delete row from another form
Hi, I have a delete_form which have a field called -- TV Station . The TV Station field is the look up field from another form Station_List . Now when user select any station name from drop down list of Delete_form then I want to delete this station from another form LPTV_form , where TV station is the lookup field of the Station_List form also. I have tried the below code but not working might be because of two field are look up to another field if (input.TV_Station != null) { delete from
Allow an admin support staff to enter and edit records?
Some of our sales reps use a shared support staff member to enter and edit records in addition to the individual sales rep. What would be a useful form structure for this? Currently if a sales rep enters a record the system value Added User can be entered as a criteria in a Report to filter all appropriate records for editing purposes. The criteria would be Added_User == zoho.loginuser This is made more complicated if some records are being entered or edited by a shared support staff member.
is it possible to insert a record into a subform of one form, from separate form?
is it possible to insert a record into a subform of one form, from separate form? example: insert record into subform of form2, from a field in form 1
can you link to a file upload field in a stateless form
I have created a stateless form to show data from multiple forms. When I select a lookup in the stateless form I want it to give me a link to a file that was uploaded in the corresponding form.
auto populate lookup field based on previous field entry
Hi, I have form which has five field like below TV Station Form : TV Station Not -01 -- -- (lookup field from Network form) Not -02 -- -- (lookup field from Network form) Not -03 - -- (lookup field from Network form) Not -04 ---- (lookup field from Network form) Screenshot of TV Station Form view ; What I am trying to do is to fetch all respective values from the fields --Not-01, Not-02, N ot-03, N ot-04 to a picklist Network of below form when user select any station name. Say User Select TV
zoho reports is not updating
The following is the code I have used to update the data from Zoho Creator to Zoho reports, unfortunately it is not updating the records. And no error is generated at the creator screen. I just want to update one record based on date criteria. rowInfo = map(); rowInfo.put("Date", input.Date_field); rowInfo.put("NewDaily", input.New_Cars_Daily_Sales); rowInfo.put("UsedDaily", input.Used_Cars_Daily_Sales); rowInfo.put("WholesaleDaily", input.Wholesale_Daily_Sales); criteria = " \"Date\" =' " + input.Date_field
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.
Next Page