Creator Mobile Menu: How to hide menu?
See attached images. When a customer portal user logs in they see this standard menu view, but I want them to be directed to our dashboard page shown in the second image with the blue buttons. How can I hide the mobile menu and show just my dashboard
Creator App not updating record
Hi Everyone I am a grou private practice (Therapist). So far I am loving Zoho One. Here is my issue: I created an app in Creator, for client chart. Previously, we did everything with Google Workspace and are migrating to Zoho One. Previously, the client
Zoho Creator Save Drafts or Tricks
Hi, I would like to ask if there's a way to increase the number of saved drafts or is their other way to do like how this drafts do? TIA : )
Tip 33: How to create custom forms and reports using widgets
Hi folks, In this month's tip, we're going to talk about how to use widgets to create custom forms and reports in your Creator application. But, before that, let's cover a few basics. What are widgets? Widgets help you extend the capabilities of your
CRM with production data, Creator app with sandbox. How to test it?
Hello! I have a CRM project with production data in use. I have an app created in Creator. I need to make some major changes in app. So I decided to create sandbox app to make changes and test there before publish. My question is, how can I use non-prod
Add Subform Row Into Existing Main Form
Hi, I have a main form A with subform AA. I want to add data from main form B to existing main form A subrows. How can I achieve this using deluge scripts? The current example I see is adding subrow in new main form record, but how do I add to existing
Zoho Creator Upcoming Updates — July 2023
Hello all! We hope you’ve had a chance to check out the newly updated Product Roadmap, which now includes the new features coming up as part of our 2023 Projection 2. Our goal is to continually improve and add new features to our platform on a regular
Field Type: Address, Change District/State to Dropdown with picklist??
Using the Address Field type, is there a way to make the District/State field be a dropdown with a picklist so the users can select rather than type the state name every time? I know this can be done if I use a drowdown field for the State (or entire address information), but that isn't as tidy as using the address field type. I apologize if this is a duplicate. I posted this question the other day, or so I though. Can't find that post.
Remove Special Characters
Hi folks, I know that Number field type, does not allow the data to get submitted if there are any special characters eg:- entering 1-1-1- in a Number field type & submitting the form, will show as error / invalid entries. I have seen removealpha(), remove aphanumeric() in string funtions. But i was not able to locate any function that allows to remove special character tried giving alert = input.number1.abs() , but alert just did not pop up. Wonder why? Infact, i would like to use removeallspecialcharacters()
データ未提出のポータルユーザーの特定
社員全員に週に1回データを提出してもらうためのフォームを作成しています。 きちんと全員が提出したかを確認する必要があるのですが、未提出の社員がいる場合、特定することは可能ですか? 社員はポータルユーザーとして登録します。 どのような方法でもいいので、お知恵を貸していただけると幸いです。
multi-select fields and report builder
Hello, Is there a work around (via deluge script or else) to allow data in multi-select fields be grouped or filtered in the report builder? We have activities that are participated by multiple participants that we input via look up -multi-select fields. We need to make a monthly report for each of the participant vis-a-vis the collective activities they have participated. How can we do this here? Its a feature we commonly used at dabbledb. Thanks, Edith
Formula field and zoho.loginuserid
Hello, Can the formula field be used to display a value from another field based on the logged in user? I have multi lingual users so I'm thinking of having a single line field with the product name in Spanish and another in English, then use the formula
Problem with pass a value to a Zoho CRM Integration field
Dear All, In a form I have added a Zoho CRM Integration field ("Supplier" Name) which is connected in the Vendors Module of the CRM. I would like to create a record in Creator through Zoho CRM and this field to be filled with a specific value. I have
Display a collection of images within a page
I have an app that calls the realtor.com API. I am successfully grabbing a collection of images and uploading them via a subform of image fields. I would like to display the images from the most recent API call somewhere on a page in the app. I have made
How can I transfer data from Production to Development environment?
Hi, I am using Creator V6 and would like to bring all the data in production to the Development and Testing environments? Is there an easy way of doing that or I have to export and import each table?
Sub-Form Permissions
I have a Form with a Sub-Form on it. I would like users to be able to add records to this Sub-Form, but I do not want them to be able to edit or delete existing records that are in it. This is easy to do with top level Forms via user permissions, however,
Video streaming on Zoho Creator
I used the video upload field in my form for my public users. Upon recording and uploading their video, I am able to view the videos in my apps. The issue I am currently facing is that the playback of the video is very slow. Every few secs, the playback video would pause and a circular image would appear suggesting that the video is still being downloaded. My video file is only 1 min long and is about 20MB. My connection to the internet at the point of testing is around 32Mbps (download speed).
How To Create A JSON Request With More Than One Array Element?
Hi, I am using the postURL functionality. JSON Request body contains more than one array element like shown below, Original JSON Request Body Format To Be Used: { "Name": "Hello World", "Roles": [ { "Profile": "asdf", } ], "Description": "sent" } This is my code used for creating above JSON request using "map()" functionality, myMapData = map(); myMapData.put("Name", "Hello World"); myMapData.put("Description", "sent"); // I used the following code for creating "Roles"
Bulk edit lookup field
Im my form (MONEY) i have one old field CURRENCY (type string) with several pre-choices (usd, eur, lkr, etc). I have created new form (currencies) and report with these choices (usd, eur, lkr etc) to use it like lookup. I have there such fields as: Country, currency code. In my MONEY form i have created new lookup field NEW_CURRENCY (Bigint) witch takes data from new form (currencies) with specified criteria (country). But bulk edit do not allow me to edit this lookup field in old entries. What should
Zoho creator Integration with Biometric
Hello, Is there anyway to store biometric details for each employee inside my custom made Zoho creator application as a field and then use it to track attendance of the employees, if there is any what device do you recommend to be used for tap-in\out and what api should i use. Thanks,
Question regarding Twilio deluge task
I am using the deluge twilio.sms.send to send SMS to clients. https://www.zoho.com/deluge/help/twilio/send-sms.html Is there any way to setup the below somehow? 1) I would like when a client receive an SMS the FROM to show a name like 'Transfer' and not
Can I get stock prices in Creator
Is there a way for me to get current stock prices, DayHigh, And DayLow into Zoho Creator the same way as in Zoho Sheet?
Changing the name of Record Template sent as attachment in SendMail
Is this doable or not yet?
Update / Refresh report automatically?
I have 2 forms: newspapers and prices. I have a report of newspapers linked to prices. If I update the price for a specific newspaper in form "prices", I would like to see the price of the existing record in my newspaper report change as well, which is currently not the case. How to automatically refresh the report? Thank you in advance
Determining user device
I need to be able to determine whether the user is accessing the form through a desktop or mobile browser. Is there a way to determine user client? If not, is there a way to read the url of a page using deluge scripting? I know that when a user access the form through a mobile browser, there is a "form-mobile " in the string. The reason I need this functionality is because Zoho Creator only allows the user to take a picture using their camera through mobile browsers, but I need to create the
Direct URL to "View Record"
I would like to create a button (Deluge Script) to jump to the "view record" without passing by the record menu, but I can not aford to find the right url. I don't want the "view record" as a single page. I want the "view record" in the application like the picture below: Thanks in advance for your help
How do I make a report based on two forms?
Can I combine two Forms in the same report? For example I have a form with the average results of each student and a different form with the preferred assignatures and I would like to make a report (for example a list) combining both forms. Can I do that?
Pause(1);
I'm using scheduler to invoke an interaction via http post with an external service. The schedule code uses a for-each loop that runs so fast my external application's log files get messed-up (they are named by date-time stamp). What I'm suggesting is
Delay function execute
I've got a workflow which uses a webhook to send information to Flow, which in return updates a record in Creator. Problem is, by the time this has executed, the rest of my script has run and can't find the (yet to be) updated info in the record. Is there
where are creator form entries?
Where are the form submission entries located???? In FORMS, they are all listed "right there". In Creator, I cannot find em? In my opinion so far, y'all need an App that is a cross between the two. Forms is Awesome, Creator is a headache
can't select "Collection of record " for multiple record
Why I can't select "Collection of record " for multiple record
Random Sort/Shuffle a List
I'm trying to figure out an efficient method to randomly shuffle a list. Basically an implementation of Fisher/Yates/Knuth algorithm. In order to do this efficiently the best way is to repeatedly swap two elements in a list (or even a map). The built in functions do not seem to allow you directly write to elements in lists. So I end up having to repeatedly create temporary lists. Which is obviously very inefficient and slow. Can anyone think of a better way to easily swap two elements within the
How to prefill data on a subform properly?
Hi everyone, I'm struggling on how to prefill the data on a subform properly. Scenario: I have 3 Forms: Shops, Clients and Needs Analysis. Shops is a subform of Clients as well as Needs Analysis. Whenever I create a new Client then I can add in the Shop
Zoho Desk and Zoho Creator Integration
Hello Everyone, I have an senario about Zoho Desk and Zoho Creator integration. I developed a app for our service team and they fill up the service form end of the service. But I want to merge ticket and service form. For example I created a ticket from
Age Calculation
I've attempted to calculate the age of someone based on their birthday input by using the formula field. It works but I don't want all those decimals on there. I then tried to use "set variable" after birthday input but I get a field type mismatch, long vs. floating. Any ideas would be wonderful.
Zoho Creator - Revamped Release Notes
Hello everyone! We're thrilled to announce the launch of our revamped Release Notes page. We'll now be saying goodbye to the current layout and introducing a fresh, updated Release Notes page in its place. A wide range of people have provided us with
Creator information to Books custom field
Hello community, I've two surely basic questions for people with more expertise than me, but it's been two days checking forum posts to get a solution without success. Context In our business, we need to qualify/approve all our suppliers before allowing
Scanning App
Hi, I have created a scanner app for events that we host, this works fine as we have different ticket types from different vendors, however there is one ticket type that comes in that is a URL which when accessed checks the attendee in on the vendors
2 Field With same value
Dear Sir I need help with a problem I'm facing If I have 2 fields with their respective values then I have recorded them, when I enter the same data for the two files, the new record will automatically be rejected by the system or can't be save, see the
Route Draw on Google Map
Can we draw a route between the two locations using Google Map?
Next Page