is it possible to set unrequired to the field using deluge script.?
How to set field as unrequired in deluge script ? i have a field , some time it show and some times it hide , i want to make this field as required when it shows and make this field as unrequired when it hide .
Possibility to Drill Down into More Information?
I am using Zoho Creator and I have a form that I created to hold a list of contacts. The contacts table has approximately 15-20 fields that I defined (name, email, address 1, address 2, etc.). I have created a view of the contacts table that I have embedded into the page of another website. In the view that I created, I only have 4-5 of the 15-20 fields displaying (if I display all the columns in the contacts table the iframe becomes unattractive and has a long horizontal scroll bar). What I am trying
How to get a vendor id from Zoho Books?
I am trying to make a bill from a Zoho Creator list record but does anyone know how to get the vendor id already made in Zoho Books?
Search Form
Hi guys, Can anyone help me to create a Page which has a form with one search field (say, "Country Name") and a button "Search", which opens a Report filtered by the selected Country (same page, below the search form). Is there any easy way of doing it without HTML programming ?
creating a graphical style report
I want to be able to produce reports on properties we inspect. the repots need to be graphically pleasing and will include lot of photos. the reports are done on a room by room basis (average is about 10 rooms) and in each room there will be 10-15 sub items(ie walls, carpets, furniture, lights etc) I want to collectthe data using zoho app creator and this will need to merge with data stored in the main zoho creator database. I have seen other programmes which link directly with an excel template
Get Error 500 After I enter login info
I go through the process of logging in, including two factor authentication, but then I get an error 500 screen. Any ideas?
More than two columns in Forms?
Hi, Is there any way to have more than two fields per row (or two columns)? Is there any plan to make more flexible the form field positioning? Thanks, Fidel Martín
Question conditional formatting (calendar)
Español: Buenas tardes, deseo aplicar formato condicional al calendario, dada la siguiente condiciones. Si la fecha del campo menos la hoy es menor a 7 días. Ingles; Good afternoon , I want to apply conditional formatting to the calendar , given the following conditions. If the field date minus today is less than 7 days. Example: conditional formatting ( "Test" { condition = ( (FECHA_V - zoho.currentdate) < 7 ) format = "color:#ffffff;background-color:#489641;"
Cannot save after editing in spreadsheet mode
Hi everyone, Please refer to the screenshot, after editing multiple records in the writing time column, I tried to click save but nothing happened. Then of course I cannot save my editing. Sometimes it works, but most of the time it doesn't. Please look into the issue and advise. Thank you Regards
URGENT | User does not exist? | USER ID 49606658
Dear Service Provider, None of my user have access to this application except for the app owner socure.bureau@gmail.com Please advise ASAP how this can be fixed. Please find attached print screen
Lookup question
Hi I'm currently writing a booking system for the theatre company that I work for. The image at the bottom of this post may explain it better, so you may want to look at that first!, but my problem is: The initial form ('New Gig') has 2 fields, 'GigID' (autonumber) and 'Event Name' As soon as this form is submitted, it automatically creates a record in the 'Tech' report, autofilling the 'GigID' and 'Event Name' fields (there are actually lots more reports, but just to keep it simple to explain)
Embed Google Drive iFrame in a form
Hello, I'd like embed a Google Drive iFrame in a Note field in a form, but I can see preview correctly and when it save, code disappear and form is without iFrame content. Anyone has any idea? Thank you!
Pivot Tables No Data, Help
List Reports are showing data fine, but our Pivot Tables don't show any data, as if there's nothing in our database. There's also some inconsistencies with "Select/Drag and Drop the Columns"; it's listing some column names wrong. It's as if Pivot Tables is unsynced from our database. Is there anything we can do to fix this?
Dynamically add or remove stages
Is it possible to dynamically add or remove stages from potentials based on another value in the form such as the amount? We have 3 types of potentials (small, medium, and large) each one has a specific set of stages. I would like to only show the stages that are relevant to each size.
Add the value of a single field to a lockup
I would write on a single field and the value of lockup were the same as the single field, then do a fetch automatically. I wish I could do this because I'll make a public view and not to display data from the lockup to the public, Thanks! if (input.Alta_de_vendedores == null) { if (input.Correo_electronico != null) { ALTA = input.Alta_de_vendedores.toString(); ALTA = input.Correo_electronico; x = Alta_de_vendedores [ID == input.Alta_de_vendedores]; input.Verificacion_Correo
Zoho Creater + WooCommerce + Zapier
I'm running an ecommerce clothing brand, and I'm trying to integrate my WooCommerce store orders with Zoho Creator using Zapier. I've gotten through most of the process, but I'm struggling to figure out how to have my attributes and variations come through to Zoho. Here's an example... Each item of clothing listed on my website is a unique color. No single product has multiple color variations within it, only sizes. Through the Zapier connection, I'm looking to have these fields imported to my Zoho
Display multiple fields on calendar
Is it possible to display an event title and starting time on a monthly calendar report view? I only seem to be able to choose one field. I suppose I could create another field that combines them, like "1:00pm Staff Meeting", but the data is already there, it would be easier to just show a combination of the fields. Bruce Letterle Red Lab Media
Upload excel data without touching master table
Good Morning Please help and advice me in the following issue ... We want to upload excel sheet in the zoho creator, but don't want to do this directly in the master table.. Basically my query is can we upload excel data without touching the master table. and after upload fetch data and apply some criteria like duplicate etc. also. Please advice Thanks Shiv.
Cancel an account
Hello to everyone in the forum. Anybody here know how? or where? to cancel an account on Zoho-Creator or zoho.com
Zoho Creator mobile not displaying report column
I have a very simple Creator app that when I access a report from the mobile version, the last column in the report is not displayed. It displays fine when I access the web-based version on a PC. There are 5 columns in the report and only the first 4 are displayed when I access via the mobile app (Android). Am I doing something wrong, or is this a limitation?
Zoho Creator Application Packages documentation?
Where can I find any documentation on the Zoho Creator Application Packages feature?
Fetch Data from ID
Hi I'm trying to populate a table based on the ID number of a record. I have a table (Main) with People & Courses having lookup values as their records People Courses 3081044 3001505 3150808 3205808 3081044 3045088 I want to fetch records in this table where People = the ID number of the People table when I edit the People table. So; user edits People table (maybe adds a new course that the person needs to do). When they click 'Update', this code kicks in... training_records
How Do I Populate a Notes Field with Iterated or List Values?
I have two tables: Locations CustomerContacts (there are many customer contacts for each location) In a third form, I would like to show all of the CustomerContacts in a "note" field once a Location is selected. I understand how to use the for each and iterate through the CustomerContacts, but I cannot seem to get it to list, or show all of them. How can I do this? Thanks!
passing a variable to a wordpress embedded form
Hello. I am stuck. I use 'WP Estore' and WP Emember to manage my store functionality. I want to pass the sign-in email to a Zoho embedded form on my Wordpress site. I've searched these forums, and found a few that are very similar, but not enough for me to figure out how to pull the variable from Wordpress to Zoho. The Wordpress variable can be called with this WP Emember function: wp_eMember_get_user_details("email"); First time posting, and fairly newbie php programmer. Any ideas? Jason
Zoho Creator - Who can start developing the application
Is it necessary that a developer need to be coding / programing the application? Can a person who does not know coding / programming develop application using Zoho creator?
Sorting a multiselect lookup on success
Hi, Here is a list of options selected in my lookup field called contact type (NB: It is a multiselect) that references my form contact types: Warehouse Accounts Sales Purchases I want it to sort to alphabetical order: Accounts Purchases Sales Warehouse The code I have written on the On Add-> On Success portion is as follows: IDList = List(); for each ContactType in input.Contact_Type { GetDetails = Contact_Types [ID == ContactType]; IDList.add(GetDetails.ID); } GetSortOrder = (Contact_Types[ID
Create report for time spent
Hi, I have in one of the forms start time and it saves it in the DB, MM/DD/YYYY HH:MM:SS then in the reports you have an Add Time when the user finish and submit the report automatically saved by the system with the same format MM/DD/YYYY HH:MM:SS. I'm trying to make a report where it takes form start (MM/DD/YYYY HH:MM:SS) - finished form (MM/DD/YYYY HH:MM:SS) = time spent (HH:MM:SS) I can't figure out how. If you can please help me it would be great. Thanks!
get records from zoho books using "greater than"
Hello, I want to fetch records from zohobooks searching for Invorce IDs greater than the last one fetched. Example below. is it possible? if no, what's the most efficient alternative? Books_Response = zoho.books.getRecords("invoices", "xxxxxxxxxx", "Invoice_ID >" + Last_Invoice_ID); Thanks Luis
Using Creator with Zoho Sites
I'm new to Zoho, so forgive me if this is a dumb question. Is it possible to run your "Entire" public and private website using your own domain name with Zoho? I currently use WordPress to sell online classes and subscriptions. The online classes are videos, hosted by Vimeo and embeded in WordPress Pages. The subscriptions are handled by a "Membership" plugin restricting access to custom documents just for that customer. Can I use Zoho for my public site pages (blog, static content pages, forms,
Dudas sobre el limite de uso
Buenas tardes! Realice el pago de la suscripción por paypal , adjunto imagen. Debería tener habilitados 10.000 registros pero solo me dice que tengo disponibles 750. Me podrían explicar?
Maximum fields in a stateless form
Hi I'm doing a booking system for the theatre company that I work for, and the tech section is quite substantial (100+ fields). I've split this up into several forms, but would like to enter the data into one big form (much easier for me) I've got the stateless form working, so that it updates a number of different reports, Do the limits on the maximum number of fields apply to stateless forms, or just to the reports that they're pointing at? It would be good to know this before I spend lots of time
FTP
hi, do you have a solution in ZCREATOR for read/write in a FTP ? thanks you
Time Stamp
I have a notes field on each clients form. I add notes to their record from time to time. Is there any way a time stamp can be added. before the note, each time I edit the notes field? Thank you.
Problem with copying the application
Hi. I was explained in one tutorial, that I should copy Zoho application via the following link into my account: "Once you are logged in, go to this application on Zoho. We will start by cloning the application used for this prototype, which makes life a lot easier. On the application you just opened, click on More Actions > Copy Application. This will make a full copy directly to your account with all the settings already in place." But I do not see any buttons with possibility to copy this application.
Atomicity in Zoho Creator?
I need a unique "order number" for each new order. I use a form's field to keep track of the next "order number" and increment it. string WalkIn.OM.Orders.NewOrderNumber() { g = Global [ID != 0]; temp = g.Next_Order_Num; g.Next_Order_Num = (g.Next_Order_Num + 1); return temp.toString(); } The problem is, when 2 orders are created within 3 seconds apart, they'd get the same order number. Is there anyway to guarantee atomicity for the function above?? What's the right way to implement
CREATOR Grid & Spreadsheet Reports in the NEW UI
I am developing an application that heavily utilizes grid or spreadsheet views for the purpose of QUICK data update without having to open every record. Several weeks ago you could not get creator to accept a value into a field in these views. This has been fixed.....and I was told by email that the grid and spreadsheet report views are fixed. However these issues REMAIN: 1. The grid and spreadsheet are no longer 2 distinct views 2. When there are 20 to 40 or more records....it can take 5-8 seconds
Issues with viewing VIEWS on creator forms in CRM
I recently purchased crm plus. The first two weeks. I could create a tab for a creator from. I could than view ALL views of that form beautifully. Then there was an API issue and you could not view any integrations. That has been corrected. HOWEVER, I currently CAN NOT view ALL the views of a form that has been integrated in crm plus from the crm. No matter what view is selected the same view appears. I have made several calls to tech support with NO feedback on when this might be fixed. This
Date format and decimal separator
Although my application be set for the Brazilian date format, my forms show the months with the abbreviation in English as "Sep" for September instead of "set". I'm also not finding a way to use the comma as the decimal separator. Could you please help me? Thank you!
msg...... invalid entries found (HELP ME)
I'm and my public colleague receiving this msg when we try to add any app record... "invalid entries found please correct and submit again" in zoho creator. HELP ME PLZ as soon as possible
Integration with CRM
There needs to be a way of sharing prospect and client data between applications built with Creator and Zoho CRM. Creator gives the ability to build a full-featured applicaiton to capture and service the contacts/leads/prospects but CRM is needed to manage and follow-up. Last reference to this I can find is from Nov 2007. Any progress?
Next Page