Is it possible to hide or show a field conditionally once the record is saved in view and or report?
As the subject line stated, would it be possible to hide or show fields conditionally in view and or report, once the record is created and saved? Here is a sample voucher that I would to create: Created record after the following data entry Surname: Mitchel Age: 22 Gender: (X) Male (this radio button was selected) (O) Female Weight in lb.: 170 ---------Form the newly added record---------------------------- I would like to view or print the above record after it has been created (conditionally)
Zoho Creator on an Iphone crashes when entering a Date-Time field in a subform
Hi there, I have a form which has a subform that captures two Date-Time fields on each subform record. It works fine on Android phones and a desktop, but on an Iphone the minute I enter the first Date_Time field, the app crashes. Any thoughts?
How to fetch records from a separate application
Hello, I would like to fetch records from a separate application. Here is an example: ApplicationA: "Form1" has fields: Name1, Email1, Department1 ApplicationB: "Form2" has fields: Name2 and Email2 --> Name2 is my lookup field. --> When I lookup a name, I want Email2 to automatically populate from Application A field Email1. How do I do this? Please give me an example. Thank you.
adding an image in a scheduled email dynamically
Project overview: How do i add an image that is stored in a form using the scheduled email workflow. The image is stored in the "offer" form and when entering the customer info we use a lookup field to connect the image that will be embedded. We enter order information into a form "Customer" so that we can send out a specific email XX days after the order shipped. My struggles 1 How do i add the embedded image in the email dynamically? Do i add the code in the email notice 2 when i rough tested
Typical Responses of Zoho Creator support Folks - #FRUSTRATION
Zoho Creator Team, Here are few typical problems I frequently run into - 1. Un-promptness - Support folks usually don't respond quickly - Reason: They are working on multiple chat sessions Evidence - are you there Vinod? 5:46 PM Hey... are you there!!!!!???? Vinod Chandrasekaran Yes,I'm here Please give me a moment. saurabh570 u already ate your time ... Story repeats.. saurabh570 it is 1 record at a time I will be able to show properly with screen sharing 5:52 PM are you good for that?
How can i restrict visibility in a page?
I want to restrict the visibility of a page from some users, but in the page builder dont appear "Restrict Visibility" as in a Report.
Don't share data with other users
Hi guys, I'm evaluating Zoho Creator and trying to understand if it fits my use case. Let's assume that I have my Entity: Customer (id, name, address) And this application users: Steve Jobs (Role: user) Bill Gates (Role: user) Elon Musk (Role: admin) I want that Jobs and Gates only see customers added by themselves while Musk can see all customers (with the detail of who added the customer). Is this possible with Zoho Creator? With the free trial I can't add any role so I can't understand if it is
Converting Month Numeric Value to Month Name
Is there a way to convert the number returned by getmonth() from the numeric value to the month name? I would think something like a built-in function or CASE OF statement but I don't see either of those as available. I could do it with a really long series of if/then statements but there has to be an easier way. Thanks! Parker Byron Network Administrator Kansas City Regional Homes, Inc.
How to display numbers as 6,000,000 in fields?
Hey, In excel I have a bunch of numbers written as 6,000,000 is it possible to have this same formatting in Zoho Creator? I can't find an option for it. Thanks, Dan
subscriptions
i cant find a subscription window to upgrade my account because i am blocked because of over use! i want to upgrace but it is impossible!! very fustrating
Zoho Inventory and zoho creator
Hi I need help in integrating zoho creator with zoho inventory. Kindly let me know.
Importing data from Access with auto numbers
Hello, I want to migrate an Access application into Zoho. My existing application has multiple tables linked on ID columns which are of the type "auto number" (using Zoho terms). Can I import those tables and keep the data in those columns BUT THEN have Zoho start incrementing the values going forward? Example: existing student ID's ranging from 1-10000. After my import, can Zoho start adding records with incremented Student IDs? Thanks in advance!
Calculate percentage field in C5 pages (Dashboard)
Hi, is there a way to have a percentage value calculated from two field values in the new C5 Page builder? I found a panel with a percentage sign but it only allows the regular operations (sum, average, etc.) but not a way to set the two values needed for a percentage. Thanks, Constantino
Fetch Product Name, Qty,Price Etc in a quote module to zoho creator?
is this thing possible? thank you for your reply
How to Add Row to subform via script?
Hi, I have a bunch of itesm in the multiselect checkboxeds eg: 1ft x 24ft = $4.9 1ft x 36ft = $7.3 1ft x 50ft = $10.5 Thes are actually len x width based pricing When the item is selcted in thse checkboxes, i would like to add a row to the subform and pre-fill it with the above values len = 1 ; wid = 24 ; unit proce = 4.9 So that, in the end, the user only enters the (No. of items) in the subform, ... This is to mimise manual error I have set the default row = 1 in parent form & input
Creator 5 migration
We're new to Zoho Creator. Seems very good for our needs. We've done a great deal of work and were surprised to see we're already being moved to a new platform. Of course, things change and we do understand. Reading the support information about migrating to the new version, it mostly looks like front end changes, all fine. Would you please tell us the significant changes in the new version that might be challenging for migration of existing applications? What areas should we look at most closely?
house rental app
my project is HOUSE RENTAL APP i need to display images in the BHK form i soon as i select proceed based on particular id of the house present in the report of house details form.
Return text I do not code.
Hello, I'm starting with the creator of zoho, I have a problem. When assigning an entry in a "conditional format" field, it returns the code, and I hope it returns the selected text in another field. I have put in a field the following expression: if (input.Cannal_de_entrada_1 = "Client", input.Cliente_crm, input.Agencia_de_transporte) The problem is that the order runs fine, however when it returns the entry, it returns it in code format and I would like it to return text. For example, in the case
Records error
Hi, I have a quata of 45000 records and i have in use the 12000 of them. The problem after i delete i still see that i have 40000 in use. Can you refresh please the record count? Mike!
Section Icons Are Not Updating
I changed the section icons and they were working perfectly. But suddenly they changed to the default section icon. When I try to update them, it saves but they don't change. I've tried to reset and select new ones, but still the same result.
The page is no longer automatically updating after adding data to the embed report
I have a page with 2 embed reports and html-button which call the form for adding data to embed report. For example. Page Invoice with Embed Report "Payments" filtered by invoice ID. Button "<a href='#Form:Payments?" + formParams + "&Invoice=" + NewRecID + "'><input type='button' class='addNew zc-formbutton' value='New Payment'>", formParams = "zc_LoadIn=dialog&zc_BdrClr=transparent&zc_Header=false" When I closed the form "Payments", the page "Invoice" was updated automatically. About 10 days it
Criteria Setting Via Deluge
I have a form that has a radio button named 'Filter'. There are two choices namely '2 years' and 'Custom Filter'. If 2 years is selected a table filled with number of students in each department. If Custom Filter is selected, two Date fields namely 'Start Date' and 'End Date' appear. When a user enters a date for each date field, the table should contain the number of students in each department within those dates. Problem: If I select 2 years, nothing happens to the table, it only displays all of
SORT RECORDS WITHIN RECORD SUMMARY
Hello...how do I sort the the records that appear listed within a record summary? I've got the records sorted in the corresponding report, but they do not sort the same when embedded within the record summary. Any ideas?
Offline Mobile App Works Differently in Each Phone
I've signed for offline mobile app account (2 users). In my phone, I can access all my forms. However, the user's phone can't. And when I tried to log into my account using the user's phone, it didn't show my app offline. Both phones run Android. Why does the app behave differently in each device?
Schedule Push Notifications
How can I create a form schedule that sends push notifications to my phone?
Attaching files from zoho docs in creator form
We have invested allot of time creating our soho infrastructure. It turns out that the bottle neck is an inability to link files from zoho docs on to forms in creator. We can upload files but this defeats the object of the cloud. The only way we can associate documents with records in creator is to download the document from docs then upload it again to the form using the attach file field in the form. I am sure I am not the only one trying to provide access or links to files in creator. Also, even
Repeating Lookup Field Values from Last Form
Is there a way to repeat lookup field values from the last form I've just added? For instance, I have field A, B, and C. I would like to submit a form where A is going to have the same value for the next 16 forms, B is going to change every 4 forms, and C always changes. In any case, if the value from the last form repeated into the next, it would save me a lot of time. Thanks.
Can the Lookup Field pull in data from a Photo Field
I want to enable the lookup field to show Students Photos that where selected through the Lookup Field from the same form or create an association from another form. For example, I want to show a group of students who are boys in 7th grade math. I can pull in all the corresponding data from Boys, Grade and Class. But I'm unable to get the photo's appear as an association for the Look Up Field.
Sections in forms
Hi... let me start by saying that this is a great application... Here is a thought... Whenever we make a form, the form can have multiple sub areas. For example, when we make a form for say a contact, the different areas could be office address, home address, personal details... stuff like that... It will be nice of you could allow me to add such form dividers... Thanks... Aseem Saxena India a.saxena
Stateless form + URL parameter + Web Page + Embed Report
I have Stateless Form to enter userID and password, the workflow of the button onclick is OPENURL with URLparameter of userID and password to a Page. In the page I'm using an embed Report. Is it possible to add the URLparameter to the search string of the embedReport? I tried different approaches most of the time it crashes and I have to delete the page and start over... Thanks, Martin
How to show the top 5 results in a Report
I've created a database and I want to see the top 5 sales people at the end of the week. I've looked at the User Guides and I haven't found a definitive answer. Any insight would be appreciated! SC
Docusign integration with Zoho Creator - Update envelope status - PUT method
I have managed to set an integration with Docusign to create envelopes. However I have a problem to update the envelope status to void, using Docusing REST API method. Since Zoho offers the posturl method (POST), I have tried including "X-HTTP-Method-Override": "PUT" in my header (instead of POST) without success. I keep getting the the following error: " INVALID_REQUEST_PARAMETER\" - "The request contained at least one invalid parameter. Invalid value for 'status' in envelope definition. Only 'sent'
formula field expression
I need to use the TODAY date in a expression for a formula (calculated field) but nothing seems to work. How do I get the TODAY date ? Thanks.
Fetch all values from a single record
Hi, I would like to fetch all values from a single record but can't figure out the exact way. At the moment I have: det = Addresses[ID = input.Delivery_Address]; input.Address_Details= det.Account_Name + " " + det.Address_Line_1 + det.Address_Line_2 + det.City + det.City + det.County + det.Country; What I would like is something like: input.Address_Details = det.getall(); Where "getall()" returns every field values for that specific record in my Addresses form. I'm guessing it's something simple
Using the Multi Select Field results in a Lookup Feild
I'm trying to user create a registration form to allow users to select their city, then from which city they select to display which services that city offers. In the City Form, the services have been selected via checkbox. In the user form, I've created the Lookup Field however it can't sort or exclude data based on what services where selected. I've read several articles however all the design solutions seem to be for Zoho CRM. Is there away to do this through the creator? Thanks
Changing Application Owner
Hi folks, I'm developing an application for an organization where I'm an intern. I created the application on my own Zoho account and have successfully shared it with the other staff. Since my internship will be over soon, I need to transfer ownership of the application to another staff member's account -- and I also don't want everyone typing my name in the URL long after I'm gone, heh. Any guidance? Do I need to get a Zoho staff person to help? Thanks!
GDPR Compliance
Am looking into GDPR compliance regarding data we maintain using Zoho Creator. Although Zoho has published some info on: https://www.zoho.com/gdpr.html I've been looking into implications about certain types of data we maintain on Zoho Creator and my understanding is that we need to keep a log of any changes to data. ie If a record is changed a log should be kept of the old value of the field and date and time it was changed and user that changed it. My question is is there is system-wide setting
Custome creator app developing
How can I share my app with a developer if he'll be granted all access and data? is there a way to share the app without the data?
Genrated Image in Record Summary
I have a field with an URL to an image. Would like to display this image in a Record Summary, is that possible? The URL is dynamically generated so i cannot add it as a normal image field. Tried to wrap the field value in some html img tags, such as: <img src="${Value element}"> but that is not accepted.
Customize form style with CSS (not for published forms)
I am using Zoho Creator to run a Word Order database application and would like to know if it's possible to customize the layout of the form. I keep reading that you can customize a published from but that's not what I am looking for. I know you can go to Settings > Customize but this only allows me to choose from pre-built layouts. The other thing I discovered is the option to set the form to single or double column in the screen where you can edit the form but this also is limited. I would like
Next Page