Calculating between dates
Hi all New to Zoho Creator but have come from FileMaker/Access style things. I have an "expiry date" and I would like to show "number of days until". According to my logic "expiry_date - zoho.createdate". According to Zoho help it needs to be "(expiry_date - zoho.createdate) * 60 * 60 * 60 / 1000)" [something like that]. But... well the formula syntax is right but the result is weird. I either get "3" or "-345600000". (depending on the various calculations I am entering!) So given the "expiry_date"
On user-input Action for Subform Fields
I am having a strange issue where an On User-Input Action is not being executed when editing a subform fields after opening the Main form and attempting to edit a field in a row. However if you add a new Row, then add data to the field, the On User-input Action is executed. When you do the same action on a Row that was already in the record when it was opened for editing, the Action is not executed. I have screenshot but the system is not allowing me to upload them. The Application is ghsagjv/projects/
get current http - url as an initial value
Hi, I've been trying for over a year in Zoho to get the current browser address information (current url -http) to populate "on success". I have over 200 subdomains with 14 forms per, and want to know which "subdomain.domain" (browser address) the form was filled out from. In my case, I don't need to "get" the "/abc.html". Just [subdomain.domain]. As it stands, I'll need to build and track 2800 forms to accomplish this (or become a perl, java, php expert) I used to use Godaddy's "Easy Database".
Associating Subform Records with Main Form Record?
I am creating an application to schedule a person to go to different stores and perform inventory of items on the store shelf. I have created a Main Form and SubForm. The Main Form is for the Inventory Scheduled event. The Sub Form is the items that are to be inventoried at that Scheduled event. Thus when a new Main Form Record is created (Scheduled Event) I want to run a script which automatically add records to the SubForm and auto fill the fields (Items to be inventoried). I have written the
Push Data into Zoho Creator using a USSD Application
Hi, I'm new to API's and I need your help. I want to allow my prospective clients to be able to submit their data through USSD (Unstructured Supplementary Service Data) using their mobile phone. Here is an axample of the workflow: Client dials *123# on their phone. USSD is triggered and prompts the client for their Name and then Surname and Email Address and so forth. When the USSD session ends successfully, the data is pushed to a form in Zoho Creator, that contains the fields; Name, Surname, Email
Problem embedding form
Hi, I am trying to embed a form on my website and the bottom area of the form keeps getting cut off causing there to be a scroll bar. This issue persists no matter how big I make the form. Could there be an issue with the HTML code I am using? Please help it looks highly unprofessional
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?
Hide Search Functionality in Customer Portal
Hi, We have the customer portal. We are close to launching this however there is an issue. At the top of the page there is a search box. This search box seems to allow any user to search any records within the system when logged into the portal, regardless of if they are the owner of the record or not. Please can you advise to A - How to hide this search box as we don't really need it or B - How to remove/hide the data that seems to be able to be searched. Please can you advise on how to do either
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
Lookup field to assciated ID field
I need a lookup field to associate the ID field of child form, but show value from another 2 to 3 columns; how can this be done?
Import an XML form
I have the XML code for a form that I'd like to have accessible to my users in Zoho to gather indepth information about one of their clients. How would I go about doing this?
Why does my app kick me out to my ipad when I try and access my form?
I downloaded the Zoho creator App to my ipad. I can sign in and my apps(Form) is present but when I try and access my form to fill out, it kicks me out of the App completely to my ipad home page. I am not sure that I published it correctly.
Zoho Creator running slow since early September
We have a Zoho Creator database of many thousands of items and as of the last three weeks the service has been running increasingly slowly. It has reached the stage where we click 'Add' to add a new project and have to wait about 30-60 seconds for the 'Add Record' panel to appear. Making other changes also takes a long time to update, and searching is equally slow. Is anyone else having this difficulty?
simple but possible?
I need to create a report/form/page (not sure what it is considered) where an employee enters a zip code, hits submit and it returns data with a hyperlink (from our excel spreadsheet/database) Can creator do this?
New user can't access app
I shared my app with a new user and an error message pops up saying that they are logged in but they can't access the app.
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 !
Copying data between two forms
Hi Sorry if this seems like a simple question! Currently I have an 'Application Form' that is completed by a customer. I want to be able to automatically draw information from this form on Zoho Creator to another form in Zoho Creator. For example: The contents FirstName field in 'Application Form' be copied to FirstName in another form. I think I need to use a stateless form for this but really don't know where to start. I've read the support docs on stateless forms but would appreciate any advice.
Universal search, instead of one search per table
It could be very usefull to have a "universal search" in Creator, instead to search table by table. For example, the user search a person Mr "Little", and he wants to know all the rows of all the tables where "Litlle" appears. It could be very helpfull for basic users. Thanks in advance. Best regards Jérôme
Having Problems with IPAD App when trying to load my form (Zoho Creator)
When I try and access my form through the Ipad App it kicks me out to the ipad main screen and will not let me access my form. It lets me get into my Zoho Creator portal and lets me get my form reports, but not the form itself. Please Help if you can! I am very new to this and am not sure I even Published it right!
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.
look up field with pivot function in zoho
Hello I need some experts for help me to make the below function workable Sourcing view Form Pivot Here you can see all the fields are look up fields from sourcing view,function I would like to set up is same as exel pivot table, for example while user select specific data in Region, country fields only pop up data under this selected region. I’v tried many times with different solutions, still doesn’t work. Please help Many thanks Priscilla
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.
4x4 Row in form
Hey people, I'm using the trial version of Creator right now and really like it. I am planning on getting the full version but am caught up on one part. I can't seem to figure out how to insert a 4x4 row into my form. I can only seem to make single fields, but can't place them next to each other or underneath each other in a 4x4 fashion. If anyone knows how to do this I would greatly appreciate some advise. Below I've attached some screen shots to show what I'm trying to do what where I'm getting
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,
Previous Import Not Shown on Report App
I'm evaluating the Basic Version. I had done an Import of 721 records, and everything came through, except there were some records that had errors, which I fixed. When I tried to re-import the corrected spreadsheet it wouldn't let me because it said I had too many records. I called support and he told me I could only have 1000 records for free version. He said if I wanted to re-import that I would have to go to the Report app, select all of the records, then delete them. Then, I could re-import
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!
Fetching data from forms into pages
Apologies if this has been asked many times, but - I have a form ('Form_A') with two lookup fields ('Image_Title' and 'Image_Name'). I want to create a Page in which the data that has been looked up is fetched from the Form and displayed on the Page. I have already read all of the various help pages but I'm not particularly code-savvy and, despite my best efforts, I keep coming up against error messages such as 'null', 'the input 'Image_Title' is not defined', 'type required bool; type found string'.
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 .
Next Page