Trying To Link Lookup to Another Form so that fields will be auto filled.
As said in my subject title above, I'm trying to link my Lookup field to Another field in another form so that once I key in e.g. Name, the address of the person will be filled automatically. I have tried editing the fields actions , however, I got two of the either errors saying that Error in statement at line number 1 The Left expression is of type STRING and the right expression is of type BIGINT And the operator == is not valid here (When my BIGINT is actually the lookup field. Look at pic 3
Zoho Creator Form Sharing
Is there something wrong with the Sharing feature in Creator? If I select multiple Sections to assign permissions, only the first will save correctly, then will not allow me to set additional permissions through the "Quick Invite" form. Then I click "Invite" and get the select boxes to click the sections and forms to share, but when I "select user" hangs. I can refresh and get the select users box to work, but I cannot seem to reach my goal of sharing multiple sections to one user.
Payroll in Creator
I'm trying to create a program in ZC that allows us to track some payroll information and margins on a per cleaning bases (own a cleaning company with several hundred clients). Here's what I need and I've attached the beginnings of my form/view as well: We work in crews of 3-4 people. Each crew supervisor brings back work orders for all the homes they cleaned each day. Usually between 4-6 homes per day. I need my admin person to take each work order and input the following information on a
copy certain field in multiple data entry
I created a form for data entry called "Report". It is used to register time spent on different project.User have to enter multiple record in a single data entry session and some of the filed are always the same. In particular Month (with is a dropdown field) and Manager (which not a dropdown field). How can I get the following behaviour: - a user log in and go to the application with the form "report' it enter the first data with all the field blank. - hit submit for the first record - when the
How to reverse rows to columns in reports
If I have a report like the image which I attach is there any way to change the rows to columns and vice versa? To have something like Super High Season High Season II High Season I Mid Season Low Season 02-Aug-2014 12-Jul-2014 07-jun-2014 etc etc 23-Aug-2014 01-Aug-2014 11-Jul-2014 etc etc
Please wait msg during submit
A previously correctly worked form now has a problem to submit the form. The "Please wait" msg is displaying for long time and there is no data submit. It does in a strange way, since one kind of data can be submit correctly, chosen from the drop down list. Any idea? Thanks
Custom Action Returning wrong Recod
I have been a Zoho developer for over two years and used this capability numerous times.I have a custom action that passes the ID to a url that brings up a view. It worked fine for a while but now it returns the wrong record. I've called customer support and logged a problem with edit access but have heard absolutely nothing back thus far. This custom action is critical the functioning of the entire application. This is a new application I am developing for a very large organization new to Zoho.
Sent mail with the content of Lookup field
I read many post regarding sent mail with the content of Lookup field. The notification email doesn't show the content of Lookup field, instead, it shows the ID number. Anup has answered for one post as following In the new app builder interface the lookups by default is linked to the ID field. So when you set an email notification to get the exact data from the lookup field, you can set the field value as "input.Lookup_field_name.Field_name". This way works well in setting FORM Email Notification
Embed form no longer free?
Could you please clarify the position on embedding forms for free. I have a client with a very low throughput and the free option for up to three apps is all that is needed. However it is useless unless the forms can be embedded in his site. Zoho Creator allows me to do it and initially it appears to work - it does not display a login - but it comes up with the error message 'Invalid entries found. Please correct and submit again' when I put data in. Is that a symptom of the need to upgrade? If
Live App building session at Zoholics Developers
We believe most of you are aware that Zoho Creator community are coming together for a two day event on March 20-21 at San Francisco , California The keynote of the event will be delivered by Sridhar Vembu, CEO of Zoho Corp. I will be doing two sessions focused on live application building and showcasing standalone applications. The product demo session will show how Zoho Creator can be utilised for all your business needs by creating database. This session will be useful for anyone who wants to
Count Jobs
Hi, I have created a job system which lists jobs per customer. I would like to have a field that counts per customer i.e Job1 Cust 1 - Open Job 2 Cust 2 - Closed I would like a field that shows a count of Jobs open and a filed that shows Jobs closed per customer? Cheers Scott
Print the report summary for multiple records at the same time.
I have created a customized report summary for a report instead of using the default template. The only way I know to print this custom summary is to run the report and click on View Record next to one of the rows of the report. The problem is that I can only print one record (row) at a time. If I have a lot of records (rows) that I want to print in the custom report summary format, doing one at a time will be very time consuming. Is there a way that I can select multiple records (rows) of the report
No Records Found With Specified Criteria. in Migration tool for excel
hi , i am trying to update data with Migration from excel to Zoho cloud tool when i import excel and click on update data it generate error file which showing "No Records Found With Specified Criteria" please help me i am new to Migration tool i want to know how to specify correct criteria for update
How to edit the URL in Customer Portal
I am using customer portal in my application. I created a new customer Portal URL but I am not happy with the name of the url which I gave to it. I would like to ask you if there is any way to edit the URL or to delete it and re-create a new one for this application.
Square Register
I am working on an application that will act as a guestbook for a historic site. We offer tours and I have made the form calculate the cost and record cash payment. Now, I want to make the form open the Square Register app that is installed on the tablet the form will be open on. It would open the app when a user clicks a checkbox for credit. Does anybody know how I can do this? I have read how you can do it on an android app, but I don't know how to make it work on Zoho
Changes to the Customer Portal last night?
This morning when people use the Customer Portal after entering their information they just get a blank screen. The url contains index.jsp?serviceurl=%Fuserhome%Fnull%Fdashboard Another problem If a person asks for a password reset they get a screen to enter their email and the word from the image in the box below. There is no image! Only a broken image link. I have tested this on different computers and different browsers.
database name and table name
hi return value as map> = zoho.reports.updatedata(<DATABASE NAME>,<TABLE NAME>, <Data as map>,<Criteria>); from where i will get database name and table name
Remove Mobile Logo
I'm working with a client that will use iPads for form inputs. The zoho creator login form has a rather large ZOHO logo on the iPad. Please remove this class logo statement: <div class="mobilelogo"></div> Cheers, John Whitney
I want to calculate number of records(count row). What is the simplist way?
I have this Registration form with 2 subForms in one page. https://creator.zoho.com/zoho_spt3/yongin24 [SubForm1] Sub Total 1 = number of rows added on SubForm2 x 25000 [SubForm2] Sub Total 2 = number of rows added on SubForm2 x 50000 Grant Total = Sub Total 1 + Sub Total 2 Pretty simple, isn't it? But I can't get over with this for 12 hours now. Can someone help me? I need to know where to put the script with what.
No Mobile Access After Annual Subscription Paid
Paid in full only to have my access and all users access denied to the mobile app. Getting the message "trial has expired purchase the professional addition for access" WHAT? (3) email attempts to zoho support and also its team members who were quick to have me sign up for a paid subscription. ABSOLUTELY no response not even and acknowledgement of my of my email. 2 phone calls to support only to get an answering service. WHY would i leave a message to a company who doesn't respond to begin with.
Stateless Form - contains more than one record (return fields values as list) - help!
Hi, I have created a stateless form from a master form. My master form contains the following fields: Unit No. Lease End Date Checklist Item 1 Checklist Item 2 Checklist Item 3 I have created a stateless form that fetches data from the master list based on Unit No. I worked out that I can then sort column by descending Lease End Date to pull up the most recent data. The Deluge script is as follows: RecData = Master[Unit_Number == input.Unit_Number] sort by Lease_End_Date desc; Lease_End_Date=RecData.Lease_End_Date;
Embedded Forms and Users
I am having problems with some computers not being able to save embedded forms. I am wondering is this is a user count issue. How does ZOHO define a user - is a computer accessing an embedded form if user is not required to logiin considered a user. I have the basic 5 user account, can 6 or more computers update embedded forms?
Best way to develop a conditional form with fields that hide, show, clear and follow a series of steps?
I am creating a form that represents a lab procedure to follow step by step where each step is a field dropdown (Yes/ No) and may require data to be collected in a separate field. The steps are all conditional decisions and could lead a user down a different path each time. A user can also go back a step and choose a different value which then takes them down a different path. How can I accomplish this and be able to maintain the flow/ path and make changes to it? I don't think hard coding the
formatting values from related field in a record summary
Hi Zoho, I'm creating a template for a record summary and am having trouble with the formatting. I'm trying to get multi-select values to display in some other way (e.g. ordered or unordered list, or with line breaks) than just value,value,value,value,etc. If I'm just using "Insert Field" I can't figure out how to avoid this. If, instead, I drag from the left and drop the field onto the template, it accomplishes what I want but introduces a new problem: two labels. The left label is fine, but how
Multiply values from different forms in a formula field
Is it possible to calculate in a formula field two values from different forms? Lets say that I have a form called Product with a number field (Quantity) and a second form called Pricelist with a number field (Price). Is there any way to do this multiply Quantity*Price into a formula field?
Problems with migration tool
It should be noted that some days I can not update zoho through the migration tool. The system gives me error like "username or password is incorrect." Username and password are the same ones used to access zoho and turn out to be right. This is the script used: zohocreator.exe c:\scripts\Magazzini\Articoli_famiglia.xls <Username> <password> -e giacenze -au Articoli_famiglie Codice Codice that has until now worked!!! How can I fix the problem? Best regards
database and tables in zoho
hi , in trail version should i get access of joho database and table, if yes, from where i will get there names
help please? how do i use soho
hello i'm trying to use zoho to purchase an item online but it won't bring me to the PayPal screen, every time i check out with the item i want in my card it brings me to zoho and then i get this screen: after i click go to the home page it brings me to the Zoho Creator. I'm not sure what to do from there to purchase my item with PP
grid view cutting text and saving balance of field
when in grid view, for record "xyz", creator cuts-off long text in field "A" (for example, if text field is <2 Pack 9" Wax Finish Tapers w/ 5-Hour Timer>, then in grid view I only see <2 Pack 9> note the <> are my brackets). then somewhere else on that record row I make a change in _only_ field "B". then the record needs to be updated, but after saving the update Creator now has only <2 Pack 9> in field A when I view the record in list view or summary view. It did not show me balance of text
Why is a new schedule bringing up code from another schedule?
Either this is a problem or this is just the dumbest most confusing user interface... So I create a new schedule, in my case I have 3 custom schedules. I set up the "When to do" part easy then click Save. Next i click "Next". I would expect zoho to take me to a blank code editor but instead it takes me to a code editor containing code from my other custom action. I'm not sure that a new custom action actually creates its own code, instead all the code is stored in the same place. What is the point
How to synchronize two date fields with the same date?
Dear Colleagues, My question is about the date fields. I have two datefields FROM and TO. As you can see in image1.png when I select FROM date (12/1/2015) then in TO field I have again to select the month and the year beginning from the today's date which is not very comfortable. Always the TO date should be after the FROM date. Is there any way to do something like image2.png? When I select the FROM date then the TO date to start with the date which we gave in the FROM field.
Populate a dropdown list
Hi there I'm trying to figure out how to populate a dropdown box based on another form. The setup is: Event Form has typical fields (name, date etc) but also has a multi select lookup from "Class" form. Nomination Form - has some member details (Full name, phone etc) as well as lookup fields for the Event Name and Event Date from the Event Form. On the Nomination Form, there is a subform called "Details" - amongst other fields, I have a dropdown on this subform that I want to populate with the options
Use values in a subform
HI I have one form, with subforms. In the form I have a Lookup field. In the subforms I also have a lookup field with the same values of the field of the parent form. How can I do that if I choose a value from the parent, when I add a new register on the subform the lookup field take the same value choosed on the lookup field from the parent form.?
Are you coming to Zoho Creator's first Developer Conference?
Mark your calendars! Later this month, Zoho Creator community will come together for a two day event (March 20-21) at San Francisco's Embassy Suites. You may wonder, why it took so many years to introduce such a developer conference for a product which has a great community? Frankly, we didn't focus on it. All these years, we were focused on making the product easy and powerful for our users to build custom apps on their own, and we continue to focus on that mission. Apart from product focus, from
Fetch Data using Stateless Form - More than 1 record - help!
Hi, I have created a stateless form from a master form. My master form contains the following fields: Unit No. Lease End Date Checklist Item 1 Checklist Item 2 Checklist Item 3 I have created a stateless form that fetches data from the master list based on Unit No. Throughout the year, I may have the same Unit No. that has 2 lease end dates (say 6 months apart). I worked out that I can sort column by descending Lease End Date & the stateless form will pull up the most recent data. The Deluge script
Embedded Forms - sometimes will not save updates
I have a series of embedded forms in a wordpress blog. We access the forms from multiple machines every day. Sometimes some computers will not save updates to some forms - we get the saving message that never goes away. Its only some computers some of the time and it only effects a single form. The forms it effects are different every day. I have tried using a new browser, clearing all browser history and even restarting the computer - none solve the problem. Any thoughts on either how to fix it
Login Credentials are not displayed when accessing customer portal login from a link in website
I am testing the access of my customer portal from my zoho site via a link. When the portal login page is displayed, there are no login/password fields displayed - only a link to reset a password. Thank you in advance for your help!
Change Field Value based On Selection
I searched for a solution, but obviously I am clueless as to what to do, so I thought I'd ask here. I have two forms: Managers and Players I have a third form called ManagersPlayers that has the lookup to ManagerName from the Managers form. It has a subform that contains a lookup to the Players form. This works fine. I select a manager, add a player. Now, it gets fun(ky). I have a field in the Players form called "Available" as a drop-down with YES/NO choices. By default, all players are YES available.
Dynamic Filtering for Look-up?
Maybe I'm losing my mind, but I thought that applying a filter to a look-up could change the look-up values dynamically. I know it works for on-load... Cheers, John Whitney
Zoho Creator Rebranding Footer Removal
Hi Zoho, Your rebranding options are fine but the footer shows "© 2014 ZOHO Corp. All rights reserved". How do I remove that or customize it? We are very close to choosing your service. The only concern that we have is your footer. The footer will definitely affect our business. Please help. Thanks, Sen
Next Page